I had a pretty good time during my time in Waikiki at this listing. The room is a privately owned part of a commercial hotel block, so you can use the amenities like the pool and coin washer/dryers (bring your own detergent and quarters) in the basement, and is very centrally located (max 10min walking distance) to the main part of Waikiki beach, shops, and tourist bus pickup/drop-off locations.
Roy and his wife hosts were great! He was very responsive to text/calls if anything goes wrong. There was a small electricity mishap that affected a portion of Waikiki for a short time while I was there (nothing to do with Roy), but the staff at the hotel had that sorted out within 15mins. Roy is willing to work with you on check-in/check-out times whenever possible, and if he is around, you can also ask to borrow some beach equipment.
All in all, you can expect to be in a pretty standard hotel room without the daily room service, but with extra perks/utilities you usually wouldn't find (e.g microwave, beach equipment), and the price is around the same or slightly lower as if you had booked a room in the actual hotel.