I'm good at what I do, but at 47 I'm over 20 years past my sell-by date as far as most tech companies are concerned.
I turn 47 this year, and I am conditionally calling bullshit, with the caveat on location. Yeah, there are the hipster post-social media tech startup places that might not be interested in you, but if you look behind the covers, you find they're not doing anything that interesting to someone with your seniority anyway. You mention your area, and yeah, if it's all Java monkeys and Windows admins, you might be right. The really cool tech jobs are out there, and they're not found in the same channels you found them in when we were in our 20s or even in our 30s. What technologies do you know? What technologies are you interested in? Find a meetup group or look for the user groups in your area for those technologies. Learn and network. These groups are where the cool jobs are found now. If they're not out there, start some, and if they don't take off, then consider relocating. It sucks, I know. I'm in love with where I live, and I'd hate to leave it. But it's not being 47 holding you back, unless you're going to argue that there's a big difference between being 46 and 47. :-)