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]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	60.99	[empty string]	0	[empty string]	DAI SPINCAST REEL	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	ONLINE	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Goldcast 120 - Spincast	<p>Goldcast is a fine, professional quality spincast reel. It features a durable metal construction with an oscillating spool for precise level-winding and one of the smoothest spincast drags ever.</p>	[empty string]	N	60.99	60.99	[empty string]	[empty string]	[empty string]	1000	GC120	18076	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/dai-spincast-reel-18076	1
2	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	0	58.99	0	58.99	[empty string]	58.99	[empty string]	DAI SPINCAST REEL	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]	18	50-to-100	0.00	[empty string]	Goldcast 80 - Spincast	If you like to fish hard and want the ease of spincast, the Goldcast reel is Diawa`s finest, professional-grade spincast tackle. These reels feature durable metal construction, an oscillating spool that wraps line evenly on the spool and one of the smoothest spincast drags ever.<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	58.99	58.99	[empty string]	[empty string]	[empty string]	1000	GC80	18077	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/dai-spincast-reel-18077	1
3	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	59.99	[empty string]	0	[empty string]	DAI SPINCAST REEL	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	ONLINE	[empty string]	[empty string]	24	50-to-100	0.00	[empty string]	Goldcast 100 - Spincast	<p>Goldcast is a fine, professional quality spincast reel. It features a durable metal construction with an oscillating spool for precise level-winding and one of the smoothest spincast drags ever.</p>	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	GC100	18082	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/dai-spincast-reel-18082	1
4	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	27.99	[empty string]	0	[empty string]	DAI SILVERCAST REEL MED	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	ONLINE	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Silvercast 100a - Spincast	<p>The Silvercast A reel features Hardbodyz rigid aluminum alloy construction, plus three ball bearings for smooth operation. Spincast anglers will also appreciate the new Soft Touch handle knob for increased cranking comfort and a more secure grip.</p>	[empty string]	N	27.99	27.99	[empty string]	[empty string]	[empty string]	1000	SC100A	18136	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/dai-silvercast-reel-med-18136	1
5	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	27.99	[empty string]	0	[empty string]	DAI SILVERCAST REEL MED/HVY	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	ONLINE	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Silvercast 120a - Spincast	<p>The Silvercast A reel features Hardbodyz rigid aluminum alloy construction, plus three ball bearings for smooth operation. Spincast anglers will also appreciate the new Soft Touch handle knob for increased cranking comfort and a more secure grip.</p>	[empty string]	N	27.99	27.99	[empty string]	[empty string]	[empty string]	1000	SC120A	18139	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/dai-silvercast-reel-med-hvy-18139	1
6	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	1	0	0	27.99	10555-DEFAULT-l.jpg	0	10555-DEFAULT-m.jpg	DAI SILVERCAST REEL LT	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	ONLINE	[empty string]	[empty string]	21	25-to-50	0.00	[empty string]	Silvercast 80a - Spincast	<p>The Silvercast A reel features Hardbodyz rigid aluminum alloy construction, plus three ball bearings for smooth operation. Spincast anglers will also appreciate the new Soft Touch handle knob for increased cranking comfort and a more secure grip.</p>	[empty string]	N	27.99	27.99	[empty string]	10555-DEFAULT-s.jpg	[empty string]	1000	SC80A	18141	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/dai-silvercast-reel-lt-18141	1
7	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	17.99	[empty string]	0	[empty string]	DAI UNDERSPIN REEL 40	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]	11	15-to-20	0.00	[empty string]	Underspin 40xd - Spincast	<p>Combining the balance of a spinning reel with the casting ease of a spincast, these upgraded versions of Daiwa’s classic Underspin reels work great with spinning, fly or noodle rods, even crappie poles. Soft Touch grips make cranking easy under all conditions.</p>	[empty string]	N	17.99	17.99	[empty string]	[empty string]	[empty string]	1000	US40XD-CP	18177	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/dai-underspin-reel-40-18177	1
8	[empty string]	SHAKESPEARE	Shakespeare	FISHING	Fishing>Reels>Spincasting	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	SHAKESPEARE SYNERGY SPINCAST	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]	DISC	NOT ONLINE	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	Shakespeare Synergy Spincast	[empty string]	[empty string]	N	7.99	18.99	10B	[empty string]	[empty string]	1000	SYNERGY	63298	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	shakespeare/shakespeare-synergy-spincast-63298	1
9	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	36.99	[empty string]	0	[empty string]	ZEB RHINO 4BB SPINCAST REEL	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]	DISC	NOT ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Rhino 3 - Spincast	<p>Built Rhino tough with machine forged aircraft aluminum covers, an aluminum crank handle, roller-adjustable drag and a sealed thumb button. One of the smoothest spincast reels out there. Fish on!</p>	[empty string]	N	36.99	36.99	[empty string]	[empty string]	[empty string]	1000	RSC3B	81257	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/zeb-rhino-4bb-spincast-reel-81257	1
10	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	36.99	[empty string]	0	[empty string]	ZEB RHINO 3 SPINCAST	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]	DISC	PROP 65	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Rhino 3 - Spincast - Clam Pack	<p>Built Rhino tough with machine forged aircraft aluminum covers, an aluminum crank handle, roller-adjustable drag and a sealed thumb button. One of the smoothest spincast reels out there. Fish on!</p>	[empty string]	N	36.99	36.99	[empty string]	[empty string]	[empty string]	1000	RSC3WA-CP	81258	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/zeb-rhino-3-spincast-81258	1
11	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	0	0	64.99	[empty string]	0	[empty string]	ZEBCO OMEGA 2 SPINCAST REEL	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	PROP 65	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Omega - 02 - Spincast	<p>Omega has serious spincasting performance. Casts like a dream. Stays smooth fish after fish, day after day.</p>	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	Z-02	81315	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/zebco-omega-2-spincast-reel-81315	1
12	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	0	0	64.99	48428-DEFAULT-l.jpg	0	48428-DEFAULT-m.jpg	ZEBCO OMEGA SPINCAST REEL	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	PROP 65	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Omega - 03 - Spincast	<p>Omega has serious spincasting performance. Casts like a dream. Stays smooth fish after fish, day after day.</p>	[empty string]	N	64.99	64.99	[empty string]	48428-DEFAULT-s.jpg	[empty string]	1000	Z-03	81316	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/zebco-omega-spincast-reel-81316	1
13	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	29.99	0	33.99	[empty string]	29.99	[empty string]	ZEB RHINO 2 SPINCAST CLAM	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]	DISC	NOT ONLINE	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Rhino 2 - Spincast - Clam Pack	Rhino is built tough with machine forged aircraft aluminum covers, an aluminum crank handle, roller-adjustable drag and a sealed thumb button. One of the smoothest spincast reels out there.<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	33.99	33.99	[empty string]	[empty string]	[empty string]	1000	RSC2B-C	136444	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/zeb-rhino-2-spincast-clam-136444	1
14	[empty string]	SHAKESPEARE	Shakespeare	FISHING	Fishing>Reels>Spincasting	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	SHA SYNERGY STEEL SPINCASTING	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	5	5-to-10	0.00	[empty string]	Synergy - Steel 10 - Spincast	<p>Shakespeare continues to innovate and design products for everyday anglers. The Synergy Steel series is a great value for anglers of all skill levels.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	SYNST10B	138717	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	shakespeare/sha-synergy-steel-spincasting-138717	1
15	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	49.99	0	49.99	34412-DEFAULT-l.jpg	49.99	34412-DEFAULT-m.jpg	DELTA 3 SPINCASTING REEL	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	PROP 65	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Delta 3 - Spincast	<p>With a smooth 5-bearing drive, lightweight aircraft aluminum covers and a Triple-cam multi-disc drag for fish-stopping power, the Delta offers serious spincast performance.</p>	[empty string]	N	49.99	49.99	[empty string]	34412-DEFAULT-s.jpg	[empty string]	1000	ZD3	163715	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/delta-3-spincasting-reel-163715	1
16	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	32.99	0	34.49	[empty string]	32.99	[empty string]	33 PLATINUM SPINCAST REEL CLAM	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]	DISC	NOT ONLINE	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	33 Platinum - Spincast - Clam Pack	The 33 Platinum is Zebco`s top-of-the-line Zebco 33 spincast. Sturdy all-metal body, 5 bearings, Continuous Anti-Reverse and a 4.1:1 gear ratio for smooth, fast retrieves. Fish will practically feel honored to be caught.<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	34.49	34.49	[empty string]	[empty string]	[empty string]	1000	33KPLA-10C-CP3	168427	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-platinum-spincast-reel-clam-168427	1
17	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	27.99	0	29.99	[empty string]	27.99	[empty string]	33 GOLD SPINCAST REEL CLAM	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]	SELL THRU	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	33 Gold - Spincast - Clam Pack	With industrial-grade brushed stainless steel covers, Continuous Anti-Reverse and a 3-bearing drive, the full-featured Zebco 33 Gold sets the standard for spincast performance.<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	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	33KGOLD CP	168429	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-gold-spincast-reel-clam-168429	1
18	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	35.99	0	35.99	[empty string]	35.99	[empty string]	33 MAX GOLD SPINCAST REEL	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]	DISC	NOT ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	33 Max Gold - Spincast	<p>With industrial-grade brushed stainless steel covers, Continuous Anti-Reverse and a 3-bearing drive; the full-featured Zebco 33 Gold MAX has a high standard for spincast performance.</p>	[empty string]	N	35.99	35.99	[empty string]	[empty string]	[empty string]	1000	33MXKGOLD	232081	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-max-gold-spincast-reel-232081	1
19	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	0	27.99	0	27.99	[empty string]	27.99	[empty string]	SILVERCAST REEL 100 CLAM PACK	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	ONLINE	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Silvercast 100a - Spin Cast - Clam Pack	<p>Daiwa`s Silvercast-A reels feature rigid construction, plus three ball bearings for smooth operation. Spincast anglers will also appreciate the Soft Touch handle knob for increased cranking comfort and a more secure grip.</p>	[empty string]	N	27.99	27.99	[empty string]	[empty string]	[empty string]	1000	SC100A-CP	247385	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/silvercast-reel-100-clam-pack-247385	1
20	[empty string]	SHAKESPEARE	Shakespeare	FISHING	Fishing>Reels>Spincasting	[empty string]	1	8.99	0	8.99	53867-DEFAULT-l.jpg	8.99	53867-DEFAULT-m.jpg	SYNERGY STEEL SPINCAST REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Synergy - Steel 6 - Spincast	<p>Shakespeare continues to innovate and design products for everyday anglers. The Synergy Steel series is a great value for anglers of all skill levels.</p>	[empty string]	N	8.99	8.99	[empty string]	53867-DEFAULT-s.jpg	[empty string]	1000	SYNST6B	252488	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	shakespeare/synergy-steel-spincast-reel-252488	1
21	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	7.49	0	7.49	[empty string]	7.49	[empty string]	202 SPINCAST REEL	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]	DISC	NOT ONLINE	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	202 - Spincast	The famous Zebco 202 offers durable all-metal gears, a dial-adjustable drag and a built-in Hook Keeper.<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.49	7.49	[empty string]	[empty string]	[empty string]	1000	202KBK DISC	255438	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/202-spincast-reel-255438	1
22	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	10.99	0	10.99	[empty string]	10.99	[empty string]	404 SPINCAST REEL CLAM	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]	DISC	NOT ONLINE	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	404 - Spincast - Clam Pack	The 404 spincast reel is legendary heavy-duty performance and durability. With all-metal gears built to reel-in bigger lures and bigger fish!<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	10.99	10.99	[empty string]	[empty string]	[empty string]	1000	404MBK-CP	255446	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/404-spincast-reel-clam-255446	1
23	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	16.49	0	16.49	[empty string]	16.49	[empty string]	606 SPINCAST REEL CLAM	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]	DISC	NOT ONLINE	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	606 - Spincast - Clam Pack	The next size up from the Zebco 404, this heavy-duty reel features durable all-metal gears, a selectable multi-stop anti-reverse and comes pre-spooled with 20lb line.<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	16.49	16.49	[empty string]	[empty string]	[empty string]	1000	606KBK-CP DISC	255451	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/606-spincast-reel-clam-255451	1
24	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	21.99	0	21.99	[empty string]	21.99	[empty string]	808 SPINCAST REEL	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]	SELL THRU	PROP 65	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	808 - Spincast	<p>Fishing’s most popular large spincast reel, the Zebco 808 features a thumb button that’s anchored to the body of the reel for a much more solid feel and features a hardier anti-reverse system. Pre-spooled with 20 lb line.</p>	[empty string]	N	21.99	21.99	[empty string]	[empty string]	[empty string]	1000	808H	255564	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/808-spincast-reel-255564	1
25	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	BULLET SPINCAST REEL 9 BEARINGS	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]	DISC	PROP 65	[empty string]	[empty string]	20	50-to-100	0.00	[empty string]	Bullet - Spincast	<p>Geared at 5.1:1, Bullet picks up an unprecedented 29.6” of line with each revolution of the handle - a handle that’s padded with unique-feeling new GripEm All Weather Handle Knobs.</p>	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	ZB3	273402	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/bullet-spincast-reel-9-bearings-273402	1
26	[empty string]	SHAKESPEARE	Shakespeare	FISHING	Fishing>Reels>Spincasting	[empty string]	0	17.99	0	17.99	[empty string]	17.99	[empty string]	SHAKESPEARE SYNERGY SPINCAST REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Synergy Ti 6 - Spincast - 10 Reel Size	<p>The Synergy Ti from Shakespeare features a look to compliment its traditional quality and dependability.</p>	[empty string]	N	17.99	17.99	[empty string]	[empty string]	[empty string]	1000	SYN2TI10B	276125	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	shakespeare/shakespeare-synergy-spincast-reel-276125	1
27	[empty string]	SHAKESPEARE	Shakespeare	FISHING	Fishing>Reels>Spincasting	[empty string]	0	17.99	0	17.99	[empty string]	17.99	[empty string]	SHAKESPEARE SYNERGY SPINCAST REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	3	15-to-20	0.00	[empty string]	Synergy Ti 6 - Spincast - 6 Reel Size	<p>The Synergy Ti from Shakespeare features an all-new look to compliment its traditional quality and dependability.</p>	[empty string]	N	17.99	17.99	[empty string]	[empty string]	[empty string]	1000	SYN2TI6B	276126	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	shakespeare/shakespeare-synergy-spincast-reel-276126	1
28	CP	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	CP\|NULL\|NULL	0	9.99	0	9.99	[empty string]	9.99	[empty string]	202 SPINCAST REEL	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	PROP 65	[empty string]	[empty string]	23	5-to-10	0.00	[empty string]	202 - Spincast	<p>Since 1949, Zebco has been inviting people to explore the outdoors. Whether you're curious or serious about fishing, the reel that taught America to fish makes it easy. Pick a spot, grab some gear and good friends, and see what you discover. Get started with Zebco's all-purpose 202 Spincast reel for your outdoor adventures.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	202MBK	307715	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/202-spincast-reel-307715	1
29	CP	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	CP\|NULL\|NULL	1	12.99	0	12.99	82859-DEFAULT-l.jpg	12.99	82859-DEFAULT-m.jpg	404 SPINCAST REEL	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	PROP 65	[empty string]	[empty string]	8	10-to-15	0.00	[empty string]	404 - Spincast	<p>Legendary heavy-duty performance and durability. With all-metal gears built to reel-in bigger lures and bigger fish! Pre-spooled with tough 15 lb line.</p>	[empty string]	N	12.99	12.99	[empty string]	82859-DEFAULT-s.jpg	[empty string]	1000	404MBK	307716	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/404-spincast-reel-307716	1
30	CP	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	CP\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	606 SPINCAST REEL	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	PROP 65	[empty string]	[empty string]	19	15-to-20	0.00	[empty string]	606 - Spincast	<p>The next size up from the Zebco 404, this heavy-duty reel features durable all-metal gears, a selectable multi-stop anti-reverse and comes pre-spooled with 20lb line.</p>	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	606MBK	307717	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/606-spincast-reel-307717	1
31	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	29.99	0	29.99	82851-DEFAULT-l.jpg	29.99	82851-DEFAULT-m.jpg	33 MICRO GOLD SC REEL 4#C CP	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]	2019	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	33 Gold Micro - Spincast	<p>The 33 Gold brings an elevated fishing experience to a trusted spincast. Featuring a sleek brushed finish, brass pinion gear, patented no-tangle design and a Instant Anti-Reverse clutch, the gold standard of spincast reels appears to have been raised — even if the price hasn’t.</p>	[empty string]	N	29.99	29.99	[empty string]	82851-DEFAULT-s.jpg	[empty string]	1000	33MCNGOLD	324759	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-micro-gold-sc-reel-4-c-cp-324759	1
32	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	32.99	0	32.99	82850-DEFAULT-l.jpg	32.99	82850-DEFAULT-m.jpg	33 MICRO GOLD SPINCAST REEL 10#C CP	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]	2019	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	33 Gold - Spincast	<p>The 33 Gold brings an elevated fishing experience to a trusted spincast. Featuring a sleek brushed finish, brass pinion gear, patented no-tangle design and a Instant Anti-Reverse clutch, the gold standard of spincast reels appears to have been raised — even if the price hasn’t.</p>	[empty string]	N	32.99	32.99	[empty string]	82850-DEFAULT-s.jpg	[empty string]	1000	33NGOLD	324767	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-micro-gold-spincast-reel-10-c-cp-324767	1
33	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	26.99	0	26.99	82856-DEFAULT-l.jpg	26.99	82856-DEFAULT-m.jpg	33 SPINCAST REEL 10#C CP	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]	2019	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	33 - Spincast	<p>It’s America’s most trusted, easy-to-use fishing reel, now with a larger gear ratio that lets you retrieve your lure 20% faster. Features all-metal gears, QuickSet anti-reverse, Bite Alert and a dial-adjustable drag. All at a price that lets everyone in on the action.</p>	[empty string]	N	26.99	26.99	[empty string]	82856-DEFAULT-s.jpg	[empty string]	1000	33N	324768	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-spincast-reel-10-c-cp-324768	1
34	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	26.99	0	26.99	82849-DEFAULT-l.jpg	26.99	82849-DEFAULT-m.jpg	33LADY SPINCAST REEL 10#C CP	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]	2019	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	33 - Spincast	<p>It’s America’s most trusted, easy-to-use fishing reel, now with a larger gear ratio that lets you retrieve your lure 20% faster. Features all-metal gears, QuickSet anti-reverse, Bite Alert and a dial-adjustable drag.</p>	[empty string]	N	26.99	26.99	[empty string]	82849-DEFAULT-s.jpg	[empty string]	1000	33NL	324769	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33lady-spincast-reel-10-c-cp-324769	1
35	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	33 MICRO SPINCAST REEL 4#C CP	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]	2019	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	11	15-to-20	0.00	[empty string]	33 Micro - Spincast	<p>If you’re a fan of the panfish, the 33 Micro spincast is the last ultralight you’ll ever need. Designed to finesse bites from even the most wily of sunfish and crappie, the 33 Micro features all metal gears, patented no-tangle design, a lightweight graphite frame and comes pre-spooled with 4 lb. Zebco Cajun Line. A terrific, micro ultralight reel with a macro impact on panfish.</p>	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	33MCN	324773	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-micro-spincast-reel-4-c-cp-324773	1
36	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	39.99	0	39.99	48403-DEFAULT-l.jpg	39.99	48403-DEFAULT-m.jpg	33 PLATINUM SPINCAST REEL 602M	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]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	33 Platinum Spincast Reel 602m	[empty string]	[empty string]	N	39.99	39.99	[empty string]	48403-DEFAULT-s.jpg	[empty string]	1000	33NPL REEL	338899	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-platinum-spincast-reel-602m-338899	1
37	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	808J SPINCAST REEL	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]	2020	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	808j Spincast Reel	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	808J	338903	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/808j-spincast-reel-338903	1
38	20,6,10	SHAKESPEARE	Shakespeare	FISHING	Fishing>Reels>Spincasting	20\|NULL\|NULL,6\|NULL\|NULL,10\|NULL\|NULL	0	29.99	1	24.99	[empty string]	29.99	[empty string]	UGLY TUFF SPINCAST REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	19	20-to-25	0.00	[empty string]	Ugly Tuff Spincast Reel	[empty string]	[empty string]	N	24.99	29.99	[empty string]	[empty string]	[empty string]	1000	USTUFFSC	340953	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	shakespeare/ugly-tuff-spincast-reel-340953	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts477 ORDER BY sortposition asc

Fishing

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Brand

Size

Goldcast 120 - Spincast

Goldcast 80 - Spincast

Goldcast 100 - Spincast

Silvercast 100a - Spincast

Silvercast 120a - Spincast

Silvercast 80a - Spincast

Underspin 40xd - Spincast

Shakespeare Synergy Spincast

Rhino 3 - Spincast

Rhino 3 - Spincast - Clam Pack

Omega - 02 - Spincast

Omega - 03 - Spincast

Rhino 2 - Spincast - Clam Pack

Synergy - Steel 10 - Spincast

Delta 3 - Spincast

33 Platinum - Spincast - Clam Pack

33 Gold - Spincast - Clam Pack

33 Max Gold - Spincast

Silvercast 100a - Spin Cast - Clam Pack

Synergy - Steel 6 - Spincast

202 - Spincast

404 - Spincast - Clam Pack

606 - Spincast - Clam Pack

808 - Spincast