I like to check out the suggestions on Red Tricycle: https://www.redtri.com/san-francisco/fun-stuff/family-vacation. My husband and I just went on a trip to Napa WITH KIDS after reading one of their articles, and everyone had a blast. (I didn't think it would be possible!) They have great ideas for trips and day trips in the Bay Area--I haven't tried them all, but I like to dream
Re: Weekend trip ideas
oops! we want to take the kids to the aquarium, know of any good deals?
Do you mean one day trips or all weekend? I love Sea Ranch, but it is too far for a day. Really best for a two-nighter or more.
A couple other ideas- Half Moon Bay, SF (of course), Stinson Beach, Muir Woods.