A Decent Motel in the Castro Area
We stayed here two nights. Off street parking was a major plus, especially after walking down one of the side streets coming back from lunch and seeing a broken car window with the glass still on the ground. I would recommend a second or third story room if you want some security. First floor rooms are literally open to the world. There is only one elevator and no hand carts for luggage were available the night we checked in.
Be prepared as most rooms don't have AC. We had windows open (there is a bar that prevents each window from opening more than 6") and the fan running. Even with the window open, the place was relatively quiet, especially considering that you are right on Market Street. 
Yes, the complex is old, but the location is right. The front desk did claim they were planning to renovate the place this winter. The room was clean and modest, with a flat screen TV, a refrigerator, and a large closet. The bed was acceptable. Public transportation is a short walk away. In a nutshell, it served our purpose.