There ain't much in our area. We usually go over to Hidden Falls. It's a few hour drive, but well worth it. Spend the weekend and wheel at night!!
It all depends on what you want. Rocks and more technical stuff you'll have to drive. Mud and just trails, there are several "close" to Houston area.
General Sams (Huntsville)
Shilo Ridge (Alto)
Down South (Crosby)