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 (56,68,69,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 (56,68,69,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 (56,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 41 - 60 of 752
€165,000
TSEA5149822
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 38 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 38 Area: Manilva Region: Andalucía
Situated in Playa Paraíso, Manilva, this charming duplex apartment enjoys an enviable position just a few steps from a quiet and peaceful stretch of beach.
The area offers a tranquil coastal (...)
€452,000
TSEA5148715
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house for sale located in the exclusive area of Calahonda, Mijas Costa, within a quiet and well-connected residential complex. A unique opportunity to acquire a spacious home on (...)
€599,000
TSEA5148580
- Málaga Centro, Costa Del Sol, Malaga
Beds: 6 Baths: 5 M2: 157 Area: Malaga Region: Andalucía
Beds: 6 Baths: 5 M2: 157 Area: Malaga Region: Andalucía
Townhouse for sale in Malaga - Charming and modern
Discover this magnificent, fully renovated townhouse located on Salamanca's market square in the heart of Malaga. With a floor area of 1,700 sq ft, (...)
€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 (...)
€495,000
TSEA5148283
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 2 M2: 142 Lot Size: 222 Area: Manilva Region: Andalucía
Beds: 4 Baths: 2 M2: 142 Lot Size: 222 Area: Manilva Region: Andalucía
This exceptional 4-bedroom, 3-bathroom semi-detached offers a rare opportunity to live right on the beachfront, with panoramic views of the sea and the pristine, unspoiled Manilva coastline. The (...)
€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 (...)
€1,495,000
TSEA5146540
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 150 Lot Size: 600 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Lot Size: 600 Area: Marbella East Region: Andalucía
Located in the exclusive Arco Iris complex, this fully renovated townhouse combines sophisticated design, modern comfort and a privileged location. Just a few steps from the prestigious Puente Romano (...)
€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 (...)
Current Featured Properties
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
€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 (...)
€461,000
TSEA5038750
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Located in the town of Fuengirola, in the prestigious Torreblanca area, This is an exclusive residential complex consisting of 19 townhouses that offers everything you need for a dream life on the (...)
