Forget the dating part of things, just find clubs that have an interest similar to what yours are.
Also, quit putting women up on a pedestal. The good news is you're forty-seven. The women that are likely in your age group have likely been through a divorce. If you have a decent income, are a good date, haven't been through a divorce, and aren't paying child support yourself puts you in the category of the girls back in high school that had the pick of any guy they wanted.
You mentioned biking. Join a local biking club. You will at least meet people that share your interest in that.
Put in some hours doing local charity work. There isn't a volunteer organization out there that isn't short man hours and would be happy to have you aboard. Again, you'll meet people.
After you've done those for a while, the self-confidence issue will resolve itself somewhat because your out meeting people and you'll find you have friends and options.
In case your wondering, I had a bitter three year marriage that was so bad it got to the point that I dreaded the end of the work day, because I knew there was going to be a fight at home that night. After we split, I just kept recounting all the things the two of us had done wrong seperately and individually. The latter went on for about five years before I started dating again, and that was a completely dry spell for me. Then I decided to move on. I've been serially monogamous for the last eight years or so, still don't like the notion of marriage.