Noe valley as a neighborhood is excellent. Lots of cute stores and restaurants with small town feel. Warning lots uphill climbs. It's actually 3 uphill blocks from the nearest cafe. Access to city is 15 min by uber.
As to the apartment, the bed in the bedroom is comfortable enough. The walk in closet spacious for luggage etc. my daughter stayed in an air bed they set up which deflated a bit over the week. Not too comfortable for long term.
The most serious issue I had was the a/c. For some reason on the last day when it was 85 degrees out, I realize there was no cooling or minimal cooling. There was heat. So even with windows open it was more humid and hot inside than outside. It's not a place to live in the summer. During other cooler times in SF it's fine.
As hosts, Steve was amazing though! He even gave me a lift to the ups store because I had to ship a 40 pound box. He was also very accommodating with offering to print boarding passes and other internet access issues. Overall our stay was ok. Just fine for short stays