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 >= 30000 and a.houseprice <= 40000) and c.enDistrictName = 'Xuhui' order by updateTime Desc, a.dftpic desc
Very nice with high quality design, brand newly renovated, wall heating, centre ac, full furnished, 3bedrooms with extra storage room, masterbedroom with walkin...
Luxury decoration, fully furnished, with A/C. Whole house floor heating, Water purification system,, nice appliances, about 5mins walking to Line10 Shanghai Lib...