We stayed here for a week in early August - family of 4 with two girls (7 & 4).
Size - The place is a little small but still very functional - you can definitely make it work. Very clean, well organized, and pretty much everything you need. The condo is well represented by the description online. We used the kitchen daily and the grill outside came in handy.
Cost - It's one of the cheapest locations that we found online for being that close to the beach. I think it's well worth the cost.
Location - Perfect location. It's a block from the beach and there are public bathrooms at the midpoint. The outdoor showers there weren't working which was a bummer but not a major deal. The condo is on a street that abuts a marsh, so: 1) it's very quiet, unlike the downtown area a few blocks away 2) there are beautiful views, sunsets, trails within a 2 minute walk from the door. As mentioned, it's close enough to downtown - 10 minute walk to restaurants, stores, and a playground. For some reason all of the stores close at like 5:30 which is dumb, but what can you do.
Overall: The place is small but cozy and well worth the money. You wouldn't want to spend the entire day in the place but why are you at the beach if you want to do that anyway. It's perfect for meals, lazy mornings, movie nights, and sleeping - otherwise you're at the beach, downtown, or somewhere else outside. Definitely recommend and will most likely return