SELECT property_master.*,developments.name as development_name,city.city_name FROM property_master join property_type_master on type_ref_id=typeid
left join developments on development=developments.id
left join property_project on property_master.project=property_project.parent_id
left join city on city.city_id = property_master.city
WHERE 1 AND prop_for_id = 'rent' AND city = '1' AND annual_rent BETWEEN 1 AND 1500001 AND property_master.is_active = 'Y' AND property_master.is_sold = 'N' group by property_master.prop_id ORDER BY CAST(added_on as SIGNED INTEGER) DESCArray
(
[propfor] => rent
[city] => dubai
[page] => 14
[property] => residential
)
