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 = 'sales' AND type_ref_id = '3' AND ((prop_price BETWEEN 1 AND 100000001) OR price_ondemand = 'Y') 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) DESC