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 221 - 240 of 771 €1,450,000
TSEA5079052
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 276 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 276 Area: Marbella West Region: Andalucía
Nestled in Nueva Andalucia, this townhouse is a recently renovated, special corner unit with
a unique interior design. This three-floor property offers an open-plan kitchen with Siemens
appliances on (...)
€1,190,000
TSEA5078884
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 200 Lot Size: 25 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Lot Size: 25 Area: Marbella East Region: Andalucía
Nestled within one of Bahía de Marbella's most sought-after beachfront urbanizations, this stunning townhouse offers an unparalleled coastal living experience. Imagine waking up to the sound of the (...)
€270,000
TSEA5078857
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 106 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Casares Region: Andalucía
This is a super, well presented semi-detached townhouse with a private garden, situated in the peaceful and gated urbanisation on the Casares Costa. This is a lovely gated community, with secure (...)
€449,000
TSEA5078359
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 177 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 177 Area: Fuengirola Region: Andalucía
Your New Home Awaits in Torreblanca del Sol, Fuengirola
Imagine living just a 5-minute walk from the beach and the train station, in a peaceful and well-connected area with all essential services at (...)
€279,000
TSEA5078200
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 2 M2: 245 Lot Size: 114 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 2 M2: 245 Lot Size: 114 Area: Alhaurin el Grande Region: Andalucía
Located in the heart of Alhaurin el Grande, sits this spacious and deceptively large four bedroom townhouse, presented in move in ready condition. This property, will appeal to a wide range of (...)
€720,000
TSEA5077666
- Aloha, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 229 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 229 Area: Marbella West Region: Andalucía
A beautifully renovated corner townhouse in the prestigious neighborhood of Nueva Andalucía. Spanning 229 m² of refined living space with an additional 80 m² of sun-drenched terraces, this stylish (...)
€375,000
TSEA5077363
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Opportunity in Benahavís – 3-Bedroom Townhouse Ideal for Living or Investment
Located in the charming and historic village of Benahavís, this beautifully presented 3-bedroom, 2-bathroom townhouse (...)
€349,000
TSEA5077342
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beautifully Reformed 3-Bedroom Townhouse in Bel Air
Step into this bright and airy reformed townhouse, offering 3 spacious bedrooms and 2 modern bathrooms in the sought-after area of Bel Air. (...)
€546,000
TSEA5076790
- El Hornillo, Costa Del Sol East
Beds: 3 Baths: 3 M2: 187 Region: Andalucía
Beds: 3 Baths: 3 M2: 187 Region: Andalucía
For sale: a beautiful and spacious three-story townhouse located in the area of Calle Labiernago del Hornillo.
On the main floor, you'll find a bright and airy open-plan living room and (...)
€190,000
TSEA5076622
- Tolox, Costa Del Sol, Yunquera
Beds: 5 Baths: 1 M2: 177 Lot Size: 55 Area: Yunquera Region: Andalucía
Beds: 5 Baths: 1 M2: 177 Lot Size: 55 Area: Yunquera Region: Andalucía
This charming semi-detached chalet in Tolox, Málaga, is just what you need. With 177 m² spread over 3 floors, this house offers 5 spacious bedrooms, 1 large bathroom, and a fully equipped kitchen. (...)
€520,000
TSEA5076397
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 155 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 155 Area: Estepona Region: Andalucía
Magnificent semi-detached house located in Cancelada village, yet sufficiently secluded to avoid any noise or heavy traffic.
We walk to all the town's amenities, banks, shops, restaurants, etc. (...)
€945,000
TSEA5076373
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 421 Lot Size: 35 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 421 Lot Size: 35 Area: Marbella West Region: Andalucía
Elegant Family Townhouse in the Heart of Nueva Andalucía, Marbella´s Golf ValleyWelcome to this beautifully maintained and spacious townhouse, ideally situated in the prestigious Golf Valley of (...)
€226,000
TSEA5076229
- Algodonales, Costa de la Luz
Beds: 6 Baths: 3 M2: 220 Region: Andalucía
Beds: 6 Baths: 3 M2: 220 Region: Andalucía
Spacious two-story house in the town of Algodonales, Cádiz. Total measuring 255 m2; 220 m2 plus an 18 m2 patio, terrace, and a 17 m2 balcony close to all amenities.
The ground floor consists of 3.5 (...)
€110,000
TSEA5075734
- Cuevas Bajas, Costa Del Sol, Antequera
Beds: 4 Baths: 1 M2: 136 Lot Size: 186 Area: Antequera Region: Andalucía
Beds: 4 Baths: 1 M2: 136 Lot Size: 186 Area: Antequera Region: Andalucía
Charming Village House in Cuevas Bajas (Antequera)
Two-story home located in the heart of Cuevas Bajas, just 20 minutes from the growing Antequera Dry Port. A quiet area, well connected, with all (...)
€1,850,000
TSEA5075620
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 273 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 273 Area: Marbella West Region: Andalucía
Beautifully designed three-story townhouse for sale in Nueva Andalucía's Golf Valley. Recently renovated, the property blends Mediterranean charm with the clean lines and functionality of modern (...)
€173,900
TSEA5075500
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 1 M2: 108 Area: Coin Region: Andalucía
Beds: 3 Baths: 1 M2: 108 Area: Coin Region: Andalucía
TOWNHOUSE FOR SALE
Investment opportunity in the heart of Coín!
We present you this charming townhouse located in a very central area, within walking distance to all the stores, services and (...)
€553,000
TSEA5074165
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 5 Baths: 3 M2: 243 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 3 M2: 243 Area: Fuengirola Region: Andalucía
Townhouse Under Construction
Unique opportunity to finish and customize a spacious townhouse in a prime location.
This partially built property includes:
* Ground floor with front porch, (...)
€660,000
TSEA5074087
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella West Region: Andalucía
INVESTMENT OPPORTUNITY! NUEVA ANDALUCIA, WALKING DISTANCE TO AMENITIES
Townhouse, located in Nueva Andalucía, is just a short walk from the beach in Puerto Banus and only a minute's drive from the (...)
€379,900
TSEA5073976
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 173 Lot Size: 222 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 173 Lot Size: 222 Area: Benalmadena Region: Andalucía
Exquisite 3-Bedroom Townhouse in an Exclusive Community
Discover this beautiful, recently renovated 3-bedroom townhouse that combines modern luxury with a sustainable lifestyle. With solar panels on (...)
€1,160,000
TSEA5073889
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 307 Lot Size: 10 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 307 Lot Size: 10 Area: Marbella Region: Andalucía
Situated in the prestigious Oasis de Nagüeles urbanization on Marbella's sought-after Golden Mile, this spacious 5-level townhouse offers a unique opportunity to create your ideal home in one of the (...)
Current Featured Properties
€599,000
TSEA4765870
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
These impressive homes, set over 4 floors provide 3 bedrooms, 2.5 bathrooms, an ample basement area, private parking, garden, solarium and multiple terraces. The blend of sleek design with the (...)
€817,000
Townhouse in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 139 Lot Size: 22 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Lot Size: 22 Area: Mijas and Mijas Costa Region: Andalucía
SPACIOUS TOWNHOUSES SURROUNDED BY GOLF!!!
This is a gated residential complex with three and four-bedroom townhouses featuring innovative, contemporary design that blends in with beautiful natural (...)
€465,000
TSEA4292032
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
LARGE GARDEN, AMAZING VIEWS AND GYM!!!
In an incomparable enclave with magnificent views, a project of 40 semi-detached and semi-detached houses with 3 and 4 bedrooms with large terraces to enjoy (...)
