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 '%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...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,
especially good north-south light permeability. nice river view.
...