Location is as good as it gets really, you're very close to all the best things Brooklyn has to offer. The host is flexible with check-in and check-out procedures and times (within reason of course) and always responsive.
Note that in the reviews you'll see that the host seems very strict (this was a concern of mine actually), but my experience with the host is that if you use the apartment respectfully (essentially treating it as well as if it was your own place) then there is no problem at all and it seems that guests who had problems were indeed guests stepping over the line.
The apartment was very clean too. Beware that you will feel the metro passing under with vibrations and a rumble. Personally, this didn't bother me at all (and I felt the same in other places in Brooklyn I've been to), but this is worth knowing to some people perhaps.
Also, it is on the first floor, so you can hear some street activity (but it is a much quieter street than the ones around, so it's fine).