If you are looking to stay in the immediate area and explore Red Hook specifically this is. a perfect location.
I would recommend, if you come in the fall/winter to just take the bus or Uber to the nearest train station. Either the F train at Carroll St or the R train at Prospect Place. Ubering to the train will save time getting into the city.
But overall the apartment was well stocked, everything was clean and very organized. Anthony was immediately available to help us with the issue we had getting into the unit. Highly recommend for the price and location!