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.houseArea >= 100 and a.houseArea <= 200) and c.enDistrictName = 'Pudong' order by updateTime Desc, a.dftpic desc
Pudong, Fantastic decoration, fully furnished, nice light, River view, comfortable livingroom and balcony, floor heating, close to Shangcheng rd station.
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.fully furnished