SELECT DISTINCT r.ID, b.idB, bi.location, type, englishName, chineseName, bedroom, specialOffer, squareMeter, pic1, d.district_name, type, marketPrice, r.decoration
FROM building b, residential r, Binfo bi, districts d
WHERE b.compGroup = '95'
AND bi.language_id = '1'
AND r.buildingID <> 1045
AND b.idB=r.buildingID
AND bi.idB = b.idB
AND d.district_id=b.dist_id
AND ptype = 'lease'
AND visibility = 1
AND activation = 1
GROUP BY ID
ORDER BY updated, bedroom, specialOffer
limit 0,15
4 Bedrooms | 378 Sqm
45000 元
4 Bedrooms | 500 Sqm
50000 元
4 Bedrooms | 500 Sqm
53000 元
4 Bedrooms | 350 Sqm
50000 元
3 Bedrooms | 200 Sqm
34000 元
4 Bedrooms | 247 Sqm
43000 元
4 Bedrooms | 285 Sqm
45000 元
3 Bedrooms | 249 Sqm
38000 元
4 Bedrooms | 260 Sqm
36000 元
4 Bedrooms | 350 Sqm
40000 元
4 Bedrooms | 300 Sqm
43000 元
4 Bedrooms | 300 Sqm
44000 元
4 Bedrooms | 300 Sqm
44000 元
4 Bedrooms | 300 Sqm
44000 元
4 Bedrooms | 250 Sqm
45000 元