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.houseType = 3 and (a.houseArea >= 200 and a.houseArea <= 300) and c.enDistrictName = 'Changning' order by updateTime Desc, a.dftpic desc
North-south transparent, good ventilation, good lighting,with outdoor balcony,open landscape.The apartment also include free fitness center,offer free cleaning ...
Large and round shape livingroom make you are comfotable and good mood everyday! The window which reached floor can attract much sunshine! Comtenpory kitchen wi...