Heads up on the non-refundable rate: they mean it. I booked 5 months out and tried to cancel 3 months out, and they said no - even though the hotel ended up sold out that weekend. I've never had another hotel refuse a cancellation that far ahead, so book the flexible rate if your plans might change.
Once I arrived - it's a good location if you're out all day. It's close to the Hewes St. and Broadway subway stops, but it's still a ride into Manhattan. The lobby's cool and sometimes has free wine. The area looks a little grimy, but there's foot traffic at all hours, so it never felt sketchy.
My main complaint - the walls are paper thin. I could hear my neighbors talking, their TV, and even their shower. The subway noise didn't bother me. Housekeeping is loud in the mornings too, with slamming doors, talking, and music in the hallway. The room itself had dead bugs by the window and a bedframe that wasn't clean. The bed was a bit too firm for me, but not awful.
Overall it was a fine stay, but I wouldn't return, and I definitely wouldn't recommend it for business travelers or anyone sensitive to noise.