My car is in the Garage at the mo with a presumed knackered box, lots of metal came out when they drained it

Does anyone have or know where i can get a second hand box from? obviously in as good a condition / lowest milleage as possible... even a short guarntee maybe....

any help appriciated....

Leon