A cozy, clean unit! We had to stay in a different unit that Niko provided for the first night of our 6 day stay because of a plumbing issue, but once we were able to stay in the room we booked, it was lovely. Fully stocked with all the kitchen appliances you might want, including a blender and toaster, which were key for us haha. It's newly refurbished, with linoleum floors instead of a carpet, a nice full-sized fridge, and a new air-con unit, which came in handy throughout our stay. Internet was fast, and I could video conference regularly from our unit. Lots of nice little touches, like boogie boards and beach chairs provided.
Assigned parking spot is in a lot that is quite tight, so I would recommend that whoever is behind the wheel should be a good driver!
Location is indeed in the middle of Waikiki, which means that all of the really touristy things are within 15 min walk. We were able to just walk to the beach within 10 min! But of course, this also means that it will be noisy in the evening. There is a bar or something close-by that you can hear until about 11 PM each night, with live performances of hit classic songs (eg. The Eagles, Elvis, The Beatles). If you're a light early sleeper, I wouldn't suggest booking anywhere in Waikiki, since this seems to be par for the course in this area. I'm sure that any building in this area would have similar noise, so it's not a knock on this unit in particular.
Overall, it worked well for our purposes, and Niko was communicative via text the whole trip!