We loved the location - at the top of the island but only 15-20 minutes to groceries/gas/food. SO close to the water which was high in our wishlist. Pretty quiet, and gorgeous views greater than 180 degrees. Fyi, water was quite rough many days - low tide is the best bet with kids. Lots of fun critters to find in the tide pools - we found a ton of crabs, hermit crabs, and small fish, and even some surprises including a small ray, a flounder, a shrimp, and some really cool Mudskipper-type fish.
Property was fine - came with some typical downsides of rentals, like non-draining tubs, dirty or broken kitchenware, subpar A/C, things like that. For the price, I think at least some of these things could be improved. But it was overall just fine, kitchen was large with a huge peninsula and bar stools, couches were comfortable, and it had two oceanfront decks. Side note - there was no beach access from the decks on the back of the house - you have to use the front door and stairs and walk through the sand under the house. No big deal on the way out but not great for keeping sand out of the house - you have to walk through sand after rinsing off at the hose. Swings were a fun touch for the kids.
FYI, Oceans Edge restaurant at the condos down the road was terrible. Gorgeous views, but service was average to bad, and food was absolutely awful. Go anywhere else. We had way better food at the SeaView Pier restaurant and pretty good pizza and subs from Baked.