I use my 2012 TDI Golf to tote my Yak around. 40MPG and it does EVERYTHING!!
You can also get a TDI Volkswagen Jetta Wagon. Same fuel economy with a little more storage.
I sell Volkswagen by the way so if you need a car send me a PM. (Shameless plug)
