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 = 4 and (a.houseArea >= 300 and a.houseArea <= 400) and c.enDistrictName = 'Pudong' order by updateTime Desc, a.dftpic desc
Nice decoration, fully furnished, Lujiazui Business circle, River view, Four large bedroom and large livingroom, 311sqm, quality compound, nice light, about 10m...
It is an amazing single-family lane house with newly renovated with elegant decoration.
This house's highlights include two bright and spacious livingroom, wel...
It is an amazing single-family house with three floors, newly renovated with elegant decoration. This house's highlights include a bright and spacious livingroo...