Marc's place is exactly as described -- clean, well-located, with great views from the deck (you literally have a partial view of the Golden Gate bridge from the deck). Don't let the busy street entrance give you the wrong impression. We traveled with our kids and was not concerned about safety in this area.
The apartment is located within a 10-15 minute walk of so many great things. You can walk to Ghirardelli, Fisherman's Wharf; then connect to the rest of the tourist attractions via cable car, trolley, or bus from those areas.
The real gem though...the apartment is mere blocks from a hip locals area where an eclectic and lively selection of restaurants are. There are great places for brunch, lunch, and dinner.
We stayed over a long weekend and were able to find street parking nearby. On weekends, the 2 hour limit during the day is not in effect, but of course, read the signs. There are paid parking nearby as well, if you need it.
Marc was really cool...he even let me drink his beer. I paid it forward by leaving some frozen burritos.
As for the street noise that a previous reviewer mentioned, it was mostly from traffic and the occasional car with a loud engine. Though located near a large street, there are no late night bars/clubs; so, no crowd noise from bar patrons or the like, which I would think is worse than car noise.
Do not miss out on this hidden gem. I would have no hesitation in staying here again.