Awesome apartment. We stayed for two months with my two young kids - the apartment is as beautiful as it looks on the pictures - very high ceilings, well decorated, the kitchen stocked with all the pots, pans and appliances you might need: everything to make your stay a great experience.
The apartment is located in the heart of the Mission - probably the most vibrant neighborhood in San Francisco, and some might even say on the West Coast. There are so many great bars and restaurants to explore. The bedrooms are all facing the backside of the apartment though, so they are quiet at night.
Darren was very responsive, communicates effectively, and was flexible and always trying to find solutions to our small problems. I met with the neighbors who were really also very nice, despite our young kids being quite loud.
I would totally recommend for a short or a long stay in SF.