What can I do with a 2001 Mazda Millenium with 95K miles whose engine rods died?

What is your question?

This car has been driven gently yet the engine rod is bad. Barely drivable,I can only go 2 miles back and forth to work (horrible sound and bucking) and know that this car will die anytime now. Is it worth it to replace/rebuild engine? Dealer says no given their price to do it, and would only give me $500 for trade-in. Where can I get another engine? What about scrap metal places? Has anyone else had this problem...this should NOT happen at under 100,000 miles!