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
Sorry, no records were found. Please try again.
Current Featured Properties
€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 (...)
€2,900,000
TSEA4679083
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 5 M2: 271 Lot Size: 11 Area: Estepona Region: Andalucía
Beds: 3 Baths: 5 M2: 271 Lot Size: 11 Area: Estepona Region: Andalucía
Located in a picturesque and coveted setting amidst nature's splendour, This luxury development comprises a collection of twelve sophisticated and exclusive villas boasting contemporary aesthetics. (...)
€3,485,000
TSEA5156128
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 573 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 573 Area: Benahavis Region: Andalucía
A top quality, new built contemporaty villa (2024), located in the sought after residential area of La Alqueria, Benahavís. South to west facing with views to mountains and some seaviews from the (...)
