I'm glad to hear this worked out for you OP. I'm in your situation in that Ill be looking at renting soon and am afraid I'll have trouble due to being retired and living off savings plus a small pension/VA benefit. Wary about paying 6 months or more upfront but not sure how much choice I'll have. Throw in a dog and that I have no rental history (owned paid off house for long time) and not sure I'm tenant material. Open to hearing others experiences and advice beyond showing them your bank account and/or offering to pay cash upfront for the whole lease.
To be clear, the property manager who I know told me that 6 months rent prepaid is the most that he would think should ever be necessary. It was just the very suspicious landlady I first spoke to who suggested paying 12 months all at once, and I didn't rent from her.
Like you, I worried that I'd look like a poor candidate. I hadn't rented in over 10 years. But when I sat down and thought about it, I figured I could make myself look pretty good. Think of it a little like applying for a job. You may not be the conventional candidate but that doesn't mean you're a bad one. You might be surprised at how much more attractive you will be as a renter than many who others who apply.
If you don't want to show a bank statement, maybe have your lawyer, accountant, or financial advisor write a letter vouching for your ability to pay (assuming you have one of those). I'm just spitballling here.