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 (63,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 (63,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 (63,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 321 - 340 of 746 €290,000
TSEA5050981
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beautifully renovated duplex for sale in a quiet area of Las Lagunas, offering extra privacy with no neighbors above or below, only on each side.
Originally a 3-bedroom property, it has been (...)
€549,000
TSEA5050462
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 177 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 177 Area: Fuengirola Region: Andalucía
Beautiful townhouse, ideal for those seeking comfort, style, and an unbeatable location.
Spacious 3-Bedroom Townhouse in Fuengirola – Ideal Coastal Living
Situated in a sought-after urbanisation (...)
€90,000
TSEA5050291
- Archidona, Costa Del Sol, Antequera
Beds: 4 Baths: 1 M2: 154 Area: Antequera Region: Andalucía
Beds: 4 Baths: 1 M2: 154 Area: Antequera Region: Andalucía
GREAT INVESTMENT!
Townhouse with Potential – Reform Needed – in the Historic Heart of Archidona!
Located in the very center of Archidona, this 154 m² townhouse offers a unique opportunity (...)
€535,000
TSEA5050177
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 249 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 249 Area: Mijas and Mijas Costa Region: Andalucía
Experience Luxury and Tranquility at La Cala Golf
Discover this exclusive 3-bedroom, 4-bathroom townhouse located in the heart of La Cala Golf, the largest golf resort in Spain. Perfect for those (...)
€615,000
TSEA5050165
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Beautifully Renovated Townhouse in the Sought-After Beachside McDonald Resort Community.
Nestled in the charming Andalusian-style McDonald Resort, this beautifully updated three-bedroom townhouse (...)
€845,000
TSEA5049418
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 305 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 305 Area: Estepona Region: Andalucía
Unique Townhouse in Dominion Beach – Estepona
5 Bedrooms | 3 Bathrooms | Jacuzzi | 2 Parking Spaces | Rental License
Discover this spacious and stylish 5-bedroom, 3-bathroom townhouse, ideally (...)
€1,995,000
TSEA5049322
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 240 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 240 Area: Marbella East Region: Andalucía
This fully renovated property is located in the desirable area of Altos de Puente Romano, less than a 20 minutes' walk to the well know Puente Romano Hotel, the beach and the promenade that links you (...)
€490,000
TSEA5049223
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 140 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 140 Area: Benalmadena Region: Andalucía
Townhouse, Benalmadena Costa, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 140 m².
Setting : Commercial Area, Close To Shops, Close To Sea, Close To Town, Close To Schools, (...)
€395,000
TSEA5049043
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 147 Lot Size: 300 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Lot Size: 300 Area: Estepona Region: Andalucía
Charming townhouse with sea views in the exclusive urbanization Don Pedro, Estepona.
Located in a quiet and well-kept urbanization just five minutes drive from the center of Estepona and its (...)
€185,000
TSEA5049028
- Alora, Costa Del Sol, Älora
Beds: 4 Baths: 1 M2: 183 Area: Älora Region: Andalucía
Beds: 4 Baths: 1 M2: 183 Area: Älora Region: Andalucía
Charming village house in the centre of Álora - 4 bedrooms, terrace and great potential.
Charming townhouse in the centre of Álora, with independent entrance from the street. This is a traditional (...)
€949,000
TSEA5048650
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 129 Lot Size: 38 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 129 Lot Size: 38 Area: Marbella West Region: Andalucía
Top renovated 4 bedroom townhouse with beautiful golf views
Newly renovated 4-bedroom townhouse located in the heart of the prestigious Aloha area in Nueva Andalucía. This elegant townhouse offers (...)
€695,000
TSEA5048608
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 198 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 198 Area: Estepona Region: Andalucía
Charming Townhouse with Private Garden and Panoramic Sea Views in El Paraíso
Located in a peaceful residential area of El Paraíso, this bright and spacious townhouse offers the perfect balance of (...)
€364,000
TSEA5048593
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 3 M2: 125 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 3 M2: 125 Area: Torremolinos Region: Andalucía
*Large Townhouse with Spacious Spaces and Unbeatable Location!*
This spectacular townhouse, located in La Colina, offers a prime location less than a minute's walk from the commuter train station, (...)
€600,000
TSEA5048548
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 145 Lot Size: 182 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 145 Lot Size: 182 Area: Estepona Region: Andalucía
Welcome to this charming 4-bedroom, 2-bathroom house located in the sought-after Bahia Dorada 4 complex, nestled in the picturesque town of Estepona on the stunning Costa del Sol.
The property (...)
€480,000
TSEA5048374
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 136 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Casares Region: Andalucía
Marina de Casares, charming terraced house.
Located in the sought-after community of Marina de Casares, just moments from the vibrant town of San Luis de Sabinillas, this charming Spanish-style (...)
€450,000
TSEA5048176
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Estepona Region: Andalucía
Spacious End-Terrace Townhouse with Sea Views in Residencial Atalaya Golf
Nestled in the sought-after Residencial Atalaya Golf, this end-terrace townhouse presents an exceptional opportunity for (...)
€155,000
TSEA5047231
- Viñuela, Costa Del Sol East
Beds: 2 Baths: 1 M2: 81 Lot Size: 386 Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Lot Size: 386 Region: Andalucía
Charming opportunity in La Aldea, Viñuela!
Are you looking for a house with character, outdoor space, and lots of possibilities? Here it is!.
Located in the quiet and picturesque area of La Aldea, (...)
€398,000
TSEA5047069
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 136 Lot Size: 8 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Lot Size: 8 Area: Mijas and Mijas Costa Region: Andalucía
Charming Andalusian style townhouse in Mijas Golf!
Located in a peaceful and exclusive setting, it combines Andalusian style charm with modern comfort. Situated in a well-kept urbanization in Mijas (...)
€765,000
TSEA5046961
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 226 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 226 Area: Benahavis Region: Andalucía
Stylish Townhouse in Los Arqueros
Los Almendros – Los Arqueros Golf, Benahavís
3 Bedrooms + 1 Guest/Multi-purpose room/ Apartment
3 ½ Bathrooms | Private garage | Multiple (...)
€550,000
TSEA5046070
- Bel Air, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 275 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 275 Area: Estepona Region: Andalucía
We present to you a stunning townhouse in COSTALITA on the New Golden Mile
5 bedrooms, 3.5 bathrooms, and 2 private underground parking spaces — the perfect
choice for a family or anyone who (...)
Current Featured Properties
€515,000
TSEA4941421
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 149 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 (...)
€720,000
TSEA4713529
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 116 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 (...)
€980,000
TSEA4621648
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
This exclusive project with an elegant Scandinavian design blends harmoniously with the surrounding nature. The architecture of the townhouses follows seamlessly the undulating shapes of the (...)
