query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	99.99	0	99.99	94532-DEFAULT-l.jpg	99.99	94532-DEFAULT-m.jpg	LCD JAKE QUARTER STRUT TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2012	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	LCD QUARTER-STRUT JAKE	<p>Give them something to pick on with the LCD Quarter-Strut Jake. This guy's non-aggressive pose makes him attractive to both dominant and sub-dominant gobblers, while his size - 15 percent smaller than a real jake - keeps him non-threatening and portable. Crafted from rugged dura-rubber, the Quarter-Strut Jake easily fits in a turkey vest, and won't crease or dent like other folding decoys. Pair with the LCD Laydown Hen to mimic a breeding pair that will drive longbeards absolutely wild. Decoy comes complete with colapsible stake and carry bag.</p> <p> </p> <ul> <li>Quarter-Strut</li> <li>Non-aggressive and non-dominant</li> <li>Easy target for gobblers to pick on</li> <li>Lifelike Collapsible Decoy (LCD)</li> <li>Easy transport and storage</li> <li>15% smaller than a real turkey</li> <li>Includes pre-attached beard</li> <li>PVC dura-rubber quiets movements</li> <li>Realistic movement without unnatural spin</li> <li>Quarter-Strut Jake Decoy</li> <li>Storage Compression Strap</li> <li>Carry Bag</li> <li>Collapsible Carbon Stake</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	99.99	99.99	[empty string]	94532-DEFAULT-s.jpg	[empty string]	1000	8003	147518	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/lcd-quarter-strut-jake-147518	1
2	[empty string]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	29.99	0	29.99	94530-DEFAULT-l.jpg	29.99	94530-DEFAULT-m.jpg	FUNKY CHICKEN TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2013	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	FUNKY CHICKEN GEN. 2	<p>The Funky Chicken is the wimpiest, skinniest tom in the woods. We've upgraded the original Funky Chicken design with a new molding pattern for even greater realism and durability. The result: an irresistible punching bag. Throw in a sturdy mounting stake and incredible paint detail and, well, just wait until you see what this little twerp can do. He may be small, but he brings big results.</p> <p> </p> <ul> <li>Non-intimidating decoy</li> <li>Sparks fights with all ages of gobblers</li> <li>Small size travels easily in the field</li> <li>High-quality carving and paint detail</li> <li>Incredible durability and realism</li> <li>Pre-attached synthetic beard</li> <li>Collapsible design easily stores in vest</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	94530-DEFAULT-s.jpg	[empty string]	1000	FLXDY330	161052	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	flextone-game-calls/funky-chicken-gen-2-161052	1
3	[empty string]	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	79.99	0	79.99	94517-DEFAULT-l.jpg	79.99	94517-DEFAULT-m.jpg	LCD LOOKOUT TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2014	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	LCD LOOKOUT HEN	<p>The LCD Lookout Hen has a similar look and effect as the popular Breeder Hen, but she's got a little something extra. The Lookout's raised height aids visibility so passing gobblers can spot her even in tall grass and dense vegetation. She features the same attention to detail and authentic paint scheme you expect from Avian-X, and the Lifelike Collapsible Decoy design you need for easy setups and transport. Decoy comes complete with colapsible stake and carry bag.</p> <p> </p> <ul> <li>Lookout</li> <li>Similar effect as breeder posture</li> <li>Added height for improved visibility</li> <li>Lifelike Collapsible Decoy (LCD)</li> <li>Easy transport and storage</li> <li>15% smaller than a real turkey</li> <li>Unmatched realism and detail</li> <li>Mimics natural reflection of real hen feathers</li> <li>PVC dura-rubber quiets movements</li> <li>Realistic movement without unnatural spin</li> <li>Lookout Hen Decoy</li> <li>Storage Compression Strap</li> <li>Carry Bag</li> <li>Collapsible Carbon Stake</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	94517-DEFAULT-s.jpg	[empty string]	1000	AVX8006	180301	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/lcd-lookout-hen-180301	1
4	[empty string]	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	79.99	0	79.99	94526-DEFAULT-l.jpg	79.99	94526-DEFAULT-m.jpg	LCD FEEDER TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2014	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	LCD FEEDER HEN	<p>The LCD Feeder Hen draws gobblers in close to set up the perfect kill shot. Typically, a hen will notice a gobbler's advances and approach, signaling she's ready to breed. So if a longbeard's gobbles go ignored, he'll assume she didn't hear or see him and he'll move closer to make sure she does. As he gets closer, the LCD Feeder's ultra-detailed paint schemes with true-to-life reflective feathers will pull him even deeper under her spell. This little lady will surprise you with what she's able to accomplish during her morning snack. Decoy comes complete with colapsible stake and carry bag. </p> <p> </p> <ul> <li>Feeder</li> <li>Relaxed, content position</li> <li>Draws gobblers in close</li> <li>Lifelike Collapsible Decoy (LCD)</li> <li>Easy transport and storage</li> <li>15% smaller than a real turkey</li> <li>Unmatched realism and detail</li> <li>Mimics natural reflection of real hen feathers</li> <li>PVC dura-rubber quiets movements</li> <li>Realistic movement without unnatural spin</li> <li>Feeder Hen Decoy</li> <li>Storage Compression Strap</li> <li>Carry Bag</li> <li>Collapsible Carbon Stake</li> </ul> <p> </p> <ul> <li>FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	94526-DEFAULT-s.jpg	[empty string]	1000	AVX8007	180302	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/lcd-feeder-hen-180302	1
5	[empty string]	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	79.99	0	79.99	94522-DEFAULT-l.jpg	79.99	94522-DEFAULT-m.jpg	LCD BREEDER TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2014	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	LCD BREEDER HEN	<p>The LCD Breeder Hen plays up gobbler's top priority every spring: finding a mate. This lady is the ultimate temptation, displaying she's ready to breed. High-quality feather detail and intricate paint schemes complement this inviting pose to bring the gobblers to the hen house. Like all LCD decoys, the Breeder Hen features a collapsible dura-rubber body that won't crease or dent and stays quiet in the field. Your setup won't be complete without this one! Decoy comes complete with colapsible stake and carry bag.</p> <p> </p> <ul> <li>Breeder</li> <li>Posture signals she's ready to breed</li> <li>Lifelike Collapsible Decoy (LCD)</li> <li>Easy transport and storage</li> <li>15% smaller than a real turkey</li> <li>Unmatched realism and detail</li> <li>Mimics natural reflection of real hen feathers</li> <li>PVC dura-rubber quiets movements</li> <li>Realistic movement without unnatural spin</li> <li>Breeder Hen Decoy</li> <li>Storage Compression Strap</li> <li>Carry Bag</li> <li>Collapsible Carbon Stake</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	94522-DEFAULT-s.jpg	[empty string]	1000	AVX8008	180303	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/lcd-breeder-hen-180303	1
6	[empty string]	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	79.99	0	79.99	53475-DEFAULT-l.jpg	79.99	53475-DEFAULT-m.jpg	LCD SQUATTING HENTURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	LCD LAYDOWN HEN	<p>This lady is ready and waiting! The LCD Laydown Hen's body, wings and head simulate a hen turkey's authentic breeding position. It's a compelling invitation, and one that's been the demise of many a boss gobbler. She pairs perfectly with the LCD Quarter-Strut Jake to create a scene that a boss gobbler just won't tolerate. This pose can also double-down as a highly realistic dusting hen during mid-morning setups. The Laydown Hen does it all and then some!</p> <p> </p> <ul> <li>Laydown</li> <li>Relaxed, comfortable position signals she's ready to breed</li> <li>Calms turkeys down</li> <li>Lifelike Collapsible Decoy (LCD)</li> <li>Easy transport and storage</li> <li>15% smaller than a real turkey</li> <li>Unmatched realism and detail</li> <li>Mimics natural reflection of real hen feathers</li> <li>PVC dura-rubber quiets movements</li> <li>Realistic movement without unnatural spin</li> <li>Laydown Hen Decoy</li> <li>Storage Compression Strap</li> <li>Carry Bag</li> <li>Collapsible Carbon Stake</li> </ul> <p> </p> <ul> <li>FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	53475-DEFAULT-s.jpg	[empty string]	1000	AVX8011	261980	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/lcd-laydown-hen-261980	1
7	[empty string]	TURKEY FAN	Turkey Fan	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	99.99	0	99.99	94540-DEFAULT-l.jpg	99.99	94540-DEFAULT-m.jpg	TURKEY FAN DECOY UMBRELLA STYLE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	TF0000001	<p>The TurkeyFan is the first and only decoy designed for on the move, proactive “fanning method” style of turkey hunting. It is designed to trigger the aggressive territorial response of a dominant Tom, greatly increasing your odds of a successful harvest by mimicking the movements of an immature Jake going in and out of strut bringing them running for up close in your face action. Take your next hunt from a game of yards to a game of inches.</p> <p> </p> <ul> <li>Designed to mimic the strutting motion of a male turkey</li> <li>Portable, compact, and light weight</li> <li>Able to film your hunt using a smart phone and or POV camera</li> <li>Designed to look real and mimic the natural movements of a male turkey</li> </ul> <p> </p> <ul> <li>Weight: 2.15 lbs</li> <li>Dimensions: 33.5" x 4.5" x 2"</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	99.99	99.99	[empty string]	94540-DEFAULT-s.jpg	[empty string]	1000	TF0000001	262083	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	turkey-fan/tf0000001-262083	1
8	[empty string]	MONTANA DECOY	Montana Decoy	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	44.99	0	44.99	109494-DEFAULT-l.jpg	44.99	109494-DEFAULT-m.jpg	FANATIC FULL STRUT TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Fanatic	FEATURES:<br/> -The life-like size and photographic realism creates an appearance that`s sure to rile up any gobbler that sees it.<BR/> -With the attached stake, push it into the ground within seconds for a quick setup or use it to stalk a hung-up bird while peering through the mesh window.<BR/> -It`s light weight and stalking handle makes it easy to hold in one hand and while securing your gun in the other.<BR/> -For the run-and-gun turkey hunter, your chances just got a little bit better.<BR/> -The see-through mesh window for total concealment when stalking.<BR/> -A NOTE ON SAFETY: Turkey reaping is a hot new tactic, but is a practice that should only be applied on private land where, if there happens to be multiple hunters, everyone is aware of each other`s location at all times. Hunt safe, hunt smart.<BR/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	44.99	44.99	[empty string]	109494-DEFAULT-s.jpg	[empty string]	1000	0058	266408	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	montana-decoy/fanatic-full-strut-turkey-decoy-266408	1
9	JAKE	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	JAKE\|NULL\|NULL	1	109.99	0	109.99	94525-DEFAULT-l.jpg	109.99	94525-DEFAULT-m.jpg	LCD JAKE 1/2 STRUT JAKE TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2017	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	LCD HALF-STRUT JAKE	<p>The LCD Half-Strut Jake tells the tragic tale of a young gobbler living dangerously outside the pecking order. His sub-dominant head and relaxed feather positioning show he's fearless in his pursuit to establish dominance. Not to be tested, wild gobblers will be all too willing to teach him a swift lesson. This decoy is especially good for the early season when turkeys are working through the pecking order. Combine with your favorite LCD hens and watch a tragedy unfold. Decoy comes complete with colapsible stake and carry bag.</p> <p> </p> <ul> <li>Half-Strut</li> <li>Sub-dominant posture tests dominant gobblers</li> <li>Relaxed wings and sub-dominant head</li> <li>Lifelike Collapsible Decoy (LCD)</li> <li>Easy transport and storage</li> <li>15% smaller than a real turkey</li> <li>Unmatched realism and detail</li> <li>Includes pre-attached beard</li> <li>PVC dura-rubber quiets movements</li> <li>Great for early season</li> <li>Realistic movement without unnatural spinHalf-Strut Jake Decoy</li> <li>Storage Compression Strap</li> <li>Carry Bag</li> <li>Collapsible Carbon Stake</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	109.99	109.99	[empty string]	94525-DEFAULT-s.jpg	[empty string]	1000	8012	274493	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/lcd-half-strut-jake-274493	1
10	HEN	HUNTERS SPECIALTIES	Hunters Specialties	HUNTING	Hunting>Decoys>Turkey	HEN\|NULL\|NULL	1	32.99	0	32.99	57430-DEFAULT-l.jpg	32.99	57430-DEFAULT-m.jpg	STRUT-LITE FEEDING HEN TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	STRUT-LITE FEEDING HEN DECOY	<p>Strut-Lite Decoys from H.S. Strut offer a lightweight, foldable hollow body construction for easy transportation and storage. Best-in-class detail in the decoys’ flake-resistant paint job makes for extremely realistic decoys that fool even the wisest old toms. Use individually, as pairs or use all three Strut-Lite Decoys together for the “flock” effect. The Feeding Hen’s relaxed feeding position lets other turkeys know that the area is safe. Includes (1) 2-piece ground stake.</p> <p> </p> <ul> <li>FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	32.99	32.99	[empty string]	57430-DEFAULT-s.jpg	[empty string]	1000	100002	275869	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	hunters-specialties/strut-lite-feeding-hen-decoy-275869	1
11	JAKE	HUNTERS SPECIALTIES	Hunters Specialties	HUNTING	Hunting>Decoys>Turkey	JAKE\|NULL\|NULL	1	39.99	0	39.99	83571-DEFAULT-l.jpg	39.99	83571-DEFAULT-m.jpg	STRUT-LITE JAKE TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	STRUT-LITE JAKE DECOY	<p>Strut-Lite Decoys from H.S. Strut offer a lightweight, foldable hollow body construction for easy transportation and storage. Best-in-class detail in the decoys’ flake-resistant paint job makes for extremely realistic decoys that fool even the wisest old toms. Use individually, as pairs or use all three Strut-Lite Decoys together for the “flock” effect. The included 2-piece ground stakes allow for quick setup and removal when things are happening fast in the woods.</p> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	83571-DEFAULT-s.jpg	[empty string]	1000	100003	275870	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	hunters-specialties/strut-lite-jake-decoy-275870	1
12	STRUTTER	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Decoys>Turkey	STRUTTER\|NULL\|NULL	1	59.99	0	59.99	59193-DEFAULT-l.jpg	59.99	59193-DEFAULT-m.jpg	THUNDER CREEPER STRUTTER DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2016	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	THUNDER CREEPER	<p>The Thunder Creeper is the most portable strutting decoy on the market today. Strutting profiles attract attention, and the Thunder Creeper's smaller scale makes him slightly less threatening so incoming turkeys are more likely to approach. Detailed molding and paint on the flexible plastic body give this gobbler an undeniably realistic look. Setup is simple thanks to an attached carbon stake and compact size that make getting into field position fast and easy. Use the supplied folding tail fan or easily add the real deal. It's a flashy invitation for a fight that a boss gobbler won't tolerate.</p> <p> </p> <ul> <li>Strutting profile demands attention</li> <li>Compact body for easy carrying</li> <li>Ultra-realistic paint schemes and feather detail</li> <li>Use with included folding fan or attach one of your own</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	59.99	59.99	[empty string]	59193-DEFAULT-s.jpg	[empty string]	1000	FLXDY316	278672	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	flextone-game-calls/thunder-creeper-278672	1
13	JAKE	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	JAKE\|NULL\|NULL	1	139.99	0	139.99	94539-DEFAULT-l.jpg	139.99	94539-DEFAULT-m.jpg	ROTO MOLDED JAKE TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	HDR JAKE	<p>The HDR jake is sized slightly smaller than a real turkey, but just big enough that he'll make a tempting target. His quarter-strut posture and subdominant feathers signal he's content but ready to fight if an opportunity presents itself. Choose from two included removable head designs one with a curled, aggressive posture, the other straight and submissive. Pair with any Avian-X hen for a completely customized setup, and you'll paint a picture that'll draw in every boss gobbler for miles.  Includes decoy, 2 removable heads, integrated carbon stake and carrying bag.</p> <p> </p> <ul> <li>Quarter-Strut</li> <li>Durable blow-molded design for many seasons of use</li> <li>Relaxed quarter-strut body posture</li> <li>Rubber molded leg stumps with authentic spur detail</li> <li>Customize setups with two removable head designs</li> <li>Includes aggressive and submissive head postures</li> <li>Pre-attached synthetic beard</li> <li>True-to-life paint scheme and feather detail</li> <li>Storage for mounting stake in tail</li> <li>Pairs well with any hen to mimic a breeding pair</li> <li>Includes mounting stake for quick setup</li> <li>Realistic movement without unnatural spin</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	139.99	139.99	[empty string]	94539-DEFAULT-s.jpg	[empty string]	1000	AVX8105	307114	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/hdr-jake-307114	1
14	[empty string]	TURKEY FAN	Turkey Fan	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	139.99	0	139.99	100932-DEFAULT-l.jpg	139.99	100932-DEFAULT-m.jpg	JAKE FAN DECOY UMBRELLA STYLE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	14	100-to-150	0.00	[empty string]	JAKE FAN	<p>Dramatically increase your odds of harvesting a bird by using the JakeFan as a traditional stationary decoy or a run and gun Fanning decoy all in one, to trigger the territorial response of a dominant tom against an adolescent Jake. Included with decoy is a built in stake and 3D head, carrying bag, and TurkeyFan Face mask. JakeFan manually functions to mimic an adolescent bird going in and out of strut. This decoy folds up to be easily portable, and durable for safe transport out in the field. Life like imagery with a 3D head will fool the most finicky Gobbler.</p> <p> </p> <ul> <li>Customize the window in seconds to utilize it for Gun or bow hunting, filming or viewing window all in one</li> <li>Custom window works for filming with any POV camera (Requires POV bracket sold separately)</li> <li>Built in ground stake recesses into handle when not in use, so you never have to worry about loosing it</li> <li>Decoy is designed to be used in traditional hunting scenarios with the ground stake or as a Fanning decoy</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	139.99	139.99	JAKE	100932-DEFAULT-s.jpg	[empty string]	1000	TF10000002	313768	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	turkey-fan/jake-fan-313768	1
15	JAKE	PRIMOS	Primos	HUNTING	Hunting>Decoys>Turkey	JAKE\|NULL\|NULL	1	89.99	0	89.99	83581-DEFAULT-l.jpg	89.99	83581-DEFAULT-m.jpg	PHOTFORM JAKE DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	PHOTOFORM JAKE TURKEY DECOY	<p>The Primos Photoform Jake Decoy looks like a young Jake looking to stake his claim. Utilizing a proprietary process that allows us to take actual imagery of a Jake and print it on 3D molded lightweight foam, this guy is just bold enough to get those birds fired up and ready to fight! Not only will this decoy be light enough to carry around all day, but it will also allow you to collapse it down to fit right in your vest.</p> <p> </p> <ul> <li>Proprietary Photoform process using actual imagery of a turkey</li> <li>Extremely lightweight and portable</li> <li>Realistic head coloration to trigger reaction from onlooking gobblers</li> <li>Content/Submissive body to drive gobblers insane</li> </ul>	[empty string]	N	89.99	89.99	[empty string]	83581-DEFAULT-s.jpg	[empty string]	1000	69069	330567	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	primos/photoform-jake-turkey-decoy-330567	1
16	HEN	PRIMOS	Primos	HUNTING	Hunting>Decoys>Turkey	HEN\|NULL\|NULL	1	79.99	0	79.99	83579-DEFAULT-l.jpg	79.99	83579-DEFAULT-m.jpg	PHOTFORM HEN DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	PHOTOFORM HEN TURKEY DECOY	<p>The Primos Photoform Hen Decoy utilizes a proprietary process that allows us to take actual imagery of a hen and print it on 3D molded foam. Not only will this decoy be light enough to carry around all day but it will also allow you to collapse it down to fit right in your vest. Never worry about lugging your overweight decoys around the turkey woods again with this new decoy.</p> <p> </p> <ul> <li>Proprietary Photoform process using actual imagery of a turkey</li> <li>Extremely lightweight, flexible and portable</li> <li>Multiple positions; contented, feeding and breeding</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	83579-DEFAULT-s.jpg	[empty string]	1000	69068	330568	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	primos/photoform-hen-turkey-decoy-330568	1
17	HEN	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	HEN\|NULL\|NULL	1	139.99	0	139.99	83567-DEFAULT-l.jpg	139.99	83567-DEFAULT-m.jpg	HDR HEN TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	HDR HEN	<p>Introducing the Heavy-Duty Realism (HDR) line of turkey decoys. Blow-molded into reality from hand-carved designs, these decoys harness unbeatable detail and durability. The HDR Hen features an upright body with two interchangeable head postures for double the realism and double the customization. Use the outstretched head for more aggressive setups, or the resting head to signal submissiveness. The HDR Hen pairs perfectly with jake and gobbler decoys as well as other hen decoys to create an authentic, enticing turkey setup. Includes decoy, 2 removable heads, integrated carbon stake and carrying bag.</p> <p> </p> <ul> <li>Breeder</li> <li>Durable blow-molded design for many seasons of use</li> <li>Authentic rubber-molded leg stumps</li> <li>Customize setups with two interchangeable head postures</li> <li>Outstretched head for aggressive setup</li> <li>Resting head signals submissiveness</li> <li>True-to-life paint scheme and feather detail</li> <li>Flocked tail section for added realism</li> <li>Includes integrated mounting stake that stores in tail</li> <li>Realistic movement without unnatural spin</li> <li>Hen Decoy</li> <li>2 Removable Heads</li> <li>Integrated Stake</li> <li>Decoy Bag</li> </ul>	[empty string]	N	139.99	139.99	[empty string]	83567-DEFAULT-s.jpg	[empty string]	1000	AVX8106	332546	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/hdr-hen-332546	1
18	HEN	AVIAN X	Avian X	HUNTING	Hunting>Decoys>Turkey	HEN\|NULL\|NULL	1	139.99	0	139.99	94542-DEFAULT-l.jpg	139.99	94542-DEFAULT-m.jpg	HDR FEEDING HEN TURKEY DECOY	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	HDR FEEDING HEN	<p>The HDR Feeding Hen decoy brings a submissive feeding posture into the HDR (Heavy-Duty Realism) line. This lady's relaxed feathers and lowered feeding posture signal she is content and calm. This makes the hen turkey decoy an attractive invitation for all turkeys: from a potential gobbler mate to another curious hen, a great decoy to add to the flock. Add the HDR Feeding Hen to any setup for an extra dose of realism this turkey season!  Package includes decoy, integrated stake and carrying bag.</p> <p> </p> <ul> <li>Feeding</li> <li>Durable blow-molded design for many seasons of use</li> <li>Relaxed feeding posture signals contentment</li> <li>Authentic rubber-molded leg stumps</li> <li>True-to-life paint scheme and feather detail</li> <li>Flocked tail section for added realism</li> <li>Handle under decoy for easy carry</li> <li>Includes integrated mounting stake that stores in tail</li> <li>Realistic movement without unnatural spin</li> </ul> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	139.99	139.99	[empty string]	94542-DEFAULT-s.jpg	[empty string]	1000	AVX8107	346508	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	avian-x/hdr-feeding-hen-346508	1
19	[empty string]	MOJO MALLARD	Mojo Mallard	HUNTING	Hunting>Decoys>Turkey	[empty string]	1	29.99	0	29.99	94538-DEFAULT-l.jpg	29.99	94538-DEFAULT-m.jpg	FATAL FAN	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	FATAL FAN	<p>The<strong> </strong>MOJO Fatal Fan is a<strong> </strong>realistic artificial fan with photo head, mounted to a stake on a hinge with convenient thumb tab that allows the fan to be laid back in the aggressive posture. Both fan and stake fold to fit in the vest or coat. Includes specially designed fan hub that allows substitution of your real turkey fan for added realism. The most convenient way to enjoy the wildly popular Scoot & Shoot style of hunting. Also serves as standard decoy.</p> <p> </p> <ul> <li>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	94538-DEFAULT-s.jpg	[empty string]	1000	HW2497	348154	TURKEY	EMPTY	EMPTY	0	0	0	DECOYS	[empty string]	mojo-mallard/fatal-fan-348154	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts174 ORDER BY sortposition asc

Hunting

Sort By:

Items per page:

Filter

Filter By

Price

Brand

Size

Lcd Quarter- Strut Jake

Funky Chicken Gen.2

Lcd Lookout Hen

Lcd Feeder Hen

Lcd Breeder Hen

Lcd Laydown Hen

Tf0000001

Fanatic

Lcd Half- Strut Jake

Strut- Lite Feeding Hen Decoy

Strut- Lite Jake Decoy

Thunder Creeper

Hdr Jake

Jake Fan

Photoform Jake Turkey Decoy

Photoform Hen Turkey Decoy

Hdr Hen

Hdr Feeding Hen

Fatal Fan