Miegan and Charles place is perfect for a longer stay in SF.
You are right on the doorstep of the Mission District (without being in it) and the Bernal Heights area gives you some great views of the city.
This will definitely be my first choice next time I visit SF!