We used John's house as a rendezvous point in Hawaii for us and another family. For that, it was great! The house was spacious and well-appointed; and the snorkeling gear, travel guides and tips, and beach towels and toys made for a great visit. The kitchen was stocked with good cookware and equipment, and we ate fabulous meals around the large dining table.
The location was both a blessing and a curse. The road between Kona and Papa Bay is CURVY and slow. If you're wanting to frequent the shops and dining of Kona or the Kohala beaches, this house is probably too far. Also, stopping in the market for some small necessities requires planning, as none are closer than 20 minutes away. Still, if you like less-developed (i.e., not crowded) beaches and excellent snorkeling, this is an ideal spot. Our favorite west coast beach, Honomalino, is super close. The nice beach at Ho'okena and the exceptional snorkeling at Honaunau Bay (2-step) are reasonably close.
So, if you have a larger party, you aren't interested in doing lots of touristy stuff in Kona and farther north, and you can be reasonably self-sufficient in food and activity-planning, this is an awesome place to stay.