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.houseprice >= 10000 and a.houseprice <= 20000) and (a.houseArea >= 0 and a.houseArea <= 100) and c.enDistrictName = 'Pudong' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Lujiazui') order by updateTime Desc, a.dftpic desc
Golden location in Lujiazui bussniess circle. Very convenient transportation. The home is newly furnished, wooden floor, spacious layout, elegant and beautiful...
Right next to Huangpu River. beautiful view to the river. Fully furnished, wooden floor, spacious layout, elegant and beautiful decoration, bright and sunny l...