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	301,297,213,222,323 DISC	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	301\|NULL\|NULL,297\|NULL\|NULL,213\|NULL\|NULL,222\|NULL\|NULL,323 DISC\|NULL\|NULL	1	7.99	0	7.99	89249-DEFAULT-l.jpg	7.99	89249-DEFAULT-m.jpg	5 IN. SWIMSENKO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	91	5-to-10	0.00	[empty string]	SWIMMING SENKO - 5 INCH	<p>A twist on a classic – the Swim Senko is everything that’s great about the legendary Senko, but with a little extra magic. Thanks to the tail, the Swim Senko presents a hard-to-resist horizontal action that’s more than enough to tempt a lunker to bite. The Swim Senko marries the natural profile and subtleness of the Senko with the vibration and movement of a paddletail swimbait. The result is the perfect amount of subtle shimmy, and the perfect amount of kick.</p> <p> </p> <ul> <li>Length: 5"</li> <li>10 per pack</li> </ul>	[empty string]	N	7.99	7.99	[empty string]	89249-DEFAULT-s.jpg	[empty string]	1000	31-10	171467	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/swimming-senko-5-inch-171467	1
2	297,926,305,234,222,363,908,542,953,912,156,960,302,021,913,980,922,968,918,301,031,186,157,306,356,213,547,967,355,323,194,367,904,901,368,955,187,214,020,241,900,051,979,215,357,042,952,196,208,176,956,221,328,238,330,963,326	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	297\|NULL\|NULL,926\|NULL\|NULL,305\|NULL\|NULL,234\|NULL\|NULL,222\|NULL\|NULL,363\|NULL\|NULL,908\|NULL\|NULL,542\|NULL\|NULL,953\|NULL\|NULL,912\|NULL\|NULL,156\|NULL\|NULL,960\|NULL\|NULL,302\|NULL\|NULL,021\|NULL\|NULL,913\|NULL\|NULL,980\|NULL\|NULL,922\|NULL\|NULL,968\|NULL\|NULL,918\|NULL\|NULL,301\|NULL\|NULL,031\|NULL\|NULL,186\|NULL\|NULL,157\|NULL\|NULL,306\|NULL\|NULL,356\|NULL\|NULL,213\|NULL\|NULL,547\|NULL\|NULL,967\|NULL\|NULL,355\|NULL\|NULL,323\|NULL\|NULL,194\|NULL\|NULL,367\|NULL\|NULL,904\|NULL\|NULL,901\|NULL\|NULL,368\|NULL\|NULL,	1	7.49	0	7.49	89171-DEFAULT-l.jpg	7.49	89171-DEFAULT-m.jpg	5 IN. YAMASENKO WORM	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1880	5-to-10	0.00	[empty string]	SENKO - 5 INCH	<p>The Senko is a staple in the fishing world. “Iconic” is an understatement – the Senko has spawned thousands of imposters, but nothing beats the original. Versatility is a key attribute of the Senko, allowing it to be fished in a multitude of ways that all end up putting more fish in the boat. The only wrong way to fish a Senko is to not fish with the original Senko.</p> <p> </p> <ul> <li>Length: 5"</li> <li>10 per pack</li> </ul>	[empty string]	N	7.49	7.49	[empty string]	89171-DEFAULT-s.jpg	[empty string]	1000	9-10	171564	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/senko-5-inch-171564	1
3	156,297,208,176,021,194,196,286,150	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	156\|NULL\|NULL,297\|NULL\|NULL,208\|NULL\|NULL,176\|NULL\|NULL,021\|NULL\|NULL,194\|NULL\|NULL,196\|NULL\|NULL,286\|NULL\|NULL,150\|NULL\|NULL	1	7.49	0	7.49	89411-DEFAULT-l.jpg	7.49	89411-DEFAULT-m.jpg	4IN. DBBL TAIL HULA GRUB	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	179	5-to-10	0.00	[empty string]	DOUBLE TAIL – YAMAMOTO HULA GRUB - 4 INCH	<p>It is impossible to talk about Yamamoto baits without talking about the Hula Grub. The bait that started it all for us. The Hula Grub is a golden standard for offshore fishing with a soft plastic bait. Thanks to its unique shape, this plastic stays on the bottom while providing a ton of action. The Hula Grub is a timeless classic that will always have a place in an experienced angler’s tacklebox.</p> <p> </p> <ul> <li>Length: 4"</li> <li>10 per pack</li> </ul>	[empty string]	N	7.49	7.49	[empty string]	89411-DEFAULT-s.jpg	[empty string]	1000	93-10	171568	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/double-tail-yamamoto-hula-grub-4-inch-171568	1
4	297,218,021,305,176,301,213,194,318,208,306	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	297\|NULL\|NULL,218\|NULL\|NULL,021\|NULL\|NULL,305\|NULL\|NULL,176\|NULL\|NULL,301\|NULL\|NULL,213\|NULL\|NULL,194\|NULL\|NULL,318\|NULL\|NULL,208\|NULL\|NULL,306\|NULL\|NULL	1	7.49	0	7.49	89369-DEFAULT-l.jpg	7.49	89369-DEFAULT-m.jpg	5 IN. DBBL TAIL HULA GRUB	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	330	5-to-10	0.00	[empty string]	DOUBLE TAIL – YAMAMOTO HULA GRUB - 5 INCH	<p>It is impossible to talk about Yamamoto baits without talking about the Hula Grub. The bait that started it all for us. The Hula Grub is a golden standard for offshore fishing with a soft plastic bait. Thanks to its unique shape, this plastic stays on the bottom while providing a ton of action. The Hula Grub is a timeless classic that will always have a place in an experienced angler’s tacklebox.</p> <p> </p> <ul> <li>Length: 5"</li> <li>10 per pack</li> </ul>	[empty string]	N	7.49	7.49	[empty string]	89369-DEFAULT-s.jpg	[empty string]	1000	97-10	171569	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/double-tail-yamamoto-hula-grub-5-inch-171569	1
5	926,955,956,214,953,357,297,213,900,912,196,021,157,979,305,194,221,234,306,901,323,967,980,968,241,042,176	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	926\|NULL\|NULL,955\|NULL\|NULL,956\|NULL\|NULL,214\|NULL\|NULL,953\|NULL\|NULL,357\|NULL\|NULL,297\|NULL\|NULL,213\|NULL\|NULL,900\|NULL\|NULL,912\|NULL\|NULL,196\|NULL\|NULL,021\|NULL\|NULL,157\|NULL\|NULL,979\|NULL\|NULL,305\|NULL\|NULL,194\|NULL\|NULL,221\|NULL\|NULL,234\|NULL\|NULL,306\|NULL\|NULL,901\|NULL\|NULL,323\|NULL\|NULL,967\|NULL\|NULL,980\|NULL\|NULL,968\|NULL\|NULL,241\|NULL\|NULL,042\|NULL\|NULL,176\|NULL\|NULL	1	7.49	0	7.49	89222-DEFAULT-l.jpg	7.49	89222-DEFAULT-m.jpg	4 IN. YAMASENKO WORM	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	656	5-to-10	0.00	[empty string]	SENKO - 4 INCH	<p>The Senko is a staple in the fishing world. “Iconic” is an understatement – the Senko has spawned thousands of imposters, but nothing beats the original. Versatility is a key attribute of the Senko, allowing it to be fished in a multitude of ways that all end up putting more fish in the boat. The only wrong way to fish a Senko is to not fish with the original Senko.</p> <p> </p> <ul> <li>Length: 4"</li> <li>10 per pack</li> </ul>	[empty string]	N	7.49	7.49	[empty string]	89222-DEFAULT-s.jpg	[empty string]	1000	9S-10	171573	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/senko-4-inch-171573	1
6	021,330,208,956,297,196,952,955	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	021\|NULL\|NULL,330\|NULL\|NULL,208\|NULL\|NULL,956\|NULL\|NULL,297\|NULL\|NULL,196\|NULL\|NULL,952\|NULL\|NULL,955\|NULL\|NULL	1	6.99	0	6.99	89276-DEFAULT-l.jpg	6.99	89276-DEFAULT-m.jpg	YAMAMOTO FLAPPIN HOG	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	105	5-to-10	0.00	[empty string]	YAMAMOTO FLAPPIN' HOG - 3.75 INCH	<p>The Flappin’ Hog was built for pigs. As versatile as a bait can be, the Flappin Hog is a like a Swiss Army knife in your tackle box. Texas Rig it. Carolina Rig it. Use it as a jig trailer. No matter how you rig it, the bulky body and 3 different types of appendages will put off vibes that bass can’t resist.</p> <p> </p> <ul> <li>Length: 3.75"</li> <li>7 per pack</li> </ul>	[empty string]	N	6.99	6.99	[empty string]	89276-DEFAULT-s.jpg	[empty string]	1000	FH-07	171578	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/yamamoto-flappin-hog-3-75-inch-171578	1
7	994,981,036,297,993,909,194J,9008,9006,9005,9004,9007,973,021	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	994\|NULL\|NULL,981\|NULL\|NULL,036\|NULL\|NULL,297\|NULL\|NULL,993\|NULL\|NULL,909\|NULL\|NULL,194J\|NULL\|NULL,9008\|NULL\|NULL,9006\|NULL\|NULL,9005\|NULL\|NULL,9004\|NULL\|NULL,9007\|NULL\|NULL,973\|NULL\|NULL,021\|NULL\|NULL	1	6.99	0	6.99	89081-DEFAULT-l.jpg	6.99	89081-DEFAULT-m.jpg	4 IN. YAMASENKO ZAKO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	467	5-to-10	0.00	[empty string]	YAMAMOTO ZAKO SWIMBAIT - 4 INCH	<p>The Zako Swimbait is a great vibrating jig trailer.  Measuring in at 4 inches long, the Zako’s segmented design and natural profile makes it the perfect match for your favorite vibrating jig. But don’t limit it to just that application, it can be used a spinnerbait trailer and many other ways as well. Tie one on and find out for yourself.</p> <p> </p> <ul> <li>Length: 4"</li> <li>6 per pack</li> </ul>	[empty string]	N	6.99	6.99	[empty string]	89081-DEFAULT-s.jpg	[empty string]	1000	134-06	300915	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/yamamoto-zako-swimbait-4-inch-300915	1
8	301,926,297,305,021,194J	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	301\|NULL\|NULL,926\|NULL\|NULL,297\|NULL\|NULL,305\|NULL\|NULL,021\|NULL\|NULL,194J\|NULL\|NULL	1	7.49	0	7.49	89286-DEFAULT-l.jpg	7.49	89286-DEFAULT-m.jpg	YAMAMOTO COWBOY	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	102	5-to-10	0.00	[empty string]	COWBOY - 3.75 INCH	<p>This Cowboy is well-armed. This creature bait pairs the bulky body of the 4.5” Flappin’ Hawg and the swimming tail kick of the iconic DT Grub to create a well-rounded plastic that shines in any scenario. If you need to be shallow, the Cowboy excels as a stand-alone Texas Rig as well as on the back of a jig. Conversely, the Cowboy will do just as much damage out away from the bank as part of a Carolina Rig or on a wobble-head jig. Bulky and loud, the Cowboy is ready for a showdown with big bass!</p> <p> </p> <ul> <li>Length: 3.75"</li> <li>7 per pack</li> </ul>	[empty string]	N	7.49	7.49	[empty string]	89286-DEFAULT-s.jpg	[empty string]	1000	136-07	305560	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/cowboy-3-75-inch-305560	1
9	297,194J,355,386,021,996,980,973	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	297\|NULL\|NULL,194J\|NULL\|NULL,355\|NULL\|NULL,386\|NULL\|NULL,021\|NULL\|NULL,996\|NULL\|NULL,980\|NULL\|NULL,973\|NULL\|NULL	1	5.99	0	5.99	102186-DEFAULT-l.jpg	5.99	102186-DEFAULT-m.jpg	3IN NED SENKO FLOATER 10 PK	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	181	5-to-10	0.00	[empty string]	NED SENKO - 3 INCH	<p>The exact same shape as the 3” fat Senko but built utilizing Yamamoto's “Mega Floater Formula” to make this bait stand up on a Ned head. The size is perfect. The shape is perfect and now the formula is perfect for Ned rigging. While the Original Senko formula is hands down the best for a lot of applications, it isn’t for Ned rigging. We designed this bait to have the same feel and texture of the time-tested Senko, but it floats making it stand up and be more visible when dancing around the bottom of your favorite fishing hole.</p> <p> </p> <ul> <li>Length: 3"</li> <li>10 per pack</li> </ul>	[empty string]	N	5.99	5.99	3IN	102186-DEFAULT-s.jpg	[empty string]	1000	YAM-9N3	376111	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/ned-senko-3-inch-376111	1
10	9006,992,993,9004,994,9005,036,973,297,9007	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	9006\|NULL\|NULL,992\|NULL\|NULL,993\|NULL\|NULL,9004\|NULL\|NULL,994\|NULL\|NULL,9005\|NULL\|NULL,036\|NULL\|NULL,973\|NULL\|NULL,297\|NULL\|NULL,9007\|NULL\|NULL	1	5.99	0	5.99	102198-DEFAULT-l.jpg	5.99	102198-DEFAULT-m.jpg	3IN ZAKO 8PCK	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	229	5-to-10	0.00	[empty string]	ZAKO - 3 INCH	<p>3” Zako is in response to demand from Yakamoto's pros and their customers. As many anglers start utilizing smaller bladed jigs, they asked them to make their favorite trailer in a smaller size. It maintains all the qualities that make the original the industry standard, just in a new fish-catching size.</p> <p> </p> <ul> <li>Length: 3"</li> <li>6 per pack</li> </ul>	[empty string]	N	5.99	5.99	3IN	102198-DEFAULT-s.jpg	[empty string]	1000	YAM-134JR-08	376112	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/zako-3-inch-376112	1
11	9006,9005,9004,958,364,948	GARY YAMAMOTO	Gary Yamamoto	FISHING	Fishing>Lures and Baits>Soft	9006\|NULL\|NULL,9005\|NULL\|NULL,9004\|NULL\|NULL,958\|NULL\|NULL,364\|NULL\|NULL,948\|NULL\|NULL	1	5.99	0	5.99	102243-DEFAULT-l.jpg	5.99	102243-DEFAULT-m.jpg	5IN D-SHAD 7PK	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	141	5-to-10	0.00	[empty string]	D-SHAD - 5 INCH	<p>The D-Shad is a new twist on an old classic. Heavier than a traditional soft-body jerk bait, the D-Shad allows for aggressive action, while allowing you to fish it more effectively all-throughout the water column. This comes in handy when fish want fast retrieval. When paused, the D-Shad will sink much like a Senko. The D-Shad's heavier tail provides a shimmy that drives fish mad.</p> <p> </p> <ul> <li>Length: 5"</li> <li>7 per pack</li> </ul>	[empty string]	N	5.99	5.99	5IN	102243-DEFAULT-s.jpg	[empty string]	1000	YAM-121-07	376114	SOFT	EMPTY	EMPTY	0	0	0	LURES AND BAITS	[empty string]	gary-yamamoto/d-shad-5-inch-376114	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

3IN
5IN

Filter