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 = 'Hongkou' order by updateTime Desc, a.dftpic desc
Large two bed-room with high ceilings, lots of closet space, this incredible home is located along the Suzhou River next to the center of Shanghai, People squar...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,
especially good north-south light permeability. With large balcony...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.with a beauty balcony...