If you are looking for extraordinary studio-space, rental and awesome customer service included: this is your place to have your photo-shoots happening! There is also a lot of attractive outdoor options in the area around Greenpoint.
I live above TriBeCa and take walks into and around this area often. It's quiet, usually on the emptier side, and hosts a few gems of restaurants including Tiny's, Takahachi, and Odeon - all on the same block of West Broadway.