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>Decoys>Turkey	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	FUNKY CHICKEN 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]	2013	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	14	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]	[empty string]	[empty string]	1000	FLXDY330	161052	TURKEY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	flextone-game-calls/funky-chicken-turkey-decoy-161052	1
2	[empty string]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Game Calls>Turkey	[empty string]	0	11.99	0	11.99	[empty string]	11.99	[empty string]	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]	4	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, we’ve perfectly mimicked the throat tissue and vocal box of a crow. The result is undeniably unrealistic sounds from an easy-to-use and super effective mouth call.</p>	[empty string]	N	11.99	11.99	[empty string]	[empty string]	[empty string]	1000	FG-TURK-00067	177558	TURKEY	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/lightning-crow-177558	1
3	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]	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]	27	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
4	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]	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]	10	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
5	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]	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]	17	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
6	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]	34	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
7	[empty string]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Game Calls>Turkey	[empty string]	1	17.99	0	17.99	75458-DEFAULT-l.jpg	17.99	75458-DEFAULT-m.jpg	THUNDER CLUCK N PURR GEN 2 TURKEY CALL	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]	2018	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Thunder Cluck-n-purr - Gen2	<p>The Thunder Cluck-N-Purr is the perfect close- to mid-range turkey call to coax your bird right into your path. Seductive hen turkey clucks and purrs are often difficult to master with diaphragm and box calls, but the Thunder Cluck-N-Purr simplifies things with an easy-to-use, handheld hybrid design. Blow across the double reed through the ergonomic mouthpiece to drive thunder chickens wild and bring them in close.</p>	[empty string]	N	17.99	17.99	[empty string]	75458-DEFAULT-s.jpg	[empty string]	1000	FLXTK131	299771	TURKEY	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/thunder-cluck-n-purr-gen-2-turkey-call-299771	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter