High city MPG and rear-wheel drive is a tough combo.
There aren't any 2009 and newer RWD compact sedans that cost less than $10,000. The only RWD sedans that fall in that price range are all large: Dodge Charger, Chrysler 300, Ford Crown Victoria, Mercury Grand Mercury. Maybe a Hyundai Genesis. None of these are offered with a manual. And none get high city MPG, since they're large and heavy.
On AutoTrader, I see one Pontiac G8 for sale in your price range, but must wonder if it's a price mistake.
An Acura TSX might be the closest match, except it will be hard to find one for less than $15,000. An Infiniti G37 is RWD, but even more expensive than the Acura.
So something less sporty is looking more likely. Maybe a Ford Fusion with a manual transmission. Midsize, but you probably don't want to go too small because your passengers will want legroom.