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 c.enDistrictName = 'Putuo' order by updateTime Desc, a.dftpic desc
Central air conditioning, bathroom with floor heating, embedded oven, embedded microwave oven, whole house soft water purification system. The community has its...
Luxury decoration, fully furnished, with a 50sqm large terrace, every room can view river, open kitchen, comfortable livingroom, about 5mins walking to Line3/4 ...