We stayed here over Labor Day weekend -- 6 adults and 3 young children (2, 3 and 5 years old).
Situated just south of and within easy walking distance of the downtown shopping/dining area, and a few blocks from the Grand Haven State Park at Lake Michigan (a short drive or bike ride -- too far to walk with young children). For older kids, there are a few parks nearby, including a large playground at Mulligan's Hollow which is also adjacent to the skate park. The neighborhood is safe & walkable, the neighbors (we met a few of them while the kids were playing outside) were all very friendly and stopped by to say hi, and let the kids pet their dogs, etc.
This house was a great central location that allowed all of our families to stay together; the kids could play, adults could socialize, plenty of room for lounging and a formal dining room let everyone eat together, as well as a large covered porch to enjoy the evenings or stay in the shade while the kids ride bikes outside. Additionally, compared to many rentals we've stayed in before -- especially those near Lake Michigan/waterfront, the house was very spacious: large living room, formal dining room, and bedrooms big enough for everyone. Comfortable beds and recently updated/renovated bathrooms were a nice bonus.
I'd definitely recommend and consider staying here again -- especially for families or groups who want the amenities and conveniences of a "home", rather than separate hotel rooms/etc.