Hale Road in Trafford was voted the 2nd 'most-attractive' road in the North West