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 >= 40000 and a.houseprice <= 50000) and a.houseType = 4 and (a.houseArea >= 100 and a.houseArea <= 200) order by updateTime Desc, a.dftpic desc
Nice decoration, fully furnished, Sinan rd near Taikang rd, with a balcony, open kitchen, with floor heating and A/C, high floor, nice view, about 7mins walking...
Totally newly renovated apartment with nice hghway view.Living room with larger space. Those make you everyday with colorful once your saw the wondeful view. Wh...