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 '%Shimao Riviera Garden%' or b.enpropertyname like '%Shimao Riviera Garden%') order by updateTime Desc, a.dftpic desc
Nice decoration, fully furnished, Lujiazui Business circle, River view, Four large bedroom and large livingroom, 311sqm, quality compound, nice light, about 10m...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.With large balcony,ni...