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 (36,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 (36,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 (36,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Sorry, no records were found. Please try again.
Current Featured Properties
€640,000
TSEA4551028
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 3 M2: 193 Area: Istan Region: Andalucía
Beds: 3 Baths: 3 M2: 193 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 (...)
€747,000
Townhouse in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 141 Lot Size: 24 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 141 Lot Size: 24 Area: Mijas and Mijas Costa Region: Andalucía
TOWNHOUSES IN LA CALA DE MIJAS.
Ideally located next to El Chaparral Golf Course, a few metres from the beach, very close to the lively, bustling entertainment area of La Cala de Mijas and the (...)
€5,200,000
3 Bed ground floor apartment in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 447 Lot Size: 135 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 447 Lot Size: 135 Area: Marbella Region: Andalucía
PRE LAUNCH, ACT FAST AS THESE WILL GO QUICKLY!!!
The brand new off plan development, of 64 apartments and 32 townhouses. Uniquly located on one of the last avaialable plots on the marbella coast. (...)
