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.houseprice >= 10000 and a.houseprice <= 20000) and c.enDistrictName = 'Huangpu' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Laoximen') order by updateTime Desc, a.dftpic desc
The kitchen is equipped with oven, steaming oven and sterilizing cabinet. The surrounding environment of the district is clean and tidy, with two stairs and thr...
Great decoration, fully furnished, nice one bedroom, with balcony, about 5mins walking to L8/10Laoximen station, about 10-12 mins walking to Xintiandi Area
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...