Good location that is just a stones throw away from most of the chaos in Waikiki and easy to walk to the beach. Very close to Zoo and Aquarium if you are interested in visiting those attractions.
Condo was very clean and the managers of the rental are responsive and very prompt (5 stars for customer service!) It also has a nice city view and a cozy little balcony.
The kitchen has a good collection of utensils, plates, bowls and cooking implements but empty pantry and refrigerator. If you plan to do any cooking, you will need to stop by a local supermarket to get condiments, cooking oil, seasonings, etc. Laundry costs a nominal fee and is shared on the floor with no laundry soap provided.
Also, there are no beach amenities included (e.g. no beach towels, chairs, boogies boards, etc.) so be sure to bring your own.