The location is one of the best things about this place without a doubt. It was one minutes walk to Waikiki Beach and surrounded by great eating places. Cheesecake Factory was walking distance too. Roy was really responsive. They allowed us an early check in for my parents who just needed to sit.
The apartment is great, clean and quite spacious. We had a family group of 7 and there was plenty of room, though the only bathrooms are in the two bedrooms, so if you have anyone staying on the bed settee in the lounge, they will have to use your bathroom.
As others have stated, it is noisy. Most of the noise becomes background noise, but it does get pretty crazy sometimes. It did not ruin our stay.
We were able to use shuttle pickup from the Aston Beach resort up the road to do tours etc.
There is also an excellent Mexican food truck just beside the apartment, and this was excellent.
Overall, it was secure, sparkling clean, excellently positioned and had great hosts. Highly recommend.