We stayed for 2 nights and it was fine for what we needed--mostly a place to crash on the days we were doing our hiking, but if you really want to spend time at the beach and getting a feel for downtown Waikiki, I would recommend staying closer to the beach.
The pool was ok for a quick dip, but if you're looking for a spot to lay out by the pool, this is not it, as it lacks atmosphere.
The apartment itself was clean and really cute and beachy! We loved that there was laundry in the building and parking included. The building is older and a bit run-down, but overall we were not displeased with our stay.