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 181 - 200 of 306 €160,000
TSEA4979083
- Benamargosa, Costa Del Sol East
Beds: 2 Baths: 1 M2: 39 Lot Size: 1,302 Region: Andalucía
Beds: 2 Baths: 1 M2: 39 Lot Size: 1,302 Region: Andalucía
Nestled in the rolling hills near Benamargosa, this charming chalet is a true green paradise for nature lovers and those seeking tranquility. Surrounded by lush vegetation and a variety of fruit (...)
€2,490,000
TSEA4979035
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 396 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 396 Area: Marbella Region: Andalucía
A divine property located in a prime location just off the famous Golden Mile, close to the Mosque and with Puente Romano at the end of the road within walking distance. You couldn't ask for a more (...)
€1,295,000
TSEA4975258
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 270 Lot Size: 493 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 270 Lot Size: 493 Area: San Pedro Region: Andalucía
Welcome to semi-detached Villa Treetops, an exclusive retreat located in the heart of Guadalmina, one of Marbella's most prestigious neighbourhoods. Combining modern elegance with natural serenity, (...)
€1,375,000
TSEA4973302
- Santa Clara, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 182 Lot Size: 588 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 182 Lot Size: 588 Area: Marbella East Region: Andalucía
HOUSE WITH SEA VIEWS AND LARGE GARDEN IN A SECURED URBANIZATION
Fantastic family home, just a few minutes from the center of Marbella next to the best beaches, close to services and several of the (...)
€255,000
TSEA4972156
- Castellar de la Frontera, Costa de la Luz
Beds: 3 Baths: 2 M2: 180 Lot Size: 380 Region: Andalucía
Beds: 3 Baths: 2 M2: 180 Lot Size: 380 Region: Andalucía
Semi-detached house in Castellar de la Frontera
This semi-detached house offers great potential for those looking for a renovation project and the chance to personalize their home. With 3 bedrooms (...)
€650,000
TSEA4967569
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 397 Lot Size: 600 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 397 Lot Size: 600 Area: Mijas and Mijas Costa Region: Andalucía
Discover this impressive semi-detached house for sale in the prestigious area of El Coto, a unique property that combines comfort, privacy and spacious interior and exterior spaces. With (...)
€836,000
TSEA4966927
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 91 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 91 Area: Estepona Region: Andalucía
Beautiful renovated house in second line beach just 15 meters from the beach, with spectacular views over the Mediterranean Sea and Estepona Mountains.The house has 77m2 useful and 60m2 terraces.
On (...)
€690,000
TSEA4966093
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 185 Lot Size: 585 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 185 Lot Size: 585 Area: Estepona Region: Andalucía
Individual villa, in a gated community composed of 10 individual and semi-detached villas, in the Atalaya area, Monte Biarritz east of Estepona, next to the beach and Atalya Golf. This property, (...)
€265,000
TSEA4964071
- Río de la Miel, Costa Del Sol East
Beds: 4 Baths: 2 M2: 79 Region: Andalucía
Beds: 4 Baths: 2 M2: 79 Region: Andalucía
4-Bedroom Semi detached villa with Stunning Views – Ideal Renovation Project Near Nerja
Discover the potential of this 4-bedroom, 2-bathroom semi detached villa, set in a breathtaking countryside (...)
€1,350,000
TSEA4958254
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 338 Lot Size: 200 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 338 Lot Size: 200 Area: Estepona Region: Andalucía
Semi-Detached House, Costalita, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 337 m², Terrace 100 m², Garden/Plot 200 m².
Setting : Beachside, Close To Golf, Close To Shops, Close To Sea, Close (...)
€260,000
TSEA4958047
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 111 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: Manilva Region: Andalucía
Gorgeous independent house just of the main village center in Manilva village, close to all amenities and in an urbanisation with heated pool, but still within the mountains and with spectacular (...)
€499,000
TSEA4952554
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 3 M2: 180 Lot Size: 320 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 3 M2: 180 Lot Size: 320 Area: Alhaurin el Grande Region: Andalucía
Lovely large semi detached house for sale in Alhaurin el Grande, only 200m from the main road into Alhaurin where you will find within walking distance, bars / restaurants, shops, supermarkets and (...)
€375,000
TSEA4949641
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 2 M2: 129 Lot Size: 100 Area: Estepona Region: Andalucía
Beds: 5 Baths: 2 M2: 129 Lot Size: 100 Area: Estepona Region: Andalucía
wowowooooowww, just reduced with 65000 euros! Are you looking for a fixer upper? THIS COULD BE YOUR DEAL! This is an semi-independent house in need of love, centre of Estepona, owners now very keen (...)
€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 (...)
€950,000
TSEA4938940
- Pedregalejo, Costa Del Sol
Beds: 3 Baths: 2 M2: 200 Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Region: Andalucía
Fantastic semi-detached house in Pedregalejo Alto. Good access to the motorway and the beach.
Large living room with fireplace.
It consists of three large bedrooms, 3 bathrooms and a toilet.
Large (...)
€1,375,000
TSEA4936006
- Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 5 Baths: 4 M2: 278 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 4 M2: 278 Area: Nerja and Malaga East Region: Andalucía
Spectacular semi detached villa with stunning sea views, highlight its excellent condition as well as the qualities, the luminosity of the rooms, the sea views from the interior of the house and its (...)
€515,000
TSEA4934383
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
Situated in the desirable area of Bel Air, this well-maintained semi-detached house offers a comfortable and practical layout across three levels. Built in 1990, the property boasts 145 m² of (...)
€849,900
TSEA4929346
- Nagüeles, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 314 Lot Size: 350 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 314 Lot Size: 350 Area: Marbella Region: Andalucía
Iconic Design. Irreplaceable Views. Timeless Value. 5 Minutes from Manolo Santana in the Golden Mile, 10 Minutes from Victors Beach Chiringuito/the Beach
Perched on the most privileged plot in the (...)
€1,040,000
TSEA4926721
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 204 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Estepona Region: Andalucía
Located in the prestigious gated community of "Las Villas de Santa María," this home enjoys a privileged location in an elevated area, offering spectacular views of the sea, mountains, and (...)
€1,475,000
TSEA4926259
- La Quinta, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 375 Lot Size: 775 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 375 Lot Size: 775 Area: Benahavis Region: Andalucía
Welcome to this a remarkable semi-detached property located in the exclusive community of Las Terrazas de La Quinta. This residence offers a unique combination of elegance, modernity, and potential, (...)
Current Featured Properties
€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 (...)
€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,580,000
TSEA4639777
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 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 (...)
