The apartment is a great place to stay while you're visiting SF. The location is perfect.
However if you're planning to work make sure you confirm if the internet connection was upgraded. The house has poor internet (~7/8Mbps) and since it's on a lower floor the cell service is pretty bad as well.