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 (56,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 (56,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 (56,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 181 - 200 of 752 €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 (...)
€199,000
TSEA5107873
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 1 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 1 M2: 102 Area: Mijas and Mijas Costa Region: Andalucía
"Great Investment Opportunity in Mijas, on the Border with Fuengirola!
Commercial premises with project and license for change of use to residential. Located on a quiet street, just steps away (...)
€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 (...)
Current Featured Properties
€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 (...)
€825,000
TSEA4340413
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
€461,000
TSEA5038750
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Located in the town of Fuengirola, in the prestigious Torreblanca area, This is an exclusive residential complex consisting of 19 townhouses that offers everything you need for a dream life on the (...)
