I have a cabin on Lake Poinsett just 25 minutes away from Brookings. Great place to stay for SDSU home football games. Most all weekends in September and October are still open. Here is the web site...
http://h1.ripway.com/cabinrental/
http://h1.ripway.com/cabinrental/