A very local experience in this neighbourhood, which I liked for the authenticity and relaxed atmosphere. You won't find a lot of tourists here, only locals (who are friendly), some chain stores, fish fries, the ever present beauty and nail stores and a bit more trash on the street than in Manhattan. It's a bit far, if you are mainly interested in Manhattan, but the bonus is that the J train once it leaves Manhattan runs above ground with great sights of Brooklyn and you'll have a great view of the skyline when crossing the bridge to Manhattan.
If you like walking, some nice neighbourhoods are not far. I got to know Brooklyn much better this time, which was my plan. And I really like the people and the atmosphere there.
The flat has everything you need (including a very big fridge and a very big stove) and is clean and tidy. I didn't get to meet Madison, but she was available all the time. A friendly guy called Josh who lives there as well received me, showed me around and helped me out once.
You walk into the flat directly from the street, so there's a bit of traffic noise, but then again, this is New York. You have to expect a bit of noise.