Great location.
great location for getting the bART from the airport and then only walking about 400m ( uphill though!) right to the door. Saves a fortune on taxis.
After that, you are right on Powell Street, a couple of blocks from Union Square and the rest of th edelights.
Trams on market street to get you up to Fishermans Wharf and the piers, trams and BART to get you back over to Mission District for the best super burritos and lively nightlfe. cable car stop right outside and er, for that reason probably better to get a room on the back if you want a quiet night before 12.
Rooms are a bit small on US standards but they are clean, breakfast is enough to get you going, staff helpful so give this one a go!