Let me clarify - when I said the rates I found online were too high, I was only finding high-end resorts at about 450/night. They'll rent you a smaller cabin but with a 30 dollar charge per person it comes out to just as much so I'd say we're looking to pay in the 500 range for two and a half days, two nights.

A smaller (1000-10,000 acre) lake would be ideal too.