A wonderful location exceeded only by the host. Joseph met us when we arrived and gave us the lay of the land. He's an incredibly knowledgable guy when it comes to Manhattan - especially the world-famous stuff and little bodegas just around the corner.
We slept very soundly and comfortably on the trundle bed set-up. The windows look out on 10th Ave, so it comes with some background street noise but nothing too strong. If you're coming from another urban environment yourself, you hardly notice it.
As for transportation, Joseph's place is close to bus and train lines and is about 10-15 minutes' walk from Columbus Circle and the SW corner of Central Park. Also close to midtown Manhattan locales: Times Square, Madison Square Garden, Penn Station, etc. Joseph's neighborhood is lively and filled with restaurants and shops. We were in town for the NYC Marathon and it was a perfect spot.