I stayed in Andrews studio for three months, while working in SF. The place is small but well planned with the bonus of having a loft to either store things in or just sit and look at the beautiful city from. The studio is located in SoMa, very close to Market Street. I also found there are busses close by to both The Mission and the China Town/North Beach and Golden gate Bridge.
The communication with Andrew was very smooth and he checked in with me a few times to make sure everything was fine and to ask if I needed anything.
I can highly recommend Andrews studio!