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 = '3'
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 Chambres | 378 m²
45000 元

4 Chambres | 500 m²
50000 元

4 Chambres | 500 m²
53000 元

4 Chambres | 350 m²
50000 元

3 Chambres | 200 m²
34000 元

4 Chambres | 247 m²
43000 元

4 Chambres | 285 m²
45000 元

3 Chambres | 249 m²
38000 元

4 Chambres | 260 m²
36000 元

4 Chambres | 350 m²
40000 元

4 Chambres | 300 m²
43000 元

4 Chambres | 300 m²
44000 元

4 Chambres | 300 m²
44000 元

4 Chambres | 300 m²
44000 元

4 Chambres | 250 m²
45000 元