no frills hotel for solos/couples, but well kept in a perfect location
This is a place that definitely would work for some, and not at all for others. Stayed in September for 3 nights and originally booked a queen with bathroom for $209 a night, but then saw it was almost half as much for a single queen with shared common bathroom (109-119$) and during the weekend I stayed the neighbouring 4 star hotels were running around 400 a night
As mentioned in other reviews, this is a remodeled victorian building, so the rooms are very small. In the Single Queen, the bed takes up 90% of the space with maybe 1 foot around the permiter, and the walls are very thin, very easy to hear noise from other rooms. So not the best place for people with rambunctious or small kids, large families, some seniors, people on long stays or pack heavy. The shared bathroom and shower was very clean and never had to wait, but the rooms are about the size of closets, so not for claustrophobics.
The room itself was perfectly fine to pretty decent. It was nice and clean, bed was pretty comfortable, and had flat screen TV and good wifi connection. I skipped the morning coffee and muffins in the lobby.. it was bizarre seeing patrons scattered everywhere in the lobby having their coffee whereever they could find a spot to sit. I think they need to partner with a nearby breakfast place or have a rail along a wall and barstool seating to maximize space, but then that would dectract from the victorian lobby.. they are trying to have it both way.. but falls flat there.
Service seemed friendly enough to me, but I didnt really probe with my questions. having stayed in European hotels before, I can understand the range of opinions to quite helpful to not at all usually the direct correlation is the more lenghty/difficult the question, the more impatient/less helpful they will be. 
The best asset of this place is the LOCATION!. You can take the train from the airport to a station which is about 100 feet from the hotel, basically a walk around the corner of the Old Navy Store. Also at that location is the Metro (subway), the trams that go to Castro, Fishermans Wharf and elsewhere and the cable cars to Fishermans Wharf are about 2 blocks away. Every mode of public transportation available is pretty well much there and will get you anywhere if you know what youre doing. Within that 100 feet walk to the hotel is a mall with all the main stores (Bloomingdales, Old Navy. Ross and the Apple Store is across the street... Macy's Union is a block away..and goes on and on MoMa and Yerba Gardens less than a block out where theres a AMC Imax theatre and greenspace and a small kids park.The walk to At&T ballpark is an easy 8 block walk down 3rd street. In this part of town, I felt fairly safe.. you will see homeless people around, but you will in all parts of SF, but lets say compared to the Mission area at night, its pretty quiet and docile.