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 '%鸿艺豪苑%' or b.enpropertyname like '%鸿艺豪苑%' or a.houseID like '%鸿艺豪苑%') order by updateTime Desc, a.dftpic desc
Open kitchen. Extremely big living and dinning. Floor heating, throughout wall insulation, daikin central ac, double glazing windows. Smeg oven, Coway filtered ...
New decoration, fully furnished, will floor heating, with club, playground, cloakroom, A/C, quality compound, about 3mins walking to L10 Shanghai Library statio...