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 = 4 and (b.cnpropertyname like '%Yanlord Garden%' or b.enpropertyname like '%Yanlord Garden%') order by updateTime Desc, a.dftpic desc
It is an amazing single-family apartment with four bedrooms newly renovated with elegant decoration. This home's highlights include two bright and spacious livi...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...
