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,36,37,38)
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,36,37,38)
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,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 161 - 180 of 2008 €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 (...)
€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 (...)
€1,695,000
TSEA5134261
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 490 Lot Size: 737 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 490 Lot Size: 737 Area: San Pedro Region: Andalucía
We are thrilled to present our exclusive listing; an unparalleled opportunity to own an exquisite and modern villa located in the highly sought-after area of San Pedro de Alcantara. Renovated and in (...)
€1,095,000
TSEA5133601
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 8 M2: 757 Lot Size: 1,383 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 8 M2: 757 Lot Size: 1,383 Area: Mijas and Mijas Costa Region: Andalucía
This exquisite villa offers a harmonious combination of quality and comfort. The owner built the house himself 20 years ago, which guarantees quality throughout. It is a perfect home for the large (...)
€595,000
TSEA5133370
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 521 Lot Size: 803 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 521 Lot Size: 803 Area: Coin Region: Andalucía
Boho style villa, located in once of Southern Spain's best inland towns. The property was designed by a Swedish architect and is a fantastic family home. Houses of this style and quality, are (...)
€255,000
TSEA5133121
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 88 Lot Size: 45 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 88 Lot Size: 45 Area: Benalmadena Region: Andalucía
Charming casa mata for sale, ideally located in the very center of Arroyo de la Miel, in a quiet residential area with all essential services nearby. Supermarkets, train station, health centers, (...)
€625,000
TSEA5132815
- Ojén, Costa Del Sol, Ojen
Beds: 5 Baths: 3 M2: 447 Lot Size: 600 Area: Ojen Region: Andalucía
Beds: 5 Baths: 3 M2: 447 Lot Size: 600 Area: Ojen Region: Andalucía
✨ Live Your Mediterranean Dream in This Gem of Ojén ✨
Imagine waking up each morning to the sound of the breeze through the pine trees and breathtaking views—where the deep blue sea meets the (...)
€1,800,000
TSEA5132668
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 7 M2: 446 Lot Size: 3,600 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 7 M2: 446 Lot Size: 3,600 Area: Mijas and Mijas Costa Region: Andalucía
Villa for sale in , Mijas with 7 bedrooms, 7 bathrooms and with orientation south, with private swimming pool, private garage and private garden. Regarding property dimensions, it has 446 m² built (...)
€2,300,000
TSEA5132662
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 736 Lot Size: 3,000 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 736 Lot Size: 3,000 Area: Benahavis Region: Andalucía
Villa Benahavís is an exceptional property for sale in one of the most coveted areas of the Costa del Sol, offering an unparalleled blend of luxury, tranquility, and natural beauty. Nestled within (...)
Current Featured Properties
€3,890,000
Detached Villa in Nueva Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Combining luxury and nature in an exceptional environment. Two unique villas built on one floor and designed to enjoy the Mediterranean lifestyle in a relaxed way, (...)
€4,500,000
TSEA4218301
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 300 Lot Size: 92 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 300 Lot Size: 92 Area: Marbella West Region: Andalucía
The "central courtyard" of each "Vila", is undoubtedly the main axis, everything happens around this unique space, open to both, the inside and the outside. Everything in the (...)
€1,011,000
TSEA4391047
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
NATUTAL LIGHT FLOODS INTO THE PROPERTIES!!!
The architecture of these sixty-nine villas blends with nature and reinvents the traditional Andalusian style. A refuge where the natural beauty of the (...)
