Oh man that stinks - especially when you're trying to sell the car! (I've been seeing it in the classifieds for many months now, price reductions and all...)
Highly recommend a new transmission if you can grab one cheap .. it's a great selling feature.