The apartment is exactly what you see in the photos, small and clean, also has all the basic living appliances (microwave, refrigerator, etc.) for a short vacation stay.
The location is awesome - walking distance to majority Waikiki areas, including the Waikiki beach. Very accessible to lots of restaurants/shopping malls.
If you rented a car, make sure to communicate with the host beforehand. They can help reserve a parking spot underneath the building which makes everything so much easier.
Another thing is that it could be a bit loud at the nighttime (the street + the AC in the room).
Overall, this is a great option in Waikiki area! We enjoyed our stay and would come back.