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]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	MIDGE WP BOX	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	ONLINE	[empty string]	[empty string]	18	5-to-10	0.00	[empty string]	Double Sided Waterproof Fly Boxes - 4.25" X 3"	<p>These Fly Boxes are strong, durable, clarified ABS plastic boxes with positive snap tight latch and stainless steel hinge pins.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	FG1448	258124	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/midge-wp-box-258124	1
2	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	VEST WP BOX	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	ONLINE	[empty string]	[empty string]	24	10-to-15	0.00	[empty string]	Double Sided Waterproof Fly Boxes - 5" X 3.5"	<p>These Fly Boxes are strong, durable, clarified ABS plastic boxes with positive snap tight latch and stainless steel hinge pins.</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	FG1449	258126	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/vest-wp-box-258126	1
3	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	MEDIUM WP BOX	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	ONLINE	[empty string]	[empty string]	34	10-to-15	0.00	[empty string]	Double Sided Waterproof Fly Boxes - 5" X 4"	<p>These Fly Boxes are strong, durable, clarified ABS plastic boxes with positive snap tight latch and stainless steel hinge pins.</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	FG1450	258128	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/medium-wp-box-258128	1
4	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	LARGE WP BOX	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	ONLINE	[empty string]	[empty string]	31	10-to-15	0.00	[empty string]	Double Sided Waterproof Fly Boxes - 6" X 4"	<p>These Fly Boxes are strong, durable, clarified ABS plastic boxes with positive snap tight latch and stainless steel hinge pins.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	FG1454	258129	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/large-wp-box-258129	1
5	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	11.99	0	11.99	[empty string]	11.99	[empty string]	MEDIUM POLYCARB BOX	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	10-to-15	0.00	[empty string]	Medium Polycarb Box	[empty string]	[empty string]	N	11.99	11.99	[empty string]	[empty string]	[empty string]	1000	FG1268	258130	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/medium-polycarb-box-258130	1
6	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	SLIM BOX TALL TEARDROP FOAM	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]	31	5-to-10	0.00	[empty string]	Slim Box Tall Teardrop Foam	[empty string]	[empty string]	N	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	FG1420	258131	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/slim-box-tall-teardrop-foam-258131	1
7	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	SLIM BOX TALL 12 COMPARTMENT	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]	23	5-to-10	0.00	[empty string]	Slim Box Tall 12 Compartment	[empty string]	[empty string]	N	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	FG1421	258132	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/slim-box-tall-12-compartment-258132	1
8	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	13.99	0	13.99	[empty string]	13.99	[empty string]	GO TO BOX	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	ONLINE	[empty string]	[empty string]	50	10-to-15	0.00	[empty string]	The Go To Box	<p>Trout, Steelhead, Bass, Blue Fill, Carp, a fisherman never knows what kind of fish he will be chasing from day to day. To be prepared, all fisherman need a "Go To box." A box that will allow you to fish for whatever and whenever the opportunity presents itself. With a detachable swing lead, positive latch, and sure grip exterior, hundreds of flies can call this box home. This is a rugged, durable, watertight box that anglers will utilize for years.</p>	[empty string]	N	13.99	13.99	[empty string]	[empty string]	[empty string]	1000	FG1209	258133	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/go-to-box-258133	1
9	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	GO TO BOX W/O SWINGLEAF	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	ONLINE	[empty string]	[empty string]	51	10-to-15	0.00	[empty string]	Go To Box Without Swing Leaf	<p>This same rugged, stylish water proof box as the FG 1209, but with the "inline" foam inserts on both sides and no swing leaf. The extra middle space makes this box an excellent choice for various larger size flies, streamers, large dry flies, leeches, and steelhead patterns.</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	FG1211	258134	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/go-to-box-w-o-swingleaf-258134	1
10	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	SMALL FLY BOX	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	ONLINE	[empty string]	[empty string]	47	5-to-10	0.00	[empty string]	Small Fly Box	<p>For those looking for a small water tight box, this is it! Besides holding over 200 flies, it has a sure grip ribbed exterior and a positive latch.</p>	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	FG 1205	258135	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/small-fly-box-258135	1
11	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	15.99	0	15.99	[empty string]	15.99	[empty string]	ADJUSTAMAG NET KEEPER	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	ONLINE	[empty string]	[empty string]	22	15-to-20	0.00	[empty string]	Adjustamag Magnetic Net Retainer	<p>The Adjustamag net keeper features a unique tension adjustment system which allows you to set the strength of the magnet to your preference.</p>	[empty string]	N	15.99	15.99	[empty string]	[empty string]	[empty string]	1000	FG1911	258136	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/adjustamag-net-keeper-258136	1
12	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	HOOK SHARPENING FILE	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	ONLINE	[empty string]	[empty string]	19	5-to-10	0.00	[empty string]	Hook Sharpening File	<p>Two sided stainless steel file with diamond grit surfaces and grooves on both sides.</p>	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	FG1912	258137	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/hook-sharpening-file-258137	1
13	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	0.69	0	0.69	[empty string]	0.69	[empty string]	FLY CUP TETHERED LID	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]	31	5-AND-under	0.00	[empty string]	Fly Cup Tethered Lid	[empty string]	[empty string]	N	0.69	0.69	[empty string]	[empty string]	[empty string]	1000	FG1385	258138	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/fly-cup-tethered-lid-258138	1
14	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	23.99	0	23.99	[empty string]	23.99	[empty string]	CLASSIC CANVAS/SHEEPSKIN FLY WALLET	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	20-to-25	0.00	[empty string]	Classic Canvas/sheepskin Fly Wallet	[empty string]	[empty string]	N	23.99	23.99	[empty string]	[empty string]	[empty string]	1000	1224	271564	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/classic-canvas-sheepskin-fly-wallet-271564	1
15	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	4.59	0	4.59	[empty string]	4.59	[empty string]	RIGGING FOAM SPOOLS W/CUP	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]	13	5-AND-under	0.00	[empty string]	Rigging Foam Spools W/cup	[empty string]	[empty string]	N	4.59	4.59	[empty string]	[empty string]	[empty string]	1000	1938	276627	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/rigging-foam-spools-w-cup-276627	1
16	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	1.19	0	1.19	[empty string]	1.19	[empty string]	JUMBO FLY CUP	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	ONLINE	[empty string]	[empty string]	16	5-AND-under	0.00	[empty string]	Jumbo Fly Cups	<p>Specifically designed for extra large flies, New Phase's Jumbo Fly Cups are 3" diameter and 1 3/8" deep with a tethered lid. Made of clarified polypropylene.</p>	[empty string]	N	1.19	1.19	[empty string]	[empty string]	[empty string]	1000	1387	276628	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/jumbo-fly-cup-276628	1
17	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	SLIM BOX SHORT/TEARDROP FOAM	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	ONLINE	[empty string]	[empty string]	32	5-to-10	0.00	[empty string]	Slim Boxes - Tear Drop Foam	<p>The Slim Box is made from tough, clarified polypropylene. These 1/2" thick minimalist boxes will keep you loaded with midges and options while keeping the bulk down.</p>	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	1426	276629	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/slim-box-short-teardrop-foam-276629	1
18	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	WATERPROOF SLIM BOX FOAM 2 COMPARTMENT	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	27	10-to-15	0.00	[empty string]	Waterproof Thin Boxes	<p>These thin waterproof boxes have secure waterproof latches, high density rubbers seals, and magnetic inserts in each compartment. These boxes have more depth than our standard slim boxes to fit larger flies.</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	1320	276630	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/waterproof-slim-box-foam-2-compartment-276630	1
19	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	26.99	0	26.99	[empty string]	26.99	[empty string]	CATCH AND RELEASE NET	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	ONLINE	[empty string]	[empty string]	20	25-to-50	0.00	[empty string]	Catch & Release Landing Net	<p>New Phase's soft & durable clear rubber net material protects delicate fish and won’t snag flies. It also will not tangle, rot, or mildew.</p>	[empty string]	N	26.99	26.99	[empty string]	[empty string]	[empty string]	1000	1934	276631	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/catch-and-release-net-276631	1
20	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	FLYBRUARY OF CONGRESS WATERPROOF BOX	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	25-to-50	0.00	[empty string]	Flybruary Of Congress Waterproof Box	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	FG 1275	310636	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/flybruary-of-congress-waterproof-box-310636	1
21	OLIVE	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	OLIVE\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	TETON SLING PACK	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]	20	50-to-100	0.00	[empty string]	Teton Sling Pack	[empty string]	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	FG 1809	310637	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/teton-sling-pack-310637	1
22	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	22.99	0	22.99	[empty string]	22.99	[empty string]	ROD TUBE	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	ONLINE	[empty string]	[empty string]	7	20-to-25	0.00	[empty string]	Rod Tube	<p>This Rod Tube is a 30” rod tube made with ABS and nylon, zip closure, includes foam ends to protect rod tips. Inside length of 30” fits a 4 piece 9 foot rod.</p>	[empty string]	N	22.99	22.99	[empty string]	[empty string]	[empty string]	1000	1813	310639	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/rod-tube-310639	1
23	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	RIPPLE FOAM FLY PATCH HOOK AND LOOP BACKING	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]	18	5-to-10	0.00	[empty string]	Ripple Foam Fly Patch Hook And Loop Backing	[empty string]	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	1928	310641	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/ripple-foam-fly-patch-hook-and-loop-backing-310641	1
24	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	FLY DRYING PATCH	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]	Fly Drying Patch	[empty string]	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	1924	310644	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/fly-drying-patch-310644	1
25	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	3.99	0	3.99	[empty string]	3.99	[empty string]	SMALL PROMO BOX 6 COMPARTMENT	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	25	5-AND-under	0.00	[empty string]	Small Promo Box 6 Compartment	[empty string]	[empty string]	N	3.99	3.99	[empty string]	[empty string]	[empty string]	1000	1240	310816	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/small-promo-box-6-compartment-310816	1
26	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	18.99	0	18.99	[empty string]	18.99	[empty string]	XL WATERPROOF CLEAR SLIM FLY BOX	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	8	15-to-20	0.00	[empty string]	Xl Waterproof Slim Box	<p>1363 XL waterproof slim box with slit foam. Same design as our slim waterproof boxes now larger and with added depth to handle larger flies and streamers.</p>	[empty string]	N	18.99	18.99	[empty string]	[empty string]	[empty string]	1000	FG 1363	310817	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/xl-waterproof-clear-slim-fly-box-310817	1
27	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	0.99	0	0.99	[empty string]	0.99	[empty string]	GREEN TETHERED LID CUPS	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	209	5-AND-under	0.00	[empty string]	Green Biobased Fly Cup	<p>Made from a blend of USDA Certified Biobased product, these green cups are compostable, recyclable, reusable and inceneratable. They have a long shelf life but are degraded by bacteria in soil.</p>	[empty string]	N	0.99	0.99	[empty string]	[empty string]	[empty string]	1000	1384	310818	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/green-tethered-lid-cups-310818	1
28	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	1.49	0	1.49	[empty string]	1.49	[empty string]	XL SNAPPY CONTAINER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	50	5-AND-under	0.00	[empty string]	Xl Snappy Container	[empty string]	[empty string]	N	1.49	1.49	[empty string]	[empty string]	[empty string]	1000	1388N	310819	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/xl-snappy-container-310819	1
29	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	CLEAR BOX WITH GRAY LINER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	24	5-to-10	0.00	[empty string]	Clear Box With Gray Liner	[empty string]	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	1463N	310821	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/clear-box-with-gray-liner-310821	1
30	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	BELT CLIP ROD HOLDER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	9	10-to-15	0.00	[empty string]	Belt Clip Rod Holder	[empty string]	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	1906	310822	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/belt-clip-rod-holder-310822	1
31	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	40` TAPE MEASURE ZINGER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	17	5-to-10	0.00	[empty string]	40` Tape Measure Zinger	[empty string]	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	1909	310824	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/40-tape-measure-zinger-310824	1
32	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Gear Storage>Tackle Boxes	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	SILICON BOAT PATCH	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	5-to-10	0.00	[empty string]	Silicon Boat Patch	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	1324	328944	TACKLE BOXES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	new-phase-fly-fishing/silicon-boat-patch-328944	1
33	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Gear Storage>Tackle Boxes	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	STANDARD LYCRA COVERED TROUT DESIGN BOX	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	15-to-20	0.00	[empty string]	Standard Lycra Covered Trout Design Box	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	M1532	328945	TACKLE BOXES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	new-phase-fly-fishing/standard-lycra-covered-trout-design-box-328945	1
34	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	STAINLESS STEEL ZINGER WITH CARABINEER	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	5-AND-under	0.00	[empty string]	Stainless Steel Zinger With Carabineer	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	1910	328946	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/stainless-steel-zinger-with-carabineer-328946	1
35	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	COMBO NIPPER WITH KNOT TOOL AND HOOK FILE	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	5-AND-under	0.00	[empty string]	Combo Nipper With Knot Tool And Hook File	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	2105	328947	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/combo-nipper-with-knot-tool-and-hook-file-328947	1
36	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Gear Storage>Tackle Boxes	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	GO TO DROPPER RIG BOX	N	7 BRYAN	[empty string]	[empty string]	[empty string]	F	[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]	40	15-to-20	0.00	[empty string]	Go To Dropper Rig Box	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	1210	342931	TACKLE BOXES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	new-phase-fly-fishing/go-to-dropper-rig-box-342931	1
37	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	KNOT TOOL	N	7 BRYAN	[empty string]	[empty string]	[empty string]	F	[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	5-AND-under	0.00	[empty string]	Knot Tool	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	1916	342935	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/knot-tool-342935	1
38	[empty string]	NEW PHASE FLY FISHING	New Phase Fly Fishing	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	YANKEE FORK WATERPROOF BACKPACK 40L	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	150-to-200	0.00	[empty string]	Yankee Fork Waterproof Backpack 40l	[empty string]	[empty string]	N	169.99	169.99	[empty string]	[empty string]	[empty string]	1000	3001	357919	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	new-phase-fly-fishing/yankee-fork-waterproof-backpack-40l-357919	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

Double Sided Waterproof Fly Boxes - 4.25 " X 3 "

Double Sided Waterproof Fly Boxes - 5 " X 3.5 "

Double Sided Waterproof Fly Boxes - 5 " X 4 "

Double Sided Waterproof Fly Boxes - 6 " X 4 "

Medium Polycarb Box

Slim Box Tall Teardrop Foam

Slim Box Tall 12 Compartment

The Go To Box

Go To Box Without Swing Leaf

Small Fly Box

Adjustamag Magnetic Net Retainer

Hook Sharpening File

Fly Cup Tethered Lid

Classic Canvas/Sheepskin Fly Wallet

Rigging Foam Spools W/Cup

Jumbo Fly Cups

Slim Boxes - Tear Drop Foam

Waterproof Thin Boxes

Catch & Release Landing Net

Flybruary Of Congress Waterproof Box

Teton Sling Pack

Rod Tube

Ripple Foam Fly Patch Hook And Loop Backing

Fly Drying Patch