Jay's Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	229.99	0	229.99	96109-DEFAULT-l.jpg	229.99	96109-DEFAULT-m.jpg	RAVEN MATRIX 4 3/8IN CENTER P	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	200-to-250	0.00	[empty string]	MATRIX - CENTERPIN FLOAT REEL	<p>The Raven Matrix is unquestionably the best value in centerpin reels. 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> <p> </p> <ul> <li>Aircraft grade aluminum</li> <li>Integral low-profile reel foot</li> <li>Coin slot adjustable tension screw</li> <li>High strength stainless steel spindle</li> <li>Twin shielded ball bearings</li> <li>On/Off ratchet</li> </ul> <p> </p> <ul> <li>Color: Polished Bronze</li> <li>Diameter: 4 3/8″</li> <li>Weight: 8.2 oz</li> </ul>	[empty string]	N	229.99	229.99	[empty string]	96109-DEFAULT-s.jpg	[empty string]	1000	MXRMBR	2070	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/matrix-centerpin-float-reel-2070	1
2	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Rods>Spinning	[empty string]	1	199.99	0	199.99	95593-DEFAULT-l.jpg	199.99	95593-DEFAULT-m.jpg	RAVEN 116 IM6 S/R FLOAT ROD	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]	14	150-to-200	0.00	[empty string]	RAVEN IM6 - FLOAT - SLIDING RINGS - 11 FEET 6 INCHES - 2 PIECES	<p>RAVEN IM6 float rods have defined tradition float rod action for over a decade. They provide smooth action that cushions light leaders yet have plenty of reserve power when needed. The 11'6" Steelheader is ideal for both bottom bouncing and short to mid range float fishing, with loads of power to handle tough situations. This blank is also tied as a Spiral Wrap Baitcaster.</p> <p> </p> <ul> <li>Length: 11' 6"</li> <li>Lure Weight: 1/8-1/2 oz</li> <li>Line Rating: 6-12 lbs</li> <li>Action: Medium Light</li> <li>Pieces: 2</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	95593-DEFAULT-s.jpg	[empty string]	1000	RV116-IM6SR	2072	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	raven-fishing/raven-im6-float-sliding-rings-11-feet-6-inches-2-pieces-2072	1
3	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Rods>Spinning	[empty string]	1	249.99	0	249.99	95595-DEFAULT-l.jpg	249.99	95595-DEFAULT-m.jpg	RAVEN 136 IM6 S/R FLOAT ROD	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[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]	5	200-to-250	0.00	[empty string]	RAVEN IM6 - FLOAT - SLIDING RINGS - 13 FEET 6 INCHES - 3 PIECES	<p>RAVEN IM6 float rods have defined tradition float rod action for over a decade. They provide smooth action that cushions light leaders yet have plenty of reserve power when needed. The 11'6" Steelheader is ideal for both bottom bouncing and short to mid range float fishing, with loads of power to handle tough situations. This blank is also tied as a Spiral Wrap Baitcaster.</p> <p> </p> <ul> <li>Length: 13' 6"</li> <li>Lure Weight: 1/8-3/8 oz</li> <li>Line Rating: 4-8 lbs</li> <li>Action: Light</li> <li>Pieces: 3</li> </ul>	[empty string]	N	249.99	249.99	[empty string]	95595-DEFAULT-s.jpg	[empty string]	1000	RV136-IM6SR	2073	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	raven-fishing/raven-im6-float-sliding-rings-13-feet-6-inches-3-pieces-2073	1
4	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Rods>Spinning	[empty string]	1	239.99	0	239.99	95594-DEFAULT-l.jpg	239.99	95594-DEFAULT-m.jpg	RAVEN IM6 11FT6 W/REEL SEAT	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	200-to-250	0.00	[empty string]	RAVEN IM6 - CUSTOM - ROSEWOOD REEL SEAT - 11 FEET 6 INCHES - 2 PIECES	<p>RAVEN IM6 float rods have defined tradition float rod action for over a decade. They provide smooth action that cushions light leaders yet have plenty of reserve power when needed. The 11'6" Steelheader is ideal for both bottom bouncing and short to mid range float fishing, with loads of power to handle tough situations. This blank is also tied as a Spiral Wrap Baitcaster.</p> <p> </p> <ul> <li>Length: 11' 6"</li> <li>Lure Weight: 1/8-1/2 oz</li> <li>Line Rating: 6-12 lbs</li> <li>Action: Medium Light</li> <li>Pieces: 2</li> </ul>	[empty string]	N	239.99	239.99	[empty string]	95594-DEFAULT-s.jpg	[empty string]	1000	RV116-IM6RW	116429	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	raven-fishing/raven-im6-custom-rosewood-reel-seat-11-feet-6-inches-2-pieces-116429	1
5	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Swivels and Snaps	[empty string]	0	3.49	0	3.49	[empty string]	3.49	[empty string]	RAVEN 3-WAY SNAP SWIVEL	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]	44	5-AND-under	0.00	[empty string]	Raven 3-way Snap Swivel	[empty string]	[empty string]	N	3.49	3.49	[empty string]	[empty string]	[empty string]	1000	RV3WSS	141606	SWIVELS AND SNAPS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-3-way-snap-swivel-141606	1
6	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	RAVEN FLOAT FISHING GUIDE	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]	22	5-to-10	0.00	[empty string]	Float Fishing Guide	<p>The complete guide to float fishing rivers and streams. Features lots of step-by-step instructions and easy to follow diagrams. Great for both beginners and experienced anglers!</p>	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	RVBOOK	145255	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	raven-fishing/raven-float-fishing-guide-145255	1
7	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Hooks	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	RAVEN SPEC. HOOK BLACK SZ. 8 100 PK.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	10-to-15	0.00	[empty string]	Raven Spec. Hook Black Sz. 8 100 Pk.	[empty string]	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	RVSP08-1000	157825	HOOKS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-spec-hook-black-sz-8-100-pk-157825	1
8	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Hooks	[empty string]	0	15.99	0	15.99	[empty string]	15.99	[empty string]	RAVEN SPEC. HOOK BLACK SZ.6 100 PK.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	50	15-to-20	0.00	[empty string]	Raven Spec. Hook Black Sz.6 100 Pk.	[empty string]	[empty string]	N	15.99	15.99	[empty string]	[empty string]	[empty string]	1000	RVSP06-1000	157829	HOOKS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-spec-hook-black-sz-6-100-pk-157829	1
9	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Hooks	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	RAVEN SPEC. HOOK BLACK SZ.10 100 PK.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	19	10-to-15	0.00	[empty string]	Raven Spec. Hook Black Sz.10 100 Pk.	[empty string]	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	RVSP10-1000	157831	HOOKS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-spec-hook-black-sz-10-100-pk-157831	1
10	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Hooks	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	RAVEN SPEC. HOOK BLACK SZ.4 100 PK.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	45	15-to-20	0.00	[empty string]	Raven Spec. Hook Black Sz.4 100 Pk.	[empty string]	[empty string]	N	16.99	16.99	[empty string]	[empty string]	[empty string]	1000	RVSP04-1000	267232	HOOKS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-spec-hook-black-sz-4-100-pk-267232	1
11	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Weights and Sinkers	[empty string]	0	2.29	0	2.29	[empty string]	2.29	[empty string]	SURE SHOT SPLIT SHOT AAA 23 G.	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]	46	5-AND-under	0.00	[empty string]	Sure Shot Split Shot Aaa 23 G.	[empty string]	[empty string]	N	2.29	2.29	[empty string]	[empty string]	[empty string]	1000	SSAAA5	267455	WEIGHTS AND SINKERS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/sure-shot-split-shot-aaa-23-g-267455	1
12	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Weights and Sinkers	[empty string]	0	2.29	0	2.29	[empty string]	2.29	[empty string]	SURE SHOT SPLIT SHOT AB 23 G.	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]	61	5-AND-under	0.00	[empty string]	Sure Shot Split Shot Ab 23 G.	[empty string]	[empty string]	N	2.29	2.29	[empty string]	[empty string]	[empty string]	1000	SSAB45	267456	WEIGHTS AND SINKERS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/sure-shot-split-shot-ab-23-g-267456	1
13	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Weights and Sinkers	[empty string]	0	2.29	0	2.29	[empty string]	2.29	[empty string]	SURE SHOT SPLIT SHOT BB 23 G.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	48	5-AND-under	0.00	[empty string]	Sure Shot Split Shot Bb 23 G.	[empty string]	[empty string]	N	2.29	2.29	[empty string]	[empty string]	[empty string]	1000	SSBB40	267457	WEIGHTS AND SINKERS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/sure-shot-split-shot-bb-23-g-267457	1
14	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	12.99	0	12.99	96110-DEFAULT-l.jpg	12.99	96110-DEFAULT-m.jpg	RAVEN NEOPRENE REEL CASE 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	10-to-15	0.00	[empty string]	NEOPRENE REEL CASE - REGULAR	<p>Raven's custom designed neoprene reel cases fit Raven centerpin reels, both on and off the rod.</p>	[empty string]	N	12.99	12.99	[empty string]	96110-DEFAULT-s.jpg	[empty string]	1000	RVRCAS-B	268070	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/neoprene-reel-case-regular-268070	1
15	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	19.99	0	19.99	96111-DEFAULT-l.jpg	19.99	96111-DEFAULT-m.jpg	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]	17	15-to-20	0.00	[empty string]	NEOPRENE REEL CASE - X LARGE	<p>Raven's custom designed neoprene reel cases fit Raven centerpin reels, both on and off the rod. The XL reel case is ideal for 5”+ centerpins.</p>	[empty string]	N	19.99	19.99	[empty string]	96111-DEFAULT-s.jpg	[empty string]	1000	RVRCAS-XL	268071	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/neoprene-reel-case-x-large-268071	1
16	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	429.99	0	429.99	96112-DEFAULT-l.jpg	429.99	96112-DEFAULT-m.jpg	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]	T-5 - CENTERPIN FLOAT REEL	<p>The extensively ported Raven T-5 reels are designed to be the very best centrepins ever produced. Exceptionally light and amazingly solid, this reel is the ideal match for the Raven RPX and RV9 float rods.</p> <p> </p> <p>The T-series reels are the ultimate balance between strength and design. Starting from the exclusive bearing housing that is precision machined to ABEC 5 standards and features the same thermal expansion as the bearings to ensure the optimal performance from the dead of winter to the heat of the August sun. To ensure maximum dependability, the clicker system is machined directly into the backplate to eliminate extra moving parts. The high precision milling of the spool and backplate offers the massive weight reduction, maximizes structural integrity and ensures optimal ergonomics to make it fit perfectly to hand. And finally, the deep penetrating Hard Anodized finish resists scratching to protect its beauty while offering an amazingly smooth polished edge that allows for more “drag” control and reduced finger burn on screaming runs.</p> <p> </p> <ul> <li>Aircraft grade aluminum</li> <li>Exclusive High Tolerance Stainless Steel Bearing Housing</li> <li>Integral low-profile reel foot</li> <li>Adjustable tension screw</li> <li>High strength stainless steel spindle</li> <li>Twin Shielded High Precision ABEC 5 Bearings</li> <li>Low Profile Cam-Action Ratchet Button</li> <li>Fully Integrated Clicker System</li> <li>Capacity: 325 yards 10lbs Line plus Backing</li> </ul> <p> </p> <ul> <li>Color: Dark Titanium</li> <li>Finish: Ultra Smooth Scratch Resistant Hard Anodized</li> <li>Diameter: 4 3/4″</li> <li>Weight: 7.5 oz</li> </ul>	[empty string]	N	429.99	429.99	[empty string]	96112-DEFAULT-s.jpg	[empty string]	1000	RVRT50	309245	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/t-5-centerpin-float-reel-309245	1
17	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Floats, Bobbers, and Indicators	[empty string]	0	4.49	1	3.99	[empty string]	4.49	[empty string]	RAVEN FD FLOAT	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]	385	5-AND-under	0.00	[empty string]	Raven Fd Float	[empty string]	[empty string]	N	3.99	4.49	4/15G,3/11G,2/8G,5/20G,1/5.5G	[empty string]	[empty string]	1000	RVFFD	309830	FLOATS, BOBBERS, AND INDICATORS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-fd-float-309830	1
18	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Floats, Bobbers, and Indicators	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	RAVEN FM FLOAT 2PK	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]	115	5-to-10	0.00	[empty string]	Raven Fm Float 2pk	[empty string]	[empty string]	N	5.99	5.99	1/4.2G,2/5G,3/6.2G	[empty string]	[empty string]	1000	RVFFM	309910	FLOATS, BOBBERS, AND INDICATORS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-fm-float-2pk-309910	1
19	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Floats, Bobbers, and Indicators	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	RAVEN FS FLOAT 2PACK	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]	50	5-to-10	0.00	[empty string]	Raven Fs Float 2pack	[empty string]	[empty string]	N	5.99	5.99	3/3.8G,1/1G,2/2.2G	[empty string]	[empty string]	1000	RVFFS	309911	FLOATS, BOBBERS, AND INDICATORS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-fs-float-2pack-309911	1
20	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Swivels and Snaps	[empty string]	0	4.49	1	3.49	[empty string]	4.49	[empty string]	RAVEN ULTRA MICRO SWIVEL	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]	143	5-AND-under	0.00	[empty string]	Raven Ultra Micro Swivel	[empty string]	[empty string]	N	3.49	4.49	1X,3X,2X	[empty string]	[empty string]	1000	RVMS	309927	SWIVELS AND SNAPS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-ultra-micro-swivel-309927	1
21	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Terminal Tackle>Hooks	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	RAVEN SICKLE HOOK BLK 10 PK.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	142	5-AND-under	0.00	[empty string]	Raven Sickle Hook Blk 10 Pk.	[empty string]	[empty string]	N	4.99	4.99	10,06,04,08	[empty string]	[empty string]	1000	RVSK	309928	HOOKS	EMPTY	EMPTY	0	0	0	TERMINAL TACKLE	[empty string]	raven-fishing/raven-sickle-hook-blk-10-pk-309928	1
22	PB,SB	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	PB\|NULL\|NULL,SB\|NULL\|NULL	1	229.99	0	229.99	96113-DEFAULT-l.jpg	229.99	96113-DEFAULT-m.jpg	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]	12	200-to-250	0.00	[empty string]	HELIX - CENTERPIN FLOAT REEL - 5 1/8"	<p>The Helix is the ultimate value in centerpin reels. Features a solid backplate and ergonomic ported spool. The stylish design and great performance makes it the best choice for new steelheaders.</p> <p> </p> <ul> <li>Aircraft grade aluminum</li> <li>Integral low-profile reel foot</li> <li>Adjustable tension screw</li> <li>High strength stainless steel spindle</li> <li>Twin shielded bearings</li> <li>On/Off ratchet</li> </ul> <p> </p> <ul> <li>Diameter: 5 1/8″</li> <li>Weight: 8.9 oz</li> <li>Capacity: 250 yards 10lb line and backing</li> </ul>	[empty string]	N	229.99	229.99	5IN	96113-DEFAULT-s.jpg	[empty string]	1000	HXCXL	326824	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/helix-centerpin-float-reel-5-1-8-326824	1
23	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]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	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
24	[empty string]	RAVEN FISHING	Raven Fishing	FISHING	Fishing>Reels>Fly	[empty string]	1	199.99	0	199.99	96114-DEFAULT-l.jpg	199.99	96114-DEFAULT-m.jpg	4.5 IN HELIX REEL BLU/BLK	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	150-to-200	0.00	[empty string]	HELIX - CENTERPIN FLOAT REEL - 4 1/2"	<p>The Helix is the ultimate value in centerpin reels. Features a solid backplate and ergonomic ported spool. The stylish design and great performance makes it the best choice for new steelheaders.</p> <p> </p> <ul> <li>Aircraft grade aluminum</li> <li>Integral low-profile reel foot</li> <li>Adjustable tension screw</li> <li>High strength stainless steel spindle</li> <li>Twin shielded bearings</li> <li>On/Off ratchet</li> </ul> <p> </p> <ul> <li>iameter: 4 1/2"</li> <li>Weight: 7.5 oz</li> <li>Capacity: 250 yards 10lb line and backing</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	96114-DEFAULT-s.jpg	[empty string]	1000	HXCPRB-B	358274	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	raven-fishing/helix-centerpin-float-reel-4-1-2-358274	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter

