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
Affordable Hunting Trips for Elk - Self-Guided DIY Drop Camp Elk Hunts
 
Outfitter Pros

Self-Guided Cheap Hunting Trips and Drop Camp Hunts for Elk

Find a D-I-Y Cheap Drop Camp Elk Hunting Trip with Pre-Screened Hunting Guides and Outfitters

Cheap Self-Guided Elk Hunting - We offer a great selection of Cheap Self-Guided & Drop Camp Elk hunts, 12 in total. Cheap (price relative to guided hunts) Elk hunts from reputable elk hunting guides and outfitters in Colorado, New Mexico, Idaho, Wyoming, Montana, Canada, and more.... Self-guided bow and gun elk hunts, some with no lodging, and some drop camps with tent lodging, at very reasonable prices for the hunter that doesn't need or want a guide - just access to great elk properties. Many of these hunts also allow the hunter to take a mule deer and/or black bear.


Top Self-Guided & Drop Camp Elk 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 = 95 AND oh.hunt_weapon = 1 AND oh.enabled = 1 AND of.enabled = 1 GROUP BY st.id ORDER BY 2 DESC LIMIT 10