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 = 2 and (b.cnpropertyname like '%Yanlord Garden%' or b.enpropertyname like '%Yanlord Garden%') order by updateTime Desc, a.dftpic desc
Right next to Huangpu River. Nice river view. Delicated decoration,the property comprises two brigh and sunny livingroom and well equipped contemporary kitchen,...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...