The CX-7 is a four door SUV with a turbocharged I4 engine. That engine has been paired with a 6 speed automatic. No manual transmission has been made for this car as of yet. Front wheel drive is standard, with four wheel drive optional.
Despite only having a 4 cylinder engine, it actually has quite a bit of power. The engine makes 244 horsepower and a lot of torque, even at low RPMs.
Trim levels include the base model sport, which starts at $24,300, the upscale Touring, which starts $26,000, and the top of the line Grand Touring, starting at $28,500. Each model has four wheel drive as an option, so most of the upgrades are cosmetic or for comfort.
These CX-7s will start appearing on the used car market soon enough. You can obviously pick up a new one at your Mazda dealer, but if you want to save a few bucks try looking over the listings on eBay.