The unit is as advertised, the pictures don't lie. Clean and comfy, but since you're in Honolulu, you shouldn't be in the room much anyway! Mark is a very communicative host and I had no issues with checking in/out or navigating the building.
Looking at the building head on, the unit is on the right side. Didn't hear any neighbor noise or see any neighbors either. It's located on a quiet side street with all the action right around the corner. Musubi, the beach, and coco puffs are all within short walking distance, although I didn't recognize the International Market Place right away. Plate lunch @ Rainbow is a 10-15 minute walk. Zipcars are a block or two away.
Keep in mind that although you are in paradise, Waikiki is busy so you will hear "city" noises (loud cars, garbage trucks, sirens) so bring earplugs if necessary. The air conditioner is right next to the bed too (but the air blows upwards) so earplugs may help dampen its sound as well. The unit also has blackout curtains.
I hope to return soon!