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 (41,36,37,38)
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 (41,36,37,38)
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 (41,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Sorry, no records were found. Please try again.
Current Featured Properties
€1,190,000
TSEA4648012
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
This new development is an ambitious project consisting of 164 homes surrounded by the natural landscape of El Higueron. The properties are made up of 70 deluxe apartments, 49 garden villas, 25 sky (...)
€742,600
Top Floor Apartment in Mijas Costa
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 119 Area: Mijas and Mijas Costa Region: Andalucía
RELAX AND LET MOTHER NATURE WORK HER MAGIC.
This unique new development ideally situated between La Cala de Mijas and Fuengirola, is a NEW CONCEPT of apartments and penthouses of 2, 3 and 4 (...)
€682,000
TSEA4251622
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 98 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Benalmadena Region: Andalucía
AN AMAZING LOCATION!!!
This is an exclusive, private development situated in a privileged location in Benalmádena. Thanks to its elevated position, all homes boast breathtaking panoramic views of (...)


