Ye Olde Pipe has a great selection of cigars and a very big walk-in humidor, almost too big. I say that because as I walked around I came across a few boxes of cigars that were way too dry. With that said, I still found SEVERAL cigars that were fresh and moist. What I liked best about Ye Olde was the variety, they had several cigars at all price points, so if you can't afford to smoke an Opus X, they had plenty of cigars for less than $10.
If you aren't an avid smoker, I don't know if you will get any help because the staff did not seem very friendly or welcoming, but if you know what you want, there is a good chance they have it.