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]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	GAR LOW PROFILE BAITCAST COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[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]	Black Max Combo - Baitcasting - 7 Feet	<p>The upgraded Black Max low profile baitcast combo is engineered with class-leading performance in a compact, lightweight design. A graphite frame and body, along with the compact bent handle and drag star, provide a more ergonomic feel for all-day fishing sessions. The result is proven value and reliability that anglers have come to expect from this series.</p>	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	BMAX3/701MH	281502	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/gar-low-profile-baitcast-combo-281502	1
2	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Spinning	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	GAR VERITAS VTSC69-6	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	INSTORE PICK UP ONLY	[empty string]	[empty string]	PURE FISHING	[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]	Veritas - Casting - 6 Feet 9 Inches - Medium Heavy	<p>Abu Garcia's most renowned rod series now with increased comfort and improved weight and balance. Veritas rods combine a 30 ton construction with Sublayer Armor for uncompromising strength and sensitivity in a lightweight, balanced design. Their Abu designed up locking micro click reel seat design offers secure connection between the rod and reel and the ultimate in comfort.</p>	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	VTSC69-6	292194	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/gar-veritas-vtsc69-6-292194	1
3	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Trolling	[empty string]	0	79.99	0	79.99	[empty string]	79.99	[empty string]	AMBASSADEUR S LINE COUNTER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[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]	Ambassadeur S Line Counter	[empty string]	[empty string]	N	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	AMBS-5500LC	322726	TROLLING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/ambassadeur-s-line-counter-322726	1
4	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	MAXPRO20SP/EAG70ML BAIT SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Maxpro20sp/eag70ml Bait Spin Combo	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	MAX-EAG7MLCBO	338581	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/maxpro20sp-eag70ml-bait-spin-combo-338581	1
5	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	JORDON LEE BAITCAST COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	50-to-100	0.00	[empty string]	Jordon Lee Baitcast Combo	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	JLEELP/701MH	338585	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/jordon-lee-baitcast-combo-338585	1
6	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	JORDON LEE SPINNING COMBO JLSSSP30/701M	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	30	50-to-100	0.00	[empty string]	Jordon Lee Spinning Combo Jlsssp30/701m	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	JLEESP30/701M	338621	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/jordon-lee-spinning-combo-jlsssp30-701m-338621	1
7	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spincasting	[empty string]	0	269.99	0	269.99	[empty string]	269.99	[empty string]	VERITAS LOW PROFILE 7` MH COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	11	250-to-300	0.00	[empty string]	Veritas Low Profile 7` Mh Combo 1pc	[empty string]	[empty string]	N	269.99	269.99	[empty string]	[empty string]	[empty string]	1000	VTPLP/701MH	340898	SPINCASTING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-low-profile-7-mh-combo-1pc-340898	1
8	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spincasting	[empty string]	0	269.99	0	269.99	[empty string]	269.99	[empty string]	VERITAS LOW PROFILE 7` MH COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	250-to-300	0.00	[empty string]	Veritas Low Profile 7` Mh Combo 1pc	[empty string]	[empty string]	N	269.99	269.99	[empty string]	[empty string]	[empty string]	1000	VTPLP-L/701MH	340899	SPINCASTING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-low-profile-7-mh-combo-1pc-340899	1
9	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	REVO X BAITCAST 7` MH COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Revo X Baitcast 7` Mh Combo 1pc	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	REVO4XLP/701MH	340900	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/revo-x-baitcast-7-mh-combo-1pc-340900	1
10	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	JORDAN LEE BAITCAST 7` MH COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	Jordan Lee Baitcast 7` Mh Combo 1pc	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	JLEELP-L/701MH	340902	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/jordan-lee-baitcast-7-mh-combo-1pc-340902	1
11	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	REVO X SPINNING 7` M COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	100-to-150	0.00	[empty string]	Revo X Spinning 7` M Combo 1pc	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	REVO2X30/701M	340903	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/revo-x-spinning-7-m-combo-1pc-340903	1
12	6501,5501,6500,5500	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	6501\|NULL\|NULL,5501\|NULL\|NULL,6500\|NULL\|NULL,5500\|NULL\|NULL	0	69.99	1	59.99	[empty string]	69.99	[empty string]	AMBASSADEUR S ROUND REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	28	50-to-100	0.00	[empty string]	Ambassadeur S Round Reel	[empty string]	[empty string]	N	59.99	69.99	[empty string]	[empty string]	[empty string]	1000	AMBS	340908	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/ambassadeur-s-round-reel-340908	1
13	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Spincasting	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	MAX PRO SPINCAST REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Max Pro Spincast Reel	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	MAXPROSC10-C	340910	SPINCASTING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/max-pro-spincast-reel-340910	1
14	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	VERITAS WINCH CASTING ROD 70-6 MH	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Veritas Winch Casting Rod 70-6 Mh	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	VTPCW70-6	340916	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-winch-casting-rod-70-6-mh-340916	1
15	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	VERITAS WINCH CASTING ROD 76-6 MH	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Veritas Winch Casting Rod 76-6 Mh	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	VTPCW76-6	340917	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-winch-casting-rod-76-6-mh-340917	1
16	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	VERITAS FROG CASTING ROD 76-6 MH	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Veritas Frog Casting Rod 76-6 Mh	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	VTPCF76-6	340919	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-frog-casting-rod-76-6-mh-340919	1
17	767H,737H,705M	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	767H\|NULL\|NULL,737H\|NULL\|NULL,705M\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	VENDETTA CASTING ROD 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Vendetta Casting Rod 1pc	[empty string]	[empty string]	N	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	VDTC	340922	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/vendetta-casting-rod-1pc-340922	1
18	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	84.99	0	84.99	[empty string]	84.99	[empty string]	MAX PRO 6`6 2PC M SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	19	50-to-100	0.00	[empty string]	Max Pro 6`6 2pc M Spin Combo	[empty string]	[empty string]	N	84.99	84.99	[empty string]	[empty string]	[empty string]	1000	MAXPROSP30/662M	341240	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/max-pro-6-6-2pc-m-spin-combo-341240	1
19	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	84.99	0	84.99	[empty string]	84.99	[empty string]	MAX PRO 7`0 1PC M SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	Max Pro 7`0 1pc M Spin Combo	[empty string]	[empty string]	N	84.99	84.99	[empty string]	[empty string]	[empty string]	1000	MAXPROSP30/701M	341241	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/max-pro-7-0-1pc-m-spin-combo-341241	1
20	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	MAXX SP 6`6 1PC M SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	15	50-to-100	0.00	[empty string]	Maxx Sp 6`6 1pc M Spin Combo	[empty string]	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	MAXXSP30/661M	341242	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/maxx-sp-6-6-1pc-m-spin-combo-341242	1
21	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	MAXX SP 6`6 2PC M SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Maxx Sp 6`6 2pc M Spin Combo	[empty string]	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	MAXXSP30/662M	341243	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/maxx-sp-6-6-2pc-m-spin-combo-341243	1
22	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	74.99	0	74.99	[empty string]	74.99	[empty string]	MAXX SP 7`0 1PC M SPIN COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Maxx Sp 7`0 1pc M Spin Combo	[empty string]	[empty string]	N	74.99	74.99	[empty string]	[empty string]	[empty string]	1000	MAXXSP60/701MH	341244	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/maxx-sp-7-0-1pc-m-spin-combo-341244	1
23	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Spinning	[empty string]	0	37.99	1	32.99	[empty string]	37.99	[empty string]	MAXX SP SPINNING REEL BOX	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	66	25-to-50	0.00	[empty string]	Maxx Sp Spinning Reel Box	[empty string]	[empty string]	N	32.99	37.99	5,10,30,40,20	[empty string]	[empty string]	1000	MAXXSP	341248	SPINNING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/maxx-sp-spinning-reel-box-341248	1
24	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	GAR LOW PROFILE BAITCAST COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Gar Low Profile Baitcast Combo	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	BMAX3/662M	346373	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/gar-low-profile-baitcast-combo-346373	1
25	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spincasting	[empty string]	0	269.99	0	269.99	[empty string]	269.99	[empty string]	VERITAS LOW PROFILE 7`3 H COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	250-to-300	0.00	[empty string]	Veritas Low Profile 7`3 H Combo 1pc	[empty string]	[empty string]	N	269.99	269.99	[empty string]	[empty string]	[empty string]	1000	VTPLP/731H	350649	SPINCASTING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-low-profile-7-3-h-combo-1pc-350649	1
26	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spincasting	[empty string]	0	269.99	0	269.99	[empty string]	269.99	[empty string]	VERITAS LOW PROFILE-L 7`3 H COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	250-to-300	0.00	[empty string]	Veritas Low Profile-l 7`3 H Combo 1pc	[empty string]	[empty string]	N	269.99	269.99	[empty string]	[empty string]	[empty string]	1000	VTPLP-L/731H	350651	SPINCASTING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-low-profile-l-7-3-h-combo-1pc-350651	1
27	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	MAX PRO 7 MH SPIN COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	14	100-to-150	0.00	[empty string]	Max Pro 7 Mh Spin Combo 1pc	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	MAXPRO/701MH	350655	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/max-pro-7-mh-spin-combo-1pc-350655	1
28	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	MAX PRO 7`1 MH BAITCAST COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	20	100-to-150	0.00	[empty string]	Max Pro 7`1 Mh Baitcast Combo 1pc	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	MAXPRO-L/701MH	350657	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/max-pro-7-1-mh-baitcast-combo-1pc-350657	1
29	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	1	109.99	0	109.99	78812-DEFAULT-l.jpg	109.99	78812-DEFAULT-m.jpg	MAX STX 7 M BAITCAST COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Max Stx 7 M Baitcast Combo 1pc	[empty string]	[empty string]	N	109.99	109.99	[empty string]	78812-DEFAULT-s.jpg	[empty string]	1000	MAXSTX/701M	350661	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/max-stx-7-m-baitcast-combo-1pc-350661	1
30	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	MAX STX 7`1 MH BAITCAST COMBO 1PC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	19	100-to-150	0.00	[empty string]	Max Stx 7`1 Mh Baitcast Combo 1pc	[empty string]	[empty string]	N	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	MAXSTX/701MH	350665	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/max-stx-7-1-mh-baitcast-combo-1pc-350665	1
31	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Casting	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	AQUA MAX BAITCAST COMBO LP/7`1 MH	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Aqua Max Baitcast Combo Lp/7`1 Mh	[empty string]	[empty string]	N	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	AMAXLP/701MH	350668	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/aqua-max-baitcast-combo-lp-7-1-mh-350668	1
32	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	269.99	0	269.99	[empty string]	269.99	[empty string]	VERITAS 30SP 6`6 M 2PC COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	16	250-to-300	0.00	[empty string]	Veritas 30sp 6`6 M 2pc Combo	[empty string]	[empty string]	N	269.99	269.99	[empty string]	[empty string]	[empty string]	1000	VTPSP30/662M	350669	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-30sp-6-6-m-2pc-combo-350669	1
33	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	269.99	0	269.99	[empty string]	269.99	[empty string]	VERITAS 30SP 7`2 M 2PC COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	11	250-to-300	0.00	[empty string]	Veritas 30sp 7`2 M 2pc Combo	[empty string]	[empty string]	N	269.99	269.99	[empty string]	[empty string]	[empty string]	1000	VTPSP30/702M	350670	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-30sp-7-2-m-2pc-combo-350670	1
34	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	79.99	0	79.99	[empty string]	79.99	[empty string]	AQUA MAX SPINNING COMBO 30/6`6 M	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	Aqua Max Spinning Combo 30/6`6 M	[empty string]	[empty string]	N	79.99	79.99	[empty string]	[empty string]	[empty string]	1000	AMAXSP30/661M	350671	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/aqua-max-spinning-combo-30-6-6-m-350671	1
35	[empty string]	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Spinning	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	SHAKE US CUF LAKEPOND 602M 30P	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	21	50-to-100	0.00	[empty string]	Shake Us Cuf Lakepond 602m 30p	[empty string]	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	USCUFSPLAPO	350677	SPINNING	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/shake-us-cuf-lakepond-602m-30p-350677	1
36	27ML,28M,30L	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Spinning	27ML\|NULL\|NULL,28M\|NULL\|NULL,30L\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	VERITAS LTD ICE RODS	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Veritas Ltd Ice Rods	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	AVTILTD	350864	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-ltd-ice-rods-350864	1
37	28M,27ML,30L	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Ice	28M\|NULL\|NULL,27ML\|NULL\|NULL,30L\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	VERITAS LTD ICE COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	36	50-to-100	0.00	[empty string]	Veritas Ltd Ice Combo	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	AVTILTD-CBO	350865	ICE	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-ltd-ice-combo-350865	1
38	27ML,28M,26UL,34MH,30L	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Spinning	27ML\|NULL\|NULL,28M\|NULL\|NULL,26UL\|NULL\|NULL,34MH\|NULL\|NULL,30L\|NULL\|NULL	1	39.99	0	39.99	78812-DEFAULT-l.jpg	39.99	78812-DEFAULT-m.jpg	VERITAS ICE SPINNING ROD	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Veritas Ice Spinning Rod	[empty string]	[empty string]	N	39.99	39.99	[empty string]	78812-DEFAULT-s.jpg	[empty string]	1000	AVTI	351488	SPINNING	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-ice-spinning-rod-351488	1
39	30L,26UL	ABU GARCIA	Abu Garcia	FISHING	Fishing>Combos>Ice	30L\|NULL\|NULL,26UL\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	VERITAS ICE SPINNING COMBO	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Veritas Ice Spinning Combo	[empty string]	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	AVTI-CBO	351494	ICE	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	abu-garcia/veritas-ice-spinning-combo-351494	1
40	ROCKET,ROCKET-L	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	ROCKET\|NULL\|NULL,ROCKET-L\|NULL\|NULL	1	299.99	0	299.99	91765-DEFAULT-l.jpg	299.99	91765-DEFAULT-m.jpg	REVO ROCKET LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	Revo Rocket Low Profile Reel	[empty string]	[empty string]	N	299.99	299.99	10.1:1	91765-DEFAULT-s.jpg	[empty string]	1000	REVO4-ROCKET	353723	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/revo-rocket-low-profile-reel-353723	1
41	LH-41,RH-40	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	LH-41\|NULL\|NULL,RH-40\|NULL\|NULL	0	279.99	0	279.99	[empty string]	279.99	[empty string]	REVO BEAST LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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	250-to-300	0.00	[empty string]	Revo Beast Low Profile Reel	[empty string]	[empty string]	N	279.99	279.99	7.3:1HS	[empty string]	[empty string]	1000	REVO-BEAST	353724	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/revo-beast-low-profile-reel-353724	1
42	C3,C4	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	C3\|NULL\|NULL,C4\|NULL\|NULL	1	129.99	1	119.99	90562-DEFAULT-l.jpg	129.99	90562-DEFAULT-m.jpg	AMBASSADEUR ROUND REEL CLASSIC	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	30	100-to-150	0.00	[empty string]	Ambassadeur Round Reel Classic	[empty string]	[empty string]	N	119.99	129.99	5501-L,6500-HS,5500,6501-HS-L	90562-DEFAULT-s.jpg	[empty string]	1000	C3/C4	353791	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/ambassadeur-round-reel-classic-353791	1
43	MAXSTXSP	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Spinning	MAXSTXSP\|NULL\|NULL	0	42.99	0	42.99	[empty string]	42.99	[empty string]	MAXX SP SPINNING REEL BOX	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	Maxx Sp Spinning Reel Box	[empty string]	[empty string]	N	42.99	42.99	5	[empty string]	[empty string]	1000	MAXSTXSP	353819	SPINNING	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/maxx-sp-spinning-reel-box-353819	1
44	BMAX3,BMAX3-L	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	BMAX3\|NULL\|NULL,BMAX3-L\|NULL\|NULL	1	49.99	0	49.99	53463-DEFAULT-l.jpg	49.99	53463-DEFAULT-m.jpg	GAR LOW PROFILE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Black Max - Low Profile - Baitcasting - Right Hand	<p>The upgraded Black Max low profile baitcast reel delivers class-leading performance in a compact, lightweight design. The new generation of Max reels incorporates new styling with the proven value and reliability that anglers have come to expect from this series.</p>	[empty string]	N	49.99	49.99	6.4:1	53463-DEFAULT-s.jpg	[empty string]	1000	BMAX3	353823	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/gar-low-profile-353823	1
45	MAX4XL,MAX4X	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	MAX4XL\|NULL\|NULL,MAX4X\|NULL\|NULL	0	54.99	0	54.99	[empty string]	54.99	[empty string]	MAX X LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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]	13	50-to-100	0.00	[empty string]	Max X Low Profile Reel	[empty string]	[empty string]	N	54.99	54.99	6.4:1	[empty string]	[empty string]	1000	MAX4X	353826	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/max-x-low-profile-reel-353826	1
46	X	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	X\|NULL\|NULL	1	129.99	1	99.99	91473-DEFAULT-l.jpg	129.99	91473-DEFAULT-m.jpg	REVO LOW PROFILE REEL S/X	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[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	50-to-100	0.00	[empty string]	Revo Low Profile Reel S/x	[empty string]	[empty string]	N	99.99	129.99	6.6:1,6.6:1L	91473-DEFAULT-s.jpg	[empty string]	1000	REVO4	353840	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/revo-low-profile-reel-s-x-353840	1
47	ZATA	ABU GARCIA	Abu Garcia	FISHING	Fishing>Reels>Casting	ZATA\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	ZATA LOW PROFILE REEL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	150-to-200	0.00	[empty string]	Zata Low Profile Reel	[empty string]	[empty string]	N	169.99	169.99	7.1:1HS,7.1:1HSL	[empty string]	[empty string]	1000	ZATA	353868	EMPTY	EMPTY	EMPTY	0	0	0	REELS	[empty string]	abu-garcia/zata-low-profile-reel-353868	1
48	69-6 MH,73-6 MH,70-7 H,76-7 H,70-5 M,610-6 MH,610-4 ML,70-6 MH,73-7 H	ABU GARCIA	Abu Garcia	FISHING	Fishing>Rods>Casting	69-6 MH\|NULL\|NULL,73-6 MH\|NULL\|NULL,70-7 H\|NULL\|NULL,76-7 H\|NULL\|NULL,70-5 M\|NULL\|NULL,610-6 MH\|NULL\|NULL,610-4 ML\|NULL\|NULL,70-6 MH\|NULL\|NULL,73-7 H\|NULL\|NULL	0	119.99	1	99.99	[empty string]	119.99	[empty string]	VERITAS CASTING ROD	N	7 BRYAN	[empty string]	[empty string]	[empty string]	PF	[empty string]	[empty string]	[empty string]	PURE FISHING	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	31	50-to-100	0.00	[empty string]	Veritas Casting Rod	[empty string]	[empty string]	N	99.99	119.99	VTPC	[empty string]	[empty string]	1000	VTPC	356877	EMPTY	EMPTY	EMPTY	0	0	0	RODS	[empty string]	abu-garcia/veritas-casting-rod-356877	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Categories

Brand

Size

Black Max Combo - Baitcasting - 7 Feet

Veritas - Casting - 6 Feet 9 Inches - Medium Heavy

Ambassadeur S Line Counter

Maxpro20sp/Eag70ml Bait Spin Combo

Jordon Lee Baitcast Combo

Jordon Lee Spinning Combo Jlsssp30/701m

Veritas Low Profile 7 ` Mh Combo 1pc

Veritas Low Profile 7 ` Mh Combo 1pc

Revo X Baitcast 7 ` Mh Combo 1pc

Jordan Lee Baitcast 7 ` Mh Combo 1pc

Revo X Spinning 7 ` M Combo 1pc

Ambassadeur S Round Reel

Max Pro Spincast Reel

Veritas Winch Casting Rod 70- 6 Mh

Veritas Winch Casting Rod 76- 6 Mh

Veritas Frog Casting Rod 76- 6 Mh

Vendetta Casting Rod 1pc

Max Pro 6 ` 6 2pc M Spin Combo

Max Pro 7 ` 0 1pc M Spin Combo

Maxx Sp 6 ` 6 1pc M Spin Combo

Maxx Sp 6 ` 6 2pc M Spin Combo

Maxx Sp 7 ` 0 1pc M Spin Combo

Maxx Sp Spinning Reel Box

Gar Low Profile Baitcast Combo