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 (46,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 (46,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 (46,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 61 - 80 of 771
€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
€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 (...)
€2,080,000
TSEA4893667
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 280 Lot Size: 20 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 280 Lot Size: 20 Area: Marbella Region: Andalucía
A community of 27 opulent semidetached homes with expansive rooms, private gardens, swimming pools, and prime sea views can be found in Marbella at The List Rio Real. Because to its multi-level (...)
€470,250
TSEA5065117
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
