The Henry Norman Hotel is a great place to stay in the Greenpoint section of Brooklyn. It's within walking distance of the restaurants and eateries on Manhattan Avenue and the shops along Franklin Street, but it's far enough away that you aren't right in the mix. Probably a 10-15 minute walk.
There is a complementary car service that can take you within a mile of the building—a welcome option during my rainy visit.
The room was great, and there are outdoor common areas on the 2nd and 3rd floors. I always travel with a noise machine because I sleep with one at home. I recommend it to everyone, no matter where they stay, and it definitely comes in handy when visiting cities.
Enjoy your trip!