Where I'm at, we only have one 'decent' LFS. They do a lot of business, but I've frequented the store less and less for animals and use it more for hardscape supplies and other general supplies. I've never really been impressed with their selection of fish. They sell what I would consider "bread-and-butter" fish that seem to always be popular - danios, various tetras, malawis, mbunas, goldfish, glo-fish, etc. Nothing that I would consider 'specialty' or niche, such as L-number plecos or multis. Live plant selection, last I checked, was limited to easy growers like swords and vals. When I last went in there, they also carried Hans discus (that's how it was labeled, not sure how else I would verify without asking to see shipping labels), but they were not in good shape - thin foreheads, ragged fins, and very overcrowded. I'm not implying Hans sells poor discus, it's much more likely due to poor husbandry and care at the LFS level. They have some saltwater fish as well.
They don't ship and their website is pretty basic without a whole lot of information on their stock list, etc.
If there's anything I ever need specialty wise, I try and make the 3 hour trip to The Reef Aquarium Shop in Indianapolis. It's quite the drive, but they're by far the best shop I have ever been in. Top tier in selection for hardware, hardscape, plants, inverts, fish, etc.