Yeah, and you need to zoom in quite close and scroll down the street, or else Google Maps (or Bing Maps) will hide some of the locations.
I don’t see much in the way of web sites that actually just let you search “34th Ave, Seattle, WA” and give you a full list of every place they know about on that street. It IS possible to query their databases that way using an Advanced Programmer Interface, but I don’t see any handy free apps that do that.
The Internet is full of web sites, and the world is full of software, though, so there probably is something somewhere. It’d be a pretty easy program to write.