The
Aida Plaza Hotel is cheap ($55 a night), and only a few blocks from the Moscone Center. According to Google most of the distance can be covered by public transit down Market St.
It has some mixed reviews, but after 10 years in the military my hotel standards are generally lower than most people's.
