I lived in Turner Street in 2002 till 2004 approximately when I found it extraordinarily quiet for a street so close to main traffic sewers. (That is, arterial roads.) You have a train station at one end of the street and the Yarra River, Yarra Bend Park and the bike path at the other and Victoria Park opposite. Victoria Park has reverted to community use after the relocation of the famous Collingwood Football Club. This ground is going to be wonderful for the street as there are not many houses in Melbourne that can boast a village green our the front door. The plan is for the ground to lose the stand and wall on Turner Street to open the ground up as a community park, and for other stands to be redeveloped into community assets including a centre for sustainability, according to the latest 2030 report from State Government. Also mentioned in this State Government report was the construction of a path from the opened up Victoria Park to the Collingwood Children's Farm and Convent Arts Precinct via the lovely path on the Yarra River.
As if this isn't enough, Turner Street also enjoys the famous shopping strips of Smith and Brunswick Streets just to the West. If you cant be bothered walking to the train, a bus on Johnson Street is only 80 meters away and can take you to these streets or the Kew Junction in the other direction.
On the negative side, there's some very light commerse and industry located on Johnson Street and Little Turner Street which is the second street frontage of Turner Street housing, but I find this is interesting rather than a downside.