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.houseprice >= 10000 and a.houseprice <= 20000) and a.houseType = 3 and c.enDistrictName = 'Xuhui' order by housePrice Asc, a.dftpic desc
Located in Huangpu District，Only a few steps away from Xintiandi Bar area.Luxury European style decoration with oven,dryer,and Floor heating. 5minute to subway...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.with beauty balcony.
