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 c.enDistrictName = 'Jingan' and (b.cnpropertyname like '%Ladoll International City%' or b.enpropertyname like '%Ladoll International City%') order by updateTime Desc, a.dftpic desc
New decoration, whole room floor heating, whole room central air conditioning, with embedded oven, microwave oven, dishwasher! The house has its own super 100 f...