Fantastic location. If you're a light sleeper (I'm not particularly) I wouldn't recommend this place.
I really cannot imagine a better location - you're a block from the subway, surrounded by restaurants and have easy access to Brooklyn.