This apartment is located in a great spot for a stay in NY. Just a couple of blocks from York St on the F line direct to Manhattan. Dumbo is a great spot to base yourself for a holiday. It's a very clean and hip part of Brooklyn. Plenty of places to eat nearby, try Almar Restaurant a couple of blocks away. Plenty of places to drink, try Pedro's across the road. It's also a one block from the water, with a riverside walk and great views of the bridges and Manhattan skyline
The apartment itself is very clean and in good condition. There are only 2 apartments in the building. 2 full Bedrooms, bathroom, kitchen and lounge. Outside noise is minimal and the a/c works well.
One stop on the F to Jay St Metrotech station where you'll find more food options and some outlet stores (Gap, Banana Republic).
If this is your first time in NY, don't make the mistake of thinking you need to stay at Times Square to see everything. You don't. Brooklyn is a good option, and Dumbo Brooklyn is even better