Rent a flat, apartment or villa in Beijing

King Stone International

in Beijing

INFORMATIONS

Compound
District

Fill this form to get more informations about King Stone International

You name*	Desired moving date*
Your email*	Your message*
You phone number*	Your message*

Properties in the compound

Do not have others properties in this compound.

Other properties in the same compound

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 = '' AND bi.language_id = '1' AND r.buildingID <> 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,15You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.idB=r.buildingID AND bi.idB = b.idB ' at line 6