網上揾樓

select * from flag_detail fd where (TO_DAYS(NOW()) - TO_DAYS(fd.submit_date) < ) AND fd.submit_date <> '0000-00-00 00:00:00' AND ( ( ( (fd.area2_1 <= fd.area1_1 AND fd.area1_1 > 0) OR (fd.area2_1 > 0 AND fd.area1_1 = 0)) AND (fd.flatusage ='住宅' OR fd.flatusage ='居屋')) OR !(fd.flatusage ='住宅' OR fd.flatusage ='居屋') ) and fd.agence = '' and fd.canned_feature = 1 order by fd.submit_date desc

特選樓盤


網上筍盤 搜尋

租/售
用途
地區
售價(萬)
租金
呎數
樓宇/街道
搜尋


港人港情品牌大獎2016-17