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 = 3 and a.houseType = 4 and c.enDistrictName = 'Xuhui' order by updateTime Desc, a.dftpic desc
Three floors of the whole building, independent space, courtyard, terrace, as well as climbing the back wall and the entire fence of the mountain tiger, green. ...
Luxury decoration, fully furnished, open kitchen, with a balcony, floor heating, A/C, elevator, about 5mins walking to Line10/11 Jiaotong University station
