The place was exactly as listed. A cozy, nicely decorated space in the heart of the Upper West Side. It is a pre-war building with all the little things that go with a pre-war building, so if you're expecting the Waldorf-Astoria, you'll be disappointed. If you are expecting a nice home-base in a great location, you'll be happy.
It was very clean, absolutely pest free, and I hardly heard any of the neighbors. The description mentions the street noise and you can certainly hear the activity on the street... but its a really quiet street with very little traffic. Unless you are super-light sleeper, I wouldn't worry too much.
As for the hosts, they were great. When my flight was delayed, they went out of their way to make sure I had access to the apartment after their stated check-in time. I couldn't speak more highly of their hospitality!
I would certainly stay here again