The cottage is as advertised - waterfront. Note there is a seawall in front of the cottage, so it is simultaneously awesome and loud. The beach super-easy to access during low tide, and stunningly gorgeous. Location is quiet and away from the touristy areas. The complex itself is older but well-maintained... some old-Hawaii charm gives the place a retro feel. Inside the cottage, louvered windows don't quite close 100% so the sound of the surf is a constant companion. If you need it to be quiet to sleep, this is not your place - ocean waves are loud! About 15 minutes from shops and restaurants.
Furnishing and equipment is average. The furniture is very low to the ground, so it might be tougher for folks with limited mobility. The mini-kitchen is nice, and the bathroom is retro-quirky. The toilet is smaller model. so keep that in mind if you're of the larger body type.
Overall this is a solid cottage in a beautiful area - a great place to stay for your north shore retreat!