I'm 27 and feel the same way about being too old for some places, too young for others. I'm usually not into the bar scene anymore, but when I do go out, it's usually happy hour in Manhattan after work. Lots of young professionals, not too young, and usually not too smashed. When my friends do drag me out at night, it's usually to the village, which I just find tiring and I always want to go home within 5 minutes.
If you can't convince your friends to go to a bar in Astoria, maybe you can convince them to go to a nice dinner here and you can drink? Or maybe you can talk them into the beer garden, as I find that even my friends living in Manhattan will come over for that.
And since you posted this in the singles section, I assume you're wondering where to meet people to date? Well,I don't know, but if you find out--let me know!