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.houseArea >= 100 and a.houseArea <= 200) 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...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.with a beauty balcony...