IMO as a former SF resident, Mikey & Mike's place is in just about my favorite location anywhere in the city. The location is within walking distance to some of the best local neighborhoods and attractions in the city - Inner Sunset, Cole Valley, the Haight, and of course, Golden Gate Park. In addition, the N-Judah line is within blocks, so it's super easy to jump on MUNI and head to the Upper Market/Castro area, downtown, or out to the beach. Parking isn't the easiest, but if you pay attention to the signs and don't mind walking a couple of blocks and moving the car on the way out to get coffee in the morning, it certainly isn't a big deal.
The place itself is great and in fact, the pictures really don't do it justice as there's more space than appears in the pictures. Even with cleaning fees and service charges, etc. - the overall per night cost was very reasonable compared to a typical night in SF AND you get to stay in one of SF's best neighborhoods instead of downtown where most of the rooms are located.