Close to the fairgrounds and nice really limits your options. The Holiday Inn Express and the Hampton Inn are going to be your best choices in this case with your need for trailer parking.

I used to stay at the Best Western right off the turnpike before I moved down here (work related)...not sure how it is now. Was really nice when it was new, but seemed to go down hill each year.