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 >= 10000 and a.houseprice <= 20000) and a.houseType = 2 order by housePrice Asc, a.dftpic desc
Newly renovated, first time for rent. Modern european style. next to several subway station and close to all sort of shopping malls restraunt, and bussiness s...