Great location & value if you want to stay right in downtown Honolulu and near Waikiki Beach. It does get loud, even at night, but that should be expected given the location.
Unfortunately, we had a few issues:
1. There was no shower curtain.
2. 2 pillows were missing from one of the beds.
3. There were only 3 full-size towels for our family of 4 (which Ed claimed should be sufficient for 4 people).
4. There were no beach towels, so we had to use the bath towels.
5. The "futon" wasn't a true futon. It was more of a plush bench and it was short/small. My petite 7-year-old could only sleep on it if she curled up and she said it was uncomfortable that way.
Fortunately, I contacted Ed regarding issues 1, 2, 3, and 4 and he was very quick to response. A shower curtain was delivered to the condo pretty quickly. We told Ed we wouldn't be home so they could enter and put up the shower curtain; however, they entered and just left the shower curtain on the dresser... so I had to hang it up. Additional bath towels were delivered promptly once we reported there weren't enough. He didn't provide the 2 missing pillows, however, so we had to sleep on 2 "decorative" pillows. And he didn't provide the beach towels, so we did give him a heads up that we'd have to take the beach towels with us.
From previous reviews it seems like these issues were a fluke, although they did cause some inconveniences. But we only stayed for 2 nights and it was a great price for the location - centrally located, easy to get to the airport, Pearl Harbor Memorial, and Diamond Head State Park.