Connie's place checks all the boxes for me. It's in a cool neighbourhood in the Castro/Mission area which has a lot of awesome restaurants. The major light rail and bus lines are a short walk away. The space was really unique and is worth spending some time to examine if you have some downtime from your travels. I didn't get a chance to chat with Connie much but she was more than helpful since even before my stay started with her - she gave me a lot of useful tips around the SF area. I would definitely stay again if I came back to SF. Thanks Connie!