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 (61,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 (61,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 (61,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 261 - 280 of 2653 €1,595,000
TSEA5129893
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 6 Baths: 6 M2: 831 Lot Size: 2,506 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 6 M2: 831 Lot Size: 2,506 Area: Sotogrande Region: Andalucía
This traditional-style villa is located between Valderrama and the Almenara golf course, surrounded by mature woodlands and landscaped gardens. Spread over three floors, it features rustic elements (...)
€339,000
TSEA5129890
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 128 Lot Size: 10,520 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Lot Size: 10,520 Area: Nerja and Malaga East Region: Andalucía
Rural property with complete privacy in Comares - Malaga - Costa del Sol - Axarquia
Discover this charming rural property in picturesque Comares, situated in a beautiful, peaceful location with (...)
€1,010,000
TSEA5129800
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 101 Lot Size: 506 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 101 Lot Size: 506 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent detached villa in El Coto.
Discover this magnificent, fully renovated villa in the quiet residential area of El Coto in Mijas Costa.
Ideal for those looking for a turnkey home, close to (...)
€2,495,000
TSEA5129767
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 6 M2: 600 Lot Size: 2,150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 6 M2: 600 Lot Size: 2,150 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Villa in Valtocado – Panoramic Views
Set in the prestigious and tranquil urbanisation of Valtocado, Mijas, this impressive modern villa offers the ultimate blend of privacy, comfort, and (...)
€18,000,000
TSEA5129758
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 6 Baths: 6 M2: 1,163 Lot Size: 2,048 Area: Marbella Region: Andalucía
Beds: 6 Baths: 6 M2: 1,163 Lot Size: 2,048 Area: Marbella Region: Andalucía
New Development: Prices from 18,000,000 € to 18,000,000 €. [Beds: 6 - 6] [Baths: 6 - 6] [Built size: 1,163.00 m2 - 1,163.00 m2]
This is a luxury two-storey property located in Sierra Blanca, one (...)
€595,000
TSEA5129590
- Guadacorte, Costa de la Luz
Beds: 4 Baths: 3 M2: 214 Lot Size: 1,200 Region: Andalucía
Beds: 4 Baths: 3 M2: 214 Lot Size: 1,200 Region: Andalucía
Charming Riverside Villa in Guadacorte – A Private Retreat Surrounded by Nature
Discover this cozy detached villa located in a privileged setting in Guadacorte, right by the river and surrounded (...)
€699,000
TSEA5129566
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 145 Lot Size: 354 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Lot Size: 354 Area: San Pedro Region: Andalucía
Welcome to this charming and well-designed semi-detached home in the sought-after Linda Vista alta area – just a short walk from the vibrant centre of San Pedro de Alcántara, with shops, (...)
€3,800,000
TSEA5129392
- Ojén, Costa Del Sol, Ojen
Beds: 9 Baths: 9 M2: 1,688 Lot Size: 58,283 Area: Ojen Region: Andalucía
Beds: 9 Baths: 9 M2: 1,688 Lot Size: 58,283 Area: Ojen Region: Andalucía
This estate is much more than a property: it's a statement of style, refined taste, and forward-thinking vision. A place where understated luxury blends seamlessly with the serenity of the Andalusian (...)
€900,000
TSEA5129257
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 165 Lot Size: 500 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Lot Size: 500 Area: Estepona Region: Andalucía
€900,000 – 3 Bedrooms | 2 Bathrooms | 165 m² Built | 500 m² Plot | Private Pool
Located just minutes from the beach on Estepona's sought-after New Golden Mile, this south-facing villa offers (...)
€1,350,000
TSEA5129245
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Introducing this elegant single-level villa, ideally situated in one of the most exclusive areas of San Pedro Alcántara. Designed with a perfect balance of comfort, quality and privacy, it offers (...)
€1,885,000
TSEA5129080
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 3 M2: 727 Lot Size: 1,200 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 3 M2: 727 Lot Size: 1,200 Area: Sotogrande Region: Andalucía
Grand villa with incredible sea views La Alcaidesa
Villa Casablanca is an Andalusian style white villa located in a quiet street with no drive through traffic and with the best possible views of the (...)
€850,000
TSEA5129014
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 167 Lot Size: 775 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 167 Lot Size: 775 Area: Marbella East Region: Andalucía
Mediterranean living on one level: comfort, tranquility, and proximity to the sea
This charming villa combines the Mediterranean lifestyle with maximum comfort. Situated on a spacious floor, this (...)
€2,300,000
TSEA5128981
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 241 Lot Size: 508 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 241 Lot Size: 508 Area: Marbella East Region: Andalucía
Exclusive semi-detached house with private pool, right in front of Cabopino Marina, boasting stunning sea views.
This elegant and traditional property in Spanish style features 4 bedrooms, 3 full (...)
€455,000
TSEA5128978
- Riogordo, Costa Del Sol East
Beds: 3 Baths: 2 M2: 229 Lot Size: 9,470 Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Lot Size: 9,470 Region: Andalucía
Authentic finca near Riogordo (Málaga, Costa del Sol) – ready to move in with swimming pool, solar panels and beautiful views
This excellently maintained finca is located just 10 minutes from the (...)
€2,390,000
TSEA5128939
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 7 M2: 441 Lot Size: 800 Area: Estepona Region: Andalucía
Beds: 5 Baths: 7 M2: 441 Lot Size: 800 Area: Estepona Region: Andalucía
Villa Kartala. Viewings possible from September. Love at first sight! Impeccable luxury detached villa in a top location. Situated between Marbella and Estepona, with the beaches of Costalita only (...)
€18,000,000
TSEA5128903
- Marbella, Costa Del Sol, Marbella
Beds: 8 Baths: 8 M2: 1,343 Lot Size: 2,374 Area: Marbella Region: Andalucía
Beds: 8 Baths: 8 M2: 1,343 Lot Size: 2,374 Area: Marbella Region: Andalucía
New Development: Prices from 18,000,000 € to 18,000,000 €. [Beds: 8 - 8] [Baths: 8 - 8] [Built size: 1,343.00 m2 - 1,343.00 m2]
This is a majestic contemporary villa in the exclusive 24hrs (...)
€10,750,000
TSEA5128873
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 986 Lot Size: 1,727 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 986 Lot Size: 1,727 Area: Marbella West Region: Andalucía
New Development: Prices from 10,750,000 € to 10,750,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 986.00 m2 - 986.00 m2]
This is an exceptional modern villa located in the heart of the Golf (...)
€9,750,000
TSEA5128849
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 867 Lot Size: 1,458 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 867 Lot Size: 1,458 Area: Marbella West Region: Andalucía
New Development: Prices from 9,750,000 € to 9,750,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 867.00 m2 - 867.00 m2]
PROJECT IN THE HEART OF NUEVA ANDALUCÍA
This is a luxury villa located (...)
€5,950,000
TSEA5128846
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 577 Lot Size: 1,160 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 577 Lot Size: 1,160 Area: Benahavis Region: Andalucía
New Development: Prices from 5,950,000 € to 5,950,000 €. [Beds: 5 - 5] [Baths: 6 - 6] [Built size: 577.00 m2 - 577.00 m2]
An exclusive residential development in La Quinta is a 24-hour gated (...)
€5,750,000
TSEA5128819
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 605 Lot Size: 1,210 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 605 Lot Size: 1,210 Area: Benahavis Region: Andalucía
New Development: Prices from 5,750,000 € to 5,750,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 605.00 m2 - 605.00 m2]
Now finished. READY TO VISIT TODAY.
An exclusive residential (...)
Current Featured Properties
€1,490,000
Control your home with your smart device!
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
ULTIMATE IN DESIGNER LIVING IN BEAUTIFUL MARBELLA!!!
Villas in a unique project with an emphasis on design to meet the requirements of the most demanding client. Located on a privileged plot, the (...)
€940,000
TSEA4753036
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 265 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 265 Area: Manilva Region: Andalucía
9 magnificent independent modern villas of high quality on plots of approx. 600m2. with 4 bedrooms all en suite, toilet, large living room-kitchen, private pool, private natural garden and private (...)
€2,950,000
EMPTY
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
We are thrilled to present this modern south facing villa, just 250m from the Mediterranean Sea near San Pedro town. The property is built over two floors plus basement and rooftop terrace with views (...)
