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 (b.cnpropertyname like '%Old House In Hengshan Road%' or b.enpropertyname like '%Old House In Hengshan Road%') order by updateTime Desc, a.dftpic desc
Built in 1928,West lake apartment is situated in Hengshan Rd,close Gaoan Rd.A lot of famous people are living in this area.Also hundreds of old sycamore tree m...