It is well located if you use a car (15min away from main SF tourists highlights), not sure about public transportation.
The place is pretty small and there very little natural light. I went with my family (5 people and 2infants) and had to use the sofa bed but be aware that it is really uncomfortable, you will feel the iron bars of the structure when you lay down. Probably time to upgrade it.
You need to find public parking in the street since the driveway is not available, it shouldn’t be a problem with small or midsize cars but it is challenging if you drive a 7 seater SUV but eventually you will find it.
The floor heaters works but it takes forever to warm up.
Other than that, we had a great time in SF and the apartment had everything we needed to have some rest and continue exploring the city the following day.
Hope it helps.