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 >= 30000 and a.houseprice <= 40000) and a.houseType = 3 and c.enDistrictName = 'Xuhui' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Xujiahui') order by updateTime Desc, a.dftpic desc
High rise Building with elevator, Heritage apt in the Xinle Road, nice with large size terrace, high quality equipements, floor heating system installed
Luxury decoration,Full furnished,Newly renovated,whole house water and floor heating,whole house centro air-conditioning,open kitchen,with a bar,oven,dish-washi...
Newly renovated,Whole house wall heating,Whole house centro air-conditionning,open kitchen,oven,with a large bar table,microwave.dish washing machine and drying...