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.houseType = 1 and (a.houseArea >= 100 and a.houseArea <= 200) and c.enDistrictName = 'Huangpu' 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 ...
Fully furnished with floor heating and aircon (cooling and heating), oven, washer-dryer,
communal garden. Size: 110sqm Special conditions: no pets and no smok...
Luxury decoration, comfortable and cozy, large size livingroom and diningroom, open kitchen with good equipments, oven, dish washing; beautiful change room and ...
Fully new furnitured,walking distance to subway, large living room,very comfortable living environment. Floor heating system, Oven and dryer machine are attache...