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 (b.cnpropertyname like '%First Block%' or b.enpropertyname like '%First Block%') order by updateTime Desc, a.dftpic desc
The whole house is heated by water and warmth. The living room has an outside balcony facing the southwest. It has good lighting and landscape for the atrium ga...
