I stayed at this location for four weeks, so here's my take on it. As far as value goes, great value! I feel that I got everything I needed for a long stay.
As far as location, it's within walking distance to Knockdown Center, the Brooklyn Mirage, Elsewhere, etc. if you want to go out during your stay. It's also less than half a mile from the L-Train. There are two gas stations if you walk toward Metropolitan. Also on Metropolitan is a pizza place called Bella Donna. I went there a lot. Great selection and prices for a neighborhood spot.
As others have said, the upstairs neighbors do make some noise at time and it does appear they have a toddler. However, that goes with the territory when deciding to stay in a residential area in New York City. You may not get hotel quiet.
If you stay here, please take into consideration that you're staying in a shared space. The mess and noise you make affects others. Also, your shoes do track in all the dirt and grime of New York City. You may not have to wake up early, but others do. Clean up after yourself.
Access to the washer and dryer was AMAZING!!!
I think this place is perfect for the tourist who plans to stay in NYC for a week or so. During my stay, it just so happened that other guest made loud noise on nights when I had to wake up early, but again, it's a shared space.
Overall a great stay when you factor in everything.