There is a great NYT article about the elite coffee hounds and it mentions nearby Greenpoint-based Cafe Grumpy (also with a location in Chelsea) as a place to get the good stuff.

Head over to Meserole and Diamond -- about 15 minutes walk from the Pulaski Bridge. You'll enjoy the views as you walk. Grumpy's site