facebook pixel

Property for Sale in Bay Central West, Dubai Marina

Found 0 properties
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 development ='1' AND city = '1' AND ( project In(8,667,69)) 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) DESCdubai

No properties found for this search!