Well damn. The 2007 F-150 in for repairs at Carleton Place Ford. Needs transmission. Going to look at used trucks and SUVs tomorrow. 
ouch
Ugh
So sorry!
ouch
A new or rebuilt transmission is a lot cheaper than a new truck.
Good luck.