The space was clean, and had all the basics (mini fridge, kettle, shower etc), good wifi, and a comfortable bed. My husband and I really enjoyed the location close to Golden Gate Park, and it was an easy walk to a direct transit line (though it then did take about an hour to get into the city). We were able to find on street overnight parking for our rental car two blocks over.
The space was however incredibly small and is probably best suited to one guest. With two people it was quite cramped, and made it almost impossible if one person woke up before the other in the morning.
I didn't have any issues with noise or sleeping, but my husband who is a light sleeper found it loud in the unit at night, and there were people coming and going from other units in the house at different times.