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 (a.houseArea >= 100 and a.houseArea <= 200) and (b.cnpropertyname like '%S506293%' or b.enpropertyname like '%S506293%' or a.houseID like '%S506293%') order by updateTime Desc, a.dftpic desc
Newly renovated with nice decoration, whole room with wall heating, wooden floor with full furnished. Please feel free to contact with our property consultant f...