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 = '970'
AND bi.language_id = '3'
AND r.buildingID <> 970
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
Nous n'avons pas d'autres propriétés de cette résidence.
