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 161 - 180 of 306
€411,000
TSEA4877248
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 124 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 411,000 € to 520,000 €. [Beds: 3 - 4] [Baths: 2 - 2] [Built size: 124.00 m2 - 141.00 m2]
Our company is a real estate investment and development group with 80 years (...)
€335,000
TSEA4995277
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 1 M2: 90 Lot Size: 208 Area: Coin Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Lot Size: 208 Area: Coin Region: Andalucía
3 Bedroom Bungalow
This charming 3-bedroom, 1-bathroom bungalow is located in a desirable urbanization on the outskirts of Coín, offering both comfort and convenience. The home is in great (...)
€649,000
TSEA4887670
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 238 Lot Size: 170 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 238 Lot Size: 170 Area: Fuengirola Region: Andalucía
New Development: Prices from 649,000 € to 649,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 238.00 m2 - 238.00 m2]
Exclusive project of 11 semi-detached and semi-detached homes in (...)
€3,500,000
TSEA4992370
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 609 Lot Size: 458 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 609 Lot Size: 458 Area: Marbella Region: Andalucía
Ladies and gentlemen, let us guide you home. Located in the prestigious area of Sierra Blanca offering a prime location, the highest of qualities and details through-out, sea views from every single (...)
€399,000
TSEA4992298
- Benamara, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 89 Area: Estepona Region: Andalucía
Fully Renovated and Move-In Ready – Semi-Detached Home in Benamara, Estepona
This beautifully renovated semi-detached house combines modern design, comfort, and a prime location in the exclusive (...)
€360,000
TSEA4992277
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 92 Lot Size: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Lot Size: 60 Area: Mijas and Mijas Costa Region: Andalucía
Recently renovated 2 bed semi detached villa
the property can be extended to make an additional couple of bedrooms
10 minutes walk to the beaches of Calahonda and close to shops and restaurants
the (...)
€600,000
TSEA4991770
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 212 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 212 Area: Mijas and Mijas Costa Region: Andalucía
Absolutely Amazing front line Golf property! Huge terrasses with lovely views also to the sea from the rooftop. This is a true canvas that is perfect for investment or for a charming & lovely (...)
€635,000
TSEA4991050
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Rare Semi-Detached Bungalow in Miraflores – Walk to Beach & Boardwalk!
Set in the heart of Miraflores, this rarely available semi-detached bungalow is just a 5-minute walk to the beach and (...)
€429,000
TSEA4990777
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 98 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Fuengirola Region: Andalucía
Perfect location, right in the center of Fuengirola, but without any annoying noise. Located in Pueblo Lopez, this house is a gem for renovation. Private parking.
Semi-Detached House, Fuengirola, (...)
€275,000
TSEA4990678
- Periana, Costa Del Sol East
Beds: 5 Baths: 2 M2: 327 Lot Size: 327 Region: Andalucía
Beds: 5 Baths: 2 M2: 327 Lot Size: 327 Region: Andalucía
Beautiful house in the heart of Periana, with an area of approximately 250 m2 and located in an unbeatable area with all services within walking distance, such as pharmacy, bakery, (...)
€1,350,000
TSEA4783264
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 284 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 284 Area: Estepona Region: Andalucía
New Development: Prices from 1,350,000 € to 1,780,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 284.00 m2 - 434.00 m2]
An exclusive boutique development of 14 semi-detached homes ideally (...)
€1,190,000
TSEA4987525
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 166 Lot Size: 168 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 166 Lot Size: 168 Area: Malaga Region: Andalucía
This property, located in one of the most exclusive areas of Málaga, is a unique opportunity for those seeking to combine luxury, comfort, and a prime location near the sea. Situated in Monte (...)
€1,650,000
TSEA4987282
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 4 M2: 171 Lot Size: 44 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 4 M2: 171 Lot Size: 44 Area: Marbella East Region: Andalucía
The Cape is an innovative residential project in Cabopino. This seaside wonder is located in the municipality of Marbella (Malaga), one of the most beautiful spots on Costa del Sol. The house is (...)
€530,000
TSEA4986472
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Charming Semi-Detached Home in Estepona – Prime Location
This delightful semi-detached house in Estepona offers the perfect blend of comfort and convenience. Ideally located just an 8-minute drive (...)
€405,000
TSEA4982734
- Estacion de Cartama, Costa Del Sol, Cartama
Beds: 3 Baths: 3 M2: 135 Lot Size: 190 Area: Cartama Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Lot Size: 190 Area: Cartama Region: Andalucía
Semi-Detached House, Estacion de Cartama, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 135 m², Garden/Plot 190 m².
Located in the popular town of Estacion de Cartama.
The town has plenty of shops (...)
€1,500,000
TSEA4982572
- Tarifa, Costa de la Luz
Beds: 5 Baths: 6 M2: 277 Region: Andalucía
Beds: 5 Baths: 6 M2: 277 Region: Andalucía
Discover this architectural gem in the heart of Tarifa's old town!
This charming 20th-century town house perfectly combines Andalusian style with modern luxury. Recently renovated with top-quality (...)
€369,000
TSEA4981810
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
lovely 3 bedroom chalet with very low community fees of only 12 euro per month. The Chalet is located in the area El Faro nearby a communual pool. The Chalet is recently renovated and has a complete (...)
€295,000
TSEA4981339
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 160 Lot Size: 20 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Lot Size: 20 Area: Estepona Region: Andalucía
Exceptional Opportunity in El Padrón, Estepona – Your Dream Home Awaits
Discover a fantastic opportunity to transform this charming semi-detached house into your ideal dream home. Located in the (...)
€265,000
TSEA4980019
- Cómpeta, Costa Del Sol East
Beds: 4 Baths: 2 M2: 345 Lot Size: 207 Region: Andalucía
Beds: 4 Baths: 2 M2: 345 Lot Size: 207 Region: Andalucía
This charming three-story semi-detached house in Cómpeta is located in a peaceful and well-connected area, perfect for those seeking space and comfort. The property offers 4 bedrooms, all with (...)
€725,000
TSEA4979941
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 165 Lot Size: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 165 Lot Size: 120 Area: Mijas and Mijas Costa Region: Andalucía
Villa for sale in Riviera del Sol, Mijas Costa with 4 bedrooms, 3 bathrooms and south/west facing, with communal swimming pool, private garage (1 beds) and communal garden. Regarding the dimensions, (...)
Current Featured Properties
€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 (...)
€1,300,000
TSEA4639768
- 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 (...)
€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 (...)
