The good: Good location, nice pool, plenty of space inside and out, lots of kitchen appliances/utensils/dishes, lots of beach items (kayaks, paddle ball, corn hole, etc) included. Property manager answered texts/messages even on Thanksgiving.
The less good: Everything needs a good spruce up...furniture, appliances, landscaping, extra blankets, decor...everything is just sorta dated and not super-well maintained.
New pool, but construction materials left sitting in the yard. New fenced in dog-area, but it's both overgrown and bare at the same time. Railroad ties along the driveway are disintegrating with nails everywhere. Stuff like that. If it doesn't bother you, no worries. Nothing too bad and maybe during peak season it's better maintained, but not "5 star" when we visited around Thanksgiving 2023.
Also, internet was fine but cable wasn't working while we were there. If you're there at a time (Thanksgiving, NYE) where you might want to watch TV, have a backup plan.
All in all, if you want to visit SGI and bring a pet, this is a decent spot.