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.houseprice >= 30000 and a.houseprice <= 40000) and (b.cnpropertyname like '%Springdale Garden%' or b.enpropertyname like '%Springdale Garden%') order by updateTime Desc, a.dftpic desc
Luxury decoration, brand new, duplex layout, with high ceilings and bright capacious livingroom, bedrooms are aslo very big and sunny, with two huge balcony, hi...