Awesome
Most of my friends have cabins/year round homes on the lake.
It is super sweat having a house on the lake, however they tend to spend a half a day a weekend mowing, watering, repairing, etc.
Small price to pay, but sure takes away from the weekend.
That being said, I would do it...