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 (53,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 (53,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 (53,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 161 - 180 of 749 €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. (...)
€330,000
TSEA5112367
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 65 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Marbella West Region: Andalucía
Located just 1 kilometre from the iconic Puerto Banús, this three-level, Southwest orientated, corner, 1 bedroom townhouse is perfect as a Marbella base. This is a fantastic opportunity at a (...)
€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 (...)
€560,000
TSEA5110996
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
Stylish south east facing, three-bedroom semi detached townhouse located in Riviera del Sol. This property offers bright and spacious interiors filled with natural light and high ceilings. The (...)
€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 : (...)
€700,000
TSEA5109610
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 181 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 181 Area: Estepona Region: Andalucía
Exclusive Townhouse in the Heart of Estepona – Space, Design, and Prime Location at a Price Well Below Market Value
Located in the very heart of Estepona, within one of the most sought-after (...)
€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 (...)
€775,000
TSEA5108920
- Nagüeles, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 235 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 235 Area: Marbella Region: Andalucía
Discover this exceptional 225 m² corner townhouse in an ultra-private gated enclave of just 10 homes on Marbella's prestigious Golden Mile. Perfectly maintained and flooded with natural light, it (...)
€595,000
TSEA5108875
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 124 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 124 Area: Mijas and Mijas Costa Region: Andalucía
Townhouse, Calahonda, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 124 m², Terrace 20 m².
Setting : Frontline Golf, Suburban, Close To Golf, Close To Sea, Close To Town, Urbanisation.
Orientation (...)
Current Featured Properties
€985,000
TSEA4713565
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Branded Residence comprising of 58 incredible 2 and 3 bedroom frontline golf homes to be built to the highest specification overlooking the renowned La Cala Resort Golf course. Reaching the (...)
€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 (...)
€3,650,000
TSEA4450162
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 364 Lot Size: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 364 Lot Size: 106 Area: Estepona Region: Andalucía
Discover coastal living in this exquisite townhome, ideally situated with views of the serene ocean waves . Boasting breathtaking views of both sunrises and sunsets, this home is a true masterpiece (...)
