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 81 - 100 of 306 €1,499,000
TSEA5076907
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 6 M2: 306 Lot Size: 150 Area: Estepona Region: Andalucía
Beds: 4 Baths: 6 M2: 306 Lot Size: 150 Area: Estepona Region: Andalucía
Semi-Detached House, Estepona, Costa del Sol.
4 Bedrooms, 4 Bathrooms, Built 250 m², Terrace 100 m², Garden/Plot 150 m².
Setting : Beachfront, Close To Shops, Close To Town, Close To Marina, (...)
€570,000
TSEA5076868
- San Roque Club, Costa Del Sol
Beds: 3 Baths: 3 M2: 156 Lot Size: 154 Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Lot Size: 154 Region: Andalucía
Nestled within the prestigious San Roque Club, this beautiful 3-bedroom semi-detached house offers the perfect blend of comfort, privacy, and scenic beauty. Surrounded by nature and two world-class (...)
€390,000
TSEA5076673
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 202 Lot Size: 320 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 202 Lot Size: 320 Area: Estepona Region: Andalucía
This semi-detached house is located in the hills of Sierra Bermeja, in the Forest Hills urbanisation of Estepona, nestled in nature and surrounded by lush vegetation and mountain air.
With a (...)
€460,000
TSEA5075458
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 138 Lot Size: 131 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Lot Size: 131 Area: Mijas and Mijas Costa Region: Andalucía
Semi-Detached Home with Private Garden in Riviera del Sol
Located in a secure and exclusive urbanisation in Riviera del Sol, this semi-detached house is just a few minutes' drive from the beach. The (...)
€205,000
TSEA5075281
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
RENOVATED STUDIO 20 METERS FROM THE BEACH IN CARBAJAL, COMPLETELY RENOVATED AND FURNISHED WITH TOURIST LICENSE, LOCATED JUST ONE STEP FROM THE BEACH, BUS AND TAXI STOP AT THE DOOR, IDEAL FOR HOLIDAYS (...)
€795,000
TSEA5074180
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
Brand new semi detached villa near Atalaya golf course and within easy reach of Atalaya golf club and El Paraiso golf club. The property faces west and has it's own private parking space within the (...)
€399,000
TSEA5071096
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 111 Lot Size: 110 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Lot Size: 110 Area: Mijas and Mijas Costa Region: Andalucía
SEMI-DETACHED HOUSE in Mijas Pueblo
Opportunity to acquire one of the unique properties you can find in the area. The property has 3 bedrooms, 2 full bathrooms, an open-plan kitchen with a living (...)
€750,000
TSEA5070838
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 128 Lot Size: 175 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Lot Size: 175 Area: Marbella East Region: Andalucía
The most beautiful corner house in the complex in Cabopino with incredible panoramic views of the sea, pine forest and golf course. Recently the house has been completely renovated and has large (...)
€81,000
TSEA5067172
- Benamargosa, Costa Del Sol East
Beds: 3 Baths: 2 M2: 106 Lot Size: 86 Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 86 Region: Andalucía
Right in the heart of the charming village of Benamargosa lies this authentic Andalusian village house full of character, history, and plenty of potential for personal touches. The property features (...)
€5,250,000
TSEA5066482
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 716 Lot Size: 329 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 716 Lot Size: 329 Area: Marbella East Region: Andalucía
Situated in the most exclusive location just a minute drive away from the 5-star luxury Puente Romano Hotel and Resort along with the sea promenade, these spectacular semi-detached villas have been (...)
€850,000
TSEA5065054
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 198 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 198 Area: Benahavis Region: Andalucía
Contemporary semi-detached residence available in Marbella Views, Benahavís. Located in a small, exclusive gated community of just 8 homes. This property is a short 10-minute drive from various golf (...)
€1,395,000
TSEA5064280
- Cabopino, Costa Del Sol, Marbella East
Beds: 5 Baths: 3 M2: 314 Lot Size: 309 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 3 M2: 314 Lot Size: 309 Area: Marbella East Region: Andalucía
This stunning semi-detached villa offers panoramic views of the Mediterranean Sea and the lush Cabopino Golf Course, set within the exclusive gated community of Green Hill Marbella. Surrounded by (...)
€6,250,000
TSEA5063695
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 589 Lot Size: 92 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 589 Lot Size: 92 Area: Marbella West Region: Andalucía
Perched in the heart of Marbella's coveted Golden Mile, this development represents the pinnacle of luxury and modern design in a locale renowned for its sophistication and exclusivity.
This (...)
€1,600,000
TSEA5062225
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 139 Lot Size: 262 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Lot Size: 262 Area: Marbella Region: Andalucía
New Development: Prices from 1,600,000 € to 1,600,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 139.00 m2 - 139.00 m2]
Divided into two levels, it consists of a ground floor or entrance level (...)
€1,150,000
TSEA5061334
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 138 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 138 Area: Mijas and Mijas Costa Region: Andalucía
This exquisite property is part of the prestigious Nature Collection by Higuerón Resort, a development that epitomizes luxury, quality, and refined living. As a proud member of the Higuerón Resort (...)
€499,000
TSEA5058766
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 150 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Area: Fuengirola Region: Andalucía
We are proud to present this fantastic semi-detached house for sale in Torreblanca, Fuengirola - just 1.2 km from the beach!
This lovely home features a spacious patio area and a gated driveway with (...)
€485,000
TSEA5058526
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 139 Lot Size: 40 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Lot Size: 40 Area: Mijas and Mijas Costa Region: Andalucía
Southwest facing, impeccably presented, 3 double bedroom, semi-detached villa with views from the upper level to the Mediterranean, located within a small, extremely well-maintained community. The (...)
€750,000
TSEA5058511
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 147 Lot Size: 15 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Lot Size: 15 Area: Marbella East Region: Andalucía
New to the Market! Exclusive Semi-Detached Home in Montepiedra, Nagüeles – Marbella
We are pleased to present this immaculate semi-detached property located in the highly sought-after Montepiedra (...)
€599,000
TSEA5057782
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 230 Lot Size: 100 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 230 Lot Size: 100 Area: Manilva Region: Andalucía
Semi-Detached House, Manilva, Costa del Sol.
4 Bedrooms, 4 Bathrooms, Built 230 m², Terrace 60 m², Garden/Plot 100 m².
Setting : Beachfront, Commercial Area, Beachside, Close To Shops, Close To (...)
€699,000
TSEA5056663
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
NEW SEMI-DETACHED HOUSE WITH BEST THE VIEW & LOCATION.
Newly built semi-detached house in Reviera Del Sol with a fantastic panoramic view and a really good location. The house was completed in (...)
Current Featured Properties
€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 (...)
€443,000
TSEA4027225
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
4 UNITS LEFT
DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!!
Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
€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 (...)
