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 = 1 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 ...
5 mins to subway station. Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transpare...