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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 4401 - 4420 of 7575 €2,295,000
EMPTY
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
The development is located in a prime enclave, surrounded by parks and landscaped areas, close to a wide variety of sports, healthcare, commercial spaces, and universities. Just 10 minutes from the (...)
€215,000
TSEA4976770
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
*** Andalusian Charm with a Modern Twist – Renovated Townhouse in Mijas Golf ***
Let yourself be seduced by the soul of this charming townhouse located in the picturesque Pueblo Mijitas (...)
€2,000,000
TSEA4976719
- Las Chapas, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 250 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 250 Lot Size: 1,000 Area: Marbella East Region: Andalucía
One Level Villa in one of the most sought-after areas of Las Chapas!
Currently Under Renovation.
The property is being renovated, offering the chance to fully customize it to your liking. You can (...)
€770,000
TSEA4976620
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Penthouse for sale in La Cala Golf. It consists of 3 bedrooms and 2 bathrooms, living room with open kitchen and 240 M2 terrace!
It also has 2 parking spaces included and a storage room.
It (...)
€3,950,000
TSEA4976617
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 5 M2: 739 Lot Size: 1,571 Area: Marbella Region: Andalucía
Beds: 6 Baths: 5 M2: 739 Lot Size: 1,571 Area: Marbella Region: Andalucía
Luxurious Villa with Panoramic Sea and Mountain Views in Marbella
This exclusive villa, located in the prestigious Altos de Los Monteros area, is a masterpiece of elegance, privacy, and impeccable (...)
€1,100,000
TSEA4593817
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 170 Lot Size: 8 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Lot Size: 8 Area: Fuengirola Region: Andalucía
New Development: Prices from 1,100,000 € to 1,790,000 €. [Beds: 3 - 4] [Baths: 3 - 3] [Built size: 170.00 m2 - 187.00 m2]
This project represents an outstanding commitment in the development of (...)
€1,990,000
TSEA4976530
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 504 Lot Size: 912 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 504 Lot Size: 912 Area: Marbella East Region: Andalucía
Most people would buy this villa just for the view to Africa and Gibraltar.
The building is built in German solid style with high standard, modern techniques and home appliances.
Villa Fantastica (...)
€629,000
TSEA4976464
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Estepona Region: Andalucía
Step Into Your Dream Mediterranean Duplex – Oceana Views, Cancelada
As you step through the front door of this stunning 3-bedroom duplex, you're immediately welcomed by a bright and airy open-plan (...)
€575,000
TSEA4976425
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 156 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Benalmadena Region: Andalucía
Allow me to introduce you to this exquisite duplex penthouse, a real estate gem in the prestigious area of El Higuerón, Benalmádena:
Property Description:
Privileged Location:
Located in the (...)
€789,000
TSEA4976416
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 136 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 136 Area: Nerja and Malaga East Region: Andalucía
Townhouse in Torrecilla with large roof terrace and sea views!
Unique opportunity to aquire one of the properties that rarely comes on the market in the Torrecilla area!
HusmanHagberg proudly (...)
€895,000
TSEA4976185
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 275 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 275 Lot Size: 1,000 Area: Mijas and Mijas Costa Region: Andalucía
A wonderfully quiet and private, 4 bed 4 bath detached villa in Mijas Golf. The ground floor offers a large modern kitchen with separate utility room, The double height entrance hall leads to a large (...)
€1,500,000
TSEA4976167
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 300 Lot Size: 630 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 300 Lot Size: 630 Area: Estepona Region: Andalucía
Independent villa with stunning views in Valle Romano Golf, one of the best areas of Estepona.
EXPECTED DELIVERY BY THE END OF 2025.
This luxury villa is currently under construction, allowing for (...)
€599,000
TSEA4976164
- Higueron, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 162 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Fuengirola Region: Andalucía
Luxury Ground Floor Apartment with 3 Bedrooms in El Higuerón, Las Lomas 2
READY TO MOVE IN!
Discover the perfect combination of luxury, comfort, and modern architecture in this stunning (...)
€375,000
TSEA4976143
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 103 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Casares Region: Andalucía
Bright two double ensuite bedroom apartment in Casares Costa with pleasant views of the gardens and the pool.
The property is located within a popular, well established and well run community within (...)
€995,000
TSEA4976140
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 5 Baths: 4 M2: 224 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 4 M2: 224 Area: Sotogrande Region: Andalucía
Exclusive Villa for Sale in Triana, Sotogrande Alto – Elegance and Comfort in a Prime Location
Discover this stunning single-story villa located in the prestigious Triana, Sotogrande Alto. Set on a (...)
€1,350,000
TSEA4976128
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 113 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Estepona Region: Andalucía
Exclusive Seafront Apartment on the Costa del Sol – A Mediterranean Paradise!
Discover this stunning 3-bedroom apartment in an exclusive seafront development, offering breathtaking views of the (...)
€3,450,000
TSEA4976098
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 6 M2: 470 Lot Size: 1,247 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 6 M2: 470 Lot Size: 1,247 Area: Marbella East Region: Andalucía
PANORAMIC-VIEW VILLA FOR SALE IN ELVIRIA | MARBELLA
Modern Villa with Panoramic Views for Sale in Elviria: A Unique Luxury Opportunity on the Costa del Sol
If you are looking for a newly-built (...)
€485,000
TSEA4976056
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Welcome to this exclusive and elegant apartment that offers and spacious residence for you and your family.
Located in the area of Cancelada between Estepona and Marbella, just 5 minutes driving (...)
€1,195,000
TSEA4976017
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€1,525,000
TSEA4976002
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 121 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
Current Featured Properties
€635,000
TSEA3948304
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Lot Size: 86 Area: Fuengirola Region: Andalucía
EVERY DETAIL HAS BEEN TAKEN CARE OF!!!
Located in the northern area of the Torreblanca del Sol Development, in the municipality of Fuengirola. An open block multi-family building with a total of 30 (...)
€365,000
TSEA4545550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
CLOSE TO FABULOUS PUERTO BANUS AND THE BEACHES.
Offering homes from 90m2 to 150m2 with finishes of first QUALITY AND MODERN design. All have a large private terrace, garage space in the building (...)
€1,535,000
TSEA5021377
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 282 Lot Size: 528 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 282 Lot Size: 528 Area: Mijas and Mijas Costa Region: Andalucía
The villas are located in the exclusive Las Farolas Urbanisation of Mijas Costa, an area that blends tranquillity with close proximity to top-tier amenities. Just a few minutes' walk from the (...)
