Blown Motor

At 170,000 miles, our car appears to have either spun a bearing or broken a rod. The block seems to be OK (still has oil and coolant in appropriate places). We are still troubleshooting and are looking at options, but suspect that if the above is true, we are looking at a motor replacement. Has anyone else had a motor replaced? New or used? All info welcomed.

We've been too happy with this car to give up on the breed now.