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]	SAGE	Sage	FISHING	Fishing>Rods>Fly and Spey Rods	[empty string]	1	325	0	325	95636-DEFAULT-l.jpg	325	95636-DEFAULT-m.jpg	FOUNDATION ROD 4 WT. 4PC. 9 FT.	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	300-to-350	0.00	[empty string]	FOUNDATION - 9 FEET - 4 WEIGHT - 4 PIECES	<p>A light and versatile trout rod, the 490-4 offers great line control without compromising accuracy.  Best for dry flies and smaller nymphs.</p> <p> </p> <ul> <li>Length: 9'</li> <li>Weight: 4</li> <li>Pieces: 4</li> </ul>	[empty string]	N	325	325	[empty string]	95636-DEFAULT-s.jpg	[empty string]	1000	2035-490-4	292439	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	sage/foundation-9-feet-4-weight-4-pieces-292439	1
2	[empty string]	SAGE	Sage	FISHING	Fishing>Rods>Fly and Spey Rods	[empty string]	1	325	0	325	95633-DEFAULT-l.jpg	325	95633-DEFAULT-m.jpg	FOUNDATION ROD 7 WT. 4PC. 9 FT.	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	300-to-350	0.00	[empty string]	FOUNDATION - 9 FEET - 7 WEIGHT - 4 PIECES	<p>A very versatile and often-overlooked rod weight. The 790-4 is equally at home fishing streamers from a drift boat or sight fishing to wary bonefish.</p> <p> </p> <ul> <li>Length: 9'</li> <li>Weight: 7</li> <li>Pieces: 4</li> </ul>	[empty string]	N	325	325	[empty string]	95633-DEFAULT-s.jpg	[empty string]	1000	2035-790-4	292442	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	sage/foundation-9-feet-7-weight-4-pieces-292442	1
3	[empty string]	SAGE	Sage	FISHING	Fishing>Rods>Fly and Spey Rods	[empty string]	1	325	0	325	95632-DEFAULT-l.jpg	325	95632-DEFAULT-m.jpg	FOUNDATION ROD 8 WT. 4PC. 9 FT.	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	300-to-350	0.00	[empty string]	FOUNDATION - 9 FEET - 8 WEIGHT - 4 PIECES	<p>Sage's most versatile and popular saltwater rod model. The 890-4 Foundation is able to effectively present flies and handle the fight with bonefish, redfish, striped bass, largemouth bass or other similarly-sized species.</p> <p> </p> <ul> <li>Length: 9'</li> <li>Weight: 8</li> <li>Pieces: 4</li> </ul>	[empty string]	N	325	325	[empty string]	95632-DEFAULT-s.jpg	[empty string]	1000	2035-890-4	292443	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	sage/foundation-9-feet-8-weight-4-pieces-292443	1
4	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	1	249	0	249	96133-DEFAULT-l.jpg	249	96133-DEFAULT-m.jpg	SPECTRUM FLY REEL 3/4 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]	1	200-to-250	0.00	[empty string]	SPECTRUM - 3/4 - BLACK	<p>Multi-purpose reels built to cover the entire range of fly fishing applications from Brook trout to Tarpon. Every reel utilizes Sage’s exclusive SCS Drag package tuned per size to match fishing application. One revolution drag knob featured throughout the series allows for ease of adjustment and reliable, consistent, repeatable drag pressure. Just select desired weight and feature set for your application. 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]	96133-DEFAULT-s.jpg	[empty string]	1000	324-3200R3405	292445	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-3-4-black-292445	1
5	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	1	249	0	249	96134-DEFAULT-l.jpg	249	96134-DEFAULT-m.jpg	SPECTRUM FLY REEL 5/6 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]	1	200-to-250	0.00	[empty string]	SPECTRUM - 5/6 - BLACK	<p>Multi-purpose reels built to cover the entire range of fly fishing applications from Brook trout to Tarpon. Every reel utilizes Sage’s exclusive SCS Drag package tuned per size to match fishing application. One revolution drag knob featured throughout the series allows for ease of adjustment and reliable, consistent, repeatable drag pressure. Just select desired weight and feature set for your application. 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]	96134-DEFAULT-s.jpg	[empty string]	1000	324-3200R5605	292447	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-5-6-black-292447	1
6	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	1	299	0	299	96135-DEFAULT-l.jpg	299	96135-DEFAULT-m.jpg	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]	1	250-to-300	0.00	[empty string]	SPECTRUM - 7/8 - BLACK	<p>Multi-purpose reels built to cover the entire range of fly fishing applications from Brook trout to Tarpon. Every reel utilizes Sage’s exclusive SCS Drag package tuned per size to match fishing application. One revolution drag knob featured throughout the series allows for ease of adjustment and reliable, consistent, repeatable drag pressure. Just select desired weight and feature set for your application. 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]	96135-DEFAULT-s.jpg	[empty string]	1000	324-3200R7805	292449	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-7-8-black-292449	1
7	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	1	299	0	299	96136-DEFAULT-l.jpg	299	96136-DEFAULT-m.jpg	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	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	SPECTRUM - 9/10 - BLACK	<p>Multi-purpose reels built to cover the entire range of fly fishing applications from Brook trout to Tarpon. Every reel utilizes Sage’s exclusive SCS Drag package tuned per size to match fishing application. One revolution drag knob featured throughout the series allows for ease of adjustment and reliable, consistent, repeatable drag pressure. Just select desired weight and feature set for your application. 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]	96136-DEFAULT-s.jpg	[empty string]	1000	324-3200R91005	292451	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-9-10-black-292451	1
8	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	1	349	0	349	96137-DEFAULT-l.jpg	349	96137-DEFAULT-m.jpg	SPECTRUM LT FLY REEL 5/6 BLACK SPRUCE	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	300-to-350	0.00	[empty string]	SPECTRUM LT - 5/6 - BLACK SPRUCE	<p>Multi-purpose reels built to cover the entire range of fly fishing applications from Brook trout to Tarpon. Every reel utilizes Sage’s exclusive SCS Drag package tuned per size to match fishing application. One revolution drag knob featured throughout the series allows for ease of adjustment and reliable, consistent, repeatable drag pressure. Just select desired weight and feature set for your application. The Spectrum LT reel offering brings a sophisticated, high-performance drag system to an ultra light rigid frame. The One Revolution Drag Knob offers quick and precise drag settings and provides the kind of power and smoothness you’d expect from a large traditional drag system, only without the bulk or weight.</p> <p> </p> <ul> <li>SCS Drag</li> <li>One Revolution Drag Knob with 20 numbers and 40 detented settings</li> <li>Large arbor for fast line pick-up</li> <li>Concave, ported arbor for greater strength and capacity</li> <li>Fully machined 6061-T6 aerospace grade aluminum</li> <li>Cold forged and tempered for superior strength and rigidity</li> <li>Hard anodized for surface protection and corrosion resistance</li> <li>Ergonomic handle</li> <li>Easy conversion from left- to right-hand retrieve</li> <li>Neoprene and embroidered ballistic nylon reel case</li> </ul>	[empty string]	N	349	349	[empty string]	96137-DEFAULT-s.jpg	[empty string]	1000	322-4200R5604	292453	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-lt-5-6-black-spruce-292453	1
9	[empty string]	SAGE	Sage	FISHING	Fishing>Reels>Fly	[empty string]	1	399	0	399	96138-DEFAULT-l.jpg	399	96138-DEFAULT-m.jpg	SPECTRUM LT FLY REEL 7/8 BLACK SPRUCE	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	350-to-400	0.00	[empty string]	SPECTRUM LT - 7/8 - BLACK SPRUCE	<p>Multi-purpose reels built to cover the entire range of fly fishing applications from Brook trout to Tarpon. Every reel utilizes Sage’s exclusive SCS Drag package tuned per size to match fishing application. One revolution drag knob featured throughout the series allows for ease of adjustment and reliable, consistent, repeatable drag pressure. Just select desired weight and feature set for your application. The Spectrum LT reel offering brings a sophisticated, high-performance drag system to an ultra light rigid frame. The One Revolution Drag Knob offers quick and precise drag settings and provides the kind of power and smoothness you’d expect from a large traditional drag system, only without the bulk or weight.</p> <p> </p> <ul> <li>SCS Drag</li> <li>One Revolution Drag Knob with 20 numbers and 40 detented settings</li> <li>Large arbor for fast line pick-up</li> <li>Concave, ported arbor for greater strength and capacity</li> <li>Fully machined 6061-T6 aerospace grade aluminum</li> <li>Cold forged and tempered for superior strength and rigidity</li> <li>Hard anodized for surface protection and corrosion resistance</li> <li>Ergonomic handle</li> <li>Easy conversion from left- to right-hand retrieve</li> <li>Neoprene and embroidered ballistic nylon reel case</li> </ul>	[empty string]	N	399	399	[empty string]	96138-DEFAULT-s.jpg	[empty string]	1000	322-4200R7804	292454	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-lt-7-8-black-spruce-292454	1
10	BLK	SAGE	Sage	FISHING	Fishing>Reels>Fly	BLK\|NULL\|NULL	1	185	1	165	96139-DEFAULT-l.jpg	185	96139-DEFAULT-m.jpg	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]	9	150-to-200	0.00	[empty string]	SPECTRUM C	<p>Multi-purpose reels built to cover the entire range of fly fishing applications from Brook trout to Tarpon. Every reel utilizes Sage’s exclusive SCS Drag package tuned per size to match fishing application. One revolution drag knob featured throughout the series allows for ease of adjustment and reliable, consistent, repeatable drag pressure. Just select desired weight and feature set for your application. The Spectrum C features a large arbor with rugged machined die-cast frame and generous concave vented spool. Equipped with the Spectrum Family One Revolution Sealed Carbon Drag and unexpected finishing touches like its fully machined drag knob and handle. The Spectrum C gives you more than the fish bargained for.</p> <p> </p> <ul> <li>SCS Drag</li> <li>One Revolution Drag Knob with 10 numbers and 20 detented settings</li> <li>Large arbor for fast line pick-up</li> <li>Vented concave arbor for greater strength and capacity</li> <li>Lightweight aluminum die-cast construction with machined finish</li> <li>Powder coated for surface protection and corrosion resistance</li> <li>Machined and anodized aluminum drag knob and ergonomic handle</li> <li>Easy conversion from left- to right-hand retrieve</li> <li>Neoprene and embroidered ballistic nylon reel case</li> </ul>	[empty string]	N	165	185	7/8,5/6,9/10	96139-DEFAULT-s.jpg	[empty string]	1000	SPECTRUM C	307390	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	sage/spectrum-c-307390	1
11	[empty string]	SAGE	Sage	FISHING	Fishing>Rods>Fly and Spey Rods	[empty string]	0	325	0	325	[empty string]	325	[empty string]	FOUNDATION 9WT 9FT 4PC FLY ROD	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]	1	300-to-350	0.00	[empty string]	Foundation 9wt 9ft 4pc Fly Rod	[empty string]	[empty string]	N	325	325	[empty string]	[empty string]	[empty string]	1000	2035-990-4	322999	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	sage/foundation-9wt-9ft-4pc-fly-rod-322999	1
12	[empty string]	SAGE	Sage	FISHING	Fishing>Rods>Fly and Spey Rods	[empty string]	1	499.99	0	499.99	95637-DEFAULT-l.jpg	499.99	95637-DEFAULT-m.jpg	890-4 MAVERICK ROD 8 WT. 4PC. 9 FT.	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[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]	2	450-to-500	0.00	[empty string]	MAVERICK - 9 FEET - 8 WEIGHT - 4 PIECES	<p>Saltwater angling is more often a game of quick shots than long casts. Dropping a fly in front of a cruising tarpon 20ft off the bow can be the difference between success and failure during a day on the flats. This Maverick is an all-around saltwater tool and go-to bonefish rod.</p> <p> </p> <ul> <li>Length: 9'</li> <li>Weight: 8</li> <li>Pieces: 4</li> </ul>	[empty string]	N	499.99	499.99	[empty string]	95637-DEFAULT-s.jpg	[empty string]	1000	2048-890-4	342453	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	sage/maverick-9-feet-8-weight-4-pieces-342453	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

Filter