I moved to Astoria from the East Village b/c I was looking for a neighborhood w/ a sense of community and I found one of its centers at McCann's! Most locals hang there and there is a lot of variety in the clientle, but everyone gets along well and hangs out; the waitstaff & bartenders know a staggering # of ppl by name, and if they don't know your name, they at least know what you drink. The bar is very clean--no stale beer smell--and the waitstaff is good. The sports element can be overwhelming if you're not in the mood (if you don't like football, stay away from there on Sundays) but if you're a fan of ANY sport, McCann's is the place to go with friends to watch. Specials every night of the week (the pitcher & wings deal ROCKS!!!!), and more to do than drink (pool, darts, paintball trips, fishing, Atlantic City, etc).\r
If you move to Astoria, especially if you don't already have friends in the area, go to McCann's--you'll make plenty of friends there!
Pros: Inexpensive drinks, clean bar, good specials, friendly staff, neighborhoody feel
Cons: Too many sports fans sometimes, only 1 stall in the Ladies' Room!