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
Sorry, no records were found. Please try again.
Current Featured Properties
€1,900,000
TSEA5005987
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 8 M2: 480 Lot Size: 1,878 Area: Benahavis Region: Andalucía
ELEGANT VILLA WITH LARGE PLOT WITH SEA VIEWS AND SPA AREA
Fantastic villa with an elegant Mediterranean style, located in a quiet and private area next to San Pedro de Alcántara, La Quinta, Monte (...)
€6,600,000
TSEA4793137
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 6 M2: 1,407 Lot Size: 1,095 Area: Marbella Region: Andalucía
Beds: 5 Baths: 6 M2: 1,407 Lot Size: 1,095 Area: Marbella Region: Andalucía
Step into the future with this breathtaking new development in Marbella, boasting panoramic sea views. This 24/7 gated community of 5 detached villas will be finished End 2025. As you enter, you are (...)
€957,000
TSEA4390957
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 143 Lot Size: 54 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 143 Lot Size: 54 Area: Mijas and Mijas Costa Region: Andalucía
A NATURAL BEAUTY!!!
The architecture of these sixty-nine villas blends with nature and reinvents the traditional Andalusian style. A refuge where the natural beauty of the environment merges with a (...)
