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 141 - 160 of 2008
€1,495,000
TSEA5139001
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Modern Luxury Villa with Panoramic Golf and Sea Views in Estepona!
This modern, newly built villa at Valle Romano Golf in Estepona offers outstanding panoramic views of both the golf course and the (...)
€769,000
TSEA5138869
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 350 Lot Size: 410 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 350 Lot Size: 410 Area: Mijas and Mijas Costa Region: Andalucía
Villa for Sale – La Sierrezuela, Mijas Costa
We present this spectacular villa located in La Sierrezuela, a prestigious residential area of Mijas Costa. A property that stands out for its spacious (...)
€2,850,000
TSEA5138845
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 385 Lot Size: 7,193 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 385 Lot Size: 7,193 Area: Benahavis Region: Andalucía
Beautiful Villa on a double plot located in the exclusive Monte Mayor estate, Benahavís
Nestled within the prestigious, gated enclave of Monte Mayor, this newly renovated villa offers a rare blend (...)
€725,000
TSEA5138077
- Chilches, Costa Del Sol East
Beds: 4 Baths: 1 M2: 175 Lot Size: 525 Region: Andalucía
Beds: 4 Baths: 1 M2: 175 Lot Size: 525 Region: Andalucía
This beautiful Spanish villa spans two floors and features three bedrooms, including an impressive primary suite, and two bathrooms, blending traditional Andalusian charm with modern comfort. The (...)
€545,000
TSEA5138065
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 305 Lot Size: 2,722 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 305 Lot Size: 2,722 Area: Mijas and Mijas Costa Region: Andalucía
Nestled on the outskirts of the prestigious Lauro Golf course, between Alhaurín el Grande and Alhaurín de la Torre, this beautifully renovated country home offers the perfect blend of comfort, (...)
€2,100,000
TSEA5138053
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 696 Lot Size: 650 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 696 Lot Size: 650 Area: Estepona Region: Andalucía
*Spacious Villa with Sea Views in Estepona / Seghers*
Located in one of Estepona's most prestigious and central residential areas — Seghers — this large villa offers unbeatable potential. Just a (...)
€770,000
TSEA5138023
- Torre del Mar, Costa Del Sol East
Beds: 4 Baths: 2 M2: 260 Lot Size: 505 Region: Andalucía
Beds: 4 Baths: 2 M2: 260 Lot Size: 505 Region: Andalucía
Torre del Mar – Casa con Alma
This house is truly unique – different from anything else you will find in Torre del Mar. An individual villa of 260 m² set on a 505 m² plot, located in one of (...)
€970,000
TSEA5137927
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 170 Lot Size: 407 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Lot Size: 407 Area: Estepona Region: Andalucía
Elegant Three-Bedroom Detached Villa – Frontline Golf, West of Estepona
This immaculate three-bedroom detached villa enjoys a privileged frontline golf position just west of Estepona. Combining (...)
€5,650,000
TSEA5137888
- Nagüeles, Costa Del Sol, Marbella
Beds: 5 Baths: 6 M2: 586 Lot Size: 1,272 Area: Marbella Region: Andalucía
Beds: 5 Baths: 6 M2: 586 Lot Size: 1,272 Area: Marbella Region: Andalucía
A stunning modern luxury Villa in Nagueles, Marbella Golden Mile offering easy access to Marbella centre and just 10 minutes' drive from Puerto Banus. The property is built to the highest (...)
€1,250,000
TSEA5137777
- Carib Playa, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 239 Lot Size: 775 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 239 Lot Size: 775 Area: Marbella East Region: Andalucía
Villa with Great Potential on a Large Flat Plot East of Marbella.
Discover an exceptional opportunity to create the home of your dreams in this villa located just east of Marbella. Situated on a (...)
€1,595,000
TSEA5137579
- Marbesa, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 295 Lot Size: 773 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 295 Lot Size: 773 Area: Marbella East Region: Andalucía
Luxury villa in the sought after area of Marbesa, East Marbella, one of the best areas of Marbella and just a stroll to the beach!
Close to Puerto de Cabopino, Nikki Beach, fine restaurants, shops (...)
€260,000
TSEA5136547
- Sayalonga, Costa Del Sol East
Beds: 1 Baths: 1 M2: 57 Lot Size: 3,440 Region: Andalucía
Beds: 1 Baths: 1 M2: 57 Lot Size: 3,440 Region: Andalucía
A charming Andalusian-style country villa with panoramic sea and mountain views, just 4 minutes from the whitewashed village of Sayalonga and 20 minutes from the golden beaches of the Costa del Sol. (...)
€690,000
TSEA5136091
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 129 Lot Size: 469 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 129 Lot Size: 469 Area: Benalmadena Region: Andalucía
Located in the prestigious Sol y Mar area of Benalmadena Costa, this three-bedroom villa all on the one level is a rare find—just 10 minutes' walk from the beach and within easy reach of shops, (...)
€11,300,000
TSEA5135956
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 1,318 Lot Size: 1,602 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 1,318 Lot Size: 1,602 Area: Marbella East Region: Andalucía
Marbella Golden Mile
Set in the very heart of Marbella's prestigious Golden Mile, this residency is a landmark contemporary residence that redefines Mediterranean luxury. With a private plot of 1,600 (...)
€1,995,000
TSEA5135941
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 410 Lot Size: 654 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 410 Lot Size: 654 Area: Benahavis Region: Andalucía
Set within the exclusive Atalaya Fairways community of Benahavís, this stunning contemporary villa offers a rare combination of elegance, privacy, and breathtaking views.
With 4 spacious bedrooms, (...)
€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 (...)
Current Featured Properties
€2,900,000
TSEA4679083
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 5 M2: 271 Lot Size: 11 Area: Estepona Region: Andalucía
Beds: 3 Baths: 5 M2: 271 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. (...)
€3,485,000
TSEA5156128
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 573 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 573 Area: Benahavis Region: Andalucía
A top quality, new built contemporaty villa (2024), located in the sought after residential area of La Alqueria, Benahavís. South to west facing with views to mountains and some seaviews from the (...)
€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 (...)
