We loved staying here! My step dad grew up in Kona, so I have been many times. The condo looks exactly like the photos and is beautiful. We came with our 9 yr old & 5 yr old. Our daughter said it was the most comfortable bed, and we needed one at home.
The condo had everything you need for your stay including: ample cooking items, even food storage options, water cups and kid items. There were extra blankets, boogie boards, beach chairs and pool floats. You are in the heart of Waikoloa, the walk to the beach might be too long for kiddos if you are hauling gear, but it is a real quick/short drive.
The other residents in the complex lean on retirement age. We worried for a moment with our kids, it there was no issue . For those with noise sensitivities the AC unit is loud/a little jarring when it first comes on and if it kicks on during the night. The 2nd bedroom closes off with sliding doors and can hear everything in living room if you have folks on different schedules (or kids lol