This is an amazing place to stay in Brooklyn! It's almost on a shore with a great view of Manhattan and its skyline (you can't see that one from within Manhattan itself unless you go very high in one of major towers), very atmospheric, only the elevator is enough to feel yourself within some kind of Half Life =) 2 block away there is a row of restaurants and coner shops, many work until very late (like 11 pm), convenient.
Location is a bit far from major bridges, so if you want to walk the Brooklyn Bridge (which I would call a must do), you'd probably take Uber, its close enough to be cheap and quick. In the same time it's just 6 minutes away from a subway station. If it takes 30 minutes least to get from anywhere to anywhere on Manhattan, your day will start with a 45 minutes trip instead and that's it.
I would definitely recommend the place for a short and long stay both.