We take our 2 with us and have stayed at some great pet friendly hotels.
The Cypress in Cupertino/San Jose is a nice pet friendly hotel with beds, water bowls and treats as well as the W in San Francisco. We have paid as little as $20.00 and as much as $100.00 for pet deposits.
I am glad your trip worked out well for all of you.
