This place is fantastic. The rooms are very large with a full kitchen (small fridge, range top, microwave/oven combo) and a separate sleeping area. I was traveling alone so it was a LOT of space. The place was super clean, everyone working at the hotel and restaurant were very nice, and the food at the restaurant was great. There is also a laundry room on-site if you hate traveling with dirty laundry (like I do).
It is in the very far northwest corner of Greenpoint, which might be a turnoff for some. I am very familiar with the neighborhood and all of it's charms so it was great for me. It is a quick walk over the Pulaski Bridge to the E and 7 trains into the city or to/from JFK. There lots of bars and restaurants in the neighborhood.
I highly suggest the Box House Hotel.