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 = 1 and (b.cnpropertyname like '%City Castle%' or b.enpropertyname like '%City Castle%') order by updateTime Desc, a.dftpic desc
Luxury decoration, fully furnished, high floor, quality compound, with a balcony, with floor heating and A/C, About 8mins walking to L2 West Nanjing rd station,...
Two club are used for free，Central AC，the apartment is new renovated with light colour fashion furniture，famous brand appliance，2 platen washing machine and 2 s...
