John was an exceptional host. Although we didn't meet him in person, he was always very prompt in his replies. Even the fridge was stocked with some food and beverages when we arrived.
The apartment is exactly as it is featured in the photos. It is nicely furnished and decorated. Internet is reliable and fast.
Two things I want to mention: it is a basement apartment, so walking in, you literally feel like walking into a basement, but that impression changes as soon as you open the apartment door. If you suffer from allergies or asthma, a word of warning - it is a bit stuffy, even with the windows open. Also it's an old house, while there is no street noise and it is a very quiet apartment - you can hear the people above walking, which is a downside if you are on vacation and they are not or if they are having a party.
Still, I would definitely recommend the SOMA Hideaway to anyone visiting San Francisco.