Andrew's is a great place - finished really nicely, super clean with an amazing kitchen, a lovely hot shower and a massive TV to watch in bed. Check-in is via a lock code which is really simple to use.
Noe Valley is quiet neighbourhood, so if you're looking for a wild time, you'll need to be jumping in a cab or on the bus - but there's plenty of good bars and restaurants in walking distance.
As mentioned in Andrew's listing, the family can be heard upstairs in the morning, so if you're planning on sleeping late then bear this in mind. In our case we were always up early, so not an issue.