SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (70,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND `p`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (70,42,43,44,45)
GROUP BY p.id
ORDER BY RAND()
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (70,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 641 - 660 of 3305 €4,500,000
TSEA5104507
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 654 Lot Size: 933 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 654 Lot Size: 933 Area: Marbella Region: Andalucía
Tucked away in the exclusive beachside area of Los Monteros in Marbella East, just a short walk from the beach, this villa is truly one of a kind. Inspired by Venetian church architecture, it (...)
€3,200,000
TSEA5104471
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 638 Lot Size: 1,743 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 638 Lot Size: 1,743 Area: Marbella East Region: Andalucía
Positioned within the prestigious Santa Maria Golf urbanization in Elviria, Villa Andrea is an extraordinary frontline golf villa for sale in Marbella offering contemporary luxury, seamless design, (...)
€520,000
TSEA5104381
- Benajarafe, Costa Del Sol East
Beds: 2 Baths: 2 M2: 101 Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Region: Andalucía
Beachfront with boho style and direct sea views
Looking for a unique home with a Mediterranean soul and direct access to the sand? Welcome to Casa Bali Beach, a bohemian gem right on the beach, just (...)
€3,000,000
TSEA5104306
- Selwo, Costa Del Sol, Estepona
Beds: 5 Baths: 8 M2: 697 Lot Size: 2,025 Area: Estepona Region: Andalucía
Beds: 5 Baths: 8 M2: 697 Lot Size: 2,025 Area: Estepona Region: Andalucía
Three-storey villa built on a 2,025.63 m² plot, located in the prestigious La Panera development in Estepona. The property is south-facing and offers sea views, ensuring plenty of natural light and (...)
€11,500,000
TSEA5104297
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 7 M2: 1,018 Lot Size: 4,594 Area: Marbella Region: Andalucía
Beds: 6 Baths: 7 M2: 1,018 Lot Size: 4,594 Area: Marbella Region: Andalucía
EXCEPTIONAL LUXURY VILLA FOR SALE IN GUADALMINA BAJA, SAN PEDRO DE ALCÁNTARA, MARBELLA
This truly exceptional villa is located in the heart of Guadalmina Baja, one of the most prestigious and (...)
€1,750,000
TSEA5104279
- El Rosario, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 326 Lot Size: 1,259 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 326 Lot Size: 1,259 Area: Marbella East Region: Andalucía
Charming 5-Bedroom Villa with Private Pool and Garden in El Rosario, Marbella – €1,750, 000
Description:
Spacious and elegant villa for sale in the exclusive residential area of El Rosario, just (...)
€480,000
TSEA5104219
- Frigiliana, Costa Del Sol East
Beds: 3 Baths: 2 M2: 120 Lot Size: 2,826 Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 2,826 Region: Andalucía
Charming Countryside Villa with Private Pool in Frigiliana, less than 1km from the village!!!
Nestled in the serene hills just outside the picturesque village of Frigiliana, this beautiful one-level (...)
€1,295,000
TSEA5104207
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 125 Lot Size: 1,067 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Lot Size: 1,067 Area: Fuengirola Region: Andalucía
Owner is keen to sell, so offers will be considered
Very charming villa in lower Torreblanca.
The Villa offers complete privacy and amazing views both sea view and Mountain View from the numerous (...)
€715,000
TSEA5104135
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 265 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 265 Area: Mijas and Mijas Costa Region: Andalucía
Beautifully presented townhouse with only the top finishes used offering an abundance of outside space plus a selection of 18 hole golf courses on your doorstep and a luxurious 4 star hotel to match. (...)
€190,000
TSEA5104129
- Cómpeta, Costa Del Sol East
Beds: 2 Baths: 2 M2: 126 Region: Andalucía
Beds: 2 Baths: 2 M2: 126 Region: Andalucía
Beautiful 2 bedroom Townhouse in the heart of Competa.
This corner terraced townhouse can be found in the heart of the beautiful Moorish white village of Competa, close to all local shops and (...)
€1,500,000
TSEA5104105
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 250 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 250 Area: Benalmadena Region: Andalucía
For sale spectacular detached villa in one of the most privileged areas of Benalmádena. This magnificent property offers unobstructed views that invite relaxation and enjoyment of the surroundings, (...)
€395,000
TSEA5104066
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 128 Lot Size: 153 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Lot Size: 153 Area: Manilva Region: Andalucía
Brand new semi-detached house 500m from the beach located in Aldea Hills, Manilva. The house has a constructed area of approximately 150m2 and consists of 2 bedrooms, 2 bathrooms, a living (...)
€490,000
TSEA5104036
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 207 Lot Size: 240 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 207 Lot Size: 240 Area: Manilva Region: Andalucía
Detached villa with sea views in Manilva. Detached villa with sea views located in the Aldea Hills development, just 500 meters from the beach. It consists of 3 bedrooms, 3 bathrooms, a living-dining (...)
€510,000
TSEA5103988
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 177 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 177 Area: Benalmadena Region: Andalucía
Welcome to your new home. This beautiful villa combines comfort and style in a space designed for maximum enjoyment.
Upon entering, you'll find an Andalusian patio that envelops you with its decor (...)
€1,750,000
TSEA5103964
- Pedregalejo, Costa Del Sol
Beds: 4 Baths: 3 M2: 409 Lot Size: 600 Region: Andalucía
Beds: 4 Baths: 3 M2: 409 Lot Size: 600 Region: Andalucía
Exclusive Villa with Sea Views in Pedregalejo
Discover this magnificent villa located in one of Málaga's most sought-after residential areas: Pedregalejo. Set on a 600 m² plot with a total built (...)
€1,795,000
TSEA5103943
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 395 Lot Size: 761 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 395 Lot Size: 761 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Newly Built Villa in Bellavista, Mijas: An Oasis of Luxury and Tranquility with Sea Views
Discover the villa of your dreams in the prestigious area of Bellavista in Mijas, a (...)
€2,695,000
TSEA5103814
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 170 Lot Size: 150 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 170 Lot Size: 150 Area: Marbella East Region: Andalucía
Semi-Detached Villa in Altos de Salamanca – Marbella's Golden Mile
Located within the prestigious gated community of Altos de Puente Romano, in the charming community of Altos de Salamanca, this (...)
€6,000,000
TSEA5103706
- Ardales, Costa Del Sol, Alhaurin el Grande
Beds: 5 Baths: 5 M2: 630 Lot Size: 270,000 Area: Alhaurin el Grande Region: Andalucía
Beds: 5 Baths: 5 M2: 630 Lot Size: 270,000 Area: Alhaurin el Grande Region: Andalucía
Set on a vast 270,000 m² estate near Ardales and the popular Caminito del Rey, this stunning cortijo blends recent renovations with preserved traditional features—thick stone walls, wooden (...)
€3,000,000
TSEA5103631
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 433 Lot Size: 1,097 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 433 Lot Size: 1,097 Area: Estepona Region: Andalucía
Villa Three, located in the distinguished La Resina Golf community within Estepona's flourishing residential zone, is an architectural statement combining contemporary sophistication and practical (...)
€3,500,000
TSEA5103574
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 310 Lot Size: 1,804 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 310 Lot Size: 1,804 Area: Marbella East Region: Andalucía
New Development: Prices from 3,500,000 € to 3,500,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 310.00 m2 - 310.00 m2]
New Project Rio Real unbeatable views.
Where Modern Elegance Meets (...)
Current Featured Properties
€1,380,000
TSEA4670587
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 149 Lot Size: 1,016 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 149 Lot Size: 1,016 Area: Mijas and Mijas Costa Region: Andalucía
Itś a energy-saving house in one level that combines an energy-efficient construction with materials of the highest quality and smart use of the surfaces. This smart, cost-effective villa with solar (...)
€950,000
TSEA4430956
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Exceptional very spacious townhouse located in frontline beach residential complex Belgravia club, Estepona.
This spectacular home has fantastic sea views and the location is unbeatable, just a few (...)
€8,096,900
TSEA4372201
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
This is a luxury residential complex of 53 unique 4, 5 villas sitting gently on the side of a hill, with every villa standing on a different height. The prestigious position is over looking the (...)
