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 (43,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 (43,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 (43,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 141 - 160 of 306
€825,000
TSEA5016826
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 250 Lot Size: 100 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 250 Lot Size: 100 Area: Benahavis Region: Andalucía
It is a four bedroom semi-detached house in the gated community of Paraiso Bellevue, located in El Paraíso on the New Golden Mile. The property has a south facing and is within walking distance of (...)
€1,300,000
TSEA5016751
- Rincón de la Victoria, Costa Del Sol East
Beds: 4 Baths: 2 M2: 180 Lot Size: 215 Region: Andalucía
Beds: 4 Baths: 2 M2: 180 Lot Size: 215 Region: Andalucía
Beachfront! Semi-detached house in need of renovation with direct access to the beach, a beautiful front garden with the possibility of creating a pool, and a cozy patio at the rear. It is (...)
€495,000
TSEA5015329
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 3 M2: 155 Lot Size: 474 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 3 M2: 155 Lot Size: 474 Area: Alhaurin el Grande Region: Andalucía
Fantastic 2 storey semi detached house for sale on Alhaurin Golf, Alhaurin el Grande. Great entertainment area at the back of the house with a large pool and terrace surrounds, with a huge covered (...)
€950,000
TSEA5014705
- Casares Playa, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 184 Lot Size: 132 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 184 Lot Size: 132 Area: Casares Region: Andalucía
Fantastic semi-detached corner unit with private garden and incredible panoramic seaviews!
Located on the domain of Finca Cortesin, one of Europe's finest golf resorts, Seaviews Villas is a (...)
€756,413
TSEA4199623
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 170 Lot Size: 432 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 170 Lot Size: 432 Area: Estepona Region: Andalucía
New Development: Prices from 756,413 € to 977,500 €. [Beds: 3 - 3] [Baths: 2 - 3] [Built size: 170.00 m2 - 283.00 m2]
IMPORTANT: Some of the photos of the properties you see furnished are only (...)
€549,000
TSEA5014354
- Rincón de la Victoria, Costa Del Sol East
Beds: 5 Baths: 2 M2: 240 Lot Size: 240 Region: Andalucía
Beds: 5 Baths: 2 M2: 240 Lot Size: 240 Region: Andalucía
Bright Semi-Detached House with Stunning Sea Views in Rincón de la Victoria
Discover this beautiful semi-detached house located in one of the most desirable areas of Rincón de la Victoria. Boasting (...)
€885,000
TSEA5013214
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 142 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Area: Fuengirola Region: Andalucía
Welcome to the residence, an exclusive retreat on the truly incomparable Costa del Sol. This groundbreaking project of villas with staggered construction on six levels not only symbolises (...)
€108,000
TSEA5012317
- Canillas de Albaida, Costa Del Sol East
Beds: 5 Baths: 1 M2: 195 Lot Size: 109 Region: Andalucía
Beds: 5 Baths: 1 M2: 195 Lot Size: 109 Region: Andalucía
If you love authentic Andalusia and are looking for a home with history and soul, this could be just the place. Tucked away in a quiet street of Canillas de Albaida, this special village house is (...)
€360,000
TSEA5010754
- Canillas de Aceituno, Costa Del Sol East
Beds: 4 Baths: 3 M2: 203 Lot Size: 1,900 Region: Andalucía
Beds: 4 Baths: 3 M2: 203 Lot Size: 1,900 Region: Andalucía
Nestled in the peaceful and quiet neighborhood of Rio Bermuza, this charming home offers an incredible opportunity to enjoy both privacy and natural beauty. Set on an expansive 1900m2 plot, the (...)
€519,000
TSEA5010751
- Torrox, Costa Del Sol East
Beds: 5 Baths: 3 M2: 207 Lot Size: 207 Region: Andalucía
Beds: 5 Baths: 3 M2: 207 Lot Size: 207 Region: Andalucía
This impressive 207 m2 property in Torrox, Málaga, offers a harmonious blend of space and comfort across three floors. The home boasts five bedrooms, including a generous 13.0 m2 primary bedroom, (...)
€415,000
TSEA5010733
- Cómpeta, Costa Del Sol East
Beds: 3 Baths: 2 M2: 94 Lot Size: 3,091 Region: Andalucía
Beds: 3 Baths: 2 M2: 94 Lot Size: 3,091 Region: Andalucía
Nestled in the gentle hills below Cómpeta, with sweeping views of the surrounding mountains, this charming country house in traditional Andalusian style offers a peaceful retreat for nature lovers (...)
€525,000
TSEA5010229
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 176 Lot Size: 262 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 176 Lot Size: 262 Area: Fuengirola Region: Andalucía
Torreblanca Villa Project
A one-off opportunity to purchase a four-bedroom, 3-bathroom, semi-detached villa with private pool and car parking for at least five vehicles. This could be the ultimate (...)
€899,000
TSEA5008516
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 332 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 332 Area: Benalmadena Region: Andalucía
Discover this stunning home with sea views in one of the most exclusive areas of Benalmádena, where the blue of the Mediterranean merges with the sky in a panoramic view that you can enjoy every day (...)
€650,000
TSEA5008261
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 286 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 286 Area: Marbella Region: Andalucía
Semi-detached house in Marbella, located in one of the most sought-after areas of the city.
The property features 5 bedrooms, 3 full bathrooms, spacious living rooms ideal for family comfort, marble (...)
€5,200,000
TSEA4087282
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 436 Lot Size: 94 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 436 Lot Size: 94 Area: Marbella Region: Andalucía
New Development: Prices from 5,200,000 € to 5,600,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 436.00 m2 - 447.00 m2]
Located on the beachfront in Marbella, this development offers 64 (...)
€475,000
TSEA5005567
- New Golden Mile, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 153 Lot Size: 43 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 153 Lot Size: 43 Area: Estepona Region: Andalucía
Spacious Semi-Detached Home in El Padrón, Estepona
For sale: bright and sunny semi-detached house with south-facing orientation and a private garden, located in one of the most peaceful and (...)
€468,000
TSEA5004580
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 140 Lot Size: 130 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 140 Lot Size: 130 Area: Estepona Region: Andalucía
✨ Charming Semi-Detached House in the Heart of Estepona! ✨
Discover this beautiful semi-detached home in the vibrant town of Estepona, where comfort meets convenience! Boasting a 130 m² private (...)
€649,995
TSEA5002921
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 182 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 182 Area: Mijas and Mijas Costa Region: Andalucía
This gorgeous semi detached house in Miraflores will stun you with its tasteful interior updates and yet it still maintains it's Spanish feel. The ground floor welcomes you with a bright, large (...)
€1,150,000
TSEA5002600
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 190 Lot Size: 300 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 190 Lot Size: 300 Area: Benahavis Region: Andalucía
Welcome to this exquisite semi-detached house with private swimming pool located in the peaceful community of La Quinta Hills, within the prestigious area of Benahavis.
With a total of 163 square (...)
€2,200,000
TSEA5002036
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 6 M2: 625 Lot Size: 545 Area: Marbella Region: Andalucía
Beds: 5 Baths: 6 M2: 625 Lot Size: 545 Area: Marbella Region: Andalucía
Semi-detached villa in the center of Marbella.
The house has a constructed area of 645 m2 on a 545 m2 plot.
It consists of 5 bedrooms, 6 bathrooms, a spacious living room, a large modern fitted (...)
Current Featured Properties
€1,100,000
TSEA4638103
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€1,675,000
TSEA4939003
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 221 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 221 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
€559,500
TSEA5019097
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Charming South-Facing Villa in Peaceful Manilva – Where Comfort Meets Coastal Living
Welcome to your new sanctuary in the heart of Manilva, a quiet and picturesque corner of the Costa del Sol. This (...)
