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 >= 300 and a.houseArea <= 400) 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
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 ...
One of the few most luxury apartment in entire Shanghai City, high class neighborhoods around. This recently renovated 1 bedroom paradise has an easy access to ...
C/A, boasts high ceilings with stunning feature windows,offering abundant living space throughout,beautiful décor throughout and large beautiful terrance