Jerry's place is great for someone looking for a cozy studio right in the middle of Waikiki. It has all the amenities you can want, you could prepare a thanksgiving meal with all of the utensils, dishes, and cookware. There are two balconies, one that looks out to the east, giving you a nice view of the hills to the north, and another that looks out to the south (you can see the ocean peeking out behind the Royal Hawaiian).
The location is perfect. It's two or three blocks from everything you need and the rest of Waikiki is easy to travel on foot. ABC right downstairs, Cococove around the block, Marukame and International Marketplace two blocks east, Lewers nightlife and bars two blocks west, Ala Moana boulevard and all the shopping you can dream of one block south, and last but not least Waikiki beach is easily accessible with a quick stroll through (or around) the beautiful Royal Hawaiian hotel.
I think this apartment is best suited for somebody who enjoys nightlife and isn't bothered by occasional street noise. Cuckoo Coconuts around the block can get a little loud at times but it didn't bother us any.