Warning: ini_set(): A session is active. You cannot change the session module's ini settings at this time in /home/outfitterpros/outfitterpros.net/config.php on line 61
Whitetail Deer Hunting Guides & Outfitters in Illinois, Kansas, Texas, Ohio, Kentucky, Missouri, and more
 
Outfitter Pros

Whitetail Deer Hunts

Book a Whitetail Deer Hunting Trip with Professional, Pre-Screened Big Game Hunting Guides and Outfitters

Whitetail Deer Hunting - From the trophy bucks in South Texas, and the big-bodied, heavy-horned bucks in the heartland states of Kansas, Iowa, Illinois, and Ohio and up into Alberta and Saskatchewan, Canada, we've put together a great selection of Whitetail Deer hunts, 40 in total. Whitetail Deer hunts from reputable big game guides and outfitters for that trophy room filling hunting experience. Guided and self-guided bow and gun Whitetail Deer hunts.


Top 10 Whitetail Deer Hunts (Gun)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'of ON oh.outfitterid = of.id JOIN states AS st ON st.id = ' at line 9

SQL:
SELECT st.state_name AS 'Location', COUNT(DISTINCT(oh.outfitterid)) AS '#_of_Outfitters', COUNT(*) AS '#_of_Hunts', ROUND((AVG(oh.hunt_minprice) + AVG(oh.hunt_maxprice)) / 2) AS 'Average_Cost', oh.hunt_state AS 'state_id' FROM species sp JOIN outfitters_hunts as oh ON sp.id = oh.hunt_species JOIN outfitters as of ON oh.outfitterid = of.id JOIN states AS st ON st.id = oh.hunt_state WHERE sp.id = 71 AND oh.hunt_weapon = 1 AND oh.enabled = 1 AND of.enabled = 1 GROUP BY st.id ORDER BY 2 DESC LIMIT 10