Well, there's a handful of generic pet shops around here in Greensboro, most of which have a handful of simple plants. But the nearest aquarium store isn't too far ...maybe a 25-minute drive west. Then there's Raleigh, about 75 minutes east. And Charlotte, 2 1/2 hours south.
There used to be a really nice, big place here in town - Aquamain's - but it went under a few years back.
I've found the Sales forum to be the easiest source for anything specific. Every once in awhile, I'll want a "neat" fish and head over to Kernersville to see what they have. Not a huge selection, but usually a few semi-exotics.