We found a place, thanks everyone for your help!
We're looking around to buy somewhere in the Bay Area but might be open to house sitting in winter for the right price/arrangement. We still have a small dog. Given ongoing "work remotely" options we're very flexible on place.