Jay's Sporting Goods

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]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Game Calls>Other	[empty string]	0	0	0	12.99	[empty string]	0	[empty string]	DYING RABBIT PRED CALL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	12	10-to-15	0.00	[empty string]	Dying Rabbit Predator Call	Predators can`t resist investigating the natural sounds of the Flextone Dying Rabbit Call. The flexible design gives this call lots of inflection and natural pleading sound. Just squeeze the end closed for a quiet whine or release for louder volume. It is a coaxer and long distance call all in one.	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	FLXPD002	25366	OTHER	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/dying-rabbit-pred-call-25366	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]	6	25-to-50	0.00	[empty string]	Funky Chicken Gen 2	<p>The Funky Chicken is the wimpiest, skinniest tom in the woods. Flextone has 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 ‘til you see what this little twerp can do. He may be small, but he brings big results.</p> <p> </p> <p>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</p>	[empty string]	N	29.99	29.99	[empty string]	94530-DEFAULT-s.jpg	[empty string]	1000	FLXDY330	161052	TURKEY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	flextone-game-calls/funky-chicken-turkey-decoy-161052	1
3	[empty string]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Game Calls>Turkey	[empty string]	1	11.99	0	11.99	94587-DEFAULT-l.jpg	11.99	94587-DEFAULT-m.jpg	LIGHTNING CROW	N	9 BILL	[empty string]	[empty string]	[empty string]	V	[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]	6	10-to-15	0.00	[empty string]	Lightning Crow	<p>Whether you’re looking to chase crows or gobblers, the Lightning Crow will turn the tables and make them chase you. It promises long-range volume and authentic crow sounds to drop whatever bird you’re after. Flextone’s innovative Flex It Technology is the secret behind this super lifelike call. By wrapping a soft, flexible body around a rigid reed,Flextone has perfectly mimicked the throat tissue and vocal box of a crow. The result is undeniably realistic sounds from an easy-to-use and super effective mouth call.</p> <p> </p> <ul> <li>Locate turkeys or call crows</li> <li>Extreme long-range volume</li> <li>Soft body for natural sounds</li> </ul>	[empty string]	N	11.99	11.99	[empty string]	94587-DEFAULT-s.jpg	[empty string]	1000	FG-TURK-00067	177558	TURKEY	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/lightning-crow-177558	1
4	[empty string]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Game Calls>Turkey	[empty string]	1	11.99	0	11.99	94588-DEFAULT-l.jpg	11.99	94588-DEFAULT-m.jpg	LIGHTNING OWL	N	9 BILL	[empty string]	[empty string]	[empty string]	V	[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]	9	10-to-15	0.00	[empty string]	Lightning Owl	<p>Flextone combined the best of two classic call styles to bring you the ultimate owl hooter. The Lightning Owl is part reed call; part barrel call; all parts effective. The oversized barrel does the work for you by creating automatic backpressure, while the reed delivers in-your-face volume. That means the Lightning Owl is as easy to use as it is versatile. The design also features two exhaust ports – one on top and one inside – for fool-proof sounds. Press the tone button for instant screams that are sure to turn turkey heads. Once you've mastered the basics, play with different tones by bending and twisting the soft, flexible body.</p> <p> </p> <ul> <li>Oversized barrel for increased volume</li> <li>Unique tone button for instant screams</li> <li>Soft body creates ultra-realistic owl calls</li> <li>Port holes for error-proof calling</li> </ul>	[empty string]	N	11.99	11.99	[empty string]	94588-DEFAULT-s.jpg	[empty string]	1000	FG-TURK-00068	177559	TURKEY	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/lightning-owl-177559	1
5	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]	1	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> <p>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</p>	[empty string]	N	59.99	59.99	[empty string]	59193-DEFAULT-s.jpg	[empty string]	1000	FLXDY316	278672	TURKEY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	flextone-game-calls/thunder-creeper-strutter-decoy-278672	1
6	HEN	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Decoys>Turkey	HEN\|NULL\|NULL	1	49.99	0	49.99	62827-DEFAULT-l.jpg	49.99	62827-DEFAULT-m.jpg	THUNDER CHIC UPRIGHT HEN 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]	Thunder Chick Upright	<p>The Thunder Chick Upright is designed with an upright head to signify dominance toward other hens. This pose also gives her a higher profile for greater visibility that`s easier for incoming turkeys to identify. Her relaxed feather positioning attracts passing birds to approach without hesitation. When it comes to bringing in gobblers for mating or hens through the pecking order, the Thunder Chick is unmatched.</p> <p> </p> <p>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</p>	[empty string]	N	49.99	49.99	[empty string]	62827-DEFAULT-s.jpg	[empty string]	1000	FLXDY315	278673	TURKEY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	flextone-game-calls/thunder-chic-upright-hen-decoy-278673	1
7	HEN	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Decoys>Turkey	HEN\|NULL\|NULL	1	49.99	0	49.99	59194-DEFAULT-l.jpg	49.99	59194-DEFAULT-m.jpg	THUNDER CHIC FEEDING HEN 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]	5	25-to-50	0.00	[empty string]	Thunder Chick Feeder	<p>When you`re looking to add contentment and relaxation to your decoy scene, the Thunder Chick Feeder is the decoy of choice. Whether standalone or combined with other decoy poses, she signifies contentment while she looks for her next bite to eat. Her relaxed head, body and feather placement will attract turkeys on all levels: from potential mates to curious hens who want to see what she`s eating. This lady is as real as it gets.</p> <p> </p> <p>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</p>	[empty string]	N	49.99	49.99	[empty string]	59194-DEFAULT-s.jpg	[empty string]	1000	FLXDY314	278674	TURKEY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	flextone-game-calls/thunder-chic-feeding-hen-decoy-278674	1
8	JAKE	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Decoys>Turkey	JAKE\|NULL\|NULL	1	59.99	0	59.99	59195-DEFAULT-l.jpg	59.99	59195-DEFAULT-m.jpg	THUNDER 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]	2016	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Thunder Jake	<p>When you challenge the pecking order, it can change the game. Adding a non-threatening decoy like the Thunder Jake can bring in a gobbler to the end of your boots. The upright design of the Thunder Jake tells nearby birds there’s a non-dominant gobbler with the hens. Most times this immediately triggers a gobbler’s dominance; he’ll quickly go from thinking about mating to a fighting mentality to establish who is boss. The paint scheme and feather detail further add to the Thunder Jake’s relaxed appearance to make him an easy target. His non-threatening, upright position has great visibility for passing birds.</p> <p> </p> <p>NOTE: FOR ORDERING MULTIPLES OF THS PRODUCT PLEASE CALL 989-386-1534 FOR SHIPPING PRICES</p>	[empty string]	N	59.99	59.99	[empty string]	59195-DEFAULT-s.jpg	[empty string]	1000	FLXDY317	278675	TURKEY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	flextone-game-calls/thunder-jake-decoy-278675	1
9	[empty string]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Game Calls>Turkey	[empty string]	1	17.99	0	17.99	94589-DEFAULT-l.jpg	17.99	94589-DEFAULT-m.jpg	THUNDER SHAKER GOBBLE	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]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Thunder Shaker Gobble	<p>For hunters looking for a modern, easy-to-use solution to draw in toms, the Thunder Shaker Gobble makes gobbling easier than ever with a user-friendly handheld design. No need to waste time practicing with difficult mouth and diaphragm calls; anyone can master this call in mere seconds! Simply shake the bellows for instant, realistic gobbles. The compact size stows easily, ready to bust out gobbling action at any moment.</p> <p> </p> <ul> <li>Incredibly easy to use</li> <li>Shake for instant, realistic gobbles</li> <li>Durable construction</li> </ul>	[empty string]	N	17.99	17.99	[empty string]	94589-DEFAULT-s.jpg	[empty string]	1000	FLXTK136	292372	TURKEY	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/thunder-shaker-gobble-292372	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter