It’s today one of Sheffield’s most affluent streets, connecting some of the city’s most sought-after suburbs.