Eh, it's ok. Some people enjoy it, but I think its kind of desolate. There are a few bars and a few good restaurants but I wouldn't exactly call it happening. My good friend lived in Tribeca for a while and ended up moving to Chelsea because she thought there was nothing to do. And, it's a little out of the way.
