I stayed here on a (personal) weekend as part of a business trip. This is a rather upscale "boutique" hotel - one of those converted from a residential property. It's one of the nicer ones I stayed at in the city - the lobby has been recently renovated, and there is an elevator (even if it's a bit slow).
The room was small but clean. The bed was comfortable. The bathroom looked recently renovated, but the shower was absolutely tiny (as expected).
My biggest complaint about the room is that the single-pane window let in a lot of noise, and the hotel faces a very noisy street!
Staff & service: there was *usually* someone at reception, but there was no way to directly contact them from the room. There was no phone in the room, I didn't have a voice plan on my phone, and there was no electronic means of messaging them. This was inconvenient when I couldn't figure out how to turn on the A/C (had to put my key card into a slot), or when I needed some fresh towels.
The area: the hotel is close to Union Square and Market St. Powell St itself is very touristy, with a historic cable car line. There were lots of restaurants around, but there wasn't a lot going on at night - hard to find food after 10pm. The area itself felt reasonable safe, but there is a sketchy neighbourhood a few blocks to the west.