Cute place, friendly owner, fantastic bathtub.
We were exploring Manhattan for most of our stay. This place is a bit out of the way to be ideal from that, but we made it work. In the morning, we could walk 5 minutes up Conover to the Ferry terminal and take the SB line towards Corlears Hook to hop over to Pier 11/Wall Street. It's about a 20 minute trip with great views of the city coming in.
Unfortunately, the ferry closed at 10, so when we had a later night, which was most nights, we had to use the subways and buses. We figured out that we could take the A line towards Brooklyn and get off at Jay St. - Metro tech, and then take the B61 down to Red Hook, within a block of our place. Not nearly as convenient, and we used Uber a couple of times to skip the hassle when we were too tired or exhausted, but it was doable.
The bath was fantastic after a long day on our feet, the bed was very comfortable, and Tom offered to get us whatever we needed. At the end of the week, my wife was tired, but completely happy.
As for cleanliness, it was okay. It's got old wooden floors, some dust, but nothing that ruined the experience for us. The sheets and blankets and towels were clean. If you need fine Hotel-level clean, this probably isn't your place, but as an Air Bnb, it was fine for us.
As for the neighborhood, we felt safe enough walking down the streets at night. They're pretty empty. We enjoyed the coffee shop next to Red Hook Tavern, just a short walk away.
There's also a Citi Bike dock nearby, if you want to ride up to Pier 6 or the Brooklyn Bridge. You can get a pass for $15 per person, which covers unlimited 30 minute trips for the day. It's $4 per 15 minutes after that until you dock.
Overall, we'd recommend this place for a quaint New York stay.