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 (43,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 (43,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 (43,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 1038
€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 (...)
€419,000
TSEA5159587
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house with no community fees in Las Lagunas (Mijas Costa)
Cozy and bright semi-detached home located in one of the most sought-after areas of Las Lagunas, close to all amenities and (...)
€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 (...)
€640,000
TSEA5158999
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
We invite you to visit this two-level, south-west facing property in the heart of San Pedro, conveniently located close to a wide range of services and infrastructure, nestled in a tranquil (...)
€749,000
TSEA5158900
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beautiful Semi-Detached Villa in Excellent Condition – 325 m² Built
This stunning villa offers space, comfort, and an unbeatable location:
• Ground floor: large, well-kept garden with fruit (...)
€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 (...)
€719,000
TSEA5158141
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic semi-detached villa with private pool and two separate homes for sale on a single plot in the exclusive Capellanía residential area, Alhaurín de la Torre.
This spectacular semi-detached (...)
€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 (...)
€595,000
TSEA5156353
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 189 Lot Size: 578 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Lot Size: 578 Area: La Duquesa Region: Andalucía
Semi-Detached One-Level House with Potential – Prime Location
This is not a move-in ready home. It requires work, and plenty of it. But for the right buyer, the reward will be a highly desirable (...)
€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 (...)
€1,445,000
TSEA5156122
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Exclusive Estepona Beachfront Villa — €50,000 Price Reduction, Split-Home Flexibility
Discover the rare opportunity to own a luxury beachfront villa in sought-after Villacana, Estepona, now (...)
Current Featured Properties
€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 (...)
€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, (...)
€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, (...)
