It shouldn't be hard to find a manual shift car anywhere in North America .
Here's a few to look for
Pontiac Vibe or Toyota Matrix , reliable as they get
Saturn between 1990 and 2000 , check for rusted out K frame
Dodge Neon , these cars can be had dirt cheap and are easy to work on
Hyundai Elantra , as reliable as a Civic and half the price