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 (47,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 (47,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 (47,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 895
€299,000
TSEA5159593
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Townhouse, Manilva, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 112 m², Terrace 72 m².
Setting : Country, Village, Close To Shops, Close To Schools, Urbanisation.
Orientation : North (...)
€425,000
TSEA5159269
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Magnificent property situated in a prime beachfront location in the coveted area of Aldea Beach, just a stone's throw from the charming Puerto de La Duquesa. A unique opportunity for those (...)
€470,000
TSEA5159014
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Discover this magnificent townhouse located in an exclusive gated community, just a short distance from the new high-resolution hospital and frontline to a spectacular golf course, offering (...)
€495,000
TSEA5158807
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
This impeccably maintained home, spanning 118 square meters, offers a harmonious blend of luxurious living and serene comfort.
Upon entering, you are greeted by a spacious living area, distinguished (...)
€634,900
TSEA5158789
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Exclusive New Development in Torreblanca del Sol – Fuengirola ✨
Just 500 metres from the beach and with excellent commuter train connections, Mirador del Limonar offers contemporary homes that (...)
€630,000
TSEA5158777
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beachside, 5 minutes from Puerto Banús
Large semi-detached house with 4 bedrooms, 3 bathrooms, a spacious living-dining room with beautiful views of the pool and gardens, in a gated community. It (...)
€449,000
TSEA5158285
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
"Istan" is a town of Arabic origin, located in the Natural Park of Sierra de las Nieves and just 15 kilometres from the beaches of Marbella.
This beautifully completely renovated house can (...)
€875,000
TSEA5158270
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 198 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 198 Area: Manilva Region: Andalucía
A stunning newly built four-story townhouse, this exceptional residence offers three double bedrooms, a spacious south-facing terrace, and an expansive rooftop solarium with panoramic views of the (...)
€485,000
TSEA5158084
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 125 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Istan Region: Andalucía
This beautiful townhouse has been TOTALLY RENOVATED to a high standard and is located in Zahara de Istan, just an 8-minute drive from Marbella's Golden Mile.
The property features a spacious living (...)
€630,000
TSEA5157463
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 136 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Area: Marbella West Region: Andalucía
Bright Semi-Detached Home in Los Naranjos de Marbella, Just 1.5 km from the Beach and Puerto Banús
Located in the prestigious Los Naranjos de Marbella urbanization, this bright and modern (...)
€320,000
TSEA5157442
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
This beautifully renovated townhouse is located in Mijas Golf within walking distance to all amenities and public transport. It is set in the tranquil gardens of a gated, secure community.There are (...)
€825,000
TSEA5157148
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 217 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 217 Area: Estepona Region: Andalucía
Stylish 4-Bedroom Townhouse in Paraiso Hills, Estepona
Located in the sought-after residential community of Paraiso Hills, this beautifully presented 4-bedroom, 3-story townhouse offers the perfect (...)
€650,000
TSEA5157049
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 192 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 192 Lot Size: 30 Area: Estepona Region: Andalucía
Situated in the sought-after community of Montevideo Hills, this spacious renovated 4-bedroom townhouse combines modern comfort with Mediterranean charm. Set within a private, gated development, the (...)
€685,000
TSEA5156278
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
For sale: a stunning 4-bedroom, 3-bathroom townhouse located in the exclusive Riviera del Sol urbanization. The property is in perfect condition, ready to move into, with spacious, bright interiors (...)
€395,000
TSEA5156059
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Location! Location! Location! Nestled in the heart of Mijas Pueblo, this stunning townhouse is a true gem of the village. Completely renovated to the highest standards, this property boasts (...)
€459,000
TSEA5155246
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
Exclusive Townhouse in Pueblo López, the Heart of Fuengirola ✨
Imagine living right in the center of Fuengirola, with everything at your fingertips, yet enjoying the peace and charm of a true (...)
€375,000
TSEA5155180
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
3-bed Townhouse in Benahavís Pueblo – Costa del Sol
Set in the picturesque heart of Benahavís Pueblo, one of Andalusia's most sought-after whitewashed villages, this beautifully presented (...)
€495,000
TSEA5155090
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Located in the sought-after frontline beach development of Bahía Azul in Estepona West, this 2-bedroom townhouse offers an excellent opportunity to renovate and personalise a home in a prime coastal (...)
€949,000
TSEA5155048
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Located in the well-established urbanisation of Tiro de Pichón, this traditional Andalusian townhouse offers 4 bedrooms and 3 bathrooms, set on a 240m2 plot with a built area of 309m2 plus (...)
€625,000
TSEA5155024
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 127 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 127 Area: Casares Region: Andalucía
Exclusive beachfront townhouse in Marina de Casares.
Charming corner house, located in one of the most privileged areas of the Costa del Sol, in Marina de Casares, perfectly situated between the (...)
Current Featured Properties
€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 (...)
€445,000
TSEA4989478
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
SECOND LINE BEACH 2 BED/2 BATH TOWNHOUSE – ESTEPONA PROMENADE!
Immaculately maintained and upgraded family townhouse less than 2 minutes walking distance from the emblematic Mirador de Estepona, (...)
€349,000
TSEA5077342
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beautifully Reformed 3-Bedroom Townhouse in Bel Air
Step into this bright and airy reformed townhouse, offering 3 spacious bedrooms and 2 modern bathrooms in the sought-after area of Bel Air. (...)
