INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT DISTINCT xcart_products.productid, xcart_products.productcode, MIN(xcart_pricing.price) AS price, IF (xcart_products_lng.product IS NOT NULL AND xcart_products_lng.product != '', xcart_products_lng.product, xcart_products.product) AS product FROM xcart_products, xcart_pricing, xcart_product_links, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code='US' WHERE xcart_products.productid=xcart_product_links.productid2 AND xcart_product_links.productid1='16161' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND xcart_products.forsale='Y' AND xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y' AND xcart_products.productid != '16161' GROUP BY xcart_products.productid ORDER BY xcart_product_links.orderby, product
Lazy Leg (Mono-Pod Turkey Gun Rest) - Shooting Sticks - Gator Outdoors
  GO
Cart is empty 
You Are Here: HomeShooting Sticks -  Lazy Leg (Mono-Pod Turkey Gun Rest)

Lazy Leg (Mono-Pod Turkey Gun Rest)


Price: $25.00
Quantity
 Add to cart 

Comfort - Whether you’re male or female, old or young with the Lazy Leg the weight of the gun is no longer an issue. All turkey hunters can relate to tired arms and numb legs. We have had many hunters try the Lazy Leg in person and have encourage them to try and get into an uncomfortable position. The answer is always the same: “It is practically impossible get uncomfortable with this rest”. Quieter - Not having to use your legs as a gun rest allows the hunter to have a greater range of motion (shooting area). With this the hunter is a lot quieter because he or she is not having to position their lower body (knees) to support the gun. This also allow the hunter to have a 180 degree range of motion. A right handed shooter could actually shoot their gun left handed. Compact - The Lazy Leg becomes a part of the gun. Although it is folded underneath the barrel of the gun the hunter can still shoot without having to use the Lazy Leg. Because the barrel clamp does not touch the vent rib it does not interfere with the shooters line of sight. The Lazy Leg can also be used on over and under shotguns. Youth and Ladies - All fathers who have taken their children turkey hunting have faced the problem of the young hunter not being able to hold their gun up. The Lazy Leg solves this problem. Unlike with shooting sticks or a home made rest the Lazy Leg is attached to the barrel of the gun so that when the hunter moves his rest moves with him. After talking with numerous lady turkey hunters the problem they face is simply the weight of the gun.



Click HERE to Watch Video



Copyright © 2006-2010 Gator Outdoors