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 (41,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 (41,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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 941 - 960 of 3420 €6,450,000
TSEA5062792
- La Quinta, Costa Del Sol, Benahavis
Beds: 6 Baths: 8 M2: 867 Lot Size: 1,932 Area: Benahavis Region: Andalucía
Beds: 6 Baths: 8 M2: 867 Lot Size: 1,932 Area: Benahavis Region: Andalucía
Experience the pinnacle of modern Mediterranean architecture with this brand-new designer villa nestled in the prestigious La Quinta residential enclave of Benahavís. Offering breathtaking panoramic (...)
€659,000
TSEA5062765
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 6 Baths: 4 M2: 296 Lot Size: 1,400 Area: Alhaurin el Grande Region: Andalucía
Beds: 6 Baths: 4 M2: 296 Lot Size: 1,400 Area: Alhaurin el Grande Region: Andalucía
Your Private Rural Retreat: Finca with Pool, Two Guest Homes & Panoramic Views
Set in a privileged location between the picturesque villages of Alhaurín el Grande and Coín, this stunning (...)
€2,850,000
TSEA5062681
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 632 Lot Size: 1,374 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 632 Lot Size: 1,374 Area: Marbella West Region: Andalucía
EXCLUSIVE PROPERTY
This sumptuous Provençal Mediterranean-style villa embodies refinement and authenticity in a verdant setting overlooking one of Marbella's most exclusive golf courses: Las Brisas (...)
€190,000
TSEA5062462
- Villanueva del Rosario, Costa Del Sol, Antequera
Beds: 1 Baths: 1 M2: 104 Lot Size: 4,227 Area: Antequera Region: Andalucía
Beds: 1 Baths: 1 M2: 104 Lot Size: 4,227 Area: Antequera Region: Andalucía
RUSTIC. Dry and undivided olive grove plot located in the Cortijo Alto neighborhood, in the municipality of Villanueva del Rosario, with an area of 4,228 m². It comprises: a separate residential (...)
€450,000
TSEA5062255
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Penthouse frontline golf
Penthouse located in Estepona Golf within the newly built Sunny Golf complex. The community features a swimming pool and outdoor parking, with one parking space included. It (...)
€1,600,000
TSEA5062225
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 139 Lot Size: 262 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Lot Size: 262 Area: Marbella Region: Andalucía
New Development: Prices from 1,600,000 € to 1,600,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 139.00 m2 - 139.00 m2]
Divided into two levels, it consists of a ground floor or entrance level (...)
€599,000
TSEA5062213
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 110 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Casares Region: Andalucía
Magnificent PENTHOUSE with LARGE TERRACE and SOLARIUM. Facing southeast, this stunning property enjoys WONDERFUL SEA and GOLF VIEWS. Located in a well-maintained urbanization, it sits in one of the (...)
€4,950,000
TSEA5061943
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 642 Lot Size: 1,720 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 642 Lot Size: 1,720 Area: Benahavis Region: Andalucía
Exquisite Contemporary Five-Bedroom Villa with Panoramic Platform Setting in the heart of La Quinta, Benahavís. Surrounded by top-tier golf courses and just minutes from Puerto Banús, Marbella, and (...)
€2,950,000
TSEA5061886
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 591 Lot Size: 822 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 591 Lot Size: 822 Area: Estepona Region: Andalucía
This exquisitely crafted contemporary villa situated within a gated community presents breathtaking sea views and an open-concept living space filled with natural light. The floor-to-ceiling glass (...)
€280,000
TSEA5061853
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 2 M2: 600 Lot Size: 9,400 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 2 M2: 600 Lot Size: 9,400 Area: Alhaurin el Grande Region: Andalucía
Shell construction for sale in a unique location by the Fahala River in Alhaurin el Grande.
Looking for a project with character, space and endless potential? This unfinished shell on a plot of 9,400 (...)
€1,950,000
TSEA5061847
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 394 Lot Size: 3,535 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 394 Lot Size: 3,535 Area: Estepona Region: Andalucía
Located in the charming area of Cancelada in Estepona, this spectacular luxury villa offers a unique experience on the Costa del Sol. Just 5 minutes' drive from the paradisiacal beaches of (...)
€5,000,000
TSEA5061757
- Málaga Centro, Costa Del Sol, Malaga
Beds: 14 Baths: 10 M2: 1,102 Area: Malaga Region: Andalucía
Beds: 14 Baths: 10 M2: 1,102 Area: Malaga Region: Andalucía
City Palace, Málaga Centro, Costa del Sol.
14 Bedrooms, 10 Bathrooms, Built 1102 m², Terrace 20 m².
Setting : Town, Commercial Area, Close To Port, Close To Shops, Close To Sea, Close To (...)
€6,499,000
TSEA5061577
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 300 Lot Size: 1,500 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 300 Lot Size: 1,500 Area: Marbella West Region: Andalucía
Modern villa with total privacy situated on a large plot in the prestigious area of Cortijo Blanco, near Puerto Banús in Marbella just two minutes walk from the sea this property has been completely (...)
€657,112
TSEA5061544
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 131 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Casares Region: Andalucía
Penthouse for Sale in Casares with Panoramic Sea and Golf Views. Walking Distance to Beach and Finca Cortesin
This luxury three-bedroom penthouse in Casares offers stunning panoramic views of the (...)
€11,900,000
TSEA5061520
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 6 M2: 425 Area: Marbella Region: Andalucía
Beds: 4 Baths: 6 M2: 425 Area: Marbella Region: Andalucía
This extraordinary residence redefines the standard of modern luxury from the moment you enter. A majestic entrance hall welcomes you with a sense of grandeur that seamlessly continues throughout the (...)
€849,000
TSEA5061439
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 276 Lot Size: 368 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 276 Lot Size: 368 Area: Fuengirola Region: Andalucía
Rare Opportunity: Spacious 4-Bedroom Villa in the Heart of Fuengirola
Nestled in a peaceful cul-de-sac in the vibrant town of Fuengirola, this rare-to-find villa presents a unique opportunity to own (...)
€549,000
TSEA5061406
- Alora, Costa Del Sol, Älora
Beds: 5 Baths: 3 M2: 300 Lot Size: 48,500 Area: Älora Region: Andalucía
Beds: 5 Baths: 3 M2: 300 Lot Size: 48,500 Area: Älora Region: Andalucía
Location
This classic Cortijo, about 40 minutes drive from Málaga airport, is easily accessible for both national and international guests.
The road to the Cortijo is paved and during the route to (...)
€495,000
TSEA5061376
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 5 Baths: 2 M2: 353 Lot Size: 3,749 Area: Alhaurin el Grande Region: Andalucía
Beds: 5 Baths: 2 M2: 353 Lot Size: 3,749 Area: Alhaurin el Grande Region: Andalucía
Spacious country house located on the outskirts of Alhaurin el Grande in a very quiet area with incredible views of the interior landscape.
The house is spread over three floors all fully registered (...)
€265,000
TSEA5061370
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 1 Baths: 1 M2: 40 Lot Size: 11,200 Area: Alhaurin el Grande Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Lot Size: 11,200 Area: Alhaurin el Grande Region: Andalucía
Finca with stunning views for sale in Alhaurín el Grande
This beautiful 11,200 m² finca, perfectly oriented to the sunny south, offers a unique combination of space, comfort and nature. Located in (...)
€1,150,000
TSEA5061334
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 138 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 138 Area: Mijas and Mijas Costa Region: Andalucía
This exquisite property is part of the prestigious Nature Collection by Higuerón Resort, a development that epitomizes luxury, quality, and refined living. As a proud member of the Higuerón Resort (...)
Current Featured Properties
€1,685,000
TSEA4647067
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Fuengirola Region: Andalucía
This new development is an ambitious project consisting of 164 homes surrounded by the natural landscape of El Higueron. The properties are made up of 70 deluxe apartments, 49 garden villas, 25 sky (...)
€1,023,500
TSEA4986727
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 182 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 182 Area: Mijas and Mijas Costa Region: Andalucía
An exclusive residential complex that redefines the concept of home, providing its residents with an experience comparable to that of a five-star hotel. Designed for maximum comfort, it integrates (...)
€518,000
TSEA3955906
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
ELEGANT AND MODERN IN THE HEART OF COSTA DEL SOL. This development is nestled in an incomparable natural environment where the sea meets the mountain and there is golf and all the services of (...)
