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.propertytype = 4 and a.houseType = 1 order by updateTime Desc, a.dftpic desc
1 bedroom plus 1 open study, bathroom shower plus bathtub design, good quality! Full room floor heating, central air conditioning, smart toilet, embedded refrig...
This flat is located at Shanghai's hot spot, Xintiandi, and is refurbished and maintained to an exceptionally high standard using the highest quality materials ...
