This place is amazing and is just perfect for my little family of four. It's 5 minutes walk to the Waikiki Beach, and from there there are plenty of restaurants, shops and pretty much anything a tourist needs/wants. It wasn't noisy or anything. Just keep the door shut and you won't be hearing any noises outside.
The condo is clean and has great views (not the oceanview if that's what you're looking for). It has two full size beds and are really comfortable so that was a bonus. AC was working perfectly and having a full kitchen was really important for us because my little boys are really picky eater so we used the kitchen more and ate less outside.
One thing that is kinda annoying was the sliding door to the patio. It was hard to slide and kept getting stuck. I think it's just needs a little oil to make it smoother to open. Other than that, it was good.
Parking is free (thanks Monique for the parking pass) but make sure you come back at the place no later than 9pm otherwise it's so hard to find a spot and the parking spots are so narrow that if you're renting a van or bigger SUV/trucks, it will be a pain to park. So keep that in mind.
Overall, we truly enjoyed our 8 nights at this place and we highly recommend it.