We had a really great stay at Miegan's place. The apartment was warm and comfortable when we visited (December). The area felt very safe for kids, with two good playgrounds nearby.
The BART at 24th and Mission was about 20 minutes walk away, (or 10 minutes + 5 minute bus ride) meaning you could be downtown in around 30 minutes. So it is a great base for exploring the city, but still provides a quiet retreat for jet-lagged arrivals.