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 (48,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 (48,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 (48,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2481 - 2500 of 2656 €5,995,000
TSEA3878467
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 7 Baths: 8 M2: 1,312 Lot Size: 2,500 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 8 M2: 1,312 Lot Size: 2,500 Area: Benahavis Region: Andalucía
Impresive Luxury Frontline Golf Villa in Los Arqueros
The best property in Los Arqueros for sale. Fully equipped luxury frontline golf villa located in Los Arqueros with big plot looking directly to (...)
€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 (...)
€1,750,000
Detached Villa in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
AMAZING VIEWS THAT GO ON FOREVER!!!.
This contemporary Mediterranean style villa on the frontline GOLF COURSE of Atalaya with fantastic sea views and views to Gibraltar. 626m2 plot at one level, (...)
€650,000
TSEA3874405
- Caleta de Vélez, Costa Del Sol East
Beds: 3 Baths: 2 M2: 150 Lot Size: 550 Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Lot Size: 550 Region: Andalucía
Top modern architecture, breathtaking perspectives and the unique flair of the popular port town of Caleta de Vélez, known far beyond the borders of the Costa del Sol: in this beautiful 150m2 (...)
€3,200,000
TSEA3863659
- Frigiliana, Costa Del Sol East
Beds: 9 Baths: 11 M2: 1,600 Lot Size: 16,000 Region: Andalucía
Beds: 9 Baths: 11 M2: 1,600 Lot Size: 16,000 Region: Andalucía
Exclusive and unique of its kind: a 16.000m2 Andalusian vacation resort with horse farm between Frigiliana and Nerja - with a built-up area of more than 1.600m2! In total, the resort has nine (...)
€2,150,000
TSEA3858085
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 206 Lot Size: 12,400 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 206 Lot Size: 12,400 Area: Mijas and Mijas Costa Region: Andalucía
Andalusian Villa located on a plot of 12,000 square meters. With a 3000 m2 garden, mature with some trees over 100 years old, close to schools and shops, with easy access to the highway and close to (...)
€3,500,000
TSEA3856531
- San Enrique, Costa Del Sol, Sotogrande
Beds: 11 Baths: 7 M2: 1,183 Lot Size: 25,000 Area: Sotogrande Region: Andalucía
Beds: 11 Baths: 7 M2: 1,183 Lot Size: 25,000 Area: Sotogrande Region: Andalucía
Gorgeous colonial traditional Andalusian style farmhouse located in the best part of San Enrique de Guadiaro, only five minutes from Sotogrande, the beach and all the Polo facilities in the area are (...)
€1,375,000
TSEA3856450
- Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 461 Lot Size: 2,150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 461 Lot Size: 2,150 Area: Mijas and Mijas Costa Region: Andalucía
Valtocado one of the most renowned and prestigious urbanizations on the Costa del Sol nestled in the Sierra of Mijas. Here you will find some of the finest Villas with spectacular panoramic (...)
€8,400,000
TSEA3855409
- Los Monteros, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 420 Lot Size: 2,467 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 420 Lot Size: 2,467 Area: Marbella East Region: Andalucía
Fantastic opportunity to purchase such a house in this unique location. Frontline beach in los monteros . An absolutely stunning plot in a fantastic beach location.
One of the best plots on the (...)
€4,500,000
TSEA3852340
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 9 Baths: 8 M2: 1,135 Lot Size: 6,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 9 Baths: 8 M2: 1,135 Lot Size: 6,000 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular south-facing luxury villa with one of the best possible sea views on the Costa del Sol, in walking distance famous Mijas village and only 15 min from the airport and about 10 min drive to (...)
€4,500,000
TSEA3851710
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 5 Baths: 5 M2: 485 Lot Size: 1,368 Area: Marbella Region: Andalucía
Beds: 5 Baths: 5 M2: 485 Lot Size: 1,368 Area: Marbella Region: Andalucía
Altos Reales is an exclusive municipality in Marbella, slightly above the Golden Mile, which has a 24 hour security service.
"Safe and secure homes"
With its lush green spaces and no (...)
€9,500,000
TSEA3849802
- Hacienda Las Chapas, Costa Del Sol, Marbella East
Beds: 7 Baths: 9 M2: 1,190 Lot Size: 4,037 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 9 M2: 1,190 Lot Size: 4,037 Area: Marbella East Region: Andalucía
Luxury 7 bedroom villa in Hacienda Las Chapas, Marbella East. It's the most elegant villas district in the eastern part of Marbella. The residential community offers 24 hours security service.
This (...)
€2,200,000
TSEA3838108
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 483 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 483 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
This gorgeous villa is located in the country side of Majadilla del muerto, just a few km from la Cala de Mijas.
It is built in 2007 on a 2500 m2 plot
It has 5 spacious bedrooms and 3 bathrooms with (...)
€1,590,000
TSEA3836239
- Entrerrios, Costa Del Sol
Beds: 5 Baths: 2 M2: 1,000 Lot Size: 72,000 Region: Andalucía
Beds: 5 Baths: 2 M2: 1,000 Lot Size: 72,000 Region: Andalucía
Finca/Cortijo near to Mijas Golf, Mijas Costa - Costa del Sol
Stunning finca for sale totalling 72.000 m² with two independent houses, swimming pool and large warehouse with ample room for stables (...)
€4,950,000
TSEA3834277
- Cabopino, Costa Del Sol, Marbella East
Beds: 8 Baths: 10 M2: 700 Lot Size: 2,400 Area: Marbella East Region: Andalucía
Beds: 8 Baths: 10 M2: 700 Lot Size: 2,400 Area: Marbella East Region: Andalucía
An exceptional location, frontline to one of the best beaches and only 10 minutes drive to Marbella. This stunning property has a unique and sophisticated design that boosts the maximum natural light (...)
€1,750,000
TSEA3830872
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 372 Lot Size: 626 Area: Benahavis Region: Andalucía
Mediterranean style villa on the frontline golf course of Atalaya with fantastic sea views and views to Gibraltar. 626m2 plot at one level, splendid garden, private pool and whirlpool. From the main (...)
€2,400,000
TSEA3830236
- Coín, Costa Del Sol, Coin
Beds: 8 Baths: 12 M2: 1,263 Lot Size: 13,640 Area: Coin Region: Andalucía
Beds: 8 Baths: 12 M2: 1,263 Lot Size: 13,640 Area: Coin Region: Andalucía
Exceptional Finca with guest apartment and stables located in Coin.
Main house is distributed as follow:
Entrance hall, guest toilet, separate fully equipped kitchen, dining room with fireplace, (...)
€169,000
TSEA3812308
- Torrox, Costa Del Sol East
Beds: 3 Baths: 2 M2: 120 Lot Size: 120 Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 120 Region: Andalucía
Traditional village house in a quiet and charming location in the historic center of Torrox. The main square, the health center, banks and stores are within 15 minutes walking distance. There is a (...)
€2,800,000
TSEA3797722
- Hacienda Las Chapas, Costa Del Sol, Marbella East
Beds: 6 Baths: 4 M2: 558 Lot Size: 2,000 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 4 M2: 558 Lot Size: 2,000 Area: Marbella East Region: Andalucía
Completely refurbished family villa located in Hacienda las Chapas, one of the most exclusive residential areas of Marbella, close to beaches, natural park, nightlife and services.
The southern (...)
€1,500,000
TSEA3795868
- Coín, Costa Del Sol, Coin
Beds: 6 Baths: 3 M2: 803 Lot Size: 74,000 Area: Coin Region: Andalucía
Beds: 6 Baths: 3 M2: 803 Lot Size: 74,000 Area: Coin Region: Andalucía
This country house is at PARTIDO GUARO VIEJO, 29130, Coín, Málaga. It is a country house that has 803 m2 and has 6 rooms and 3 bathrooms. Actually it are 2 houses on top of each other with an own (...)
Current Featured Properties
€3,890,000
Detached Villa in Nueva Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Combining luxury and nature in an exceptional environment. Two unique villas built on one floor and designed to enjoy the Mediterranean lifestyle in a relaxed way, (...)
€1,300,000
TSEA4639768
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€8,800,000
Detached Villa in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 7 M2: 1,071 Lot Size: 2,090 Area: Marbella Region: Andalucía
Beds: 6 Baths: 7 M2: 1,071 Lot Size: 2,090 Area: Marbella Region: Andalucía
This development consists of eight contemporary villas in a gated community inside the prestigious Atalaya de Rio Verde urbanization.
All houses have more than 1.000 m2 enclosed areas with a plot (...)
