We (myself, my wife, and our 5yo) stayed 4 days/3 nights at this property. We enjoyed the house, which is rambling, comfortable, and interesting, as well as the water features.
The small beach was sufficient for our daughter to play on and build sand castles. The beach is a 5 minute trip away, using the provided golf cart, so it is not ideal if you want to fall right off your back deck into the water, but the drive adds a fun element for kids or anyone who doesn't golf on a regular basis. (Plus we spotted several deer and a bald eagle on these trips.)
The inlet is perfect for use with the provided kayaks with a great combination of creek, hidden beaches/sandbars, woody shores, and marshes. You can choose any length of trip as the fractal nature of the coastline permits you to go on as long or as short a trip as you like and still enjoy new sights out and back.
The house was clean and spacious. We cooked a full dinner (including a large pot of crabs) in the kitchen and didn't lack for anything. Wifi and cellular data were slightly slow, but adequate. Full satellite TV was available.
Everything is 20+ minutes away, but everything that you would need for a vacation is available within a half hour drive.
Between the beach, fire pit, deck, and large house with numerous bathrooms, and semi-isolation, this is a great place for a family, but would be a perfect place for a youth group, sports team, or other collection of young people who need space and activities, but not necessarily a bed.