The place was in a good location for our activities near the North Shore (Rainbow Watersports Adventure for glow sunset paddleboarding) and Kailua (Kailua Ocean Adeventures for Hawaiian canoeing) (about 30-45 minutes in either direction). NOTE: there's not much to eat locally in the area late, but there are some chains open later.
As other reviews stated, there's construction on the property and a sewage-like smell at the front of the property, but you can't smell it in the condo.
The pull out couch was comfy enough to sleep on with the foam cushion, but it didn't fold in or out easily - we couldn't fold it back, most likely due to the rust from the salty air.
The lanai door doesn't lock but there is a board there to hold the door shut. We were unable to lock the front door deadbolt from the outside (but could on the inside).
We liked that they had feminine hygiene products and first aid kits available in the bathroom in case they were needed. The place also stayed cooled with the nice breeze from outside. We were also happy to be able to do a quick small load of laundry.
The place isn't luxury, but was about what was expected for what we needed for our stay and it was nice to use the dishwasher for dishes at the end of our stay.