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 >= 40000 and a.houseprice <= 50000) and (b.cnpropertyname like '%Top Of City%' or b.enpropertyname like '%Top Of City%') order by updateTime Desc, a.dftpic desc
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...