SELECT distinct area.*
FROM ((property
INNER JOIN area ON (property.area_id =area.id))
INNER JOIN property_bedroom AS PB ON(PB.property_id = property.id))
INNER JOIN property_facility ON (property.id=property_facility.property_id)
WHERE area.city_id='5'
AND property.status_id = '1' ORDER BY area.area
Hong Kong Apartments Hong Kong Serviced Apartments Hong Kong Furnished Apartments
