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 2601 - 2620 of 2656 €1,500,000
TSEA2980193
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 5 Baths: 4 M2: 505 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 4 M2: 505 Area: Benalmadena Region: Andalucía
Detached villa with 5 bedrooms, 4 bathrooms, lounge, kitchen with office, terrace, garden and pool on plot of 5000m2, has parking for 4 vehicles and two independent apartments and beautiful sea (...)
€895,000
TSEA2961143
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 363 Lot Size: 915 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 363 Lot Size: 915 Area: Mijas and Mijas Costa Region: Andalucía
Large Villa with great qualities in Carretera de Mijas area with guest accommodation, lift and orchard.
It is distributed as follows:
Ground floor: Entrance hall, large living room with fireplace (...)
€2,000,000
TSEA2941181
- Torrenueva, Costa Del Sol, Mijas and Mijas Costa
Beds: 9 Baths: 6 M2: 1,100 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 9 Baths: 6 M2: 1,100 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
THE LARGEST HOUSE IN TORRENUEVA IN MIJAS AT WALKING DISTANCE TO THE BEACH AND TO THE MOST POPULAR VILLAGE OF LA CALA WHERE YOU FIND SUPERMARKETS, BARS, SHOPS, RESTAURANTS ETC. THE ROOMS ARE ALL VERY (...)
€5,833,000
TSEA2938691
- Benahavís, Costa Del Sol, Benahavis
Beds: 7 Baths: 7 M2: 1,700 Lot Size: 11,000 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 7 M2: 1,700 Lot Size: 11,000 Area: Benahavis Region: Andalucía
Detached Villa, Benahavís, Costa del Sol.
7 Bedrooms, 7 Bathrooms, Built 1700 m², Terrace 100 m², Garden/Plot 11000 m².
Setting : Frontline Golf, Town, Country, Village, Close To Golf, Close To (...)
€895,000
TSEA2929520
- Archidona, Costa Del Sol, Antequera
Beds: 7 Baths: 5 M2: 3,650 Lot Size: 25,130 Area: Antequera Region: Andalucía
Beds: 7 Baths: 5 M2: 3,650 Lot Size: 25,130 Area: Antequera Region: Andalucía
Fantastically Elegant Finca Between Archidona and Villanueva de Tapia, which is Totally Fenced/ Walled. The Finca and Dwelling Feature Total Privacy, and Yet is Only Four minutes from the Motorway (...)
€450,000
TSEA2922320
- El Burgo, Costa Del Sol, Yunquera
Beds: 4 Baths: 3 M2: 320 Lot Size: 97,000 Area: Yunquera Region: Andalucía
Beds: 4 Baths: 3 M2: 320 Lot Size: 97,000 Area: Yunquera Region: Andalucía
This lovely property is located just outside El Burgo, in an area of natural beauty approximately 50 minutes from Malaga airport and the coast and 40 minutes from the lakes in Ardarles and El (...)
€1,690,000
TSEA2927315
- El Rosario, Costa Del Sol, Marbella East
Beds: 9 Baths: 7 M2: 712 Lot Size: 1,023 Area: Marbella East Region: Andalucía
Beds: 9 Baths: 7 M2: 712 Lot Size: 1,023 Area: Marbella East Region: Andalucía
Beautiful spacious villa in El Rosario needs modernisation has nice outllok onto garden and near by golf. The villa is spread over 3 floors. It has 9 bedrooms and 7 bathrooms, as well as a guest (...)
€475,000
TSEA2918294
- Ronda, Costa Del Sol, Ronda
Beds: 3 Baths: 2 M2: 200 Lot Size: 12,000 Area: Ronda Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Lot Size: 12,000 Area: Ronda Region: Andalucía
Impressive villa of 200 m² on a magnificent plot of 12,000 m² with olive and almond trees, with the best views of Ronda, less than 500 m from the town.
The property has 3 spacious bedrooms with (...)
€371,175
TSEA2899745
- Algeciras, Costa de la Luz, Algeciras
Beds: 4 Baths: 1 M2: 660 Lot Size: 450 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 1 M2: 660 Lot Size: 450 Area: Algeciras Region: Andalucía
Detached Villa, , Cádiz (Costa de la Luz).
4 Bedrooms, 1.5 Bathrooms, Built 660 m², Terrace 15 m², Garden/Plot 450 m².
Setting : Country, Close To Golf, Close To Shops, Close To Town, Close To (...)
€2,999,000
TSEA2899148
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 7 Baths: 6 M2: 1,033 Lot Size: 1,441 Area: Benalmadena Region: Andalucía
Beds: 7 Baths: 6 M2: 1,033 Lot Size: 1,441 Area: Benalmadena Region: Andalucía
Wonderful luxury villa in Torrequebrada with beautiful views.
It is distributed as follows:
Ground floor: Large entrance hall, office/ library with fireplace, 5 large bedrooms with fitted wardrobes (...)
€5,300,000
TSEA2888972
- Casarabonela, Costa Del Sol, Inland
Beds: 6 Baths: 4 M2: 699 Lot Size: 594,599 Area: Inland Region: Andalucía
Beds: 6 Baths: 4 M2: 699 Lot Size: 594,599 Area: Inland Region: Andalucía
Beautiful Finca with separate guest accomodation, stable, riding school and production of olive trees, avocados, and several fruit trees.
It is distributed as follows:
Main house:
Ground floor: (...)
€1,500,000
TSEA2858600
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 214 Lot Size: 800 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 214 Lot Size: 800 Area: San Pedro Region: Andalucía
Villa on the beachfront in San Pedro
The villa has been reformed to a very high standard using top quality materials on both the inside and outside of the property.
Beautiful detached beachside (...)
€16,500,000
TSEA2837321
- Ronda, Costa Del Sol, Ronda
Beds: 7 Baths: 5 M2: 735 Lot Size: 3,370,000 Area: Ronda Region: Andalucía
Beds: 7 Baths: 5 M2: 735 Lot Size: 3,370,000 Area: Ronda Region: Andalucía
Spectacular, fully reformed and highly appointed Finca atop the Serrania de Ronda. The expansive land is well defined with areas of crop production as well as a large, multi-use, agricultural (...)
€750,000
TSEA2817458
- Ronda, Costa Del Sol, Ronda
Beds: 5 Baths: 4 M2: 404 Lot Size: 194 Area: Ronda Region: Andalucía
Beds: 5 Baths: 4 M2: 404 Lot Size: 194 Area: Ronda Region: Andalucía
Elegant house in the heart of the historical centre of Ronda, surrounded by monuments (Arabian palaces, churches, ...)
It is an old house from the XVII-XVIIIth century completely renovated, but (...)
€6,250,000
TSEA2803361
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 7 M2: 1,040 Lot Size: 2,500 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 7 M2: 1,040 Lot Size: 2,500 Area: Marbella West Region: Andalucía
Brand new designer villa overlooking Las Brisas golf, situated second line to the golf course on an elevated corner plot of 2500m2. Maintenance free level flat gardens with bamboo fencing, giving (...)
€3,250,000
TSEA2739344
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 804 Lot Size: 1,529 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 804 Lot Size: 1,529 Area: Estepona Region: Andalucía
Luxury villa under construction in Estepona, next to Guadalmina Baja. Built to the highest standards and ready in 2017.
Large living area, dining area and open plan fully fitted kitchen. Master (...)
€965,000
TSEA2670854
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 492 Lot Size: 1,500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 492 Lot Size: 1,500 Area: Mijas and Mijas Costa Region: Andalucía
.Beautiful property with a plot of 2,501 Mts. Villa of about 492 meters built,
all made in high qualities with spacious environments, Great room and Great living,
Parking for several cars, storage (...)
€3,000,000
TSEA2662976
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 421 Lot Size: 60 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 421 Lot Size: 60 Area: Marbella Region: Andalucía
MEISHO HILLS is an emblematic project of modern luxury properties located in a unique and exclusive urbanization of Sierra Blanca. The complex offers spectacular views to the sea and mountain and a (...)
€7,900,000
TSEA2657510
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 7 Baths: 8 M2: 640 Lot Size: 1,201 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 8 M2: 640 Lot Size: 1,201 Area: Marbella East Region: Andalucía
Breathtaking and unique villa located in a newly built super-exclusive gated community in the prestigious Golden Mile of Marbella, with 24 hours in the area of Marbella Club, No expense has been (...)
€4,200,000
TSEA2653154
- Nagüeles, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 640 Lot Size: 3,000 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 640 Lot Size: 3,000 Area: Marbella Region: Andalucía
This villa presents an exceptional refurbishment opportunity to create your ideal family home.
Perfectly positioned in a prime area of the Golden Mile, it boasts a privileged south-facing orientation (...)
Current Featured Properties
€725,000
EMPTY
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 139 Lot Size: 748 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 139 Lot Size: 748 Area: Estepona Region: Andalucía
NEW GOLDEN MILE, ESTEPONA
Villa/finca in urb. El Velerin next to Hospiten Hospital just accross the road of Emare. In need to reform.
South facing, walking distance to the beach and the paseo of (...)
€3,000,000
Detached Villa in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 5 M2: 692 Lot Size: 4,396 Area: Marbella Region: Andalucía
Beds: 7 Baths: 5 M2: 692 Lot Size: 4,396 Area: Marbella Region: Andalucía
A charming property in a picturesque tranquil residential area above Marbella center, with the most magnificent La Concha backdrop. A fantastic investment opportunity located in a secure residential (...)
€1,500,000
TSEA4689550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
The projects itself as an exclusive residential complex of 15 spacious semi-detached homes, with boutique- style amenities - a fully equipped gym, spa and outdoor swimming pool - enjoying spectacular (...)
