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 (51,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 (51,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 (51,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 261 - 280 of 2660 €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 (...)
€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
€1,250,000
TSEA5115490
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€2,548,000
TSEA4300519
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 397 Lot Size: 833 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 397 Lot Size: 833 Area: Mijas and Mijas Costa Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Experience the ultimate in luxury living with this latest development of three stunning, open plan villas located just steps from the sea. These spacious and bright (...)
€4,600,000
TSEA4679626
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 474 Lot Size: 11 Area: Estepona Region: Andalucía
Located in a picturesque and coveted setting amidst nature's splendour, This luxury development comprises a collection of twelve sophisticated and exclusive villas boasting contemporary aesthetics. (...)
