Travelodge (formerly Bayside Inn) on Columbus
Good location. Wasn't noisy. Staff very friendly and helpful. rooms are small but they were clean and functional. Could do with better lighting.
San Francisco is an overpriced city -- we found this Travelodge just fine given how expensive SF is.