Great place to stay in the San Francisco area and a good starting point to explore the city as well as e.g. Napa Valley. Yes, you definitely need a car.
The house has really all you need (including aircon) and the area is absolutely fine.