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]	8	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]	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	EMPTY	[empty string]	flextone-game-calls/funky-chicken-gen-2-161052	1
3	[empty string]	FLEXTONE GAME CALLS	FLEXTONE GAME CALLS	HUNTING	Hunting>Game Calls>Turkey	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	FREAK MAMA TURKEY CALL	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	5-to-10	0.00	[empty string]	Freak Mama	FEATURES:<br/> -Triple reed with double batwing cut<br/> -Creates super raspy yelps, cackles and cutting<br/> -.004`` and .003`` latex for easier double notes<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	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	FG-TURK-00062	176519	TURKEY	EMPTY	EMPTY	0	0	0	GAME CALLS	[empty string]	flextone-game-calls/freak-mama-turkey-call-176519	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]	3	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]	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	EMPTY	[empty string]	flextone-game-calls/thunder-creeper-278672	1
6	[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