The location is great but be aware that this is more a 2 persons rather than a 4 persons flat. The sofa bed in the living room is used (mattress is curved) and not confortable for 2 adults. In addition the kitchen lacks basic equipment: we were not able to cook pasta for 4 (pots and pans are very small). Since there is no dishwasher, more glasses and mugs are really needed.
That being said, comfort is good for 2 persons. And you will be 5 minutes walking distance from Waikiki