Great, I'm f*cked...Threw a rod...(bearing)

I just did a search on Car-Part.com and there are a lot of them around you, the closest is about 26 miles from your zip code. They run from $350 to $600, with a bunch of them that says to just call.
I was assuming it was the base motor 1.6 not the 2.0 or 2.2.

Good luck, hope this helps.