Our experience at the condo was great. It was exactly as described! Not fancy, it's a beach cottage. So don't come expecting that. But it surpassed my expectations. The photos actually need updating because the current living room furniture is BETTER than pictured (and everything else is accurate). As of our stay, there's a day bed with pull out where the futon is pictured AND a small couch where the chairs are. We felt like there was so much room to spread out, AND there was enough drawer space so that we didn't have to live out of our suitcases for the week.
There is road noise, because the condos are right off Kamehameha Hwy. Also, on the occasion that the neighbors took the "quiet hours" very literally (10pm to 6am), we were woken up by loud talking and banging doors since the bedroom is right next to the parking lot. But this only happened once or twice with specific neighbors. And didn't bother the kids who were sleeping in the living room, at all. I feel like it's worth mentioning incase some people are very sensitive, but for us it was a very minor annoyance compared to what we were GETTING.
The beach was quiet, only ever 5 families at the most on the stretch that we could see. The swimming/snorkeling was good. The waves break far out and so the water was much gentler on our little stretch of beach. There was coral close enough to shore that even someone who wanted to stay close would at least get to see a few fish while snorkeling.
The area, as a home base, was also good. There were a few small grocery stores not too far, and plenty of food trucks. It isn't a touristy area, but is close to both the Polynesian Cultural Center AND Kualoa Ranch (about half way between the two). And plenty of beautiful, quiet beaches.
Long story short, we would certainly stay here again if we were given the opportunity!