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]	1	12.99	0	12.99	100054-DEFAULT-l.jpg	12.99	100054-DEFAULT-m.jpg	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]	16	10-to-15	0.00	[empty string]	DYING RABBIT	<p>Predators will find it hard to resist investigating the natural sounds of the Dying Rabbit predator call. The call's versatility makes it a coaxer at close range and an attention-grabber across longer distances. Simply squeeze the end closed for a quiet whine and release for increased volume. Flextone's patented flexible body design gives callers even more freedom to change tone and inflection. This easy-to-use call will be a huge help with that pesky predator population trying to overtake your property.</p> <p> </p> <ul> <li>Attracts coyotes, foxes and other predators</li> <li>Close-range and long-distance distress calls</li> <li>Flexible body controls volume and tone</li> </ul>	[empty string]	N	12.99	12.99	[empty string]	100054-DEFAULT-s.jpg	[empty string]	1000	FLXPD002	25366	OTHER	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/dying-rabbit-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]	2	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]	2	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]	5	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	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]	1	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]	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter