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 a.houseType = 3 and (a.houseArea >= 100 and a.houseArea <= 200) order by updateTime Desc, a.dftpic desc
good location,nice in&out door pool,provide nice and professional service， house keeping three times per week,towel changing twice per week and bedding changing...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.with a beauty balcony...
