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 121 - 140 of 771 €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 (...)
€2,395,000
TSEA5126059
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 280 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 280 Area: Marbella East Region: Andalucía
Exclusive townhouse in the Golden Mile, located in the prestigious Monte Marbella Club, in Lomas de Puente Romano.
Fully renovated with high-quality materials and elegant design, this property (...)
€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 (...)
€360,000
TSEA5121952
- Torrox Costa, Costa Del Sol East
Beds: 4 Baths: 3 M2: 170 Region: Andalucía
Beds: 4 Baths: 3 M2: 170 Region: Andalucía
Modern 4-Bedroom House with Sea Views and Rooftop Terrace – Costa del Sol
This stylish and well-maintained home offers 4 bedrooms, 3 bathrooms, and three south-facing terraces, including a (...)
€179,000
TSEA5121838
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 74 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 74 Area: Nerja and Malaga East Region: Andalucía
Recentely renovated corner townhouse situated in the heart of Velez Malaga, in the Plaza San Francisco near the town hall. Only 6 km from the beautiful beach in Torre Del Mar.
- Total indoor area: (...)
€678,000
TSEA5121835
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Stunning Renovated Townhouse in the Heart of Estepona's Old Town – Just Steps from the Beach.
Located in a prime south-facing corner position, this beautifully renovated townhouse combines (...)
€265,000
TSEA5121439
- Almogía, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 102 Lot Size: 93 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Lot Size: 93 Area: Malaga Region: Andalucía
Once-in-a-Lifetime Country House in Montorosso, Almogía – Ibiza Vibes in the Andalusian Hills
Fully Furnished | Saltwater Pool | Move-in Ready
Escape to your own private paradise in this (...)
€3,450,000
TSEA5121085
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Situated on the frontline of the New Golden Mile, between Puerto Banús and Estepona, this exceptional townhouse offers a unique blend of coastal luxury, privacy, and resort-style amenities. Located (...)
Current Featured Properties
€985,000
TSEA4713565
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Branded Residence comprising of 58 incredible 2 and 3 bedroom frontline golf homes to be built to the highest specification overlooking the renowned La Cala Resort Golf course. Reaching the (...)
€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 (...)
€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 (...)
