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 b.propertytype = 1 and (a.houseArea >= 0 and a.houseArea <= 100) and c.enDistrictName = 'Pudong' order by updateTime Desc, a.dftpic desc
Fully furnitured,walking distance to subway L 2 Shanghai Science and Technology Museum, with balcony and large living room,very comfortable living environment.
...
Golden location in Lujiazui bussniess circle. Very convenient transportation. The home is newly furnished, wooden floor, spacious layout, elegant and beautiful...