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 (61,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 (61,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 (61,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 21 - 40 of 2653
€595,000
TSEA5156353
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 189 Lot Size: 578 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Lot Size: 578 Area: La Duquesa Region: Andalucía
Semi-Detached One-Level House with Potential – Prime Location
This is not a move-in ready home. It requires work, and plenty of it. But for the right buyer, the reward will be a highly desirable (...)
€785,000
TSEA5156308
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 140 Lot Size: 464 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Lot Size: 464 Area: Benalmadena Region: Andalucía
Exclusive detached house for sale on a sought-after residential street in Benalmádena. A unique gem, designed for maximum comfort: single storey, with everything you need at your fingertips.
Enjoy (...)
€6,500,000
TSEA5156299
- Marbesa, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 486 Lot Size: 1,871 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 486 Lot Size: 1,871 Area: Marbella East Region: Andalucía
<strong>Location, Location, Location!</strong>
This is a rare opportunity to acquire an <strong>absolute frontline beach villa</strong> in the highly sought-after Marbesa (...)
€1,400,000
TSEA5156281
- Torreguadiaro, Costa Del Sol, Sotogrande
Beds: 4 Baths: 2 M2: 450 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 2 M2: 450 Area: Sotogrande Region: Andalucía
This magnificent villa combines space, comfort, and a privileged setting. It features four spacious bedrooms and two full bathrooms, designed to offer maximum convenience. The centralized air (...)
€952,329
TSEA5156242
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 110 Lot Size: 835 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Lot Size: 835 Area: Estepona Region: Andalucía
Detached villa with sea views in Estepona – Don Pedro Development
Living on the Costa del Sol transcends mere property ownership: it means enjoying a unique lifestyle where sun, sea, and (...)
€1,800,000
TSEA5156197
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 260 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 260 Area: Estepona Region: Andalucía
Exclusive luxury detached villa in Isdabe, just 6 minutes from the beach
Discover this magnificent, fully renovated single-storey property that combines modern design, efficiency and functionality (...)
€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,445,000
TSEA5156122
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Exclusive Estepona Beachfront Villa — €50,000 Price Reduction, Split-Home Flexibility
Discover the rare opportunity to own a luxury beachfront villa in sought-after Villacana, Estepona, now (...)
€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, (...)
€450,000
TSEA5155927
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 250 Lot Size: 60 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 250 Lot Size: 60 Area: Estepona Region: Andalucía
HOUSE WITH SQUATTER, ONCE REFORMED AND FREE FROM SQUATTERS IT WILL HAVE A MARKET VALUE OF 800K .
Bright semi-detached house in walking distance to Costalita Beach
This beautiful, bright and cosy (...)
€540,000
TSEA5155330
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 323 Lot Size: 201 Region: Andalucía
Beds: 3 Baths: 2 M2: 323 Lot Size: 201 Region: Andalucía
This three-story Mediterranean-style home in Viña Málaga, Torre del Mar, combines charm, comfort, and functionality. It features 3 spacious bedrooms and 3 bathrooms, along with multiple living (...)
€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² (...)
€1,695,000
TSEA5154985
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 422 Lot Size: 3,000 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 422 Lot Size: 3,000 Area: Marbella Region: Andalucía
Finca with Sea & Port Views – Marbella, Urb. Lindasol
Located to the East of Marbella, this 4 bedroom, 3 bathroom finca offers stunning views of the Mediterranean and down to the lively port. (...)
€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 (...)
Current Featured Properties
€1,750,000
Detached Villa in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
AMAZING VIEWS THAT GO ON FOREVER!!!.
This contemporary Mediterranean style villa on the frontline GOLF COURSE of Atalaya with fantastic sea views and views to Gibraltar. 626m2 plot at one level, (...)
€1,500,000
TSEA4689550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
The projects itself as an exclusive residential complex of 15 spacious semi-detached homes, with boutique- style amenities - a fully equipped gym, spa and outdoor swimming pool - enjoying spectacular (...)
€1,485,000
TSEA5115535
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 136 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 136 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, (...)
