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 >= 20000 and a.houseprice <= 30000) and a.houseType = 2 and c.enDistrictName = 'Xuhui' order by updateTime Desc, a.dftpic desc
New decoration, fully furnished, will floor heating, with club, playground, cloakroom, A/C, quality compound, about 3mins walking to L10 Shanghai Library statio...
Luxury decoration, fully furnished, 120sqm large two bedroom, with wall heating, good view, with 6sqm balcony, high floor, in French concession, about 7mins wa...