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 (63,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 (63,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 (63,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2641 - 2642 of 2642 €1,200,000
TSEA3119524
- Alora, Costa Del Sol, Älora
Beds: 5 Baths: 5 M2: 625 Lot Size: 70,000 Area: Älora Region: Andalucía
Beds: 5 Baths: 5 M2: 625 Lot Size: 70,000 Area: Älora Region: Andalucía
2278-V FANTASTIC FINCA FOR SALE on 70 000m2 of fenced plot, consists of many facilities in perfect condition, a house of 300m2 with living-dining room with fireplace, independent and furnished (...)
€690,000
TSEA2083928
- Alora, Costa Del Sol, Älora
Beds: 2 Baths: 2 M2: 150 Lot Size: 200,000 Area: Älora Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Lot Size: 200,000 Area: Älora Region: Andalucía
743-V For sale a farm with a house of 150 m2, all on one level consisting of very spacious lounge/dining room with fireplace, fitted kitchen, 2 bedrooms, 2 bathrooms, pantry, storage room, terrace (...)
Current Featured Properties
€7,500,000
TSEA4797559
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
YOU REALLY WILL WANT TO SEE THIS DEVELOPMENT!!!
The most exceptional new development, is currently underway on Marbella's fabled Golden Mile. With the most exclusive location, sublime design and just (...)
€1,645,000
TSEA4719550
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 418 Lot Size: 10,000 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 418 Lot Size: 10,000 Area: Casares Region: Andalucía
STUNNING VILLA IN CASARES WITH BREATHTAKING VIEWS.
This magnificent villa is located in the beautiful landscape of Casares, offering a perfect blend of elegance and modern luxury. Set on a spacious (...)
€1,400,000
TSEA4954306
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
An exclusive development of seventeen designer villas located in the Estepona golf course, where luxury and sustainability come together to create unique, welcoming homes with expansive open spaces (...)
