In need of transmission!

Id like to be able to come pick it up and I would go as far as Vancouver. I'm in the kootenays and don't wanna get it shipped across Canada. I need one pretty much now so I can take my car down to the states and have body and paint done in time for summer. Man it sucks driving a Honda again.. Also if you know of someone with one for sale that would be sick..