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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Sorry, no records were found. Please try again.
Current Featured Properties
€2,080,000
TSEA4893667
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 280 Lot Size: 20 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 280 Lot Size: 20 Area: Marbella Region: Andalucía
A community of 27 opulent semidetached homes with expansive rooms, private gardens, swimming pools, and prime sea views can be found in Marbella at The List Rio Real. Because to its multi-level (...)
€730,000
Townhouse in Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
STYLISH AND ENERGY EFFICIENT IN BEAUTIFUL ESTEPONA.
This boutique development of ten 4-bed, 3-bath luxury villas offer private gardens with beautiful sea, golf and mountain views. With unique (...)
€584,250
TSEA5065531
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
