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.houseprice >= 20000 and a.houseprice <= 30000) and (b.cnpropertyname like '%Old House in Wulumuqi Road%' or b.enpropertyname like '%Old House in Wulumuqi Road%') order by updateTime Desc, a.dftpic desc
This house is the end of the renovation. It is the best chance to enjoy the brand new furnitures, and the landlord will rearrange the house for the first perso...