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.houseArea >= 200 and a.houseArea <= 300) and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Xintiandi') order by updateTime Desc, a.dftpic desc
4bedrooms with 3bathrooms, large size livignrooms space,high quality eqipements in the kitchen, parts of furnished, can be negotiable about the furniture
Located at the Xintiandi bussiness Area, it is one of the most luxury home in Shanghai. Best home design plus the wonderful home layout. Floor Heating, fully ...
House keeping and bedding changing three times a week, Internet and Satellite TV uasge fee included, Club member ship card; Basement parking per month 1900rmb e...