This place gives a visitor a true launchpad for a "Choose Your Own Adventure" approach to Red Hook and NYC at large. Easily accessible by car/bus/Lyft/Uber, you can be in Manhattan in no time (based on BQE traffic), all points Brooklyn, OR just walk down Van Brunt to see any of the great things Red Hook has to offer.
The space is definitely unique, being somewhat small yet maximized to offer the most possible usage. There is ample closet space, a great couch for stretching out, and a rustic kitchen table with garden access.
The bedroom being separated by a ladder/staircase from the kitchen is at first a little daunting, especially in regards to any early morning comfort needs, but once you dial in that the charm outweighs standard assumptions of convenience, the place makes sense.
If you're looking for a doorman and elevator service, try Dumbo, but if you want to be "On the Waterfront" and have a once-in-a-lifetime experience, give it a shot. Risha was helpful and on the case, very accommodating.
Hot tip: The Black Flamingo is a block away and has amazing coffee and bread/pastries from Balthazar — can't go wrong.