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.houseArea >= 300 and a.houseArea <= 400) and c.enDistrictName = 'Changning' order by updateTime Desc, a.dftpic desc
Fully furnitured,walking distance to subway, with large living room,very comfortable living environment.
please confirm with our property consultant about its ...
newly decorated apartment, facing south,walking distance to subway, with large living room,very comfortable living environment.please confirm with our property ...