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 361 - 380 of 3305
€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 (...)
€832,100
TSEA5129755
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 232 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 232 Area: Estepona Region: Andalucía
Set in a quiet, sought-after residential area in the very heart of Estepona, this contemporary corner townhouse, completed in October 2019, offers luxury, comfort, and sustainability—perfect as a (...)
€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,851,000
TSEA5129251
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 441 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 441 Area: Marbella West Region: Andalucía
We offer this spacious house for sale, located in the coastal town of Marbella, province of Málaga. It has a built area of 441 m², distributed among three bedrooms, a living-dining room, a kitchen, (...)
€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 (...)
€435,000
TSEA5128711
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 275 Lot Size: 137 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 275 Lot Size: 137 Area: Mijas and Mijas Costa Region: Andalucía
DETACHED HOUSE IN THE CENTER OF PICTURESQUE MIJAS PUEBLO.
Detached house in Mijas Pueblo, close to all amenities, in a quiet area outside the town's commercial area.
The property is in need of (...)
Current Featured Properties
€7,975,000
TSEA4712791
- La Mairena, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
ASTONISHING LUXURY VILLA WITH SEA VIEWS IN LA MAIRENA
Astonishing luxury villa nestled in a secluded oasis of tranquility, close to La Mairena, offering unparalleled privacy amidst unspoiled natural (...)
€725,000
TSEA4858963
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 2 M2: 250 Lot Size: 4,000 Area: Estepona Region: Andalucía
Beds: 6 Baths: 2 M2: 250 Lot Size: 4,000 Area: Estepona Region: Andalucía
THE BEST OF BOTH WORLDS – COUNTRY LIVING JUST MINUTES FROM ESTEPONA TOWN.
If you're looking for peace and privacy without giving up convenience, this charming country estate is the perfect fit. (...)
€1,535,000
TSEA5021377
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 282 Lot Size: 528 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 282 Lot Size: 528 Area: Mijas and Mijas Costa Region: Andalucía
The villas are located in the exclusive Las Farolas Urbanisation of Mijas Costa, an area that blends tranquillity with close proximity to top-tier amenities. Just a few minutes' walk from the (...)
