So here's the deal. I only found two pipe shops in SF. Grant's on Market is really good. Brand name pipes to buy and very good blends of tobacco. I'm going back this morning to get more of their Emperor Norton - Virginias, Turkish and Latakia. I can't stop smoking the stuff.
Another one is called the Humidor. I went to two locations. The one in the Financial District has a few "generic italian pipes" as the guy working there said. Not that he said that much because something on his phone was much more interesting to him than me. So I left. The next day I ended up in the Marina district so I thought I would try that one out. If you are in the market for a small glass tobacco pipe or a large blue acrylic water pipe to enjoy your Frog Morton in, I guess this would be the place for you.
Bottom line, if you are in SF the place to go is Grant's.
Had a great time as well.