Its a great place, especially if you have a good sized group. Are there better values for a couple or small family? Probably. However, it's hard to find a place like this (lake front, feels secluded, parking for a huge Sprinter Van, etc.) at any price point.
The entire place is clean. However as other visitors shared there is some glass in the huge yard (wear shoes and you'll be fine). The main floor is the star and the upstairs is pretty good. The basement does appear to be a work in progress though.
We're from a very quiet neighborhood on the edge of a smaller city so the nearby freeway was a little noisy for our taste. But, if you live in a city you'll hardly notice the hum and occasional accelerating car. On a map it looks close to an airport but we didn't notice any air traffic.
Overall, it was great. There was room for our fairly large van in the driveway. The house was very clean. And, the lakefront location feels very secluded. It's a great spot for relaxing, catching up on work, binge watching tv, and larger groups.
However, if you're expecting a very high end home or a location near a great (walkable or trendy) neighborhood you'll probably be disappointed like a few other guests have mentioned. Honestly though... if this is at the top of your budget and you're expecting a lot you'll be happier in a hotel or small apartment in a different area.