We stayed here for an event at the Red Hook Brewery, so we were not looking for luxury, just close.
The room was basic, beds sleep-able but pretty darn poor in general. People that worked here were a little disorganized, but not terrible. The A/C worked real well. The pool area seemed nice. There was a damp smell that wouldn't go away. I wouldn't consider staying here with family or my girlfriend unless I was very desperate.
This is clearly a dive hotel, but it suited our needs. I don't recommend it unless really hard up for a room. That said, it seemed clean enough.