Stayed here for a month. Location is pretty good. A short walk to the J train or a bit longer walk (or bus ride) to two other train lines. Not too far from lots of shops on Broadway. There are also a few bikeshare locations within a 10 minute walk, which I used a ton.
I had no issues with the apartment at all. It did get hot with no A/C but really wasn’t too big of a deal. It wasn’t super clean but no bugs or real issues. Kitchen had plenty of supplies. Internet worked fine for working from the apartment. I stayed alone for most of the month and the extra bed was great when friends visited for the weekend. I could definitely hear music from the neighbors pretty often, mostly just during the day though. I spent a lot of time sitting on the stoop outside, which was awesome.
Overall, I would recommend staying here. Pretty cheap compared to other places so a good value.