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.houseArea >= 100 and a.houseArea <= 200) 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. ...
House keeping and bedding changing 6times per week, Internet and Satellite usage fee are inclused, club member ship card; Basement parking per month 1700rmb exc...
The single multi-storied building, exquisite decoration, nostalgic furnishings, all of which let you enjoy the bustling & elegant Shanghai in a glimpse.