The last manual transmission rental car I saw was a National car. It was from Quebec City but was at the Halifax Airport. It was in about 1998 or 1999 and it was a 2-door, green, Dodge Neon. It was craptacular even then!
Funny, they told me no one wanted to rent the car because it had a manual...