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 21 - 40 of 2008
€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 (...)
€500,000
TSEA5156104
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 143 Lot Size: 200 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 143 Lot Size: 200 Area: Marbella Region: Andalucía
Stunning South-Facing Villa in Bello Horizonte - Lindasol: Private Pool, Garden, and Modern Comforts!
Discover this impeccably maintained villa in the desirable Bello Horizonte - Lindasol (...)
€859,000
TSEA5156074
- Cártama, Costa Del Sol, Cartama
Beds: 3 Baths: 2 M2: 200 Lot Size: 48,000 Area: Cartama Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Lot Size: 48,000 Area: Cartama Region: Andalucía
Wonderful finca with almost 50,000 m2 of land, totally fenced, with 5 different entrances, water from its own well plus irrigation water from the canal such us two algibes/ water deposits. T he land (...)
€2,695,000
TSEA5155951
- Valle Romano, Costa Del Sol, Estepona
Beds: 6 Baths: 5 M2: 383 Lot Size: 1,005 Area: Estepona Region: Andalucía
Beds: 6 Baths: 5 M2: 383 Lot Size: 1,005 Area: Estepona Region: Andalucía
Located on a private and tranquil street, front line to the Valle Romano golf course in Estepona, Villa 17 is a stunning modern masterpiece that radiates beauty and serenity. With panoramic sea, (...)
€825,000
TSEA5155327
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 290 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 290 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
For sale in one of the most sought after urbanizations of Alhaurin de la Torre with walking access to shops, schools, bus stop. On a fenced plot of 1000 meters the villa consists on the ground floor (...)
€1,500,000
TSEA5155321
- Almayate, Costa Del Sol East
Beds: 5 Baths: 5 M2: 850 Lot Size: 7,700 Region: Andalucía
Beds: 5 Baths: 5 M2: 850 Lot Size: 7,700 Region: Andalucía
This villa in Almayate stands out for its spaciousness, versatility and excellent possibilities both as a family home and as an investment. The property has a large garden with a private pool and a (...)
€1,150,000
TSEA5155255
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 230 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 230 Area: Mijas and Mijas Costa Region: Andalucía
✨ **Villa with double plot in Campo Mijas/El Coto – where your future and lifestyle meet** ✨
Imagine living in a villa with Andalusian charm, in a quiet residential area, surrounded by the (...)
€2,250,000
TSEA5155102
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 166 Lot Size: 385 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 166 Lot Size: 385 Area: Marbella Region: Andalucía
This exclusive villa in the heart of Marbella offers the perfect mix of modern style and comfortable living. It has 4 bedrooms, 2 bathrooms, a guest toilet, and two secure garage spaces. The home (...)
€1,380,000
TSEA5155084
- Sotogrande Costa, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 252 Lot Size: 1,665 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 252 Lot Size: 1,665 Area: Sotogrande Region: Andalucía
New Build Key in Hand Dream Villa expected completion summer 2026.
An exceptional home that offers you a life without limits, combining rest and comfort.
With a constructed area of 252 m² (...)
€3,500,000
TSEA5154940
- Casares, Costa Del Sol, Casares
Beds: 5 Baths: 7 M2: 529 Lot Size: 867 Area: Casares Region: Andalucía
Beds: 5 Baths: 7 M2: 529 Lot Size: 867 Area: Casares Region: Andalucía
New Development: Prices from 3,500,000 € to 3,500,000 €. [Beds: 5 - 5] [Baths: 7 - 7] [Built size: 529.00 m2 - 529.00 m2]
Living on the Costa del Sol reaches a new level with this exclusive (...)
€900,000
TSEA5154904
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 280 Lot Size: 407 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 280 Lot Size: 407 Area: Marbella West Region: Andalucía
For Sale in Nueva Andalucía – La Campana
We present a beautiful house in Nueva Andalucía, located in the La Campana area and in excellent condition. The property features three spacious (...)
€1,800,000
TSEA5154859
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 419 Lot Size: 419 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 419 Lot Size: 419 Area: Estepona Region: Andalucía
New Development: Prices from 1,800,000 € to 1,800,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 419.00 m2 - 419.00 m2]
Discover the collection of eight exclusive designed residential villas, (...)
€2,650,000
TSEA5154856
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 372 Lot Size: 567 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 372 Lot Size: 567 Area: Estepona Region: Andalucía
New Development: Prices from 2,650,000 € to 2,650,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 372.00 m2 - 372.00 m2]
Discover the collection of eight exclusive designed residential villas, (...)
€3,495,000
TSEA5154823
- Gaucín, Costa Del Sol, Gaucin
Beds: 4 Baths: 5 M2: 525 Lot Size: 40,000 Area: Gaucin Region: Andalucía
Beds: 4 Baths: 5 M2: 525 Lot Size: 40,000 Area: Gaucin Region: Andalucía
Stunning Rural Villa in Gaucín with Panoramic Views
Nestled in the picturesque Andalusian countryside, this impressive villa built in 2008 offers a perfect blend of rustic charm and modern comfort. (...)
€695,000
TSEA5153797
- Arenas, Costa Del Sol East
Beds: 3 Baths: 3 M2: 183 Lot Size: 4,284 Region: Andalucía
Beds: 3 Baths: 3 M2: 183 Lot Size: 4,284 Region: Andalucía
Are you dreaming of a life under the Spanish sun, surrounded by peace, space and ultimate comfort? This bright and elegant villa, located between Vélez-Málaga and the charming village of Arenas, (...)
€2,295,000
TSEA5153674
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 3 M2: 222 Lot Size: 721 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 3 M2: 222 Lot Size: 721 Area: Marbella West Region: Andalucía
Detached Andalusian-Style Villa in Nueva Andalucía — Walk to Puerto Banús & the Beach
Tucked away in a quiet cul-de-sac, this charming Andalusian-style villa offers privacy, stunning views (...)
€1,092,500
TSEA5153542
- Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 349 Lot Size: 250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 349 Lot Size: 250 Area: Mijas and Mijas Costa Region: Andalucía
Appointments for viewing is in January 2026 -The property is rented until end of June 2026. Contact us for more informacion.
Amazing independent villa for sale in Los Pacos -beautiful seaviews, (...)
€340,000
TSEA5153530
- San Roque, Costa Del Sol, San Roque
Beds: 4 Baths: 3 M2: 270 Lot Size: 2,500 Area: San Roque Region: Andalucía
Beds: 4 Baths: 3 M2: 270 Lot Size: 2,500 Area: San Roque Region: Andalucía
Spacious Independent Villa in San Roque Pueblo – Private Pool, Garden, and Special Land Offer!
Discover this elegant independent house in the charming heart of San Roque Pueblo, built in 2005 and (...)
€2,200,000
TSEA5153254
- San Roque Club, Costa Del Sol
Beds: 5 Baths: 5 M2: 658 Lot Size: 1,408 Region: Andalucía
Beds: 5 Baths: 5 M2: 658 Lot Size: 1,408 Region: Andalucía
This beautifully renovated villa is located in one of Sotogrande's most prestigious areas, just steps from the world-renowned Valderrama Golf Course. Designed in an elegant Mediterranean style and (...)
€578,000
TSEA5153134
- Canillas de Albaida, Costa Del Sol East
Beds: 3 Baths: 3 M2: 135 Lot Size: 2,500 Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Lot Size: 2,500 Region: Andalucía
This charming country house in Canillas de Albaida, Malaga, offers a harmonious combination of rustic charm and modern comfort. The property, on one floor, is distributed in three bedrooms with (...)
Current Featured Properties
€2,250,000
TSEA4707427
- El Madroñal, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 255 Lot Size: 1,666 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 255 Lot Size: 1,666 Area: San Pedro Region: Andalucía
Welcome to your dream retreat! This magnificent 4 bedroom, 4 bathroom villa is located in the popular gated community of El Madroñal. Located at entrance number 1, making the villa easily accesible, (...)
€756,413
TSEA4301248
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 283 Lot Size: 400 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 283 Lot Size: 400 Area: Estepona Region: Andalucía
A BEAUTIFUL PROPERTY IN STUNNING ESTEPONA!!!
A semi-detached villa for sale with 4 bedrooms and 4 bathrooms.
Oriented North West with frontal views of the golf course and the mountains.
A property (...)
€2,950,000
EMPTY
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
We are thrilled to present this modern south facing villa, just 250m from the Mediterranean Sea near San Pedro town. The property is built over two floors plus basement and rooftop terrace with views (...)
