€50,000,000
The Golden Mile
TSEA5065927
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.price >= 15000000 AND `p`.`locstate` IN ('3') AND p.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.price 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.price >= 15000000 AND `p`.`locstate` IN ('3') AND p.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.price DESC
Luxury Properties for Sale on the Costa del Sol
Luxury Living on the Costa del Sol
Contact us today to explore the finest properties in Southern Spain.
Contact UsThe Costa del Sol offers an unrivalled combination of elegance, natural beauty, and Mediterranean charm.
Famed for its golden beaches, world-class golf courses, and exclusive marinas, this sought-after region is home to some of the most prestigious addresses in Spain. Whether it's a contemporary villa with panoramic sea views or a refined apartment in a gated community, the Costa del Sol presents exceptional opportunities for luxury living.
Perfect for a second residence, investment, or permanent relocation, the Costa del Sol invites you to enjoy a sophisticated lifestyle under the Andalusian sun. Explore our curated collection and find your dream property today.
€28,950,000
La Quinta
TSEA4891450
€24,750,000
La Zagaleta
TSEA4913128
€24,750,000
La Zagaleta
TSEA4929028
€24,000,000
Puerto Banús
TSEA3182194
€22,490,000
Sierra Blanca
TSEA5131117
€19,850,000
The Golden Mile
TSEA5073526
€18,000,000
Sierra Blanca
TSEA5129758
€18,000,000
Marbella
TSEA5128903
€18,000,000
Sotogrande
TSEA4955374
€17,500,000
The Golden Mile
TSEA5156455
€16,500,000
Ronda
TSEA2837321
€16,000,000
Sierra Blanca
TSEA4939060
€16,000,000
Marbella
TSEA4943170
€15,000,000
Estepona
TSEA5125372
€15,000,000
El Paraiso
TSEA5050729
€15,000,000
Málaga Este
TSEA5111920
