Hi, Melynn, and welcome to Piano World!
I too like old upright pianos, or even old grand pianos. But the uprights don't take up as much space as the grands.
I have had several old upright pianos over the years, and have two now, both from around 1910. In fact, I just played one of them a few minutes ago, and it put a smile on my face.
That said, there are lots and lots of old acoustic pianos from yesteryear out there, and many are free for the taking, if the taker can move it.
I've seen a few ads for a free old upright piano, but the owner requires professional movers so as not to damage their floors; and, I don't blame them. But chances are, they narrow the field of prospective takers even more by requiring professional movers, usually.
Although I really don't have room for another old upright at the moment, I still cruise the piano ads on FB marketplace and CL to see what is out there. On occasion, I see something that is really tempting.
Now, getting back to your old H.C. Bay piano, I think I have heard of the brand, but know nothing about them. You could advertise it for free, and see what happens, if you don't want to take it to the landfill. There might be someone (like me:-) who admires old, worn-out upright pianos, and would take you up on the offer to take it. However, I know you said that no one wanted it, so you may have already tried that.
I terms of whether or not is worth any money, I can't help you there, but my first guess is that it is not. If you can't find someone to take it for free, as you mentioned, I doubt you would find someone to pay you any money for it.
There was a time when the price of scrap metal was up and some of the scrap metal scavengers would pay a small amount for the cast iron plate and pick it up. I have gotten rid of a couple of old uprights by giving them to the scrap metal scavengers, who could come and pick it up for free. But I think the price of scrap metal is down now.
When I check out the piano ads, particularly the freebees, there are certain brands that catch my eye more so than others. Again, some are more tempting than others to take and go through the hassle of moving it, which is a HUGE chore.
So, the bottom line is, if you all really want to get rid of it, you have three choices... advertise it for free and see what happens, take it to the landfill or hire someone to take it to the landfill for you, or cannibalize some of the parts and panels off of it to keep for sentimental purposes or creative projects and discard the remainder.
Hope this helps, and good luck!