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) 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...
New Jingan district, Near People square, about 5mins walking to Dayuecheng Shopping Mall, 15mins to East Nanjing rd walking street, few mins to Line8/12 Qufu rd...
