When we travel to shows we usually go the Motel 6 route. Its cheap and because they allow dogs I can bring the whole clan with me.
Oh, almost forgot to add that you probably need to give them a couple of weeks notice because there are a lot of other show people with the exact same idea
Best of luck!