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 (70,36,37,38)
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 (70,36,37,38)
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 (70,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 161 - 180 of 677
€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 (...)
€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 (...)
€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. (...)
Current Featured Properties
€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, (...)
€5,200,000
3 Bed ground floor apartment in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 447 Lot Size: 135 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 447 Lot Size: 135 Area: Marbella Region: Andalucía
PRE LAUNCH, ACT FAST AS THESE WILL GO QUICKLY!!!
The brand new off plan development, of 64 apartments and 32 townhouses. Uniquly located on one of the last avaialable plots on the marbella coast. (...)
€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 (...)
