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 >= 30000 and a.houseprice <= 40000) and a.houseType = 4 and (a.houseArea >= 300 and a.houseArea <= 400) order by updateTime Desc, a.dftpic desc
Nice decoration, fully furnished, Lujiazui Business circle, River view, Four large bedroom and large livingroom, 311sqm, quality compound, nice light, about 10m...
The Villa is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.Whole floor heating,with...
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 ...
It is an amazing single-family lane house with three floors with one floor basement, newly renovated with elegant decoration.This house's highlights include a b...
It is an amazing single-family lane house with newly renovated with elegant decoration.
This house's highlights include two bright and spacious livingroom, wel...
Fully furnitured,walking distance to subway, with large living room,very comfortable living environment.
please confirm with our property consultant about its ...
Floor Heating, Unfurnitured, with balcony & terrance and large living room,very comfortable living environment,huge private garden, good property managment.