I blew the tranny in my 98 4banger auto. I need to replace the tranny. Honda is not going to assist in the repairs so I am on my own

So does anyone out there know of a place where I can get a good one new/or used just so I can get it back on the road again?