Back in May when I was looking for a new MSP, I called the Mazdaspeed department and had them do a nationwide inventory search. Back then, the nearest place was a dealership in Minnesota that had a couple, plus 1 in Illinois (Crock has since bought it). I think she said there were 5 left in the entire country. It's almost mid-July now, so maybe there's a yellow MSP left somewhere, but don't hold your breath.
There are actually plenty of used MSPs for sale with less than 20,000 miles, people who could no longer afford it or didn't like it or traded it for an SRT-4/STi/Evo.