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 (a.houseArea >= 0 and a.houseArea <= 100) and c.enDistrictName = 'Jingan' order by updateTime Desc, a.dftpic desc
Newly furnitured, with wall heating and spacious terrace,very comfortable living environment.
please confirm with our property consultant about its availablit...
Newly renovated, luxury deco with spacious and bright livingroom, fully furnished, high quality household appliances,whole house floor heating, with 25sqm garde...
