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	590,690,484	ECHO	Echo	FISHING	Fishing>Rods>Fly and Spey Rods	590\|NULL\|NULL,690\|NULL\|NULL,484\|NULL\|NULL	1	179.99	0	179.99	95511-DEFAULT-l.jpg	179.99	95511-DEFAULT-m.jpg	CARBON XL FLY FISHING 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]	6	150-to-200	0.00	[empty string]	CARBON XL - FLY FISHING	<p>The Carbon XL is designed for anglers of all skill levels who need a well-rounded rod for a variety of fishing applications. These rods feature a moderate action that excels at everything from dry fly fishing to nymphing and even light streamers without ever feeling heavy or sluggish.  The Carbon XL series looks and feels like a rod that should be selling for twice its price!</p> <p> </p> <ul> <li>490:</li> <li>Pieces: 4</li> <li>Weight: 3.4</li> <li>Length: 9'</li> <li>4wt</li> </ul> <p> </p> <ul> <li>590:</li> <li>Pieces: 4</li> <li>Weight: 3.5</li> <li>Length: 9'</li> <li>5wt</li> </ul> <p> </p> <ul> <li>690:</li> <li>Pieces: 4</li> <li>Weight: 3.7</li> <li>Length: 9'</li> <li>6wt</li> </ul>	[empty string]	N	179.99	179.99	CBXL	95511-DEFAULT-s.jpg	[empty string]	1000	CBXL	355421	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	echo/carbon-xl-fly-fishing-355421	1
2	4100	ECHO	Echo	FISHING	Fishing>Rods>Fly and Spey Rods	4100\|NULL\|NULL	1	199.99	0	199.99	95512-DEFAULT-l.jpg	199.99	95512-DEFAULT-m.jpg	CARBON XL EURO NYPH FLY FISHING 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]	2	150-to-200	0.00	[empty string]	CARBON XL EURO NYMPH - FLY FISHING	<p>With the growing demand for specialized Euro Nymph rods, the demand for a rod that fits the needs of anglers that are not looking to compete at the national championships has also been growing.  Echo used their extremely popular Carbon XL rod as a tried-and-true foundation to make a rod that met and exceeded the expectations of these anglers.</p> <p> </p> <ul> <li>4100:</li> <li>Pieces: 4</li> <li>Weight: 3.7</li> <li>Length: 10'</li> <li>4wt</li> </ul>	[empty string]	N	199.99	199.99	CBXL-N	95512-DEFAULT-s.jpg	[empty string]	1000	CBXL-N	355422	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	echo/carbon-xl-euro-nymph-fly-fishing-355422	1
3	990,8100,5100,1090,690,790,7100,890	ECHO	Echo	FISHING	Fishing>Rods>Fly and Spey Rods	990\|NULL\|NULL,8100\|NULL\|NULL,5100\|NULL\|NULL,1090\|NULL\|NULL,690\|NULL\|NULL,790\|NULL\|NULL,7100\|NULL\|NULL,890\|NULL\|NULL	1	199.99	0	199.99	95513-DEFAULT-l.jpg	199.99	95513-DEFAULT-m.jpg	ION XL FLY FISHING 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]	28	150-to-200	0.00	[empty string]	ION XL - FLY FISHING	<p>Featuring a remarkably low swing-weight and a more forgiving action, the Ion XL is equally at home stripping flesh flies as it is dropping a merkin to a tailing permit. With the Ion XL’s extreme versatility between fresh and saltwater environments, its affordable price point, and quality componentry, it has become the go-to rod for guides and fishing professionals.</p> <p> </p> <ul> <li>690:</li> <li>Pieces: 4</li> <li>Weight: 4.7</li> <li>Length: 9'</li> <li>6wt</li> </ul> <p> </p> <ul> <li>790:</li> <li>Pieces: 4</li> <li>Weight: 4.9</li> <li>Length: 9'</li> <li>7wt</li> </ul> <p> </p> <ul> <li>890:</li> <li>Pieces: 4</li> <li>Weight: 5.1</li> <li>Length: 9'</li> <li>8wt</li> </ul> <p> </p> <ul> <li>990:</li> <li>Pieces: 4</li> <li>Weight: 5.4</li> <li>Length: 9'</li> <li>9wt</li> </ul> <p> </p> <ul> <li>1090:</li> <li>Pieces: 4</li> <li>Weight: 5.8</li> <li>Length: 9'</li> <li>10wt</li> </ul> <p> </p> <ul> <li>5100:</li> <li>Pieces: 4</li> <li>Weight: 5.5</li> <li>Length: 10'</li> <li>5wt</li> </ul> <p> </p> <ul> <li>7100:</li> <li>Pieces: 4</li> <li>Weight: 5.8</li> <li>Length: 10'</li> <li>7wt</li> </ul> <p> </p> <ul> <li>8100:</li> <li>Pieces: 4</li> <li>Weight: 6.5</li> <li>Length: 10'</li> <li>8wt</li> </ul>	[empty string]	N	199.99	199.99	IONXL	95513-DEFAULT-s.jpg	[empty string]	1000	IONXL	355423	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	echo/ion-xl-fly-fishing-355423	1
4	890,690,790,590,376,480	ECHO	Echo	FISHING	Fishing>Rods>Fly and Spey Rods	890\|NULL\|NULL,690\|NULL\|NULL,790\|NULL\|NULL,590\|NULL\|NULL,376\|NULL\|NULL,480\|NULL\|NULL	1	114.99	1	99.99	95516-DEFAULT-l.jpg	114.99	95516-DEFAULT-m.jpg	LIFT 4PC FLY FISHING 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]	21	50-to-100	0.00	[empty string]	LIFT - FLY FISHING	<p>The Lift is built on the shoulders of Echo's extremely popular Echo Base series with updated actions to suit a wider range of casting styles. Few rods out there offer the bang-for-buck value of the Echo Lift and they specifically designed it to continue to impress you whether you’re still learning or many years in to your fly fishing career.</p> <p> </p> <ul> <li>376:</li> <li>Pieces: 4</li> <li>Weight: 3.1</li> <li>Length: 7' 6"</li> <li>3wt</li> </ul> <p> </p> <ul> <li>480:</li> <li>Pieces: 4</li> <li>Weight: 3.4</li> <li>Length: 8'</li> <li>4wt</li> </ul> <p> </p> <ul> <li>590:</li> <li>Pieces: 4</li> <li>Weight: 3.7</li> <li>Length: 9'</li> <li>5wt</li> </ul> <p> </p> <ul> <li>690:</li> <li>Pieces: 4</li> <li>Weight: 3.9</li> <li>Length: 9'</li> <li>6wt</li> </ul> <p> </p> <ul> <li>790:</li> <li>Pieces: 4</li> <li>Weight: 4.2</li> <li>Length: 9'</li> <li>7wt</li> </ul> <p> </p> <ul> <li>890:</li> <li>Pieces: 4</li> <li>Weight: 4.5</li> <li>Length: 9'</li> <li>8wt</li> </ul>	[empty string]	N	99.99	114.99	CORE	95516-DEFAULT-s.jpg	[empty string]	1000	LIFT	355424	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	echo/lift-fly-fishing-355424	1
5	476	ECHO	Echo	FISHING	Fishing>Rods>Fly and Spey Rods	476\|NULL\|NULL	1	249.99	0	249.99	95517-DEFAULT-l.jpg	249.99	95517-DEFAULT-m.jpg	RIVER GLASS GORGEOUS GLACIER FLY FISHING 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]	1	200-to-250	0.00	[empty string]	RIVER GLASS - GORGEOUS GLACIER - FLY FISHING	<p>The River Glass Rod Series brings the fun and feel of fiberglass to the modern angler.</p> <p> </p> <ul> <li>Fiberglass:  S-glass</li> <li>Action:  Glass Med-Fast</li> <li>Tube:  Fiberglass tube</li> <li>Guides: Chrome snake guides</li> <li>Reel Seat:  Cork reel seat</li> </ul> <p> </p> <ul> <li>476:</li> <li>Pieces: 4</li> <li>Weight: 2.8</li> <li>Length: 7' 6"</li> <li>4wt</li> </ul>	[empty string]	N	249.99	249.99	RG-GG	95517-DEFAULT-s.jpg	[empty string]	1000	RG-GG	355425	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	echo/river-glass-gorgeous-glacier-fly-fishing-355425	1
6	880,680	ECHO	Echo	FISHING	Fishing>Rods>Fly and Spey Rods	880\|NULL\|NULL,680\|NULL\|NULL	1	289.99	0	289.99	95519-DEFAULT-l.jpg	289.99	95519-DEFAULT-m.jpg	BAD ASS GLASS QUICKSHOT FLY FISHING 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]	6	250-to-300	0.00	[empty string]	BAD ASS GLASS - QUICKSHOT - FLY FISHING	<p>The Bad Ass Glass Quickshot Rod gives a glimpse at the future of fiberglass; faster, lighter and more powerful.</p> <p> </p> <ul> <li>Four piece travel design</li> <li>Action:  Glass Fast</li> <li>Blank:  Translucent Sky Blue</li> <li>Tube:  Unique fiberglass rod tube</li> <li>Guides: Stainless w/ low-friction ceramic stripper</li> <li>Grips:  Two grip styles</li> <li>Reel Seat: Maintenance-free aluminum</li> </ul> <p> </p> <ul> <li>680:</li> <li>Pieces: 4</li> <li>Weight: 4.5 oz</li> <li>Length: 8'</li> <li>Action: Glass Fast</li> <li>6wt</li> </ul> <p> </p> <ul> <li>880:</li> <li>Pieces: 4</li> <li>Weight: 5.2 oz</li> <li>Length: 8'</li> <li>Action: Glass Fast</li> <li>8wt</li> </ul>	[empty string]	N	289.99	289.99	BAG	95519-DEFAULT-s.jpg	[empty string]	1000	BAG	355427	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	echo/bad-ass-glass-quickshot-fly-fishing-355427	1
7	480,690,890	ECHO	Echo	FISHING	Fishing>Rods>Fly and Spey Rods	480\|NULL\|NULL,690\|NULL\|NULL,890\|NULL\|NULL	1	179.99	0	179.99	95518-DEFAULT-l.jpg	179.99	95518-DEFAULT-m.jpg	LIFT KITS FLY FISHING 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]	8	150-to-200	0.00	[empty string]	LIFTKIT - FLY FISHING - MEDIUM FAST	<p>A complete package priced for any budget with versatile action and durable construction.</p> <p> </p> <ul> <li>Four piece travel design</li> <li>Action: Medium Fast</li> <li>Tube:  Fabric-covered rod & reel case</li> <li>Guides: Chrome guides</li> <li>Grips:  Two grip styles</li> <li>Reel Seat:  Black anodized aluminum</li> </ul> <p> </p> <ul> <li>480:</li> <li>Pieces: 4</li> <li>Weight: 3.4 oz</li> <li>Action: Medium Fast</li> <li>Length: 8'</li> <li>4wt</li> </ul> <p> </p> <ul> <li>590:</li> <li>Pieces: 4</li> <li>Weight: 3.7 oz</li> <li>Action: Medium Fast</li> <li>Length: 9'</li> <li>5wt</li> </ul> <p> </p> <ul> <li>690:</li> <li>Pieces: 4</li> <li>Weight: 3.9 oz</li> <li>Action: Medium Fast</li> <li>Length: 9'</li> <li>6wt</li> </ul> <p> </p> <ul> <li>890:</li> <li>Pieces: 4</li> <li>Weight: 4.5 oz</li> <li>Action: Medium Fast</li> <li>Length: 9'</li> <li>8wt</li> </ul>	[empty string]	N	179.99	179.99	C-KIT	95518-DEFAULT-s.jpg	[empty string]	1000	LIFTKIT	355428	FLY AND SPEY RODS	EMPTY	EMPTY	0	0	0	RODS	[empty string]	echo/liftkit-fly-fishing-medium-fast-355428	1
8	8/10,4/5,6/7	ECHO	Echo	FISHING	Fishing>Reels>Fly	8/10\|NULL\|NULL,4/5\|NULL\|NULL,6/7\|NULL\|NULL	1	119.99	0	119.99	95966-DEFAULT-l.jpg	119.99	95966-DEFAULT-m.jpg	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]	17	100-to-150	0.00	[empty string]	BRAVO LT - FLY FISHING	<p>Starting with Echo's proven drag design, they cut, shaved, and overhauled the core of the reel until they could shoehorn a four-layer carbon fiber drag system in the hub of the Echo Bravo Lite reels. The design includes O-rings to keep water and dirt from entering the guts of the reel. The design allows a person to not only change the retrieve from left to right without tools, but also completely disassemble the drag and service it without any hassle.</p> <p> </p> <ul> <li>4 Carbon Disc Drag System</li> <li>Premium roller clutch bearing system for a smooth, instantly-engaged drag</li> <li>Large arbor design for faster line pickup</li> <li>Durable, solid aluminum alloy construction</li> <li>Incoming/outgoing audible click</li> <li>Easily convertible from left to right hand retrieve</li> <li>Sealed to protect against damaging elements</li> <li>Simple Maintenance</li> </ul> <p> </p> <ul> <li>4/5:</li> <li>Diameter: 3.48"</li> <li>Inner Width: .89"</li> <li>Weight: 4.85 oz</li> <li>Capacity: WF5+150/20</li> </ul> <p> </p> <ul> <li>6/7:</li> <li>Diameter: 3.85"</li> <li>Inner Width: .95"</li> <li>Weight: 6.54 oz</li> <li>Capacity: WF7+150/20</li> </ul> <p> </p> <ul> <li>8/10:</li> <li>Diameter: 4.17"</li> <li>Inner Width: 1.1"</li> <li>Weight: 7.78 oz</li> <li>Capacity: WF8+200/20</li> </ul>	[empty string]	N	119.99	119.99	BR-LT	95966-DEFAULT-s.jpg	[empty string]	1000	BRAVOLT	355429	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	echo/bravo-lt-fly-fishing-355429	1
9	8/10,7/9	ECHO	Echo	FISHING	Fishing>Reels>Fly	8/10\|NULL\|NULL,7/9\|NULL\|NULL	1	139.99	0	139.99	95967-DEFAULT-l.jpg	139.99	95967-DEFAULT-m.jpg	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]	15	100-to-150	0.00	[empty string]	BRAVO - FLY FISHING	<p>The ECHO Bravo reel features Echo's saltwater-safe PIT STOP drag system, allowing tool-free access to the reel’s carbon fiber disc drag system so you can keep salt where it belongs: on the rim of a margarita glass. The reel’s extra-large arbor and low startup inertia round out your new favorite fish-taming machine</p> <p> </p> <ul> <li>Saltwater-safe PIT STOP drag system featuring maintenance-free carbon fiber disc</li> <li>Premium roller clutch bearing system for a smooth, instantly-engaged drag</li> <li>Large arbor design for faster line pickup</li> <li>Durable, solid aluminum alloy construction</li> <li>Incoming/outgoing audible click</li> <li>Easily convertible from left to right hand retrieve</li> <li>Large arbor spool design for fast line pickup and low line memory</li> <li>Tool-free access to all components</li> <li>Easily convertible from left to right hand retrieve</li> <li>Simple maintenance and cleaning</li> </ul> <p> </p> <ul> <li>7/9:</li> <li>Diameter: 4.25"</li> <li>Inner Width: 1.25"</li> <li>Weight: 8.5 oz</li> <li>Capacity: WF8 + 200 yd / 20 lb</li> </ul> <p> </p> <ul> <li>8/10:</li> <li>Diameter: 4.5"</li> <li>Inner Width: 1.35"</li> <li>Weight: 8.8 oz</li> <li>Capacity: WF9 + 200 yd / 20 lb</li> </ul>	[empty string]	N	139.99	139.99	BRAVO	95967-DEFAULT-s.jpg	[empty string]	1000	BRAVO	355430	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	echo/bravo-fly-fishing-355430	1
10	8/10,7/9,6/7,4/5	ECHO	Echo	FISHING	Fishing>Reels>Fly	8/10\|NULL\|NULL,7/9\|NULL\|NULL,6/7\|NULL\|NULL,4/5\|NULL\|NULL	1	99.99	1	79.99	95968-DEFAULT-l.jpg	99.99	95968-DEFAULT-m.jpg	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]	20	50-to-100	0.00	[empty string]	ION - FLY FISHING	<p>With a large arbor for quick retrieves and a hybrid machined/cast design, the Ion is a great choice for balancing single-hand and two-hand rods of all sizes. Designed primarily for freshwater use, they can be used in the salt with a little additional care.</p> <p> </p> <ul> <li>Maintenance-free disc drag with low start-up resistance</li> <li>Easy left to right hand change</li> <li>Backlash-free, instant drag reaction</li> <li>Positive position click drag knob</li> <li>Incoming/outgoing audible click</li> <li>Durable alloy construction</li> <li>Large arbor spool design for fast line pickup and low line memory</li> </ul> <p> </p> <ul> <li>4/5:</li> <li>Diameter: 3.4"</li> <li>Inner Width: 1.2"</li> <li>Weight: 5.3 oz</li> <li>Capacity: WF5+150/20</li> </ul> <p> </p> <ul> <li>6/7:</li> <li>Diameter: 3.7"</li> <li>Inner Width: 1.2"</li> <li>Weight: 5.5 oz</li> <li>Capacity: WF7+150/20</li> </ul> <p> </p> <ul> <li>7/9:</li> <li>Diameter: 3.9"</li> <li>Inner Width: 1.3"</li> <li>Weight: 7.9 oz</li> <li>Capacity: WF8+200/20</li> </ul> <p> </p> <ul> <li>8/10:</li> <li>Diameter: 3.9"</li> <li>Inner Width: 1.5"</li> <li>Weight: 8.3 oz</li> <li>Capacity: WF8/9+200/20</li> </ul>	[empty string]	N	79.99	99.99	ION	95968-DEFAULT-s.jpg	[empty string]	1000	ION	355431	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	echo/ion-fly-fishing-355431	1
11	4/5	ECHO	Echo	FISHING	Fishing>Reels>Fly	4/5\|NULL\|NULL	1	99.99	0	99.99	107140-DEFAULT-l.jpg	99.99	107140-DEFAULT-m.jpg	SHADOW CLICK 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]	4	50-to-100	0.00	[empty string]	SHADOW CLICK - FLY REEL	<p>Echo's revolutionary “adjustable frame” design is equipped with Line Window to keep your thin diameter lines protected from the gaps and other areas that can grab it.</p> <p> </p> <ul> <li>Maintenance-free click-pawl system</li> <li>Backlash-free, instant clicker reaction</li> <li>Incoming/outgoing audible click</li> <li>Durable alloy construction</li> <li>Large arbor spool design for fast line pickup and low line memory</li> <li>Easy left to right-hand retrieve change</li> </ul> <p> </p> <ul> <li>Diameter: 3.4"</li> <li>Width: .9"</li> <li>Weight: 2.9 oz</li> <li>Capacity: WF5+125/20</li> </ul>	[empty string]	N	99.99	99.99	SH/CL	107140-DEFAULT-s.jpg	[empty string]	1000	SHCLICK	355432	FLY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	echo/shadow-click-fly-reel-355432	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter