Risha's place is the perfect spot in the summer months--a block from the really cute Coffey park and dead in the middle of Redhook. It's in perfect walking distance from the NYC Ferry and the neighborhood is super charming. Take a walk down Van Brunt st and though the lines may be long, don't skip out on the BBQ--it really is worth the hype. The walk to Carrol Gardens/Cobble Hill area also isn't too bad, very accessible.
It is worth noting that Red Hook is probably as special as it is because of its isolation--the subway is a solid 20min away and the Ferry, though it runs every half hour on the weekend, takes about 20ish min to get you to lower Manhattan. That being said, there's enough to do in the area that you won't feel like you have to slog closer to civilization every day. If you like alcohol, there are several distilleries around with good whiskey and bourbon to sample :)
The place itself is very clean, simple, and has everything you might need for a shorter stay--the tub is kind of luxurious and the AC unit perfectly suitable. The bed is a little hard, but I like it that way so I was unbothered :) Overall, it's a good spot to rest your head after a long day on the town.