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 181 - 200 of 749 €749,000
TSEA5108851
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
NEW EXCLUSIVE LISTING !
Just steps from the sea, this beautifully renovated townhouse is located in the highly sought-after Laguna Beach urbanization in Estepona.
Spread over two floors, the (...)
€390,000
TSEA5108503
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 2 M2: 103 Lot Size: 27 Area: Manilva Region: Andalucía
Beds: 4 Baths: 2 M2: 103 Lot Size: 27 Area: Manilva Region: Andalucía
Townhouse in Manilva – Enjoy peace and style on the Costa del Sol
Welcome to this lovely townhouse located in a peaceful residential urbanization in Manilva. Spread over two floors, this home (...)
€875,000
TSEA5108419
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 218 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 218 Area: Marbella Region: Andalucía
Family townhouse located in Marbella's old town, just a few meters from Plaza de Los Naranjos.
The house is located between two pedestrian streets, with entrance from either street.
Distributed over (...)
€574,950
TSEA5107501
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 157 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 157 Area: Marbella East Region: Andalucía
A very rare opportunity to invest in a beautifully-appointed, south-west-facing townhouse in Las Lomas de Cabopino; a very popular, gated-community of preferred location in Marbella East, only (...)
€445,000
TSEA5107336
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 158 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 158 Area: Estepona Region: Andalucía
***Elegant Boutique Community Living*** Ibergolf is an exclusive and intimate residential enclave nestled within the serene surroundings of Azata Golf, Estepona. This beautifully appointed property (...)
€640,500
TSEA5107063
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Experience the perfect blend of comfort, style, and Mediterranean charm in this beautifully designed modern townhouse. Set in a peaceful residential area, this home offers a calm retreat while still (...)
€800,000
TSEA5106922
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 280 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 280 Area: Mijas and Mijas Costa Region: Andalucía
Sea Views, Multiple Incomes, Unlimited Potential – Welcome to Your Mijas Investment
Set in one of Mijas' most sought-after locations, this exclusive multi-unit property combines the charm of (...)
€449,000
TSEA5105896
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Mijas and Mijas Costa Region: Andalucía
Charming Townhouse in the Idyllic Puebla Aida Community!
Welcome to this tastefully decorated townhouse in the highly sought-after and picturesque community of Puebla Aida—an area reminiscent of (...)
€599,000
TSEA5105836
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 115 Area: Marbella West Region: Andalucía
Spacious 3-Bedroom Duplex in Miragolf, Nueva Andalucía – Steps from the Golf Course
Located within the sought-after Miragolf complex in Nueva Andalucía, this elegant duplex townhouse offers the (...)
€395,000
TSEA5105716
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 3 M2: 217 Lot Size: 100 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 3 M2: 217 Lot Size: 100 Area: Alhaurin el Grande Region: Andalucía
Price reduction!
Fantastic 3 storey townhouse for sale in Las brisas, Alhaurin golf, Alhaurin el Grande.
The property has a private parking space out front and only a few stairs down to the front (...)
€1,495,000
TSEA5105251
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 240 Lot Size: 60 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 240 Lot Size: 60 Area: Marbella West Region: Andalucía
Welcome to this charming 4-bedroom townhouse! Nestled in the cozy residential development of Los Potros, this luxuriously renovated home exudes Spanish charm and boasts beautifully landscaped (...)
€425,000
TSEA5104858
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 150 Lot Size: 60 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Lot Size: 60 Area: Mijas and Mijas Costa Region: Andalucía
TOWNHOUSE WITH SOUL AND GREAT POTENTIAL IN LA CASITA COLORADA – HACIENDA DE MIJAS
We present this charming townhouse located in one of the most peaceful and green areas of the Costa del Sol: La (...)
€249,000
TSEA5104723
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 2 M2: 115 Area: Coin Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Coin Region: Andalucía
Nice townhouse with three bedrooms in a very central area of Coín.
Comfortable house distributed on two floors with 115 m2 useful approximately. On the first floor we find a toilet, living room, (...)
€520,000
TSEA5104381
- Benajarafe, Costa Del Sol East
Beds: 2 Baths: 2 M2: 101 Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Region: Andalucía
Beachfront with boho style and direct sea views
Looking for a unique home with a Mediterranean soul and direct access to the sand? Welcome to Casa Bali Beach, a bohemian gem right on the beach, just (...)
€715,000
TSEA5104135
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 265 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 265 Area: Mijas and Mijas Costa Region: Andalucía
Beautifully presented townhouse with only the top finishes used offering an abundance of outside space plus a selection of 18 hole golf courses on your doorstep and a luxurious 4 star hotel to match. (...)
€190,000
TSEA5104129
- Cómpeta, Costa Del Sol East
Beds: 2 Baths: 2 M2: 126 Region: Andalucía
Beds: 2 Baths: 2 M2: 126 Region: Andalucía
Beautiful 2 bedroom Townhouse in the heart of Competa.
This corner terraced townhouse can be found in the heart of the beautiful Moorish white village of Competa, close to all local shops and (...)
€379,000
TSEA5101006
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Bright and Cozy Townhouse in El Paraíso – Ideal for Living or Investment
Discover this charming 2-bedroom, 2-bathroom townhouse spread over two floors, located in one of the most sought-after (...)
€395,000
TSEA5085520
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 210 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 210 Area: Benahavis Region: Andalucía
Elegant Townhouse in El Casar, Benahavís
Discover this charming three-bedroom townhouse located in the prestigious El Casar development, just a short walk from all municipal amenities in the heart (...)
€345,000
TSEA5085484
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 110 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Malaga Region: Andalucía
For sale, a charming corner house that exudes the allure of traditional popular architecture in Málaga. This property is located in the Molinillo neighborhood, in the central district of Málaga. (...)
€495,000
TSEA5084074
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 131 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 131 Area: Estepona Region: Andalucía
Located within the exclusive El Campanario area of Estepona, this elegant corner townhouse is part of a peaceful development of just 47 homes. Designed with traditional Andalusian architecture, the (...)
Current Featured Properties
€620,000
Townhouse in Istan
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 3 M2: 197 Area: Istan Region: Andalucía
Beds: 3 Baths: 3 M2: 197 Area: Istan Region: Andalucía
STUNNING MOUNTAIN AND SEA VIEWS!!!
This new development encompasses precisely this combination of the best of the mountains and coast on Costa del Sol. Originally the location of an ancient oil mill (...)
€730,000
Townhouse in Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
STYLISH AND ENERGY EFFICIENT IN BEAUTIFUL ESTEPONA.
This boutique development of ten 4-bed, 3-bath luxury villas offer private gardens with beautiful sea, golf and mountain views. With unique (...)
€653,000
TSEA4428304
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
