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 61 - 80 of 752
€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 (...)
€395,000
TSEA5143597
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 114 Lot Size: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Lot Size: 100 Area: Mijas and Mijas Costa Region: Andalucía
Townhouse for sale in Las Lagunas de Mijas
Spacious townhouse for sale located in one of the fastest growing areas of Las Lagunas, at a very competitive price and well below that of any apartment in (...)
€189,900
TSEA5143306
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 74 Lot Size: 74 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Lot Size: 74 Area: Nerja and Malaga East Region: Andalucía
Charming townhouse for sale located in the picturesque old town of Vélez-Málaga, one of the areas with the most history and charm of the Axarquía of Malaga. The property, distributed over two (...)
€549,000
TSEA5143066
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 200 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
This very spacious 3 double bedroom, 3 bathroom townhouse is spread over 4 floors and offers a family a fabulous opportunity to enjoy holidays or residence in high-end quality surroundings. (...)
€685,000
TSEA5142505
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 142 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Area: Marbella Region: Andalucía
This elegant duplex in Santa Clara Golf, Marbella, is spread over two floors, offering spacious and
comfortable areas. On the ground floor, there is a large living room that connects with the (...)
€2,499,000
TSEA5141899
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 5 M2: 375 Lot Size: 1,034 Area: Estepona Region: Andalucía
Beds: 3 Baths: 5 M2: 375 Lot Size: 1,034 Area: Estepona Region: Andalucía
Turnkey ready luxury property for sale in Valle Romano, Estepona West, designed by the prestigious Atlas Group and due for completion in early 2026. This three-story villa combines sleek contemporary (...)
€795,000
TSEA5141764
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 199 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 199 Area: Fuengirola Region: Andalucía
Come and discover this stunning townhouse, designed to combine comfort, technology, and a sustainable lifestyle.
The basement features a spacious garage with room for two cars, and a multi-purpose (...)
€489,000
TSEA5141719
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 5 M2: 239 Area: Manilva Region: Andalucía
Beds: 3 Baths: 5 M2: 239 Area: Manilva Region: Andalucía
**Elegant 3-Storey Townhouse + Basement with Panoramic Sea Views and the Rock of Gibraltar – Manilva**
Discover this exceptional and spacious townhouse, perfectly located in a quiet and secluded (...)
€170,000
TSEA5141044
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 1 M2: 120 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 1 M2: 120 Area: Alhaurin el Grande Region: Andalucía
3-bedroom, 1-bathroom semi-detached house in Alhaurín el Grande. The property needs renovation, it offers excellent potential for customization. Located in a sought-after area, it's ideal for (...)
€398,000
TSEA5140831
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Partially renovated townhouse in Campo Mijas with panoramic views. Spread over 3 floors, it features 3 bedrooms, terraces on every level, a solarium, modern kitchen, and BBQ terrace. Community pool (...)
€699,000
TSEA5140534
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Townhouse for sale at La Capellanía - El Higuerón, Benalmádena
Discover this exclusive semi-detached house located in the prestigious Reserva El Higuerón complex, a privileged enclave on the (...)
€1,100,000
TSEA5139940
- Costabella, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 171 Lot Size: 31 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 171 Lot Size: 31 Area: Marbella East Region: Andalucía
Townhouse with Panoramic Sea Views in Costabella, Marbella East
Discover this outstanding residence in the exclusive enclave of Costabella, Marbella East, where elegance and tranquillity meet the (...)
€555,000
TSEA5139736
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
This charming three-storey semi-detached villa combines comfort, spaciousness and a functional layout, ideal for enjoying with the family.
On the main floor, upon entering the house, we find a (...)
€549,000
TSEA5139616
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
*Unique Opportunity in Torreblanca, Fuengirola – Your Dream Home Awaits!*
Discover this charming terraced house in the heart of Torreblanca, Fuengirola. With a generous 107 m² constructed area (...)
€390,000
TSEA5139130
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Step into your new coastal retreat! This beautifully maintained property offers 3 spacious bedrooms, 2 bathrooms, plus a convenient guest toilet.
Enjoy outdoor living with a private newly tiled (...)
€444,755
TSEA5139070
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Property with potential value, Benalmádena.
This semi-detached house is the strategic investment you are looking for. Its unbeatable location opposite the Torrequebrada International School, (...)
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 (...)
€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 (...)
€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 (...)