Filter By

Price

Categories

Brand

Size

Matrix - Centerpin Float Reel

Raven Im6 - Float - Sliding Rings - 11 Feet 6 Inches - 2 Pieces

Raven Im6 - Float - Sliding Rings - 13 Feet 6 Inches - 3 Pieces

Raven Im6 - Custom - Rosewood Reel Seat - 11 Feet 6 Inches - 2 Pieces

Raven 3- Way Snap Swivel

Float Fishing Guide

Raven Spec.Hook Black Sz.8 100 Pk.

Raven Spec.Hook Black Sz.6 100 Pk.

Raven Spec.Hook Black Sz.10 100 Pk.

Raven Spec.Hook Black Sz.4 100 Pk.

Sure Shot Split Shot Aaa 23 G.

Sure Shot Split Shot Ab 23 G.

Sure Shot Split Shot Bb 23 G.

Neoprene Reel Case - Regular

Neoprene Reel Case - X Large

T- 5 - Centerpin Float Reel

Raven Fd Float

Raven Fm Float 2pk

Raven Fs Float 2pack

Raven Ultra Micro Swivel

Raven Sickle Hook Blk 10 Pk.

Helix - Centerpin Float Reel - 5 1/8 "

5 1/8 ` Matrix Xl Fully Ported Limited Edition

Helix - Centerpin Float Reel - 4 1/2 "