Stayed in the condo for 5 nights with our two kids (5 years and 1 years old).
PROS - 1. Great location - next to Hilton Hawaiian Village lagoon and beach, easy 15 min walk (but hot in September) or close bus ride to Ala Moana Center, 20 min walk to Waikiki or option to catch various buses 2. Local amenities - many restaurants, convenience stores and shops to try out/explore 3. Great view - Right on the marina, can watch sunrise/sunset, eat/drink on the (small) balcony with a gorgeous view. We didn't see the fireworks from the condo as we didn't stay on a Friday night but I imagine the view would be fantastic. Having said that, you can also easily see the fireworks on the beach where the Hilton Hawaiian Village and Hale Koa Hotel is too 4. Easy check in/out - given a lockbox code to gain access to two set of keys 5. Fully working a/c 6. Stylish and relatively clean place to stay in the heart of Honolulu 7. Fully equipped kitchen 8. Free use of beach chairs, boogie boards, floaties, mats, snorkel/slippers, beach toys 9. Laundry facility on same floor - easy set up of app to pay for each use ($2.50) 10. Good wifi connection.
KEEP IN MIND - 1. Outside noise - the condo is on the eighth floor right on the marina with non-insulated window/balcony sliding door. You can hear people/cars down below. It wasn't an issue during the day but it could be at night. Our kids had no problems sleeping through as they were exhausted each day from all our activities! However, I am a very light sleeper and I can hear everything. Thankfully, with the a/c running at night - it acted as a little white noise buffer to the outside noise below but also I had brought along and wore my ear plugs and noise- cancelling headset. So if you are light sleeper like me - do the same and you should be fine! 2. Bathroom cleanliness - the basin sink was slow running, the sliding door trim edges to the bath/shower could do with a deep clean as well as the bathroom vent 3. Parking - we hired a car for a few days to drive to the North Shore and east side of the Oahu. We decided to pay the $20+ per day in the building garage (there was plenty of parking space and you can drive/park up on the seventh floor) for one of the days. The other parking option in the marina building garage is to pay $8 in advance for 10 hours of overnight parking (great option if you're going to be out all day anyway) . Or as some other reviewers have said you can try to find marina parking for $1 per hour 4. No temporary parking to unload at check in - we had to put our hazard lights on, parking in front of Red Lobster. I sat in the car whilst my husband would unload and take up our luggage to the condo 5. Smoky smell to common hallway - coming out of the elevator on the eighth floor and walking to the end of the hallway where the condo is you can't miss the whiff of stale smoke. But once in the condo, it wasn't a problem.