I and my mother stayed here for almost two months for the summer. Alan's place was almost perfect - the kitchen has the basics in pots and pans and Alan was kind enough to start us off with dish soap, dishwasher pellets, and a bundle of TP. Alan was also very understanding about super late check-ins and late check-outs and issues with the TV.
You can hear road traffic and passersby from within the unit - I didn't have my window open the entire time because things could get loud, but it wasn't terrible. Just a note for those who need absolute silence to sleep (my mother) - that's unlikely to work well. For some reason, the TV which gets its channels from internet streaming, didn't work well for us. The only channels that we could get weren't laggy was the porn. Before you judge, some of the movie/documentary channels turned out to be porn. Awkward, if you're trying to figure out the TV with your mom and her friend.
Flushing Main St. station was a reasonable walk away and there are lots of Asian grocery stores around. I had a much harder time finding what I needed in terms of "Western" groceries, so I had to schlep things in from elsewhere. The nearest TJ is about an hour and a half away, just FYI. We really should have gotten one of those grocery bags on wheels things.
Would definitely ask Alan if this place is available in case we need to do another month in NYC again!