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 >= 40000 and a.houseprice <= 50000) and a.houseType = 4 and (a.houseArea >= 300 and a.houseArea <= 400) order by updateTime Desc, a.dftpic desc
The Villa is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.Whole floor heating,with...
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...
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 ...
Floor Heating, Unfurnitured, with balcony & terrance and large living room,very comfortable living environment,huge private garden, good property managment.