after 20 years in Manhattan (studio in the basement of my east village place) I moved to Bushwick. I looked in:
Red Hook, (nothing under 1 M) Gowanus (small stuff just under 1M) Boerum Hill, (forget it!) Bed-Sty, (lots of great homes but architecturally not right for an artist like me) and then bingo I discovered Bushwick. Bigger housing types, the L train (best in the city) good vibes great mix of people and you can see the Empire State Building when you walk down the street. I have more space then I have ever had and rental property, a backyard, birds! Oh and PS bus service in Brooklyn is super. Here also, there is a community of artists very diverse and really great. In Manhattan there used to be a community but it has been fractured by the art market, or it seems like that. The artists whom I have met here have very consciously chosen to "create community" on every level, the political, social and cultural. This is really refreshing. There is a good range of age groups here also, in terms of artists, it's not just youngsters. (I am 56) My area is really close to all these small manufacturers: people working metal, lumber, junk yards, glass and mirror places, stone cutters, like ideal for an artist to get stuff made/materials. A great resource for me was the Bushwickbk.com website. I LOVE Bushwick and I would never move back to Manhattan! ( well maybe if I was a millionaire....)
Anthony Fernandez of ReMax was the listing agent on my property and he was great.