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 b.propertytype = 4 and (a.houseprice >= 10000 and a.houseprice <= 20000) and c.enDistrictName = 'Jingan' order by updateTime Desc, a.dftpic desc
1 bedroom plus 1 open study, bathroom shower plus bathtub design, good quality! Full room floor heating, central air conditioning, smart toilet, embedded refrig...
Top location in FFC, good design with quite nice layout, bright living room& dining room, high quality appliance. Floor heating system plus central A/C system w...
Fully furnitured,walking distance to subway line 2 jingan temple station, with large living room,very comfortable living environment. please confirm with our pr...
