Thank god it was only one night!
Hotel prices being what they are in San Francisco, you are hard pressed to find anything in the heart of the city for less than $200 per night. I used Priceline to find a place for a one night stay and ended up here. With taxes we ended up paying $212 for the night...and an additional $35 for parking! 
Our room was on the second floor (#207) and faced Mason Street...avoid it like the plague. While the characters outside provided interesting entertainment, I prefer to sleep at 6:30 in the morning...not be awakened by two women screaming at each other in the middle of the street. 
The hotel was in an old building and the room was, naturally, small with a queen sized bed, one nightstand, and a small desk. The lighting was inadequate and if you were on the side of the bed next to the window you had no lighting whatsoever. There was barely space to set anything down and a tiny little glass shelf in the bathroom to house your toiletries.
The bed was absolutely god-awful. We spent the night gripping the sides of the bed to keep from rolling into the middle. We got up in the middle of the night and stuffed a spare blanket under the mattress in the middle to help the situation but it did little to alleviate the problem. We both woke up with backaches the next morning.
So glad it was only one night...we will NOT be back!