BrettV,
What kind of riding do you do?
For offroad, there is Kentuck near Oxford AL, about 25 miles of trails. I do most of my offroad riding near Clanton at a riding club (40+ miles of marked single-track). There is also a club near Maplesville that is great.
Local spots include the Bowl (near Helena) and the MET. There's also a spot off 65 north of town (I've never been there).
If MX/SX there are a number of tracks. My favorite is MonsterMountain in Tallassee. North of town is Warrior and Corner MX. There's also a new spot in Pell City, but I've not seen it.