I have a friend who was able to snag a good last minute deal on hotels.com for a nice place in San Fran, but it depends how far out you want to plan your trip. He logged on a day or two before I believe.
I've flown into HWD a few times but only day trips, no overnights. Nice airport, only 1...