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 121 - 140 of 306
€599,000
TSEA4810195
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
New Development: Prices from 599,000 € to 599,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 141.00 m2 - 141.00 m2]
An intimate collection of 11 impressive 3 bedroom homes, distributed over 4 (...)
€840,000
TSEA4857709
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 142 Lot Size: 44 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Lot Size: 44 Area: Fuengirola Region: Andalucía
New Development: Prices from 840,000 € to 1,180,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 142.00 m2 - 157.00 m2]
Welcome to the residence, an exclusive retreat on the truly incomparable (...)
€175,000
TSEA5034157
- Olletas, Costa Del Sol
Beds: 1 Baths: 1 M2: 36 Region: Andalucía
Beds: 1 Baths: 1 M2: 36 Region: Andalucía
Charming Fully Furnished Studio Apartment in Olletas, Málaga — Ready to Move In or Rent Out
This fully furnished and equipped studio is ideal as a primary residence or as a rental unit for (...)
€550,000
TSEA5031880
- San Roque Club, Costa Del Sol
Beds: 3 Baths: 3 M2: 162 Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Region: Andalucía
Charming Villa in San Roque Club Golf – Elegance, Privacy, and Comfort
Discover this enchanting villa located in the prestigious San Roque Club Golf residential complex. Spanning 163 m² of (...)
€1,050,000
TSEA4930933
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 180 Lot Size: 250 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Lot Size: 250 Area: Marbella East Region: Andalucía
New Development: Prices from 1,050,000 € to 1,100,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 180.00 m2 - 180.00 m2]
Welcome to this new development, a collection of 14 semi-detached villas (...)
€199,999
TSEA5026900
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 98 Lot Size: 73 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Lot Size: 73 Area: Nerja and Malaga East Region: Andalucía
In the heart of the charming old town of Vélez-Málaga, this stylishly renovated village house awaits you modern, full of light, and thoughtfully laid out to offer a variety of living options. The (...)
€625,000
TSEA5026798
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 128 Lot Size: 172 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Lot Size: 172 Area: Mijas and Mijas Costa Region: Andalucía
This brand-new semi-detached villa, completing construction by the end of 2024, is designed for modern living in a prime location near Málaga.
Located in Mijas Costa with amazing panoramic views of (...)
€650,000
TSEA5026792
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 132 Lot Size: 192 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Lot Size: 192 Area: Mijas and Mijas Costa Region: Andalucía
Discover your dream home! This brand-new semi-detached villa, completing construction by the end of 2024, is designed for modern living in a prime location near Málaga.
Located in Mijas Costa with (...)
€455,000
TSEA5026306
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
Charming Semi-Detached Home in Lower Calahonda – Just 500m from the Beach
We are thrilled to present this delightful semi-detached home in the sought-after area of Lower Calahonda. Nestled within (...)
€635,000
TSEA5025967
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Discover this two-storey semi-detached house located in the quiet and well connected area of Calypso, in Calahonda (Mijas). The property has 4 bedrooms, 2 bathrooms, a large terrace, patio, solarium (...)
€429,000
TSEA5023480
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 58 Area: Nerja and Malaga East Region: Andalucía
NEW REALLY GOOD PRICE, €429,000
Exclusive semi-detached house with roof terrace and stunning views of the Mediterranean Sea, located in the well-kept urbanization Ladera del Mar 2 between Nerja and (...)
€950,000
TSEA4989874
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 3 M2: 186 Lot Size: 116 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 3 M2: 186 Lot Size: 116 Area: Torremolinos Region: Andalucía
New Development: Prices from 950,000 € to 950,000 €. [Beds: 4 - 4] [Baths: 3 - 3] [Built size: 186.00 m2 - 186.00 m2]
New promotion of Luxury Homes with 2, 3 and 4 bedrooms.
It is a promotion (...)
€825,000
TSEA5022115
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 270 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 270 Area: Benahavis Region: Andalucía
Elegant Semi-Detached House with Sea Views in El Paraíso:
Designed for those who love to enjoy life outdoors, this beautiful semi-detached house offers breathtaking sea and nature views from every (...)
€490,000
TSEA5021650
- Campanillas, Costa Del Sol, Marbella
Beds: 6 Baths: 2 M2: 290 Lot Size: 2,451 Area: Marbella Region: Andalucía
Beds: 6 Baths: 2 M2: 290 Lot Size: 2,451 Area: Marbella Region: Andalucía
We are delighted to present this exclusive listing in La Fresneda – Campanillas, a semi-detached six-bedroom home set on a 2,500-square-meter plot, offering the perfect blend of countryside (...)
€295,000
TSEA5020360
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 78 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Mijas and Mijas Costa Region: Andalucía
This charming semi-detached house, nestled within the sought-after Puebla Aida, offers a unique opportunity to own a home in a truly special location. Imagine living in a beautifully maintained (...)
€599,000
TSEA5019445
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 3 M2: 196 Lot Size: 1,200 Area: Coin Region: Andalucía
Beds: 4 Baths: 3 M2: 196 Lot Size: 1,200 Area: Coin Region: Andalucía
STUNNING SEMI DETACHED HOUSE IN COIN
4 BEDROOMS, 3 BATHROOMS
SUPERB URBANISATIOON
PRIVATE GARDEN WITH PRIVATE HEATED POOL
FULLY FURNISHED
UNDERFLOOR HEATING
LOCATED IN GATED COMPLEX WITH 24/7 (...)
€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 (...)
€370,500
TSEA4839676
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Estepona Region: Andalucía
New Development: Prices from 370,500 € to 370,500 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 107.00 m2 - 107.00 m2]
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged (...)
€1,600,000
TSEA5018968
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 239 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 239 Area: Marbella Region: Andalucía
Exclusive Semi-Detached Villa in Valdeolletas, Marbella
We are delighted to present this stunning semi-detached villa with 4 bedrooms, situated in the prestigious area of Valdeolletas, within a (...)
€750,000
TSEA5017006
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 209 Lot Size: 80 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 209 Lot Size: 80 Area: Marbella Region: Andalucía
Semi-Detached House, Marbella, Costa del Sol.
4 Bedrooms, 4 Bathrooms, Built 209 m², Terrace 20 m², Garden/Plot 80 m².
Setting : Town, Commercial Area, Close To Shops, Close To Town, Close To (...)
Current Featured Properties
€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 (...)
€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 (...)
€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 (...)
