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 (56,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 (56,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 (56,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Sorry, no records were found. Please try again.
Current Featured Properties
€715,000
TSEA4798984
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 175 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 175 Area: Estepona Region: Andalucía
BOUTIQUE COLLECTION OF FRONT-LINE GOLF TOWNHOUSES!
Situated on the front line of Estepona Golf Course, your new residence is steps away from the clubhouse and fairways of one of the best golf courses (...)
€985,000
TSEA4713565
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Branded Residence comprising of 58 incredible 2 and 3 bedroom frontline golf homes to be built to the highest specification overlooking the renowned La Cala Resort Golf course. Reaching the (...)
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
