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]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	14.99	0	14.99	90961-DEFAULT-l.jpg	14.99	90961-DEFAULT-m.jpg	BIG GAME LEADER 80 LB.	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	10-to-15	0.00	[empty string]	Big Game Leader 80 Lb.	[empty string]	[empty string]	N	14.99	14.99	[empty string]	90961-DEFAULT-s.jpg	[empty string]	1000	BGG 80	119006	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/big-game-leader-80-lb-119006	1
2	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	169.99	1	78.99	63927-DEFAULT-l.jpg	169.99	63927-DEFAULT-m.jpg	SERVICE SPOOL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	V	[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]	47	50-to-100	0.00	[empty string]	Ultragreen - Service Spool	<p>Maxima Ultragreen has been the “go-to” line of serious anglers around the world for decades. Its trademark strength is a hallmark attribute. From big game to small stream trout, Maxima Ultragreen features outstanding abrasion resistance and unchallenged tensile strength that holds up to punishing runs of all sizes of fish. Maxima Ultragreen’s moss green color is nearly invisible to fish, making it an ideal leader material as well.</p> <p> </p> <p>-Exceptionally strong by test<br /> -Superior knot strength<br /> -All species and water conditions<br /> -Extremely tough finish</p>	[empty string]	N	78.99	169.99	8,6,15,20,10,12,18,35,40,30,4,25	63927-DEFAULT-s.jpg	[empty string]	1000	MBG	300210	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/service-spool-300210	1
3	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Fluorocarbon	[empty string]	1	10.99	0	10.99	63954-DEFAULT-l.jpg	10.99	63954-DEFAULT-m.jpg	MAX FLUOR.LEADER WHEEL	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]	104	10-to-15	0.00	[empty string]	Fluorocarbon - 27 Yards	<p>A low refractive material with non-flash components makes Maxima Fluorocarbon totally invisible to fish in the water.</p> <p> </p> <p>-Polymer structure enhances the sensitivity of the line and gives extraordinary castability<br /> -Special finish is additionally treated with a UV-protection extending the line’s useful life<br /> -Maxima Fluorocarbon is exceptionally strong and reliable under all conditions</p>	[empty string]	N	10.99	10.99	10,6,12,8,4,15,2	63954-DEFAULT-s.jpg	[empty string]	1000	MFCL	300231	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/max-fluor-leader-wheel-300231	1
4	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Fluorocarbon	[empty string]	1	26.99	1	19.99	63958-DEFAULT-l.jpg	26.99	63958-DEFAULT-m.jpg	MAX FLUOR.ONE SHOT 200YD	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]	101	15-to-20	0.00	[empty string]	Fluorocarbon - One Shot - 200 Yards	<p>A low refractive material with non-flash components makes Maxima Fluorocarbon totally invisible to fish in the water. A polymer structure enhances the sensitivity of the line and gives Maxima extraordinary castability. The special finish is additionally treated with a UV-protection extending the line’s useful life. Like all Maxima lines, Maxima Fluorocarbon is exceptionally strong and reliable under all conditions.</p>	[empty string]	N	19.99	26.99	8,10,6,12,4	63958-DEFAULT-s.jpg	[empty string]	1000	MFCOS	300232	FLUOROCARBON	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/max-fluor-one-shot-200yd-300232	1
5	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	4.99	1	2.99	73855-DEFAULT-l.jpg	4.99	73855-DEFAULT-m.jpg	MAX LEADER WHEEL	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]	323	5-AND-under	0.00	[empty string]	Ultragreen - Leader Wheel - 27 Yards	<p>Maxima Ultragreen has been the “go-to” line of serious anglers around the world for decades. Its trademark strength is a hallmark attribute. From big game to small stream trout, Maxima Ultragreen features outstanding abrasion resistance and unchallenged tensile strength that holds up to punishing runs of all sizes of fish. Maxima Ultragreen’s moss green color is nearly invisible to fish, making it an ideal leader material as well.</p> <p> </p> <p>-Exceptionally strong by test<br /> -Superior knot strength<br /> -All species and water conditions<br /> -Extremely tough finish</p>	[empty string]	N	2.99	4.99	6,8,4,5,2,3,15,20,12,10,25,1	73855-DEFAULT-s.jpg	[empty string]	1000	MLG	300234	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/max-leader-wheel-300234	1
6	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	9.99	1	8.99	73856-DEFAULT-l.jpg	9.99	73856-DEFAULT-m.jpg	MAX MINI PK 110YDS/GREEN	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]	119	5-to-10	0.00	[empty string]	Ultragreen - Mini Pack - 110 Yards	<p>Maxima Ultragreen has been the “go-to” line of serious anglers around the world for decades. Its trademark strength is a hallmark attribute. From big game to small stream trout, Maxima Ultragreen features outstanding abrasion resistance and unchallenged tensile strength that holds up to punishing runs of all sizes of fish. Maxima Ultragreen’s moss green color is nearly invisible to fish, making it an ideal leader material as well.</p> <p> </p> <p>-Exceptionally strong by test<br /> -Superior knot strength<br /> -All species and water conditions<br /> -Extremely tough finish</p>	[empty string]	N	8.99	9.99	6,4,2,15,12,8,10	73856-DEFAULT-s.jpg	[empty string]	1000	MMG	300258	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/max-mini-pk-110yds-green-300258	1
7	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	18.99	1	12.99	47359-DEFAULT-l.jpg	18.99	47359-DEFAULT-m.jpg	MOC ONE SHOT 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]	ACTIVE	[empty string]	[empty string]	[empty string]	134	10-to-15	0.00	[empty string]	Chameleon - One Shot	<p>No other line can match the strength of Maxima Chameleon. For decades, anglers across the globe have trusted Maxima Chameleon to deliver unparalleled abrasion resistance, knot strength, tensile strength and toughness when the fight’s on. Like its namesake, Chameleon, this line has a unique formulation that enables it to change color hues to match the surrounding water and light conditions. No wonder that steelhead and salmon anglers who fish under some of the most challenging conditions choose Maxima Chameleon. Wherever brute strength is needed or rugged conditions are the norm, Maxima Chameleon excels.</p> <p> </p> <p>-Strongest line in its class<br /> -Outstanding abrasion resistance<br /> -Delivers increased stealth and invisibility<br /> -Unmatched toughness under all conditions</p>	[empty string]	N	12.99	18.99	6,12,10,18,8,4,15,5	47359-DEFAULT-s.jpg	[empty string]	1000	MOC	300259	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/moc-one-shot-spool-300259	1
8	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	19.99	1	12.99	73857-DEFAULT-l.jpg	19.99	73857-DEFAULT-m.jpg	MAX ONE SHOT 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]	ACTIVE	[empty string]	[empty string]	[empty string]	260	10-to-15	0.00	[empty string]	Ultragreen - One Shot	<p>Maxima Ultragreen has been the “go-to” line of serious anglers around the world for decades. Its trademark strength is a hallmark attribute. From big game to small stream trout, Maxima Ultragreen features outstanding abrasion resistance and unchallenged tensile strength that holds up to punishing runs of all sizes of fish. Maxima Ultragreen’s moss green color is nearly invisible to fish, making it an ideal leader material as well.</p> <p> </p> <p>-Exceptionally strong by test<br /> -Superior knot strength<br /> -All species and water conditions<br /> -Extremely tough finish</p>	[empty string]	N	12.99	19.99	15,8,6,4,2,12,5,18,10,20,1	73857-DEFAULT-s.jpg	[empty string]	1000	MOSS	300263	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/max-one-shot-spool-300263	1
9	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	18.99	1	12.99	47368-DEFAULT-l.jpg	18.99	47368-DEFAULT-m.jpg	HV ONE SHOT 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]	ACTIVE	[empty string]	[empty string]	[empty string]	46	10-to-15	0.00	[empty string]	Hv High Visibility - One Shot	<p>The world’s finest high visibility monofilament line, Maxima’s HV features a bright yellow color that’s easy to see in daylight and low-light conditions. Salmon and steelhead anglers have embraced HV for use in drift fishing and “free-drifting” applications. Maxima HV is also ideal for trolling applications where keeping track of multiple lines is made easy. Not only highly visible, this line is Maxima-strong with remarkable knot strength, tensile strength and abrasion resistance.</p> <p> </p> <p>-Bright yellow, HV monofilament<br /> -Outstanding performance in freshwater and salt water applications<br /> -Superior knot strength<br /> -High tensile strength and abrasion resistance</p>	[empty string]	N	12.99	18.99	6,10,8,20,12,18	47368-DEFAULT-s.jpg	[empty string]	1000	MOY	300265	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/hv-one-shot-spool-300265	1
10	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	1	14.99	0	14.99	73858-DEFAULT-l.jpg	14.99	73858-DEFAULT-m.jpg	MAXIMA 1/4LB CRYSTAL IVORY	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]	86	10-to-15	0.00	[empty string]	Crystal Ivory	<p>Another high-performance monofilament by Maxima, the distinctive golden color of Crystal Ivory makes it immediately visible above water, even in low light conditions, yet super stealthlike underwater. An ideal feature for trolling and detecting subtle bites, you’ll know exactly where your line is at all times. Crystal Ivory is, like all Maxima lines, highly durable and abrasion resistant and ideal for use in freshwater or saltwater applications.</p> <p> </p> <p>-Enhanced visibility in daylight and low light conditions<br /> -Superior strength and abrasion resistance<br /> -Distinctive golden color<br /> -Excellent casting and trolling</p>	[empty string]	N	14.99	14.99	15,20,6,8,12,10,4	73858-DEFAULT-s.jpg	[empty string]	1000	MQP	300273	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/maxima-1-4lb-crystal-ivory-300273	1
11	[empty string]	MAXIMA USA	Maxima Usa	FISHING	Fishing>Line and Leader>Monofilament	[empty string]	0	42.99	1	29.99	[empty string]	42.99	[empty string]	MAX MAXI SPOOLS	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]	95	25-to-50	0.00	[empty string]	Ultragreen - Maxi Spool - 660 Yards	<p>Maxima Ultragreen has been the “go-to” line of serious anglers around the world for decades. Its trademark strength is a hallmark attribute. From big game to small stream trout, Maxima Ultragreen features outstanding abrasion resistance and unchallenged tensile strength that holds up to punishing runs of all sizes of fish. Maxima Ultragreen’s moss green color is nearly invisible to fish, making it an ideal leader material as well.</p> <p> </p> <p>-Exceptionally strong by test<br /> -Superior knot strength<br /> -All species and water conditions<br /> -Extremely tough finish</p>	[empty string]	N	29.99	42.99	15,4,20,8,10,6,12	[empty string]	[empty string]	1000	MSFG	300275	MONOFILAMENT	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	maxima-usa/max-maxi-spools-300275	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

1
10
12
15
18
2
20
25
3
30
35
4
40
5
50
6
8

Filter