Late last week I had a metallic chatter/squeak type of noise coming from the right rear wheel. It turned out to be a u-joint that had gone bad. The needle bearings inside two of the 4 end caps were pretty much non-existent leaving the joint arms to rattle around in the end cap chewing up metal and generating much more heat than they ever should have.
I had noticed the sound intermittently for about a month and only under heavy acceleration, but last week it grew to where it was almost constant - that's when I parked it and decided not to drive it anymore until I figured out what was wrong.
I don't know if what I'm describing fits the sound you're hearing, but it's worth a look.
Culprit
PS - if the neighbor is missing a cat, that's not a bad place to start