There's been a number of nationally advertised lease specials but no one seems to have the advertised cars!

I've been looking for a manual and Mazda (Mazda6), Honda (Accord), and Toyota (Camry) but not one dealership carries the advertised car. The Honda dealership told me that there wasn't even on in Western Canada. What can I do? Can I get them to bring one in for me?