Miiiiiiiiles away!!!!!
So we picked this hotel as the photos looked ok on bookings.com and we were trying to save money. Turns out we were AGES away from Union Square and it was pretty quiet with a few vagrants wandering the streets which was questionable at best for two girls travelling in an unfamiliar city. San Fran is not really known for it's breach life (it is pretty cold at times). There were gaps around the doors so it really didn't feel super safe. There is no reception really, we talked to a guy through a window when we booked in which was pretty dodgy. I wouldn't recommend it! No free Wifi. Felt unclean. Beds were not that comfortable. 
On the upside it was VERY cheap and saved us a bit of money to shop and the tram was right outside which is handy but you will take 20 -30mins to get into the heart of San Fran. My advice in smaller places around America is the Holiday Inn Express. Free Wifi, good value, great locations everywhere, clean and reputable.