Hi, and welcome! If you took the broken cable off, you could determine the length you need if you were going to fabricate your own. This might be a bit difficult, depending on your DIY skills, so as an alternative, you could get a factory cable from J&R repair, and they are in Ohio too! email@example.com
This is a link to their homepage: Home - JR REPAIR
The solenoid is a generic "auto" part, and you can probably find a replacement in an auto store. I'd take the one you have in with you to get the right kind.
Spend a lot of time looking through this forum, you'll find answers to questions you didn't know you had.