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]	1	29.99	0	29.99	10579-DEFAULT-l.jpg	29.99	10579-DEFAULT-m.jpg	DAI UNDERSPIN REEL 120	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]	2	25-to-50	0.00	[empty string]	UNDERSPIN US XD - 120 - CLAM PACK	<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> <p> </p> <ul> <li>Smooth ball bearing drive</li> <li>Hardbodyz Rigid Aluminum Alloy Construction</li> <li>Rugged metal gearing</li> <li>Rotating, Titanium Nitrided line pickup turns with the line for less wear, easier casting</li> <li>Oversized line aperture for casting performance</li> <li>Smooth drag with easy rear adjustment (front drag on 40 size)</li> <li>Soft Touch handle knob</li> <li>Converts quickly to right or left hand retrieve</li> <li>Pre-wound with premium line</li> </ul> <p> </p> <ul> <li>Bearing: 1BB</li> <li>Gear Ratio: 4.3:1</li> <li>Line Per Crank:  25.9"</li> <li>Weight: 10.8 oz</li> <li>Mono Capacity: 12/100</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	10579-DEFAULT-s.jpg	[empty string]	1000	US120XD-CP	18175	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/underspin-us-xd-120-clam-pack-18175	1
2	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	1	29.99	0	29.99	95884-DEFAULT-l.jpg	29.99	95884-DEFAULT-m.jpg	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]	27	25-to-50	0.00	[empty string]	UNDERSPIN US XD - 40 - CLAM PACK	<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> <p> </p> <ul> <li>Smooth ball bearing drive</li> <li>Hardbodyz Rigid Aluminum Alloy Construction</li> <li>Rugged metal gearing</li> <li>Rotating, Titanium Nitrided line pickup turns with the line for less wear, easier casting</li> <li>Oversized line aperture for casting performance</li> <li>Smooth drag with easy rear adjustment (front drag on 40 size)</li> <li>Soft Touch handle knob</li> <li>Converts quickly to right or left hand retrieve</li> <li>Pre-wound with premium line</li> </ul> <p> </p> <ul> <li>Bearing: 1BB</li> <li>Gear Ratio: 4.1:1</li> <li>Line Per Crank:  16.1"</li> <li>Weight: 5.5 oz</li> <li>Mono Capacity: 4/85</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	95884-DEFAULT-s.jpg	[empty string]	1000	US40XD-CP	18177	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/underspin-us-xd-40-clam-pack-18177	1
3	[empty string]	DAIWA	Daiwa	FISHING	Fishing>Reels>Spincasting	[empty string]	1	29.99	0	29.99	10581-DEFAULT-l.jpg	29.99	10581-DEFAULT-m.jpg	DAI UNDERSPIN REEL 80	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]	12	25-to-50	0.00	[empty string]	UNDERSPIN US XD - 80 - CLAM PACK	<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> <p> </p> <ul> <li>Smooth ball bearing drive</li> <li>Hardbodyz Rigid Aluminum Alloy Construction</li> <li>Rugged metal gearing</li> <li>Rotating, Titanium Nitrided line pickup turns with the line for less wear, easier casting</li> <li>Oversized line aperture for casting performance</li> <li>Smooth drag with easy rear adjustment (front drag on 40 size)</li> <li>Soft Touch handle knob</li> <li>Converts quickly to right or left hand retrieve</li> <li>Pre-wound with premium line</li> </ul> <p> </p> <ul> <li>Bearing: 1BB</li> <li>Gear Ratio: 4.3:1</li> <li>Line Per Crank:  21.8"</li> <li>Weight: 9.2 oz</li> <li>Mono Capacity: 8/75</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	10581-DEFAULT-s.jpg	[empty string]	1000	US80XD-CP	18179	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	daiwa/underspin-us-xd-80-clam-pack-18179	1
4	CP	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	CP\|NULL\|NULL	1	9.99	0	9.99	96194-DEFAULT-l.jpg	9.99	96194-DEFAULT-m.jpg	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]	21	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> <p> </p> <ul> <li>Dial-adjustable drag</li> <li>All-metal gears</li> <li>Stainless Steel Pick-up Pin</li> <li>QuickSet Anti-Reverse</li> <li>Right-Hand Retrieve</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right</li> <li>Pre-Spooled: 10 lb</li> <li>Mono Capacity: 110/10</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 0</li> <li>Gear Ratio: 2.8:1</li> <li>Inches Per Turn: 15</li> <li>Weight: 6.2 oz</li> </ul>	[empty string]	N	9.99	9.99	[empty string]	96194-DEFAULT-s.jpg	[empty string]	1000	202MBK	307715	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/202-spincast-307715	1
5	CP	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	CP\|NULL\|NULL	1	14.99	0	14.99	82859-DEFAULT-l.jpg	14.99	82859-DEFAULT-m.jpg	404 SPINCAST REEL 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	PROP 65	[empty string]	[empty string]	16	10-to-15	0.00	[empty string]	404 - SPINCAST - CLAM PACK	<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> <p> </p> <ul> <li>Dial-adjustable drag</li> <li>All-metal gears</li> <li>Stainless Steel Pick-up Pin</li> <li>QuickSet Anti-Reverse</li> <li>Right-Hand Retrieve</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right</li> <li>Pre-Spooled: 15 lb</li> <li>Mono Capacity: 90/15</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 0</li> <li>Gear Ratio: 2.8:1</li> <li>Inches Per Turn: 17</li> <li>Weight: 9 oz</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	82859-DEFAULT-s.jpg	[empty string]	1000	404MBK-CP	307716	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/404-spincast-clam-pack-307716	1
6	CP	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	CP\|NULL\|NULL	1	19.99	0	19.99	96195-DEFAULT-l.jpg	19.99	96195-DEFAULT-m.jpg	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 20 lb. line.</p> <p> </p> <ul> <li>Dial-adjustable drag</li> <li>All-metal gears</li> <li>Stainless Steel Pick-up Pin</li> <li>QuickSet Anti-Reverse</li> <li>Right-Hand Retrieve</li> <li>Ball bearing system</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right</li> <li>Pre-Spooled: 20 lb</li> <li>Mono Capacity: 110/20</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 1</li> <li>Gear Ratio: 3.0:1</li> <li>Inches Per Turn: 19</li> <li>Weight: 10.7 oz</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	96195-DEFAULT-s.jpg	[empty string]	1000	606MBK	307717	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/606-spincast-307717	1
7	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	34.99	0	34.99	82851-DEFAULT-l.jpg	34.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]	10	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. The 33 Spincast Gold reel comes in micro and max sizes.</p> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel covers</li> <li>Lightweight graphite frame</li> <li>Instant Anti-Reverse clutch</li> <li>Changeable right- or left-hand retrieve</li> <li>3 Bearings (2 + Clutch)</li> <li>Solid-brass pinion gear</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 90/4</li> <li>Anti-Reverse: Instant</li> <li>Reel Bearings: 2+1</li> <li>Gear Ratio: 4.3:1</li> <li>Inches Per Turn: 16</li> <li>Weight: 6 oz</li> <li>Pre-Spooled: 4 lb</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	82851-DEFAULT-s.jpg	[empty string]	1000	33MCNGOLD	324759	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-gold-micro-spincast-324759	1
8	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	34.99	0	34.99	96211-DEFAULT-l.jpg	34.99	96211-DEFAULT-m.jpg	33 MICRO GOLD TRIGGERSPIN 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]	4	25-to-50	0.00	[empty string]	33 GOLD - MICRO - TRIGGERSPIN	<p>Gold-standard performance at a price that is anything but lavish. The lightweight 33 Gold Micro Trigger spincast is smoother than ever with a 3-bearing drive, Instant Anti-Reverse clutch and a fun and easy-to-handle trigger feature for perfect release. A sleek, brushed reel that’s ideal for taking aim at your favorite panfish and trout, you’ll quickly set a new gold standard for angling achievement.</p> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel front cover</li> <li>Lightweight graphite frame</li> <li>Instant Anti-Reverse clutch</li> <li>Changeable right- or left-hand retrieve</li> <li>3 Bearings (2 + Clutch)</li> <li>Solid-brass pinion gear</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 90/4</li> <li>Anti-Reverse: Instant</li> <li>Reel Bearings: 2+1</li> <li>Gear Ratio: 4.3:1</li> <li>Inches Per Turn: 16</li> <li>Weight: 6.1 oz</li> <li>Pre-Spooled: 4 lb</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	96211-DEFAULT-s.jpg	[empty string]	1000	33MTNGOLD	324766	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-gold-micro-triggerspin-324766	1
9	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	39.99	0	39.99	82850-DEFAULT-l.jpg	39.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]	9	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. The 33 Spincast Gold reel comes in micro and max sizes.</p> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel covers</li> <li>Lightweight graphite frame</li> <li>Instant Anti-Reverse clutch</li> <li>Changeable right- or left-hand retrieve</li> <li>3 Bearings (2 + Clutch)</li> <li>Solid-brass pinion gear</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 120/10</li> <li>Anti-Reverse: Instant</li> <li>Reel Bearings: 2+1</li> <li>Gear Ratio: 4.1:1</li> <li>Inches Per Turn: 23</li> <li>Weight: 9.6 oz</li> <li>Pre-Spooled: 10 lb</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	82850-DEFAULT-s.jpg	[empty string]	1000	33NGOLD	324767	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-gold-spincast-324767	1
10	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	32.99	0	32.99	82856-DEFAULT-l.jpg	32.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]	20	25-to-50	0.00	[empty string]	33 - SPINCAST	<p>The 33 Spincast reel has 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. The 33 Spincast Reel comes in silver and pink as well as micro and max sizes.</p> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel covers</li> <li>Lightweight graphite frame</li> <li>QuickSet Anti-Reverse</li> <li>Changeable right- or left-hand retrieve</li> <li>Ball bearing system</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 120/10</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 1</li> <li>Gear Ratio: 4.1:1</li> <li>Inches Per Turn: 23</li> <li>Weight: 9.3 oz</li> <li>Pre-Spooled: 10 lb</li> </ul>	[empty string]	N	32.99	32.99	[empty string]	82856-DEFAULT-s.jpg	[empty string]	1000	33N	324768	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-spincast-324768	1
11	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	32.99	0	32.99	82849-DEFAULT-l.jpg	32.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]	9	25-to-50	0.00	[empty string]	33 - SPINCAST - PINK	<p>The 33 Spincast reel has 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. The 33 Spincast Reel comes in silver and pink as well as micro and max sizes.</p> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel covers</li> <li>Lightweight graphite frame</li> <li>QuickSet Anti-Reverse</li> <li>Changeable right- or left-hand retrieve</li> <li>Ball bearing system</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 120/10</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 1</li> <li>Gear Ratio: 4.1:1</li> <li>Inches Per Turn: 23</li> <li>Weight: 9.3 oz</li> <li>Pre-Spooled: 10 lb</li> </ul>	[empty string]	N	32.99	32.99	[empty string]	82849-DEFAULT-s.jpg	[empty string]	1000	33NL	324769	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-spincast-pink-324769	1
12	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	24.99	0	24.99	96212-DEFAULT-l.jpg	24.99	96212-DEFAULT-m.jpg	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]	19	20-to-25	0.00	[empty string]	33 - MICRO - SPINCAST	<p>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> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel covers</li> <li>Lightweight graphite frame</li> <li>QuickSet Anti-Reverse</li> <li>Changeable right- or left-hand retrieve</li> <li>Ball bearing system</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 90/4</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 1</li> <li>Gear Ratio: 4.3:1</li> <li>Inches Per Turn: 16</li> <li>Weight: 5.8 oz</li> <li>Pre-Spooled: 4 lb</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	96212-DEFAULT-s.jpg	[empty string]	1000	33MCN	324773	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-micro-spincast-324773	1
13	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	19.99	0	19.99	96213-DEFAULT-l.jpg	19.99	96213-DEFAULT-m.jpg	33 MICRO TRIGGERSPIN 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]	20	15-to-20	0.00	[empty string]	33 - MICRO - TRIGGERSPIN	<p>The Triggerspin line release on the 33 Micro Trigger means you get all the benefits of a spinning reel in an easy-to-use spincast. Whether you’re after panfish or trout, the Quickset anti-reverse, patented no-tangle design, sleek graphite composite finish and one-touch trigger release make this reel the no-brainer for your next adventure.</p> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel front cover</li> <li>Lightweight graphite frame</li> <li>QuickSet Anti-Reverse</li> <li>Changeable right- or left-hand retrieve</li> <li>Ball bearing system</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 90/4</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 1</li> <li>Gear Ratio: 4.3:1</li> <li>Inches Per Turn: 16</li> <li>Weight: 6 oz</li> <li>Pre-Spooled: 4 lb</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	96213-DEFAULT-s.jpg	[empty string]	1000	33MTN	324778	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-micro-triggerspin-324778	1
14	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Spincasting	[empty string]	1	34.99	0	34.99	48403-DEFAULT-l.jpg	34.99	48403-DEFAULT-m.jpg	33MAX 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	NOT ONLINE	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	33 - MAX - SPINCAST	<p>The reel that altered the angling landscape is new again and ready for the heavy hitters. The 33 Max grows the trusted and easy-to-use classic spincast into a large fish-fighting machine, with Zebco's patented no tangle design, a modern graphite frame and pre-spooled 20 lb. Cajun Line. It’s maximum strength and value at a not-so maximum price.</p> <p> </p> <ul> <li>MicroFine dial-adjustable drag</li> <li>All-metal gears</li> <li>Dual Ceramic Pick-up Pins</li> <li>Stainless steel covers</li> <li>Lightweight graphite frame</li> <li>QuickSet Anti-Reverse</li> <li>Changeable right- or left-hand retrieve</li> <li>Ball bearing system</li> <li>Patented no-tangle design</li> </ul> <p> </p> <ul> <li>Hand Retrieve: Right/Left</li> <li>Mono Capacity: 100/20</li> <li>Anti-Reverse: QuickSet</li> <li>Reel Bearings: 1</li> <li>Gear Ratio: 2.6:1</li> <li>Inches Per Turn: 16</li> <li>Weight: 12.4 oz</li> <li>Pre-Spooled: 20 lb</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	48403-DEFAULT-s.jpg	[empty string]	1000	33MXN	338900	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/33-max-spincast-338900	1
15	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Spincasting	[empty string]	1	39.99	0	39.99	95868-DEFAULT-l.jpg	39.99	95868-DEFAULT-m.jpg	MAX PRO SPINCAST REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	MAX PRO - SPINCAST	<p>Engineered to outperform, the Max Pro takes spincast reel design to the next level. A 4-bearing system ensures smooth and efficient operation. Other upgrades include a QuadCam engagement mechanism that results is faster line engagement on the retrieve. An aluminum frame and cone round out the list of features of the Max Pro's modern design. Pre-spooled with premium monofilament fishing line.</p> <p> </p> <ul> <li>QuadCam Pickup System</li> <li>4 ball bearings</li> <li>Pre-spooled with premium monofilament</li> <li>Smooth and consistent multi disc drag system</li> <li>Aluminum Body and Cone</li> <li>Easy Spool Feature</li> </ul> <p> </p> <ul> <li>Anti-Reversal Feature: Instant Anti-Reverse</li> <li>Bearing Count: 4</li> <li>Drag Material: Teflon</li> <li>Drag Type: Twin Cam</li> <li>Gear Ratio: 3.6:1</li> <li>Max Drag: 8 lb (3.6 kg)</li> <li>Mono Capacity (m/mm): 100/0.25</li> <li>Mono Capacity (yd/lb): 110/8</li> <li>Pre-Spooled (yd/lb): 10 lb (4.5 kg)</li> <li>Recovery Rate: 23" (58 cm)</li> <li>Reel Handle Position: Right / Left</li> <li>Reel Size: 10</li> <li>Reel Spool Material: Aluminum</li> <li>Spare Spool Material: No Spare Spool</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	95868-DEFAULT-s.jpg	[empty string]	1000	MAXPROSC10-C	340910	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/max-pro-spincast-340910	1
16	20,10	SHAKESPEARE	Shakespeare	FISHING	Fishing>Reels>Spincasting	20\|NULL\|NULL,10\|NULL\|NULL	1	29.99	1	24.99	96146-DEFAULT-l.jpg	29.99	96146-DEFAULT-m.jpg	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]	21	20-to-25	0.00	[empty string]	UGLY TUFF - SPINCAST	<p>Ugly Stik toughness and dependability in spincast reels, the Ugly Stik reels are made for anglers demanding durability out of their gear.  Made with aluminum construction and stainless-steel ball bearings, Ugly Stik reels are meant to stand up to the toughest of fights.</p> <p> </p> <ul> <li>Ugly Tuff Aluminum Frame</li> <li>Ugly Tuff Aluminum Front cone</li> <li>3-ball bearing system</li> <li>Always on Instant Anti-Reverse</li> <li>Pre Spooled</li> </ul> <p> </p> <ul> <li>Anti-Reverse: Instant Anti-Reverse</li> <li>Bearing Count: 3</li> <li>Braking System: None</li> <li>Drag Material: Teflon</li> <li>Drag Type: Twin Cam</li> <li>Reel Handle Position: Right / Left</li> <li>Reel Spool Material: Aluminum</li> <li>Spare Spool Material: No Spare Spool</li> </ul> <p> </p> <ul> <li>6:</li> <li>Gear Ratio: 3.5:1</li> <li>Max Drag: 8 lb (3.6 kg)</li> <li>Mono Capacity (m/mm): 90/0.23</li> <li>Mono Capacity (yd-lb): 90/6</li> <li>Pre-Spooled (yd/lb): 6 lb (2.7 kg)</li> <li>Recovery Rate: 14.6" (37 cm)</li> <li>Reel Size: 6</li> <li>Weight: 10.1 oz</li> </ul> <p> </p> <ul> <li>10:</li> <li>Gear Ratio: 3.8:1</li> <li>Max Drag: 10.2 lb</li> <li>Mono Capacity (m/mm): 100/0.30</li> <li>Mono Capacity (yd-lb): 85/10</li> <li>Pre-Spooled (yd/lb): 10 lb (4.5 kg)</li> <li>Recovery Rate: 20.9" (53 cm)</li> <li>Reel Size: 10</li> <li>Weight: 12.6 oz</li> </ul> <p> </p> <ul> <li>20:</li> <li>Gear Ratio: 3.2:1</li> <li>Max Drag: 14 lb (6.4 kg)</li> <li>Mono Capacity (m/mm): 130/0.40</li> <li>Mono Capacity (yd-lb): 115/20</li> <li>Pre-Spooled (yd/lb): 20 lb (9 kg)</li> <li>Recovery Rate: 20.3" (52 cm)</li> <li>Reel Size: 20</li> <li>Weight: 21 oz</li> </ul>	[empty string]	N	24.99	29.99	[empty string]	96146-DEFAULT-s.jpg	[empty string]	1000	USTUFFSC	340953	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	shakespeare/ugly-tuff-spincast-340953	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts477 ORDER BY sortposition asc

Fishing

Sort By:

Items per page:

Filter