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 (42,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 (42,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 (42,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 201 - 220 of 2639 €9,600,000
TSEA5135665
- Monte Halcones, Costa Del Sol, Benahavis
Beds: 7 Baths: 11 M2: 803 Lot Size: 2,042 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 11 M2: 803 Lot Size: 2,042 Area: Benahavis Region: Andalucía
Presenting a luxurious villa for sale in the highly sought-after Monte Halcones urbanisation. Designed by a renowned architect and developed by a reputable promoter, this 2025 property brings modern (...)
€4,000,000
TSEA5135635
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 6 Baths: 9 M2: 654 Lot Size: 2,097 Area: Marbella Region: Andalucía
Beds: 6 Baths: 9 M2: 654 Lot Size: 2,097 Area: Marbella Region: Andalucía
Located in Los Altos de los Monteros, Villa Los Altos is a stunning five-bedroom property spread across three levels, offering awe-inspiring views of the Mediterranean Sea and the African (...)
€2,950,000
TSEA5135599
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 580 Lot Size: 2,385 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 580 Lot Size: 2,385 Area: Estepona Region: Andalucía
Timeless Elegance on the New Golden Mile's Frontline Golf
Welcome to this exquisite four-bedroom residence in El Paraíso, set in the very heart of the prestigious New Golden Mile one of the Costa (...)
€1,995,000
TSEA5135491
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 430 Lot Size: 1,140 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 430 Lot Size: 1,140 Area: Estepona Region: Andalucía
Modern beachside Villa for sale on the New Golden Mile between Marbella and Estepona
Discover this modern luxury villa for sale in the New Golden Mile, Estepona, perfectly located between Marbella (...)
€1,550,000
TSEA5135377
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 560 Lot Size: 1,025 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 560 Lot Size: 1,025 Area: Marbella Region: Andalucía
High-Quality Villa with Sea Views in a Quiet, Central Marbella Location.
Discover the perfect blend of peace and convenience in this exquisite, high-quality villa, ideally situated in a tranquil yet (...)
€679,000
TSEA5135173
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 228 Lot Size: 826 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 228 Lot Size: 826 Area: Mijas and Mijas Costa Region: Andalucía
Stunning 4-Bedroom 3-bathroom Villa for Sale in Cerros del Águila
This spacious and versatile 4-bedroom, 3-bathroom villa is located in the peaceful and sought-after area of Cerros del Águila. (...)
€595,000
TSEA5135164
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,200 Area: Manilva Region: Andalucía
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,200 Area: Manilva Region: Andalucía
***Stunning Character Villa in Princesa Kristina, Duquesa*** Nestled in the desirable residential area of Princesa Kristina, Duquesa, this exceptional character villa offers elegant living with a (...)
€1,595,000
TSEA5134954
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 565 Lot Size: 966 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 565 Lot Size: 966 Area: Manilva Region: Andalucía
New Development: Prices from 1,595,000 € to 1,595,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 565.00 m2 - 565.00 m2]
Set in an exclusive elevated position in Punta Chullera, this (...)
€1,690,000
TSEA5134837
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 316 Lot Size: 495 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 316 Lot Size: 495 Area: Estepona Region: Andalucía
Villa for sale in , Estepona with 5 bedrooms, 3 bathrooms, 2 en suite bathrooms, 1 toilet and with orientation west, with private swimming pool, private garage (1 parking spaces) and private garden. (...)
€495,000
TSEA5134831
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 147 Lot Size: 600 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 147 Lot Size: 600 Area: Coin Region: Andalucía
Renovated Villa with Pool & Mountain Views – Prime Location Between Coín & Alhaurín el GrandeLocated in one of the most desirable urbanisations in the area, this south facing charming (...)
€1,675,000
TSEA5134810
- Casares, Costa Del Sol, Casares
Beds: 5 Baths: 3 M2: 408 Lot Size: 981 Area: Casares Region: Andalucía
Beds: 5 Baths: 3 M2: 408 Lot Size: 981 Area: Casares Region: Andalucía
Wake up to endless horizons in this contemporary Mediterranean retreat, a home where clean modern design meets the timeless beauty of the sea.
Beyond the striking double gates, a cobbled driveway (...)
€450,000
TSEA5134780
- Arenas, Costa Del Sol East
Beds: 3 Baths: 2 M2: 120 Lot Size: 2,796 Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 2,796 Region: Andalucía
Exclusive Villa with Panoramic Views in Arenas (Málaga)
This beautiful villa is located on Mount Bentomiz in Arenas, Málaga, just 15 minutes from the coastal town of Torre del Mar and a 45-minute (...)
€489,000
TSEA5134726
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 137 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Fuengirola Region: Andalucía
Property for Sale – Los Boliches, Fuengirola
In the very heart of Los Boliches, one of the most emblematic and sought-after areas of Fuengirola.
The property is distributed into three generously (...)
€440,000
TSEA5134597
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 132 Lot Size: 2,012 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 132 Lot Size: 2,012 Area: Coin Region: Andalucía
Charming Riverside Finca in Coín
Nestled beside the tranquil Pereila River, this delightful two-level finca offers the perfect blend of rustic charm and modern convenience. Just a 5-minute drive (...)
€3,800,000
TSEA5134450
- Atalaya, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 734 Lot Size: 1,843 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 734 Lot Size: 1,843 Area: Estepona Region: Andalucía
This Villa is a captivating Mediterranean residence ideally situated in the sought-after enclave of Atalaya, just 400 metres from the prestigious Atalaya Golf Club. Drawing inspiration from classic (...)
€450,000
TSEA5134414
- Almogía, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 160 Lot Size: 2,500 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Lot Size: 2,500 Area: Malaga Region: Andalucía
Lion Hill – Luxury Villa with Private Pool and Panoramic Views
Lion Hill is a luxury villa with a private pool and panoramic views, located just a 10-minute drive from the charming villages of (...)
€1,875,000
TSEA5134288
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 4 M2: 306 Lot Size: 550 Area: Estepona Region: Andalucía
Beds: 6 Baths: 4 M2: 306 Lot Size: 550 Area: Estepona Region: Andalucía
A modern south facing 6-bedroom frontline golf villa located in El Campanario, Estepona East, within a short drive of beaches, a variety of golf courses, San Pedro de Alcantara, Puerto Banus and (...)
€1,471,000
TSEA5134285
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 4 M2: 282 Lot Size: 1,317 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 4 M2: 282 Lot Size: 1,317 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Villa with Panoramic Views, Private Pool & Proven Rental Returns
282 m² · 6 Bedrooms · 4 Bathrooms · Private Pool ·
Wake up to breathtaking views of the mountains, sea, and (...)
€795,000
TSEA5134279
- Arcos de la Frontera, Costa de la Luz
Beds: 4 Baths: 3 M2: 260 Lot Size: 2,318 Region: Andalucía
Beds: 4 Baths: 3 M2: 260 Lot Size: 2,318 Region: Andalucía
Fantastic villa located in Los Arcos, next to the wonderful and exclusive golf course of this town in the Sierra de Cádiz, located at the entrance to Los Pueblos Blancos, in the province of (...)
€2,395,000
TSEA5134264
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 508 Lot Size: 624 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 508 Lot Size: 624 Area: Estepona Region: Andalucía
We present you to our new exclusive listing: a modern luxury villa located in the privilged area of Seghers in Estepona. This stunning property, built with top-quality materials, is the ideal retreat (...)
Current Featured Properties
€1,795,000
TSEA5060815
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 430 Lot Size: 600 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 430 Lot Size: 600 Area: Estepona Region: Andalucía
Key-ready! Spectacular brand new detached villa on the doorstep of Estepona. Built over 2 floors plus a basement and set within a 600 sqm plot. Just finished to a very high standard, it offers 4 (...)
€2,300,240
Detached Villa in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
NO MORE NEED TO DREAM ABOUT THE PERFECT VIEW!!!
This upscale development with the best views in Fuengirola and Mijas consists of thirteen individual villas, each offering no less than four en-suite (...)
€4,950,000
TSEA4790245
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Nestled within the illustrious enclave of Nueva Andalucia, This new development provides residents a luxurious escape that embodies the true essence of luxury living. With its privileged location in (...)
