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 = 2 and (a.houseArea >= 200 and a.houseArea <= 300) order by updateTime Desc, a.dftpic desc
Self-residential property with good maintenance, move out of the town for the new baby born, 2bedrooms with 2bathrooms, highly quality with full furnished.
The apartment is particularly good, whole house floor heating,Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeabi...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With a loft an large ...