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 '%H607933%' or b.enpropertyname like '%H607933%' or a.houseID like '%H607933%') order by updateTime Desc, a.dftpic desc
Located at Middle Huaihai Rd and West Fuxing Rd. Next to Shanghai Liburary and several subway stations. Whole room both wall heating and floor heating. Large ...