My parents have lived in a quiet street since 1958. They are now in their late 80s. A few years back next door was converted to bed sits. They have had a range of tenants since then, some creating huge problems for the neighbours, including noise, aggression, rubbish shrewn around, domestic violence, police visits etc.. It seems there is little that can be done, though the Environment agency got involved in getting rid of a mound of rubbish outside, as there were reports of rats.
My parents would love to sit outside, but would have to remove their hearing aids so they couldn't hear the swearing. Another neighbour, a retired soldier, knocked on my parent's door and told them if they had any problems not to deal with it, but to let him know and he would sort it. It's good to know that people are looking out for my parents.
I should imagine this house affects the house prices around. Not that my parents could cope with moving unless it was to a home and then all that would be up to me.