If you're looking to stay on the north shore without paying for an expensive resort you should definitely consider this place. Also definitely stay on the north shore, it's fantastic and completely different to Waikiki.
The unit is great for two people. The living area is spacious with sofa and dining table. The king size bed is comfy. The only odd thing was that the TV is in the bedroom not the living space. There are ceiling fans throughout but AC in the bedroom only. We therefore spent most time in the bedroom.
The unit comes with some basics including fridge/freezer, portable stove top, microwave, toaster and kettle. There are pans, crockery and cutlery. We were able to prepare breakfast and basic meals. There are also lots of food trucks a few min from the unit. We did miss having a coffee maker - we ended up making it in a saucepan. Such a shame given the great Hawaiian coffee available.
The bathroom was clean and usable. On the small side but shower was a good size with good pressure.
Wi-Fi was good, not great. Netflix was available for free on the TV which was a nice touch.
The curtains were quite thin and didn't offer much privacy. We ended up putting up towels to cover the bedroom windows.
Overall this was a great unit. Excellent location in a quiet residential area. There are roosters but they are everywhere in Hawaii. The host was friendly when we met him. The price was fantastic.