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 = 1 and a.houseType = 2 and (a.houseArea >= 0 and a.houseArea <= 100) and c.enDistrictName = 'Jingan' order by updateTime Desc, a.dftpic desc
The whole house is heated by water and warmth. The living room has an outside balcony facing the southwest. It has good lighting and landscape for the atrium ga...
Jingan district, Changping rd near Xikang rd, Great decoration, fully furnished, second floor, large two bedrooms, open kitchen, cute livingroom, about 5mins wa...