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 (70)
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 (70)
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 (70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 666
€299,000
TSEA5159593
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Townhouse, Manilva, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 112 m², Terrace 72 m².
Setting : Country, Village, Close To Shops, Close To Schools, Urbanisation.
Orientation : North (...)
€425,000
TSEA5159269
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Magnificent property situated in a prime beachfront location in the coveted area of Aldea Beach, just a stone's throw from the charming Puerto de La Duquesa. A unique opportunity for those (...)
€470,000
TSEA5159014
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Discover this magnificent townhouse located in an exclusive gated community, just a short distance from the new high-resolution hospital and frontline to a spectacular golf course, offering (...)
€495,000
TSEA5158807
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
This impeccably maintained home, spanning 118 square meters, offers a harmonious blend of luxurious living and serene comfort.
Upon entering, you are greeted by a spacious living area, distinguished (...)
€634,900
TSEA5158789
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Exclusive New Development in Torreblanca del Sol – Fuengirola ✨
Just 500 metres from the beach and with excellent commuter train connections, Mirador del Limonar offers contemporary homes that (...)
€630,000
TSEA5158777
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beachside, 5 minutes from Puerto Banús
Large semi-detached house with 4 bedrooms, 3 bathrooms, a spacious living-dining room with beautiful views of the pool and gardens, in a gated community. It (...)
€449,000
TSEA5158285
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
"Istan" is a town of Arabic origin, located in the Natural Park of Sierra de las Nieves and just 15 kilometres from the beaches of Marbella.
This beautifully completely renovated house can (...)
€875,000
TSEA5158270
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 198 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 198 Area: Manilva Region: Andalucía
A stunning newly built four-story townhouse, this exceptional residence offers three double bedrooms, a spacious south-facing terrace, and an expansive rooftop solarium with panoramic views of the (...)
€485,000
TSEA5158084
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 125 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Istan Region: Andalucía
This beautiful townhouse has been TOTALLY RENOVATED to a high standard and is located in Zahara de Istan, just an 8-minute drive from Marbella's Golden Mile.
The property features a spacious living (...)
€630,000
TSEA5157463
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 136 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Area: Marbella West Region: Andalucía
Bright Semi-Detached Home in Los Naranjos de Marbella, Just 1.5 km from the Beach and Puerto Banús
Located in the prestigious Los Naranjos de Marbella urbanization, this bright and modern (...)
€320,000
TSEA5157442
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
This beautifully renovated townhouse is located in Mijas Golf within walking distance to all amenities and public transport. It is set in the tranquil gardens of a gated, secure community.There are (...)
€825,000
TSEA5157148
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 217 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 217 Area: Estepona Region: Andalucía
Stylish 4-Bedroom Townhouse in Paraiso Hills, Estepona
Located in the sought-after residential community of Paraiso Hills, this beautifully presented 4-bedroom, 3-story townhouse offers the perfect (...)
€650,000
TSEA5157049
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 192 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 192 Lot Size: 30 Area: Estepona Region: Andalucía
Situated in the sought-after community of Montevideo Hills, this spacious renovated 4-bedroom townhouse combines modern comfort with Mediterranean charm. Set within a private, gated development, the (...)
€375,000
TSEA5155180
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
3-bed Townhouse in Benahavís Pueblo – Costa del Sol
Set in the picturesque heart of Benahavís Pueblo, one of Andalusia's most sought-after whitewashed villages, this beautifully presented (...)
€495,000
TSEA5155090
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Located in the sought-after frontline beach development of Bahía Azul in Estepona West, this 2-bedroom townhouse offers an excellent opportunity to renovate and personalise a home in a prime coastal (...)
€949,000
TSEA5155048
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Located in the well-established urbanisation of Tiro de Pichón, this traditional Andalusian townhouse offers 4 bedrooms and 3 bathrooms, set on a 240m2 plot with a built area of 309m2 plus (...)
€625,000
TSEA5155024
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 127 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 127 Area: Casares Region: Andalucía
Exclusive beachfront townhouse in Marina de Casares.
Charming corner house, located in one of the most privileged areas of the Costa del Sol, in Marina de Casares, perfectly situated between the (...)
€565,000
TSEA5154889
- Benamara, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
Corner Townhouse beachside between San Pedro and Estepona. Recently reformed this 4 bed 3 bath property sits in the wonderful Benamara complex walking distance to the beach. Modern brand new open (...)
€955,000
TSEA5154769
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 139 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 139 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to a prestigious gated community in the heart of the Costa del Sol, located in the sought-after area of El Chaparral, just minutes from La Cala de Mijas and Fuengirola. This modern complex is (...)
€1,100,000
TSEA5153719
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 3 M2: 257 Lot Size: 215 Area: Malaga Region: Andalucía
Beds: 4 Baths: 3 M2: 257 Lot Size: 215 Area: Malaga Region: Andalucía
Exclusive home in Pedregalejo, beautifully designed and recently built. Quality, design and location come together in this property to create one of the most desirable houses for sale in the area. (...)
Current Featured Properties
€817,000
Townhouse in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 139 Lot Size: 22 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Lot Size: 22 Area: Mijas and Mijas Costa Region: Andalucía
SPACIOUS TOWNHOUSES SURROUNDED BY GOLF!!!
This is a gated residential complex with three and four-bedroom townhouses featuring innovative, contemporary design that blends in with beautiful natural (...)
€599,000
TSEA4765870
- 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
These impressive homes, set over 4 floors provide 3 bedrooms, 2.5 bathrooms, an ample basement area, private parking, garden, solarium and multiple terraces. The blend of sleek design with the (...)
€445,000
TSEA4989478
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
SECOND LINE BEACH 2 BED/2 BATH TOWNHOUSE – ESTEPONA PROMENADE!
Immaculately maintained and upgraded family townhouse less than 2 minutes walking distance from the emblematic Mirador de Estepona, (...)
