One of the only things I enjoy about taking the subway these days is seeing the defaced ads on the L train. Whether it's random chance, high schoolers or street artists the result is always good.
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.
My favorite place on Bedford Avenue, this bookstore has both new and used titles. If you're patient and look close enough, you can usually find a book that's worth more than they're asking. Not to mention their stellar selection of magazine titles. Good for design, art, photography, sociology, fiction, and everything in between.