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 141 - 160 of 677 €340,000
TSEA5114362
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Lot Size: 190 Area: Mijas and Mijas Costa Region: Andalucía
Charming End-of-Terrace Townhouse in Mijas Golf
This beautifully presented townhouse is located in a small, exclusive urbanisation of just four homes, offering a peaceful setting with a communal (...)
€765,000
TSEA5114287
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Stylish Townhouse with Scenic Views in Aloha Pueblo, Nueva Andalucía
Nestled in the heart of the prestigious Aloha Pueblo community in Nueva Andalucía, this thoughtfully refurbished townhouse (...)
€250,000
TSEA5114215
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Fantastic house for sale located in the coveted neighborhood of San José del Viso, an area undergoing rapid expansion and with all the amenities at your fingertips.
This bright home features 3 (...)
€415,000
TSEA5114212
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 99 Lot Size: 109 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 99 Lot Size: 109 Area: Malaga Region: Andalucía
Charming Casa Mata (Townhouse) with rooftop terrace in a sought-after neighbourhood.
Discover the potential of this bright and spacious casa mata located in a tranquil street, just a short walk from (...)
€950,000
TSEA5113849
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 230 Lot Size: 273 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 230 Lot Size: 273 Area: Sotogrande Region: Andalucía
Town House for sale in La Finca, Sotogrande with 4 bedrooms, 3 bathrooms, 1 toilet and with orientation south/east, with communal swimming pool, private garage (2 parking spaces) and private garden. (...)
€349,000
TSEA5113708
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Amazing single-story townhouse, with the possibility of building another floor above (this information pending confirmation).
With a front and rear porch.
It has a fireplace.
Open-plan kitchen. (...)
€380,000
TSEA5112271
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 127 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Alhaurin el Grande Region: Andalucía
Set in one of the most sought-after areas of Alhaurín Golf, this beautifully presented and much-loved townhouse offers the perfect blend of comfort, style, and convenience. Ideal for permanent (...)
€995,000
TSEA5111875
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 160 Lot Size: 185 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Lot Size: 185 Area: Marbella West Region: Andalucía
Discover this rare opportunity to own a charming townhouse for sale in Los Altos de Aloha, one of the most desirable residential complexes in Nueva Andalucía, Marbella. Perfectly positioned (...)
€425,000
TSEA5111626
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 138 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 138 Area: La Duquesa Region: Andalucía
Townhouse, La Duquesa, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 138 m², Terrace 88 m².
Setting : Frontline Golf, Close To Golf, Close To Port, Close To Town, Close To Marina.
Orientation : (...)
€395,000
TSEA5111614
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 4 M2: 195 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 4 M2: 195 Area: La Duquesa Region: Andalucía
A beautiful townhouse with a large private garden and fantastic terrace, overlooking the fairways of Duquesa Golf. This is located in the highly desirable community Villas del Golf, a pleasant walk (...)
€498,000
TSEA5111575
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 121 Lot Size: 91 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Lot Size: 91 Area: Benalmadena Region: Andalucía
WONDERFUL TOWNHOUSE FOR SALE located in the prestigious and sought-after location, La Reserva del Higuerón.
Situated between Benalmadena and Mijas Pueblo with easy access to highway, beaches and a (...)
€265,000
TSEA5111404
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 72 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 72 Area: La Duquesa Region: Andalucía
This is a charming semi detached townhouse found on a peaceful urbanisation close to the marina of La Duquesa.
The property has 3 bedroom, 2 bathroom, a split level lounge/dining room with a working (...)
€790,000
TSEA5110927
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 154 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 154 Area: Marbella West Region: Andalucía
This beautifully presented townhouse, nestled in the heart of the sought-after Aloha Pueblo, offers the perfect blend of traditional Andalucian charm and modern comfort. Set across two levels with (...)
€525,000
TSEA5110609
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 2 M2: 260 Area: Manilva Region: Andalucía
Beds: 4 Baths: 2 M2: 260 Area: Manilva Region: Andalucía
Renovated Townhouse with Panoramic Sea, Garden, and Mountain Views – Manilva, Costa del Sol
This impressive 230m² townhouse, with 3 terraces, a private garden, and an 80m² enclosed garage, (...)
€195,000
TSEA5110459
- Tolox, Costa Del Sol, Yunquera
Beds: 5 Baths: 2 M2: 168 Area: Yunquera Region: Andalucía
Beds: 5 Baths: 2 M2: 168 Area: Yunquera Region: Andalucía
Spacious Townhouse with Large Basement
. Prime village location next to the countryside
. Light-filled and airy interior
. Spacious basement with separate access – ideal for conversion into (...)
€460,000
TSEA5110243
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 3 M2: 173 Area: Casares Region: Andalucía
Beds: 2 Baths: 3 M2: 173 Area: Casares Region: Andalucía
Luxury Villa Just 5 Minutes from the Beach
Nestled in one of the most sought-after locations, this fully renovated luxury villa offers the perfect blend of elegance, comfort, and functionality. (...)
€537,500
TSEA5110222
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 81 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Marbella East Region: Andalucía
Townhouse, Elviria santa maría, Costa del Sol.
2 Bedrooms, 1.5 Bathrooms, Built 81 m².
With turistic licence
Setting : Close To Golf, Close To Sea, Urbanisation.
Condition : Excellent.
Pool : (...)
€179,800
TSEA5110210
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Fuengirola Region: Andalucía
Your Sweet Seaside Retreat! Ideal Studio in a Prime Location Between Miramar and the Center of Fuengirola, walking distance to the beach
Discover this charming 40 m² studio, perfectly located (...)
€299,000
TSEA5109601
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 5 Baths: 2 M2: 137 Area: Alhaurin el Grande Region: Andalucía
Beds: 5 Baths: 2 M2: 137 Area: Alhaurin el Grande Region: Andalucía
Ideally located in a sought-after area, just a stone's throw away from shops, schools, supermarkets and the bus station, this renovated townhouse offers a warm, comfortable and practical living (...)
€539,000
TSEA5109457
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 234 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 234 Area: Casares Region: Andalucía
Townhouse with panoramic sea views in Casares".
Located in the residential complex Terrazas de Bahía, this townhouse offers a rare combination of sea views, privacy, and convenient access to (...)
Current Featured Properties
€980,000
TSEA4621648
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
This exclusive project with an elegant Scandinavian design blends harmoniously with the surrounding nature. The architecture of the townhouses follows seamlessly the undulating shapes of the (...)
€1,299,000
TSEA4792552
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 374 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 374 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 (...)
€950,000
TSEA4430956
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Exceptional very spacious townhouse located in frontline beach residential complex Belgravia club, Estepona.
This spectacular home has fantastic sea views and the location is unbeatable, just a few (...)
