My husband and I are going over there again in a couple weeks. Does anyone have a recommendation for a smaller, non-chain, intimate hotel near Union Square? Cheap? Close to sights? Near a BART station?

The last time we were there, we stayed very near the Tenderloin District. We'd rather not do that this time around.