Mike,
I have played Limestone several times, and it is generally a delight to play. It is usually in good shape, firm and fast, both summer and winter, depending on recent weather of course. I agree with Tom that it is certainly better than any of the RTJ courses in Birmingham, and probably better than any in the state, with the exception of maybe Grand National if you happen to catch that on on a good day. I am not sure if they have made the transition yet, but I know the club was planning to go private when the cash flow made sense. Nevertheless, it is regarded as of the best courses in the state by many publications, sadly enough. Though it is very walkable, the standard op is carts. I think Jerry Pate has done some pretty solid work in Alabama, insofar as I much prefer his style to that of fazio, rees, arthur hills, etc. Limestone is by no means an unbelievable experience, but as far as public golf is concerned, it is really good. There are some neat short holes that tempt the ego as well as some scary ball busters, and all around fun holes. All in all, I recommend you play it if you are going to be in the area.
sam