Every street is fine except one. At that gate, or outside that one house, your dog stops, backs up, or takes a wide detour across someone's lawn to avoid it.
Why it is just the one place
This usually is not general nervousness about the street. Something happened at that address, often a dog barking hard behind a fence, a person shouting, or a startling noise. Your dog learned that spot means something unpleasant.
One bad experience can be enough, because your dog does not need it to happen twice to avoid it a third time. That is a normal way for a dog to learn, not a character flaw.
This week: stop rehearsing the freeze
Walk a different route for the next 2 weeks. Every walk your dog freezes on that spot practises freezing there.
If there is no other route, cross to the far pavement and keep moving rather than stopping in front of the house.
Do not force a stop-and-stare exposure. Standing your dog in front of the trigger to get used to it usually makes the spot scarier, not smaller.
Then find the distance where your dog can think
Working below the distance at which your dog reacts is the condition for learning near a specific trigger. That is true whether the trigger is a dog, a house or a person.
Stand far enough back that your dog notices the house or dog and can still take food from your hand. That might be 60 feet or more.
The moment your dog looks toward it, feed 1 piece, then feed again while it stays in view. Stop feeding when it is out of sight.
Do 5 or 6 short passes at that distance, on separate days, before moving 10 feet closer.
Move closer only when your dog manages 5 calm passes in a row at the current distance. If a session goes badly, the next one starts further back, not closer.
If it is one specific dog, not the house
The method is the same, at whatever distance keeps your dog eating. Where possible, walk at times that dog is less likely to be out, while you build the distance work.
Safety note
Get help now if your dog trembles, tucks their tail, tries to bolt, or has growled or snapped near that spot. The same applies if this started suddenly, over days rather than weeks. Sudden behaviour change warrants a veterinary examination, and pain often presents as a change in behaviour.
What not to do
Do not drag your dog past on a tight leash. Punishment-based approaches are associated with fear and avoidance, and dragging a frozen dog belongs in that family.
Today's version, in one line: a different route this week, then food at the distance your dog can still eat at.