My girlfriend and I are Greenpoint locals, and when our building was undergoing construction we decided to stay somewhere to get away from the noise since we often work from home. We considered more standard/private airbnb apartments but settled on the Box House since we've been curious about it since it opened. We chose wisely - the Box House lofts were far better than we expected. They are essentially apartments within the hotel, with full kitchens, a separate area for the bed, and two closets. And even though the apartments are right next to a busy bridge, it's actually really quiet.
The location may seem like it's a bit removed from everything, but it's only a 5 or 6 minute walk over a bridge to catch the 7 Train to midtown Manhattan, and only a couple minutes to get to several grocery stores, restaurants, and bodegas. They even have free taxis in the front that can take you to nearby destinations. If you're on vacation looking for a good home base to explore NYC, this is a pretty great place!