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,42,43,44,45)
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,42,43,44,45)
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,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 3305
€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 (...)
€735,000
TSEA5159485
- Istán, Costa Del Sol, Istan
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Lake and Sea View Villa for Sale in Sierra Blanca Country Club, Istan – Investment Opportunity Near Marbella
Set within the prestigious gated community of Sierra Blanca Country Club in Istan, this (...)
€7,800,000
TSEA5159374
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
This fully renovated Andalusian-style villa is set in Rocío de Nagüeles, one of the most prestigious enclaves of Marbella's Golden Mile. Positioned on a 1,965m² south-facing plot beneath the (...)
€395,000
TSEA5159308
- Cártama, Costa Del Sol, Cartama
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Charming 2/3 Bedroom Country Finca, Orchard, Stunning Gardens, A1 Condition
A wonderful opportunity to purchase a deceptively spacious, detached country finca with stunning panoramic views, located (...)
€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 (...)
€375,000
TSEA5158255
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Detached Villa with Pool and Large Plot – Fully Renovated
Discover this charming detached property, perfect for those seeking peace, privacy, and comfort. The house has been completely renovated, (...)
€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 (...)
€399,000
TSEA5158069
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Modern & Spacious 2-Bedroom Bungalow in Atalaya Aparta Golf Complex
Set within the prestigious Atalaya Golf Course, this modern and beautifully designed 2-bedroom bungalow combines comfort, (...)
€3,550,000
TSEA5157937
- Aloha, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Welcome to this exceptional modern villa located in the heart of Nueva Andalucía, offering a seamless blend of style, luxury and comfort.
Set on a generous plot of 1,038m², this beautifully (...)
€3,150,000
TSEA5157496
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Nestled in a quiet residential area of Nueva Andalucía and yet close to all local amenities we find this house for sale. The property has gone through an extensive refurbishment and updating (...)
Current Featured Properties
€1,440,000
TSEA4709815
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 226 Lot Size: 756 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 226 Lot Size: 756 Area: Estepona Region: Andalucía
This new project of villas stands out as an emblem of luxury in perfect harmony with nature, framed by a golf course, and with the charming golden beaches a stone's throw away. It offers the ideal (...)
€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 (...)
€2,400,000
TSEA3878038
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
MODULAR VILLAS IN AN UPSCALE COUNTRY CLUB RESORT!!!
A gated and secure community of villas with club house, spa and gym with verdant Mediterranean gardens and amazing panoramic sea views. located in (...)
