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 101 - 120 of 677 €749,000
TSEA5129923
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 202 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 202 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful modern townhouse in a gated community of only 40 houses located within La Cala Golf. South facing with frontline golf views the property has 3 bedrooms and 2.5 bathrooms. The living area is (...)
€695,000
TSEA5129860
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Community has aproved the touristic liscense
Completed in 2023, this elegant 3-bedroom, 3-bathroom townhouse is part of the prestigious Eden development by Kronos, located just a five-minute walk (...)
€832,100
TSEA5129755
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 232 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 232 Area: Estepona Region: Andalucía
Set in a quiet, sought-after residential area in the very heart of Estepona, this contemporary corner townhouse, completed in October 2019, offers luxury, comfort, and sustainability—perfect as a (...)
€1,851,000
TSEA5129251
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 441 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 441 Area: Marbella West Region: Andalucía
We offer this spacious house for sale, located in the coastal town of Marbella, province of Málaga. It has a built area of 441 m², distributed among three bedrooms, a living-dining room, a kitchen, (...)
€421,000
TSEA5128690
- Ciudad Jardín, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 178 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 178 Area: Marbella Region: Andalucía
Hello! I want to offer you an excellent opportunity in a quiet area of Málaga Capital: a charming townhouse located in Monte Dorado. This property is distributed over two floors and has a small (...)
€690,000
TSEA5127274
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
Exclusive 3-Bedroom Townhouse in One of Marbella's Finest Areas
Discover this magnificent three-storey home located in a peaceful and well-maintained gated community of just 36 houses, in one of the (...)
€850,000
TSEA5126953
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
We are pleased to offer this distinguished townhouse in the prestigious Costa del Sol, located just a 5-minute walk from the emblematic seafront promenade of San Pedro de Alcántara.
Strategically (...)
€419,500
TSEA5126938
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Bright and spacious three-storey townhouse, located in the charming Sitio de Calahonda. Just a short walk from the vibrant shopping centres and delicious restaurants along Avenida de España, this (...)
€346,000
TSEA5126557
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 85 Lot Size: 30 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 30 Area: Marbella East Region: Andalucía
Renovated townhouse with sea views in Reserva de Marbella
Located in one of the quietest areas of Reserva de Marbella, this townhouse offers the perfect combination of comfort, natural light, and (...)
€78,900
TSEA5125402
- Periana, Costa Del Sol East
Beds: 4 Baths: 2 M2: 81 Region: Andalucía
Beds: 4 Baths: 2 M2: 81 Region: Andalucía
Attention investors and project lovers!
Townhouse for sale to finish renovating in Periana, Málaga. A property with incredible potential and, most importantly, already done.
✅ 3 FLOORS + PRIVATE (...)
€649,000
TSEA5125180
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 185 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 185 Area: San Pedro Region: Andalucía
Discover this charming three-storey townhouse, offering the perfect balance of comfort, style, and functionality, nestled within a peaceful and well-maintained residential community — ideal for (...)
€1,260,000
TSEA5125072
- Pedregalejo, Costa Del Sol
Beds: 5 Baths: 2 M2: 196 Region: Andalucía
Beds: 5 Baths: 2 M2: 196 Region: Andalucía
Are you looking for a property to fully renovate in a privileged setting? This is a rare opportunity. Located right on the beachfront promenade of Pedregalejo, in Málaga East, this charming (...)
€499,000
TSEA5125000
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 132 Lot Size: 30 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 132 Lot Size: 30 Area: Marbella East Region: Andalucía
STUNNING TOWNHOUSE in Cabopino/Artola Alta!
This beautiful well maintained townhouse over 3 levels is located next to the Cabopino Golf Marbella golf course and when entering it gives you the (...)
€188,000
TSEA5124985
- Castellar de la Frontera, Costa de la Luz
Beds: 3 Baths: 1 M2: 91 Region: Andalucía
Beds: 3 Baths: 1 M2: 91 Region: Andalucía
A BEAUTIFUL HOUSE FOR SALE IN CASTELLAR DE LA FRONTERA. Castellar de la Frontera is a beautiful village located in the campo of Gibraltar, surrounded by nature with the charm of the White Villages (...)
€870,000
TSEA5124097
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 4 M2: 113 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 4 M2: 113 Area: Nerja and Malaga East Region: Andalucía
New Development in Fuente del Badén, Nerja
Prices from €870,000 to €990,000
[Beds: 3] [Baths: 4] [Built size: 112 m²]
We're pleased to introduce a fantastic new development in the sought-after (...)
€650,000
TSEA5123890
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 210 Lot Size: 25 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 210 Lot Size: 25 Area: Marbella West Region: Andalucía
Townhouse Nueva Andalucía
Gated community – Condes de Iza, Nueva Andalucía
Spacious and bright 4-bedroom, 3-bathroom townhouse, ideal for families or professionals seeking comfort, security, (...)
€365,000
TSEA5123158
- New Golden Mile, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 37 Lot Size: 12 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 37 Lot Size: 12 Area: Estepona Region: Andalucía
This unique little townhouse offers a lot of authentic charm, set within a beachfront development resembling an Andalusian pueblo.
The property is accessed through a private front garden and is built (...)
€745,000
TSEA5123062
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 218 Lot Size: 59 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 218 Lot Size: 59 Area: Estepona Region: Andalucía
Stunning Newly Renovated 4-Bedroom Home in Prime Location
This beautifully reformed 4-bedroom, 4-bathroom home, perfectly situated in a highly sought-after gated community. Offering a blend of (...)
€179,000
TSEA5122801
- Almayate, Costa Del Sol East
Beds: 3 Baths: 1 M2: 64 Region: Andalucía
Beds: 3 Baths: 1 M2: 64 Region: Andalucía
Townhouse, Almayate, Costa del Sol East.
3 Bedrooms, 1 Bathroom, Built 64 m², Terrace 15 m².
Setting : Beachfront.
Orientation : South.
Condition : Good.
Furniture : Optional.
Kitchen : Fully (...)
€350,000
TSEA5122687
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Lot Size: 30 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 30 Area: Marbella East Region: Andalucía
Semi-detached house in the Marbella reserve area.
Direct access from the garage door, it is also allowed to park the car at the same door.
Large front patio with awning and a storage room.
On the (...)
Current Featured Properties
€580,000
TSEA4941487
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Discover 19 stunning homes that combine nature and sea. With elegant details, spacious terraces and fitted kitchens, you will enjoy exceptional living in the heart of Mijas. Immerse yourself in a (...)
€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, (...)
€470,250
TSEA5065117
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
