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,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 (70,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 (70,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 41 - 60 of 677
€1,695,000
TSEA5148439
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 4 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
This is a stunning, recently refurbished townhouse located in the prestigious Azalea Beach area, just a short stroll from the world-famous Puerto Banús. Positioned between San Pedro and Puerto (...)
€916,000
TSEA5148295
- Gaucín, Costa Del Sol, Gaucin
Beds: 4 Baths: 3 M2: 569 Lot Size: 377 Area: Gaucin Region: Andalucía
Beds: 4 Baths: 3 M2: 569 Lot Size: 377 Area: Gaucin Region: Andalucía
Large charming townhouse with swimming pool for sale in Gaucín, Málaga, Andalusia. At the very entrance of the enchanting white village of Gaucín lies this four-story townhouse, full of character (...)
€360,000
TSEA5148286
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 164 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 164 Area: La Duquesa Region: Andalucía
This charming 3-bedroom, 2-bathroom semi-detached home offers the perfect balance of comfort and lifestyle in the sought-after Duquesa area.
On entering the property, you find a guest toilet and (...)
€1,170,000
TSEA5148274
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 240 Lot Size: 100 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 240 Lot Size: 100 Area: San Pedro Region: Andalucía
This beautifully renovated 5-bedroom townhouse is perfect for golf lovers and anyone who enjoys peace, privacy, and open green spaces. The bright and modern interior offers comfortable living (...)
€849,000
TSEA5148235
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 214 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 214 Area: Fuengirola Region: Andalucía
Exclusive Townhouse in Fuengirola – Close to Everything!
Welcome to a charming and family-friendly community with only ten homes, where it is easy to feel at home. This townhouse is located in one (...)
€674,000
TSEA5147905
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Area: Mijas and Mijas Costa Region: Andalucía
Why wait for a new build when you can enjoy this unique living experience right away?
This exceptional townhouse gives you the feeling of being the first owner, even though you would be the second. (...)
€415,000
TSEA5147173
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 213 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Manilva Region: Andalucía
Fantastic townhouse in Bahía de las Rocas!
This spacious property combines comfort, style, and breathtaking scenery, offering spectacular views of Gibraltar and the African coast from its rooftop (...)
€150,000
TSEA5147128
- Humilladero, Costa Del Sol, Antequera
Beds: 5 Baths: 1 M2: 333 Area: Antequera Region: Andalucía
Beds: 5 Baths: 1 M2: 333 Area: Antequera Region: Andalucía
Investment Opportunity in Humilladero
This 1975 townhouse presents a rare opportunity to create a spacious family home or a highly attractive investment in one of inland Málaga's most accessible (...)
€458,000
TSEA5147110
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 4 Baths: 2 M2: 140 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 2 M2: 140 Area: Benalmadena Region: Andalucía
This magnificent townhouse in Oasis Benalmar is the perfect opportunity for those seeking a move-in ready home in one of the most attractive and family-friendly areas of Benalmádena. The development (...)
€170,000
TSEA5146717
- Ronda, Costa Del Sol, Ronda
Beds: 4 Baths: 1 M2: 28 Area: Ronda Region: Andalucía
Beds: 4 Baths: 1 M2: 28 Area: Ronda Region: Andalucía
Living in a townhouse in Ronda is not just a transaction – it is an invitation to embrace a way of life woven with charm and authenticity. It means surrendering to the dreamlike rhythm of cobbled (...)
€495,000
TSEA5146699
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 206 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 206 Area: Mijas and Mijas Costa Region: Andalucía
Discover this charming 3-bedroom, 3-bathroom townhouse that has been meticulously maintained and is ready for you to call home. As you step inside, you'll immediately notice the thoughtful layout (...)
€850,000
TSEA5146675
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 4 M2: 189 Area: Marbella Region: Andalucía
Beds: 7 Baths: 4 M2: 189 Area: Marbella Region: Andalucía
A two-story building in need of restoration, featuring several bedrooms and two small, independent apartments with several terraces and patios.
The property is located between two streets, with (...)
€399,000
TSEA5146663
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 154 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 154 Area: Alhaurin el Grande Region: Andalucía
Beautifully renovated townhouse on Alhaurin Golf,
the current owners have tastefully improved the house with new open plan kitchen and new bathrooms,
on the ground floor you find a large open plan (...)
€449,000
TSEA5146189
- Monda, Costa Del Sol, Marbella
Beds: 6 Baths: 3 M2: 225 Area: Marbella Region: Andalucía
Beds: 6 Baths: 3 M2: 225 Area: Marbella Region: Andalucía
This beautifully renovated large townhouse is perfectly situated in the very center of the charming village of Monda. Spread across four floors; ground, first, second, and a stunning rooftop (...)
€210,000
TSEA5146159
- Yunquera, Costa Del Sol, Marbella
Beds: 5 Baths: 2 M2: 165 Area: Marbella Region: Andalucía
Beds: 5 Baths: 2 M2: 165 Area: Marbella Region: Andalucía
Charming Semi-Detached Townhouse in Yunquera
Discover this spacious 3-storey semi-detached townhouse located in the picturesque village of Yunquera, offering the perfect blend of traditional charm (...)
€269,000
TSEA5145838
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 2 M2: 98 Area: Coin Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Coin Region: Andalucía
Stylishly renovated Townhouse in the heart of Coín village.
This beautifully renovated townhouse combines modern style with traditional charm, offering a high-quality finish throughout. Perfectly (...)
€895,000
TSEA5145268
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 362 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 362 Area: Benahavis Region: Andalucía
This beautifully presented 3 level townhouse combines space, comfort, and privacy with exceptional views. Offering 3 bedrooms, 2 bathrooms, and a guest toilet, the home is in excellent condition (...)
€340,000
TSEA5144971
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
This is a beautiful 3 bedroom townhouse located in the upper part of the Mijas Golf estate and therefore offering amazing panoramic sea views all the way to Fuengirola and mountain views across the (...)
€770,000
TSEA5144263
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 468 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 468 Area: Benahavis Region: Andalucía
Beautiful townhouse in the prestigious Los Jaralillos community, located in the sought-after El Paraíso area of Benahavís. Within walking distance to the beach, golf courses, shops, restaurants, (...)
€360,000
TSEA5143993
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 120 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 120 Area: Nerja and Malaga East Region: Andalucía
Beautiful Townhouse for Sale in Nerja with Stunning Panoramic Views over town. Located in a popular and peaceful urbanisation, this beautifully presented townhouse offers the perfect combination of (...)
Current Featured Properties
€825,000
TSEA4340413
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
€1,595,000
TSEA5010322
- La Heredia, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
STUNNING 5-BEDROOM TOWNHOUSE WITH PANORAMIC SEA, MOUNTAIN AND GOLF VIEWS
Located in the award winning village of La Heredia, close to Benahavis on the Ronda road, this beautiful 5-bedroom townhouse (...)
€730,000
Townhouse in Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
STYLISH AND ENERGY EFFICIENT IN BEAUTIFUL ESTEPONA.
This boutique development of ten 4-bed, 3-bath luxury villas offer private gardens with beautiful sea, golf and mountain views. With unique (...)
