This is the ideal house for our family Christmas get-together. The basement DID NOT smell like mildew (my wife is super sensitive to that, and she had no issues). The upkeep of the building is about average, nothing that sticks out as obviously needing repair, but it is well used. The Indoor pool is awesome, but if you rent the property in the wintertime, keep in mind that using the hot-tub/pool makes the humidity approach 100%, this makes the bball court slick (this can be easily taken care of by opening a couple doors for 10 mins, and then allowing the heaters to kick on and warm up the (now low humidity) air). I initially thought that we would have to watch the young ones like hawks since there is an open pool, but fortunately the pool is separate from the main gathering areas, and plus it has a cover that would probably support anyone under 150lbs. The bball court had balls and the young ones thoroughly enjoyed using that area. (if you have young kids, bring along a trike... the ball court is ideal for this)
If you are serious about your basketball, this is the place to go.
The house was VERY clean (must be a cleaning service), and was very spacious. All the bedrooms seemed pretty much soundproof, so if some of you are night owls, you won't keep others awake.
At one point we invited some extra friends and family over, and we had about 30-35 people in this house. It swallowed us with no problems.
The house has its own washer and dryer, which were indispensable (we probably did 7 loads in the 5 days that we were there)
The hottub is a nice one, and it comfortably seats 6.
Close to Autozone, and several restaurants.
All in all We LOVED IT!