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]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	0	0	229.99	[empty string]	0	[empty string]	RAVEN MATRIX 4 3/8 CENTER PIN	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]	3	200-to-250	0.00	[empty string]	Matrix	<p>The Raven Matrix is designed with function in mind, it features a solid spool and backplate that prevent debris from entering the reel, and an ergonomic low-profile reel foot and backplate. Features an adjustable “coin slot” tension screw to make on-the-river adjustments a breeze.</p>	[empty string]	N	229.99	229.99	[empty string]	[empty string]	[empty string]	1000	MXRMTI	2071	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/raven-matrix-4-3-8-center-pin-2071	1
2	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	0	0	39.99	5206-DEFAULT-l.jpg	0	5206-DEFAULT-m.jpg	SIERRA FLY REEL 4/5	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]	4	25-to-50	0.00	[empty string]	Sierra Fly Reel - 4/5	<p>Okuma Sierra fly reels represent the ultimate value in a simple and reliable fly reel, the alumalite frame, one-way roller bearing and stainless steel drag system puts a smile on your face every trip out.</p>	[empty string]	N	39.99	39.99	[empty string]	5206-DEFAULT-s.jpg	[empty string]	1000	S4/5	52181	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/sierra-fly-reel-4-5-52181	1
3	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	0	0	44.99	5218-DEFAULT-l.jpg	0	5218-DEFAULT-m.jpg	SIERRA FLY REEL 7/8	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	25-to-50	0.00	[empty string]	Sierra Fly Reel - 7/8	The Sierra Fly Reel represents the ultimate value in a simple and reliable fly reel. Sierra`s Alumalite frame, one-way roller bearing and stainless steel drag system puts a smile on your face every trip out.<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	44.99	44.99	[empty string]	5218-DEFAULT-s.jpg	[empty string]	1000	S7/8	52184	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/sierra-fly-reel-7-8-52184	1
4	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	0	0	22.99	[empty string]	0	[empty string]	SIERRA FLY SPOOL 7/8	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	20-to-25	0.00	[empty string]	Sierra 7/8 Spool	The fly reel that started it all for Okuma more than a decade ago has only grown better with age. Representing the ultimate value in a simple and reliable fly reel, Sierra`s Alumalite frame, one-way roller bearing and Teflon/stainless steel drag system puts a smile on your face every trip out. Sierra`s affordability allows for a complete selection of line types to be carried and deployed at a moment`s notice.<br/> <br/>	[empty string]	N	22.99	22.99	[empty string]	[empty string]	[empty string]	1000	S7/8-SPOOL	52185	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/sierra-fly-spool-7-8-52185	1
5	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	0	0	44.99	[empty string]	0	[empty string]	SIERRA FLY REEL 8/9	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]	6	25-to-50	0.00	[empty string]	Sierra Fly Reel - 8/9	The Sierra Fly Reel represents the ultimate value in a simple and reliable fly reel. Sierra`s Alumalite frame, one-way roller bearing and stainless steel drag system puts a smile on your face every trip out.<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	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	S8/9	52186	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/sierra-fly-reel-8-9-52186	1
6	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	0	0	59.99	[empty string]	0	[empty string]	SLV FLY REEL 2/3	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]	7	50-to-100	0.00	[empty string]	Slv Fly Reel - 2/3	With super large arbor spool design for blazing fast line retrieval, SLV reels keep pace with the fastest species in water. They do it with a total commitment to advancing the quality of your fishing experience.<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	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	SLV23	52190	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/slv-fly-reel-2-3-52190	1
7	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	0	0	59.99	[empty string]	0	[empty string]	SLV FLY REEL 4/5	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]	6	50-to-100	0.00	[empty string]	Slv Fly Reel - 4/5	With super large arbor spool design for blazing fast line retrieval, SLV reels keep pace with the fastest species in water. They do it with a total commitment to advancing the quality of your fishing experience.<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	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	SLV45	52191	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/slv-fly-reel-4-5-52191	1
8	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	0	0	59.99	55967-DEFAULT-l.jpg	0	55967-DEFAULT-m.jpg	SLV FLY REEL 5/6	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]	4	50-to-100	0.00	[empty string]	Slv Fly Reel - 5/6	<p>Okuma SLV fly reels keep pace with the fast species in water with super large arbor spool design for blazing fast line retrieval. The reels feature die cast aluminum frame, precision machined stainless steel spool shaft, one-way roller bearing and multi-disc cork and stainless steel drag system.</p>	[empty string]	N	59.99	59.99	[empty string]	55967-DEFAULT-s.jpg	[empty string]	1000	SLV56	52192	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/slv-fly-reel-5-6-52192	1
9	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	0	0	59.99	5215-DEFAULT-l.jpg	0	5215-DEFAULT-m.jpg	SLV FLY REEL 7/8	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	50-to-100	0.00	[empty string]	Slv Fly Reel - 7/8	<p>Okuma SLV fly reels keep pace with the fast species in water with super large arbor spool design for blazing fast line retrieval. The reels feature die cast aluminum frame, precision machined stainless steel spool shaft, one-way roller bearing and multi-disc cork and stainless steel drag system.</p>	[empty string]	N	59.99	59.99	[empty string]	5215-DEFAULT-s.jpg	[empty string]	1000	SLV78	52193	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/slv-fly-reel-7-8-52193	1
10	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	0	0	59.99	55968-DEFAULT-l.jpg	0	55968-DEFAULT-m.jpg	SLV FLY REEL 8/9	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	50-to-100	0.00	[empty string]	Slv Fly Reel - 8/9	<p>Okuma SLV fly reels keep pace with the fast species in water with super large arbor spool design for blazing fast line retrieval. The reels feature die cast aluminum frame, precision machined stainless steel spool shaft, one-way roller bearing and multi-disc cork and stainless steel drag system.</p>	[empty string]	N	59.99	59.99	[empty string]	55968-DEFAULT-s.jpg	[empty string]	1000	SLV89	52194	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/slv-fly-reel-8-9-52194	1
11	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Fly	[empty string]	1	0	0	11.49	48313-DEFAULT-l.jpg	0	48313-DEFAULT-m.jpg	ZEB MARTIN CADDIS CR. 5/6 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]	9	10-to-15	0.00	[empty string]	Martin Caddis Creek Reel - Fly - 5/6	<p>The Martin Caddis Creek Reel is perfect for beginning fly anglers (or the budget-conscious). It features a reinforced aluminum spool, metal clicker with on/off control and an easy push-button spool release.</p>	[empty string]	N	11.49	11.49	[empty string]	48313-DEFAULT-s.jpg	[empty string]	1000	CC61	81138	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/zeb-martin-caddis-cr-5-6-reel-81138	1
12	[empty string]	ZEBCO	ZEBCO	FISHING	Fishing>Reels>Fly	[empty string]	1	0	0	11.49	48314-DEFAULT-l.jpg	0	48314-DEFAULT-m.jpg	ZEB MARTIN CADDIS CR. 7/8 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]	23	10-to-15	0.00	[empty string]	Martin Caddis Creek Reel - Fly - 7/8	<p>The Martin Caddis Creek Reel is perfect for beginning fly anglers (or the budget-conscious). Featuring a reinforced aluminum spool, metal clicker with on/off control and an easy push-button spool release.</p>	[empty string]	N	11.49	11.49	[empty string]	48314-DEFAULT-s.jpg	[empty string]	1000	CC65	81139	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	zebco/zeb-martin-caddis-cr-7-8-reel-81139	1
13	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	66.95	0	66.99	[empty string]	66.95	[empty string]	OKUMA INTEGRITY FLY REEL8/9	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	50-to-100	0.00	[empty string]	Integrity - 8/9	Okuma integrity fly reels make large arbor performance available to all interested fly anglers. Featuring a patented oversized stainless steel-based disc drag housed in a die-cast aluminum frame, Integrity models begin with a 5/6 and continue to a powerful 10/11 with a focus on big fish applications. The one-way roller bearing operates on a precision machined stainless steel spool shaft, complimenting Integrity`s fierce structural integrity.<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	66.99	66.99	[empty string]	[empty string]	[empty string]	1000	I-8/9B	84790	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/okuma-integrity-fly-reel8-9-84790	1
14	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	SLV 10/11 FLY 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]	2	50-to-100	0.00	[empty string]	Slv Fly Reel - 10/11	<p>Okuma SLV fly reels keep pace with the fast species in water with super large arbor spool design for blazing fast line retrieval. The reels feature die cast aluminum frame, precision machined stainless steel spool shaft, one-way roller bearing and multi-disc cork and stainless steel drag system.</p>	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	SLV-1011	126957	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/slv-10-11-fly-reel-126957	1
15	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	94.99	0	94.99	[empty string]	94.99	[empty string]	HELIOS 7/8 SPOOL	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	50-to-100	0.00	[empty string]	Helios 7/8 Spool	[empty string]	[empty string]	N	94.99	94.99	[empty string]	[empty string]	[empty string]	1000	H 78 SPOOL	148052	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/helios-7-8-spool-148052	1
16	[empty string]	EAGLE CLAW	Eagle Claw	FISHING	Fishing>Reels>Fly	[empty string]	0	22.99	0	24.99	[empty string]	22.99	[empty string]	IN LINE ICE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	ICE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	Inline Reel - Fly	FEATURES:<br/> -Nylon Body<br/> -Smooth Teflon drag<br/> -Spool tension adjustment<br/> -Free spool release button<br/> -Line retrieve inches per crank - 15.75``<br/> -Reduced line twist<br/> -Star drag<br/> -Line clicker<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	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	ECILIR	161984	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	eagle-claw/in-line-ice-reel-161984	1
17	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	174.99	0	174.99	[empty string]	174.99	[empty string]	RAW II CENTERPIN 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	150-to-200	0.00	[empty string]	Rawii Float Reel	<p>Okuma Raw II float reels feature precision 6061-T6 machined aluminum frame and spool, durable Type-II, two-tone anodized frame and spool.</p>	[empty string]	N	174.99	174.99	[empty string]	[empty string]	[empty string]	1000	RAW-1002	162969	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/raw-ii-centerpin-reel-162969	1
18	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	269.99	0	299.99	[empty string]	269.99	[empty string]	4.75 MATRIX FULLY PORTED TITANIUM 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]	4	250-to-300	0.00	[empty string]	Matrix Xl - 4 3/4 Inch	<p>This reel has a sleekand ergonomic design. The Raven Matrix XL offers quicker line retrieve and balances perfectly with long rods – the ultimate complement for the Raven 15′ IM8 rod. Features an adjustable “coin slot” tension screw to make on-the-river adjustments a breeze.</p>	[empty string]	N	299.99	299.99	[empty string]	[empty string]	[empty string]	1000	MXRFPT	175280	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/4-75-matrix-fully-ported-titanium-reel-175280	1
19	[empty string]	ROSS REELS	Ross Reels	FISHING	Fishing>Reels>Fly	[empty string]	0	110	0	110	[empty string]	110	[empty string]	CLA SPOOL SZ.2 BLACK	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	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Cla Spool Sz.2 Black	[empty string]	[empty string]	N	110	110	[empty string]	[empty string]	[empty string]	1000	002889	180206	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	ross-reels/cla-spool-sz-2-black-180206	1
20	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	BEHEMOTH FLY REEL GUNMETAL 5/6 WT.	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]	1	100-to-150	0.00	[empty string]	Behemoth Fly Reel Gunmetal 5/6 Wt.	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	5-5506R56G	258039	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/behemoth-fly-reel-gunmetal-5-6-wt-258039	1
21	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	BEHEMOTH FLY REEL GUNMETAL 7/8 WT.	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]	5	100-to-150	0.00	[empty string]	Behemoth - Fly Reels - Gunmetal - 7/8 Weight	<p>The Behemoth reel combines the most powerful drag in its class with stunning aesthetics that push the limits of fly reel design. The unique, un-machinable, die-cast construction is coupled with a durable, interlocking, large-arbor spool design that both looks and functions like a premium reel. A super-heavy duty carbon fiber drag package brings the utmost in drag strength, reliability and performance to the family. Sized for your favorite 5-weight trout rod, and all the way up to saltwater ready, big-game sizes, the Behemoth reels offer performance and affordability to beginner and veteran anglers alike.</p>	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	5-5506R78G	258040	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/behemoth-fly-reel-gunmetal-7-8-wt-258040	1
22	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	ZERO REEL BLACK 2/3	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]	3	50-to-100	0.00	[empty string]	Zero - Black - 2.7 Reel Weight - 2/3	<p>Redington's ZERO reel utilizes die-cast construction to create an incredibly lightweight design not achievable with CNC machining processes. An all-new, durable clicker drag system compliments the design to make for the ultimate in lightweight trout reels.</p>	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	5-5507R23B	258042	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/zero-reel-black-2-3-258042	1
23	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	ZERO REEL BLACK 4/5	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]	3	50-to-100	0.00	[empty string]	Zero - Black - 2.7 Reel Weight - 4/5	<p>Redington`s ZERO reel utilizes die-cast construction to create an incredibly lightweight design not achievable with CNC machining processes. An all-new, durable clicker drag system compliments the design to make for the ultimate in lightweight trout reels.</p>	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	5-5507R45B	258043	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/zero-reel-black-4-5-258043	1
24	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	299.99	0	349.99	[empty string]	299.99	[empty string]	MATRIX XL FULLY PORTED 5 1/8 TITANIUM	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]	2	300-to-350	0.00	[empty string]	Matrix Xl - 5 1/8 Inch	<p>This reel has a sleekand ergonomic design. The Raven Matrix XL offers quicker line retrieve and balances perfectly with long rods – the ultimate complement for the Raven 15′ IM8 rod. Features an adjustable “coin slot” tension screw to make on-the-river adjustments a breeze.</p>	[empty string]	N	349.99	349.99	[empty string]	[empty string]	[empty string]	1000	MXRXFP	267458	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/matrix-xl-fully-ported-5-1-8-titanium-267458	1
25	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	RAVEN NEOPRENE REEL CASE BLACK XL	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]	13	15-to-20	0.00	[empty string]	Raven Neoprene Reel Case Black Xl	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	RVRCAS-XL	268071	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/raven-neoprene-reel-case-black-xl-268071	1
26	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	RISE REEL SILVER 5/6	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]	3	150-to-200	0.00	[empty string]	Rise - Silver - Fly Reel - 5/6	<p>The RISE continues Redington's ongoing quest to think beyond the bounds of traditional reel designs. It features a u-shaped large-arbor and a compact carbon fiber drag system that offers smooth fish stopping torque. Lightweight design shows through in the modern aesthetic of the RISE, and thoughtful details like twin molded soft-touch handles and oversized drag knob help the reel perform in the hands of any angler.</p>	[empty string]	N	199.99	199.99	[empty string]	[empty string]	[empty string]	1000	5-5508R5602	273342	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/rise-reel-silver-5-6-273342	1
27	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	RISE REEL BLACK 7/8	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]	2	200-to-250	0.00	[empty string]	Rise - Black - Fly Reel - 7/8	<p>The RISE continues Redington's ongoing quest to think beyond the bounds of traditional reel designs. It features a u-shaped large-arbor and a compact carbon fiber drag system that offers smooth fish stopping torque. Lightweight design shows through in the modern aesthetic of the RISE, and thoughtful details like twin molded soft-touch handles and oversized drag knob help the reel perform in the hands of any angler.</p>	[empty string]	N	209.99	209.99	[empty string]	[empty string]	[empty string]	1000	5-5508R7801	273343	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/rise-reel-black-7-8-273343	1
28	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	209.99	0	209.99	[empty string]	209.99	[empty string]	RISE REEL SILVER 7/8	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]	4	200-to-250	0.00	[empty string]	Rise - Silver - Fly Reel - 7/8	<p>The RISE continues Redington's ongoing quest to think beyond the bounds of traditional reel designs. It features a u-shaped large-arbor and a compact carbon fiber drag system that offers smooth fish stopping torque. Lightweight design shows through in the modern aesthetic of the RISE, and thoughtful details like twin molded soft-touch handles and oversized drag knob help the reel perform in the hands of any angler.</p>	[empty string]	N	209.99	209.99	[empty string]	[empty string]	[empty string]	1000	5-5508R7802	273344	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/rise-reel-silver-7-8-273344	1
29	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	0	249	0	249	[empty string]	249	[empty string]	SPECTRUM FLY REEL 3/4 LIME	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]	2	200-to-250	0.00	[empty string]	Spectrum - Fly Reel - Lime - 3/4	<p>Modeled after the popular 4200 series, the fully machined SPECTRUM is a true large arbor performance fly reel. With concave spool surface, for optimal line capacity and drag-assisting smoothness, the SPECTRUM is lightweight, extremely durable, and packed with features you’d expect on higher priced reels.</p>	[empty string]	N	249	249	[empty string]	[empty string]	[empty string]	1000	324-3200R3403	292444	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-fly-reel-3-4-lime-292444	1
30	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	0	299	0	299	[empty string]	299	[empty string]	SPECTRUM FLY REEL 7/8 LIME	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	ONLINE	[empty string]	[empty string]	3	250-to-300	0.00	[empty string]	Spectrum - Fly Reel - Lime - 7/8	<p>Modeled after the popular 4200 series, the fully machined SPECTRUM is a true large arbor performance fly reel. With concave spool surface, for optimal line capacity and drag-assisting smoothness, the SPECTRUM is lightweight, extremely durable, and packed with features you’d expect on higher priced reels.</p>	[empty string]	N	299	299	[empty string]	[empty string]	[empty string]	1000	324-3200R7803	292448	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-fly-reel-7-8-lime-292448	1
31	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	0	299	0	299	[empty string]	299	[empty string]	SPECTRUM FLY REEL 7/8 BLACK	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]	5	250-to-300	0.00	[empty string]	Spectrum Fly Reel 7/8 Black	[empty string]	[empty string]	N	299	299	[empty string]	[empty string]	[empty string]	1000	324-3200R7805	292449	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-fly-reel-7-8-black-292449	1
32	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	0	299	0	299	[empty string]	299	[empty string]	SPECTRUM FLY REEL 9/10 BLACK	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]	5	250-to-300	0.00	[empty string]	Spectrum - Fly Reel - Black - 9/10	<p>Modeled after the popular 4200 series, the fully machined SPECTRUM is a true large arbor performance fly reel. With concave spool surface, for optimal line capacity and drag-assisting smoothness, the SPECTRUM is lightweight, extremely durable, and packed with features you’d expect on higher priced reels.</p>	[empty string]	N	299	299	[empty string]	[empty string]	[empty string]	1000	324-3200R91005	292451	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-fly-reel-9-10-black-292451	1
33	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	CROSSWATER 4/5/6 REEL BLACK PRESPOOLED	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]	4	50-to-100	0.00	[empty string]	Crosswater 4/5/6 Reel Black Prespooled	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	5-5511R45601PS	292491	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/crosswater-4-5-6-reel-black-prespooled-292491	1
34	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	CROSSWATER 7/8/9 REEL BLACK PRESPOOLED	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	50-to-100	0.00	[empty string]	Crosswater 7/8/9 Reel Black Prespooled	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	5-5511R78901PS	292492	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/crosswater-7-8-9-reel-black-prespooled-292492	1
35	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	BEHEMOTH REEL 5/6 DESERT	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]	1	100-to-150	0.00	[empty string]	Behemoth Reel 5/6 Desert	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	5-5506R56D	292493	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/behemoth-reel-5-6-desert-292493	1
36	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	BEHEMOTH REEL 7/8 DESERT	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]	4	100-to-150	0.00	[empty string]	Behemoth Reel 7/8 Desert	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	5-5506R78D	292494	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/behemoth-reel-7-8-desert-292494	1
37	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	139.99	0	139.99	[empty string]	139.99	[empty string]	BEHEMOTH REEL 9/10 DESERT	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	100-to-150	0.00	[empty string]	Behemoth - Fly Reel - Desert - 9/10 Weight	<p>The Behemoth reel combines the most powerful drag in its class with stunning aesthetics that push the limits of fly reel design. The unique, un-machinable, die-cast construction is coupled with a durable, interlocking, large-arbor spool design that both looks and functions like a premium reel. A super-heavy duty carbon fiber drag package brings the utmost in drag strength, reliability and performance to the family. Sized for your favorite 5-weight trout rod, and all the way up to saltwater ready, big-game sizes, the Behemoth reels offer performance and affordability to beginner and veteran anglers alike.</p>	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	5-5506R910D	292495	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/behemoth-reel-9-10-desert-292495	1
38	[empty string]	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	[empty string]	0	89.99	0	89.99	[empty string]	89.99	[empty string]	I.D REEL BLACK 5/6	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]	1	50-to-100	0.00	[empty string]	I.d - Fly Reel - Black - 5/6	<p>The I.D fly reel allows you to express your unique style while out on the water. It features a flat back surface that accepts custom decals representing anything from your home state to your favorite fish species, and the decals are simple to remove, stack, or swap to update your reel’s look over time. There is no better product to define your identity as an angler. The I.D features sturdy cast aluminum construction, a smooth rulon disc drag, and a large arbor for speedy line retrieve. Stand out from the crowds and mix it up with the i.D reel.</p>	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	5-5510R56	292497	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/i-d-reel-black-5-6-292497	1
39	BLK	SAGE	Sage	FISHING	Fishing>Reels>Fly	BLK\|NULL\|NULL	0	150	0	150	[empty string]	150	[empty string]	SPECTRUM FLY 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	[empty string]	[empty string]	[empty string]	10	100-to-150	0.00	[empty string]	Spectrum Fly Reel	[empty string]	[empty string]	N	150	150	7/8,5/6,9/10	[empty string]	[empty string]	1000	SPECTRUM C	307390	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-fly-reel-307390	1
40	BLK,CHAMP	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	BLK\|NULL\|NULL,CHAMP\|NULL\|NULL	0	299.99	0	299.99	[empty string]	299.99	[empty string]	GRANDE FLY 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	250-to-300	0.00	[empty string]	Grande - Fly Reel - 7/8/9	<p>The heavyweight champion of big game fly reels. The Grande reel is a fully anodized, machined aluminum reel that features Redington`s new sealed SUPER-TORQUE carbon drag system that will KO any fish you hook. After years of field testing, we bulked up the GRANDE with an over-sized palming rim, increased backing capacity, and designed an easy to locate handle and drag knob so you can make quick adjustments in the heat of the battle. Never stand down from a fight, regardless of the opponent.</p>	[empty string]	N	299.99	299.99	7/8/9	[empty string]	[empty string]	1000	GRANDE FLY REEL	307392	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/grande-fly-reel-307392	1
41	ODGRN,HUNTORG	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	ODGRN\|NULL\|NULL,HUNTORG\|NULL\|NULL	0	139.99	1	119.99	[empty string]	139.99	[empty string]	BEHEMOTH FLY 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]	10	100-to-150	0.00	[empty string]	Behemoth Fly Reel	[empty string]	[empty string]	N	119.99	139.99	9/10,7/8	[empty string]	[empty string]	1000	BEHEMOTH	307393	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/behemoth-fly-reel-307393	1
42	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	49.99	0	49.99	89210-DEFAULT-l.jpg	49.99	89210-DEFAULT-m.jpg	SIERRA-X FLY 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	[empty string]	[empty string]	[empty string]	38	25-to-50	0.00	[empty string]	Sierra-x Fly Reel	[empty string]	[empty string]	N	49.99	49.99	5/6,4/5,7/8,3/4	89210-DEFAULT-s.jpg	[empty string]	1000	SX	308690	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/sierra-x-fly-reel-308690	1
43	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	429.99	0	429.99	[empty string]	429.99	[empty string]	RAVEN T-5 CENTERPIN FLOAT 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]	3	400-to-450	0.00	[empty string]	Raven T-5 Centerpin Float Reel	[empty string]	[empty string]	N	429.99	429.99	[empty string]	[empty string]	[empty string]	1000	RVRT50	309245	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/raven-t-5-centerpin-float-reel-309245	1
44	BLACK	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	BLACK\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	CROSSWATER 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]	4	25-to-50	0.00	[empty string]	Crosswater Reel	[empty string]	[empty string]	N	49.99	49.99	789,456	[empty string]	[empty string]	1000	5-5511R	317388	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/crosswater-reel-317388	1
45	[empty string]	TEMPLE FORK OUTFITTS	Temple Fork Outfitts	FISHING	Fishing>Reels>Fly	[empty string]	0	105	0	105	[empty string]	105	[empty string]	BVK 2 SUPER LARGE ARBOR REEL M SPARE SPOOL	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]	SO	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Bvk 2 Super Large Arbor Reel M Spare Spool	[empty string]	[empty string]	N	105	105	[empty string]	[empty string]	[empty string]	1000	TFR BVK 2M SS	326204	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	temple-fork-outfitts/bvk-2-super-large-arbor-reel-m-spare-spool-326204	1
46	SB,PB	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	SB\|NULL\|NULL,PB\|NULL\|NULL	0	229.99	0	229.99	[empty string]	229.99	[empty string]	HELIX XL CENTERPIN 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	[empty string]	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	Helix Xl Centerpin Reel	[empty string]	[empty string]	N	229.99	229.99	5IN	[empty string]	[empty string]	1000	HXCXL	326824	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/helix-xl-centerpin-reel-326824	1
47	[empty string]	TEMPLE FORK OUTFITTS	Temple Fork Outfitts	FISHING	Fishing>Reels>Fly	[empty string]	0	99.99	1	79.99	[empty string]	99.99	[empty string]	NXT BLACK LABEL FLY REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	F	[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]	19	50-to-100	0.00	[empty string]	Nxt Black Label Fly Reel	[empty string]	[empty string]	N	79.99	99.99	2,3,1	[empty string]	[empty string]	1000	TFR NXT BLK	327042	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	temple-fork-outfitts/nxt-black-label-fly-reel-327042	1
48	JET	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	JET\|NULL\|NULL	0	389.99	0	389.99	[empty string]	389.99	[empty string]	5 1/8` MATRIX XL FULLY PORTED LIMITED EDITION	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]	3	350-to-400	0.00	[empty string]	5 1/8` Matrix Xl Fully Ported Limited Edition	[empty string]	[empty string]	N	389.99	389.99	[empty string]	[empty string]	[empty string]	1000	MXRXFL	330581	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/5-1-8-matrix-xl-fully-ported-limited-edition-330581	1
49	BURGUNDY,BLACK	REDINGTON	Redington	FISHING	Fishing>Reels>Fly	BURGUNDY\|NULL\|NULL,BLACK\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	RUN FLY 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	[empty string]	[empty string]	[empty string]	7	100-to-150	0.00	[empty string]	Run Fly Reel	[empty string]	[empty string]	N	109.99	109.99	5/6,3/4	[empty string]	[empty string]	1000	RUN FLY REEL	337661	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	redington/run-fly-reel-337661	1
50	8/10,4/5,6/7	ECHO	Echo	FISHING	Fishing>Reels>Fly	8/10\|NULL\|NULL,4/5\|NULL\|NULL,6/7\|NULL\|NULL	0	119.99	0	119.99	[empty string]	119.99	[empty string]	BRAVO LT FLY FISHING 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	[empty string]	[empty string]	[empty string]	19	100-to-150	0.00	[empty string]	Bravo Lt Fly Fishing Reel	[empty string]	[empty string]	N	119.99	119.99	BR-LT	[empty string]	[empty string]	1000	BRAVOLT	355429	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	echo/bravo-lt-fly-fishing-reel-355429	1
51	7/9,8/10	ECHO	Echo	FISHING	Fishing>Reels>Fly	7/9\|NULL\|NULL,8/10\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	BRAVO FLY FISHING 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	[empty string]	[empty string]	[empty string]	12	100-to-150	0.00	[empty string]	Bravo Fly Fishing Reel	[empty string]	[empty string]	N	139.99	139.99	BRAVO	[empty string]	[empty string]	1000	BRAVO	355430	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	echo/bravo-fly-fishing-reel-355430	1
52	7/9,6/7,4/5,8/10	ECHO	Echo	FISHING	Fishing>Reels>Fly	7/9\|NULL\|NULL,6/7\|NULL\|NULL,4/5\|NULL\|NULL,8/10\|NULL\|NULL	0	99.99	1	79.99	[empty string]	99.99	[empty string]	ION FLY FISHING 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	[empty string]	[empty string]	[empty string]	24	50-to-100	0.00	[empty string]	Ion Fly Fishing Reel	[empty string]	[empty string]	N	79.99	99.99	ION	[empty string]	[empty string]	1000	ION	355431	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	echo/ion-fly-fishing-reel-355431	1
53	[empty string]	OKUMA FISHING	Okuma Fishing	FISHING	Fishing>Reels>Fly	[empty string]	0	66.99	0	66.99	[empty string]	66.99	[empty string]	OKUM SLV 8/9WT. FLY 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	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Okum Slv 8/9wt. Fly Reel	[empty string]	[empty string]	N	66.99	66.99	[empty string]	[empty string]	[empty string]	1000	SLV89B	355895	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	okuma-fishing/okum-slv-8-9wt-fly-reel-355895	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts476 ORDER BY sortposition asc

Fishing

Sort By:

Items per page:

3 2 1

Filter

3 2 1

Filter By

Price

Brand

Size

Matrix

Sierra Fly Reel - 4/5

Sierra Fly Reel - 7/8

Sierra 7/8 Spool

Sierra Fly Reel - 8/9

Slv Fly Reel - 2/3

Slv Fly Reel - 4/5

Slv Fly Reel - 5/6

Slv Fly Reel - 7/8

Slv Fly Reel - 8/9

Martin Caddis Creek Reel - Fly - 5/6

Martin Caddis Creek Reel - Fly - 7/8

Integrity - 8/9

Slv Fly Reel - 10/11

Helios 7/8 Spool

Inline Reel - Fly

Rawii Float Reel

Matrix Xl - 4 3/4 Inch

Cla Spool Sz.2 Black

Behemoth Fly Reel Gunmetal 5/6 Wt.

Behemoth - Fly Reels - Gunmetal - 7/8 Weight

Zero - Black - 2.7 Reel Weight - 2/3

Zero - Black - 2.7 Reel Weight - 4/5

Matrix Xl - 5 1/8 Inch