sounds like you know your way around cars, so that being said. its best to start looking for a used trans. if you shop around they can be found for around 400 or less sometimes.
theres a good "how to" on the site as well.
yeah that does suck, like a kick in the balls for sure. good luck.