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 = 4 and (a.houseprice >= 20000 and a.houseprice <= 30000) and c.enDistrictName = 'Huangpu' order by updateTime Desc, a.dftpic desc
This flat is located at Shanghai's hot spot, Xintiandi, and is refurbished and maintained to an exceptionally high standard using the highest quality materials ...
