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 (a.houseprice >= 50000 and a.houseprice <= 60000) 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. ...
250 Sqm gross area ，4,2,2 with a small yard、can be used both as a office or residence.Whole wood floor,whole floor heating and wall heating,Water purification ...
