Neighbours have told of their fear after a man was shot on a 'quiet' street in Gainford, in a drive-by murder bid.