What is a B4RA? Is it something special?
Unless it's something off the wall, I'm pretty sure tranny's for a 97 dx can be had in most pull a part style junkyards across the country for between 100-150 bucks. If not that specific transmission, than something similar is probably available.
My latest trek through my closest junkyard found 6 manual Y7 and 2 Y8 manual transmissions. Wasn't even trying to find them, they were just there. There were even more autos.