2001 or newer Frontier Crew Cab ??

Group, I'm in search of a slightly used Frontier Crew cab. I've looked on e-bay motors and in the traderonline.com. I own a Mercedes shop myself but I like to get a small pick up for the "honey do list", and it has to be a 4 door or else I could just keep the 1997 Nissan pick up I have. To make a long story short, I'm quite lost, it's seems most of the crew cabs have very short beds, then others seem to have the regular size bed. Not all the adds in the trader have pictures, so what do I asked for, whats the lettering that goes with a crew cab long bed?. My next question, are they available with a 5-speed after 2002. I like reliability and economy, but a long bed 5-speed would be great. What are the pro's and what the con's? My last question (I'll promise) Anybody here selling one or knows of one worth my while?. I'm located in VA but I'm willing to travel for the right one. Please e-mail me. Thanks up front Martin. Autobahn Auto