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) order by housePrice Asc, a.dftpic desc
around IAPM,close to L1 L10 L12,5min walking distance to South shanxi rd metro station and Middle Huaihai rd metro station ,north european ins style decoration ...