select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 1 and (b.cnpropertyname like '%Old house in Yanqing Road%' or b.enpropertyname like '%Old house in Yanqing Road%') order by updateTime Desc, a.dftpic desc
Top location Franch style decoration, Convenient transportation 24 hour supermarket, near a variety of Chinese and Western style restaurant, purchase farms is a...
The reality is more beautiful than you see in the picture. Super nice one bedroom house with huge outside space now is available on Yanqing Rd in FFC. This r...
located in a beautiful historically alley, This incredible home is close to all sorts of great fabulous shopping, restaurants, city plazas and several subway s...