Excellent location. It is a few steps away from Waikiki beach. There is a deli across the street and plenty of nice restaurants in the neighborhood.
The studio apartment is spotlessly clean, and the bed was very comfortable. However, the sofa bed did not provide decent support for sleeping (it is good enough for a couple of days, but not for sleeping a full week).
The internet connection was fine for checking messages and browsing the web, but might not be fast enough if you are planning to work (I experienced some speed issues when I connected to video meetings).
The kitchen is well-equipped, but we missed a dishwasher.