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 = 4 and c.enDistrictName = 'Huangpu' 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
This flat is located at Shanghai's hot spot, Xintiandi, and is refurbished and maintained to an exceptionally high standard using the highest quality materials ...
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...
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...
House keeping and bedding changing twice a week, Internet and Satellite usage fee, Utility fee, and club membership card; Basement parking 1800rmb per month