I stayed at this unit for 2 weeks in December with my wife and 3 kids. The condo consists of a living area/kitchen, master bedroom with an en-suite bathroom, and a second bedroom with 2 beds, and another bathroom. There is a new washer/dryer in the en-suite bathroom, a split A/C with one unit in the master bedroom and another one in near the kitchen (no A/C in the second bedroom). The kitchen has a dishwasher, cooker, microwave and a coffee maker. Both master bedroom and the living area had TVs, and there is an HDMI cable to plug it into the laptop. The dishes, minor appliances, furniture (except the beds), and the contents of the drawers appears to be a mix and match from the previous owners (we even found a Maui guide book inscribed with "Happy Birthday Dad, 1986" in one of the drawers), but is ultimately usable. The roof has multiple gas grills that were not busy at all, so we enjoyed some grilled lunches on multiple days. There was also plenty of parking in front of the building.
There are a few pitfalls though. First of all, although the condo is technically waterfront, the water is much less clear compared to other beaches like Kamaole, let alone Makena. The "kid-friendly shallow water" has actually rock surface underneath, is murky enough not to see your own feet, and turned outright brown after a December storm. That said, ocean views from the balcony are wonderful and very relaxing, but if you want to get into water, you are still better off with a short drive.
Also make sure you run an empty dishwasher cycle before running your first load. When we used the dishwasher for the first time, it sprayed the dishes with a yellow liquid of unimaginable foulness. Turns out, the lower compartment accumulates some food pieces, and if there was a long enough gap after the previous guests, they tend to rot quite badly. After taking it apart, cleaning it for about an hour and running a few empty cycles the smell gradually went away, but we had to manually rinse the dishes for a couple of days.
The A/C units provide adequate cooling, however both of them have external condensate pumps right under the indoor units (you can see the small white boxes on the pictures). The pumps turn on for a few seconds every couple of minutes, and make rather annoying noise (like an espresso machine pump), even if you turned off the A/C. We did contact the host about it, and they have called an A/C technician, that cleaned the clogged filters (also pointing out that the A/C appeared to be unmaintained for a while), but the problem never fully went away. Turning the A/C off a few hours before going to bed mostly solved the noise problem.
I was also rather astounded when after our 2-week stay the host tried billing us for additional ~100 CAD$, because of some sand on the floor (accumulated from ~30 beach visits) and crumbs on the table that I would expect to be covered by the cleaning fee included in the booking. I politely objected to it and haven't heard back since then, but given the dishwasher, A/C and this incident, I got an impression that they are trying to allocate as little resources as possible to cleanup/maintenance.
Otherwise, the place is just fine if you are OK with the workarounds. Most of the issues that bugged us are totally fixable given enough attention and I hope the host will tend to them eventually.