If you good a driving stick, normal trails aren't bad, I advise you getting a manual as well as they will get 18-20mpg which is 1-2mpg more than the auto. But also because new drivers need to know how to drive stick, it helps make you more aware even when your in an auto.
And have you ever went offroading before? Before you have your parents drop $5k on a 4x4 vehicle make sure it's what you want, I am an SUV guy but as a student I jump at the chance to get my dads jetta tdi, as Pikeman said, you don't want to piss all your money away on fuel, social activities give you a much better return, so I suggest you to really think If you want an SUV, as many kids lose intrest in wheeling after a few weeks... And they are stuck with an expensive drain to their wallet. I can justify my truck, for winter purposes and I use it like a pickup, but I would much rather have a cheap DD...