Replying to Tamron 18-270 PZD

Hey guys, I'm looking at purchasing this lens for my Nikon D7000.  Anyone have anything to say about this lens?

I shoot about 60%video and 40% photos.  I just need something that covers about 20-35mm - 250-300mm and this lens looked like one of the better all-in-one zooms for the price.  I have a 18-85 and a 70-300 but my 70-300 isn't IF which sucks when using a polarizer and 70mm is a bit too tight for some shots/scenarios for hunting/fly fishing.