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 >= 20000 and a.houseprice <= 30000) and (b.cnpropertyname like '%Old house in Huashan Road%' or b.enpropertyname like '%Old house in Huashan Road%') order by updateTime Desc, a.dftpic desc
Fully new furnitured,walking distance to subway, a well arranged and spacious old house with open kitchen,offers luxury tranditional Chinese decor and spacious ...
This beautifully presented home is nestled amongst some of the most stunning urban homes,
and offers location as well as comfort. Immaculately kept,
thi...