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 (48,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 (48,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 (48,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 181 - 200 of 2656
€1,900,000
TSEA5139067
- Los Monteros, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 172 Lot Size: 723 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 172 Lot Size: 723 Area: Marbella East Region: Andalucía
INVESTMENT OPPORTUNITY
Elegant one-storey villa set within the exclusive Los Monteros urbanisation.
Located in the prestigious gated community of Los Monteros, just steps from Marbella's finest (...)
€1,200,000
TSEA5139046
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 467 Lot Size: 796 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 467 Lot Size: 796 Area: Estepona Region: Andalucía
Exceptional Opportunity to Build Your Dream Villa in Valle Romano
Discover a rare chance to create your perfect home in the exclusive and highly sought-after private urbanization of Valle Romano. (...)
€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 (...)
€395,000
TSEA5138626
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 253 Lot Size: 6,961 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 253 Lot Size: 6,961 Area: Estepona Region: Andalucía
Now there is an opportunity to buy this large bright plot with views of the sea and rural / country Spain.
The plot is classified Rustica and today has two buildings, one of which has a private pool (...)
€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 (...)
€550,000
TSEA5137591
- Entrerrios, Costa Del Sol
Beds: 3 Baths: 2 M2: 140 Lot Size: 6,449 Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Lot Size: 6,449 Region: Andalucía
A beautiful rustic house in Entrerrios with a very country feel and yet within a ten minute drive of amenities and the beaches of La Cala de Mijas. The property consists of two separate buildings, (...)
€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, (...)
€695,000
TSEA5135917
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 3 M2: 241 Lot Size: 115 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 3 M2: 241 Lot Size: 115 Area: La Duquesa Region: Andalucía
Experience luxury in this refurbished and modified semi-detached home featuring 5 bedrooms, 4 bathrooms, multiple terraces, and breathtaking panoramic views. Enjoy a private garden, private pool, and (...)
Current Featured Properties
€957,000
TSEA4390957
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 143 Lot Size: 54 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 143 Lot Size: 54 Area: Mijas and Mijas Costa Region: Andalucía
A NATURAL BEAUTY!!!
The architecture of these sixty-nine villas blends with nature and reinvents the traditional Andalusian style. A refuge where the natural beauty of the environment merges with a (...)
€7,900,000
TSEA4328788
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 12 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
Beds: 7 Baths: 12 M2: 348 Lot Size: 814 Area: Marbella Region: Andalucía
This is a collection of six exclusive luxury villas in the Cascada de Camojan urbanization, in the surroundings of Sierra Blanca, in the heart of Marbella's Golden Mile. The homes will be located (...)
€1,490,000
Control your home with your smart device!
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
ULTIMATE IN DESIGNER LIVING IN BEAUTIFUL MARBELLA!!!
Villas in a unique project with an emphasis on design to meet the requirements of the most demanding client. Located on a privileged plot, the (...)
