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 (b.cnpropertyname like '%Summit Residence%' or b.enpropertyname like '%Summit Residence%') order by updateTime Desc, a.dftpic desc
Pudong, Fantastic decoration, fully furnished, nice light, River view, comfortable livingroom and balcony, floor heating, close to Shangcheng rd station.
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.fully furnished
