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 (57,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 (57,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 (57,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Sorry, no records were found. Please try again.
Current Featured Properties
€620,000
Townhouse in Istan
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 3 M2: 197 Area: Istan Region: Andalucía
Beds: 3 Baths: 3 M2: 197 Area: Istan Region: Andalucía
STUNNING MOUNTAIN AND SEA VIEWS!!!
This new development encompasses precisely this combination of the best of the mountains and coast on Costa del Sol. Originally the location of an ancient oil mill (...)
€720,000
TSEA4713529
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 116 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 (...)
€1,299,000
TSEA4792552
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 374 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 374 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
