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]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	BEGINNERS FLY TYING KIT	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	100-to-150	0.00	[empty string]	Beginners Fly Tying Kit	[empty string]	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	35050	122143	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/beginners-fly-tying-kit-122143	1
2	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	13.99	0	13.99	[empty string]	13.99	[empty string]	UPG RETRACTOR SMALL	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]	11	10-to-15	0.00	[empty string]	Upg Retractor Small	[empty string]	[empty string]	N	13.99	13.99	[empty string]	[empty string]	[empty string]	1000	33060	122276	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/upg-retractor-small-122276	1
3	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	UPG RETRACTOR LARGE	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]	12	15-to-20	0.00	[empty string]	Upg Retractor Large	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	33065	122277	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/upg-retractor-large-122277	1
4	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	INSTA-SET INDICATOR RED LARGE	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]	8	5-to-10	0.00	[empty string]	Insta-set Indicator Red Large	[empty string]	[empty string]	N	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	30536	130507	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/insta-set-indicator-red-large-130507	1
5	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	44.99	0	44.99	[empty string]	44.99	[empty string]	BABY BOAT 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]	4	25-to-50	0.00	[empty string]	Baby Boat Box	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	30860	146064	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/baby-boat-box-146064	1
6	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	RIVER GRIP 6 IN. SCISSOR CLAMP BLUE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	32	15-to-20	0.00	[empty string]	River Grip Scissor Clamp - 6 Inch	<p>The workhorse and first choice of guides, this beefy scissor clamp will crimp barbs, cut line or even a small branch to free snagged lines. Features one oversized finger loop for easy use. The jaws are half-serrated and half-smooth.</p>	[empty string]	N	16.99	16.99	[empty string]	[empty string]	[empty string]	1000	30275	171077	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/river-grip-6-in-scissor-clamp-blue-171077	1
7	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	BUG FLOTE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	186	5-to-10	0.00	[empty string]	Bug Flote	<p>Bug Flote is an excellent gel to keep your dry flies looking natural and floating on top of the water. It also works great on line, yarn strike indicators, and leaders.</p>	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	30251	171995	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/bug-flote-171995	1
8	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	TIEMCO SHIMAZAKI DRY SHAKE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	84	15-to-20	0.00	[empty string]	Tmc Shimazaki Dry Shake	<p>Great for drying and reconditioning flies. When your dry fly begins to sink, just put it in the dry shake container and shake it. The absorbing powder in the bottle removes the moisture from the fly and coats it with a water resistant material. Your fly will again float like new.</p>	[empty string]	N	16.99	16.99	[empty string]	[empty string]	[empty string]	1000	30254	171996	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/tiemco-shimazaki-dry-shake-171996	1
9	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	HC STREAMER CRUISER CHART-WHITE 2-0	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]	10	15-to-20	0.00	[empty string]	Hc Streamer Cruiser Chart-white 2-0	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	18821	178488	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/hc-streamer-cruiser-chart-white-2-0-178488	1
10	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	HC STREAMER GAME CHANGER PEARL-WHT. 2-0	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]	13	15-to-20	0.00	[empty string]	Hc Streamer Game Changer Pearl-wht. 2-0	[empty string]	[empty string]	N	16.99	16.99	[empty string]	[empty string]	[empty string]	1000	70313	178489	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/hc-streamer-game-changer-pearl-wht-2-0-178489	1
11	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	HC STREAMER GAME CHANGER RAINBOW 2-0	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]	23	15-to-20	0.00	[empty string]	Hc Streamer Game Changer Rainbow 2-0	[empty string]	[empty string]	N	16.99	16.99	[empty string]	[empty string]	[empty string]	1000	70314	178490	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/hc-streamer-game-changer-rainbow-2-0-178490	1
12	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	HC STREAMER MURDICH WIGGLER TAN SZ.2	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	5-to-10	0.00	[empty string]	Hc Streamer Murdich Wiggler Tan Sz.2	[empty string]	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	18108	178492	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/hc-streamer-murdich-wiggler-tan-sz-2-178492	1
13	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	HC STREAMER BIG FISH DECEIVER BLU-WHT 3-	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]	Hc Streamer Big Fish Deceiver Blu-wht 3-	[empty string]	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	15503	178497	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/hc-streamer-big-fish-deceiver-blu-wht-3-178497	1
14	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	RIVER GRIP TUNGSTEN CARBIDE NIPPER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	River Grip Tungsten Carbide Nipper	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	30552	257791	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/river-grip-tungsten-carbide-nipper-257791	1
15	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	BASS POPPER SZ.6 MR. MIDNIGHT	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	5-AND-under	0.00	[empty string]	Bass Popper Sz.6 Mr. Midnight	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	70659	259175	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/bass-popper-sz-6-mr-midnight-259175	1
16	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	BASS POPPER SZ.6 MR. MINNOW	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	5-AND-under	0.00	[empty string]	Bass Popper Sz.6 Mr. Minnow	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	70661	259178	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/bass-popper-sz-6-mr-minnow-259178	1
17	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	BASS POPPER SZ.6 MOSS MAN	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-AND-under	0.00	[empty string]	Bass Popper Sz.6 Moss Man	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	70663	259180	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/bass-popper-sz-6-moss-man-259180	1
18	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	BASS POPPER SZ.6 ORANGE SPLATTER	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]	10	5-AND-under	0.00	[empty string]	Bass Popper Sz.6 Orange Splatter	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	70665	259182	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/bass-popper-sz-6-orange-splatter-259182	1
19	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	DREAMSTREAM CLAMP 5 IN. STRAIGHT BLK.	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]	5	5-to-10	0.00	[empty string]	Dreamstream Clamp 5 In. Straight Blk.	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	30602	268775	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/dreamstream-clamp-5-in-straight-blk-268775	1
20	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	10.99	0	10.99	[empty string]	10.99	[empty string]	DREAMSTREAM 5 IN. CURVE BLACK	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Dreamstream 5 In. Curve Black	[empty string]	[empty string]	N	10.99	10.99	[empty string]	[empty string]	[empty string]	1000	30606	268779	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/dreamstream-5-in-curve-black-268779	1
21	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	DREAMSTREAM NIPPER/KNOT BLK	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]	5	5-to-10	0.00	[empty string]	Dream Stream Nipper Nkt	<p>Workhorse nippers w/nail-knot tool at a great price.</p>	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	30665	268802	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/dreamstream-nipper-knot-blk-268802	1
22	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	DREAMSTREAM HOOK FILE BLK	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Dream Stream Hook File	<p>This two-sided file has grooves for sharpening the hook’s bottom and flat areas for the sides of the hook.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	30600	268804	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/dreamstream-hook-file-blk-268804	1
23	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	8.99	0	8.99	[empty string]	8.99	[empty string]	STAY HUNGRY STREAMER CHART/WHITE SZ.2	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]	7	5-to-10	0.00	[empty string]	Stay Hungry Streamer Chart/white Sz.2	[empty string]	[empty string]	N	8.99	8.99	[empty string]	[empty string]	[empty string]	1000	13451	270303	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/stay-hungry-streamer-chart-white-sz-2-270303	1
24	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	5.49	0	5.49	[empty string]	5.49	[empty string]	SLUMP BUSTER BARRS	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]	29	5-to-10	0.00	[empty string]	Slump Buster Barrs	[empty string]	[empty string]	N	5.49	5.49	[empty string]	[empty string]	[empty string]	1000	13537-00	301812	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/slump-buster-barrs-301812	1
25	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	5.49	0	5.49	[empty string]	5.49	[empty string]	CLEAR WING SPINNER HEX	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]	27	5-to-10	0.00	[empty string]	Clear Wing Spinner Hex	[empty string]	[empty string]	N	5.49	5.49	[empty string]	[empty string]	[empty string]	1000	19438-00	301896	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/clear-wing-spinner-hex-301896	1
26	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	HOME INVADER	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-to-10	0.00	[empty string]	Home Invader	[empty string]	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	19508-00	301898	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/home-invader-301898	1
27	CHART 10697,WHT 10699,BLK 10840	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	CHART 10697\|NULL\|NULL,WHT 10699\|NULL\|NULL,BLK 10840\|NULL\|NULL	0	7.99	0	7.99	[empty string]	7.99	[empty string]	MEAT WHISTLE	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	5-to-10	0.00	[empty string]	Meat Whistle	[empty string]	[empty string]	N	7.99	7.99	1/0	[empty string]	[empty string]	1000	MEAT WHISTLE	301926	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/meat-whistle-301926	1
28	CHT/WHT 15502,BLU/WHT 15503	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	CHT/WHT 15502\|NULL\|NULL,BLU/WHT 15503\|NULL\|NULL	0	6.99	0	6.99	[empty string]	6.99	[empty string]	BIG FISH DECEIVER	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]	Big Fish Deceiver	[empty string]	[empty string]	N	6.99	6.99	3/0	[empty string]	[empty string]	1000	BIG FISH DECEIVER	302003	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/big-fish-deceiver-302003	1
29	OLV 19749,WHT 19750,TAN 19748	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	OLV 19749\|NULL\|NULL,WHT 19750\|NULL\|NULL,TAN 19748\|NULL\|NULL	0	8.99	0	8.99	[empty string]	8.99	[empty string]	CIRCUS PEANUT	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]	26	5-to-10	0.00	[empty string]	Circus Peanut	[empty string]	[empty string]	N	8.99	8.99	[empty string]	[empty string]	[empty string]	1000	CIRCUS PEANUT	302066	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/circus-peanut-302066	1
30	CHART.SPLAT,MR.MINNOW,SNW.WHT,MR.MIDNIGHT,FROGGYBTTM,CO.MUSTARD,ORG.SPLAT,GRN.SPLAT,MOSSMAN	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	CHART.SPLAT\|NULL\|NULL,MR.MINNOW\|NULL\|NULL,SNW.WHT\|NULL\|NULL,MR.MIDNIGHT\|NULL\|NULL,FROGGYBTTM\|NULL\|NULL,CO.MUSTARD\|NULL\|NULL,ORG.SPLAT\|NULL\|NULL,GRN.SPLAT\|NULL\|NULL,MOSSMAN\|NULL\|NULL	0	6.99	0	6.99	[empty string]	6.99	[empty string]	BASS POPPER	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]	98	5-to-10	0.00	[empty string]	Bass Popper	[empty string]	[empty string]	N	6.99	6.99	10,06	[empty string]	[empty string]	1000	BASS POPPER	302073	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/bass-popper-302073	1
31	CHART/WHT,COP/YEL,COP,GLD,GRY/WHT,RNBW	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	CHART/WHT\|NULL\|NULL,COP/YEL\|NULL\|NULL,COP\|NULL\|NULL,GLD\|NULL\|NULL,GRY/WHT\|NULL\|NULL,RNBW\|NULL\|NULL	0	7.99	0	7.99	[empty string]	7.99	[empty string]	MURDICH MINI MINNOW	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]	50	5-to-10	0.00	[empty string]	Murdich Mini Minnow	[empty string]	[empty string]	N	7.99	7.99	4	[empty string]	[empty string]	1000	MURDICH MINI MINNOW	302075	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/murdich-mini-minnow-302075	1
32	TANTRKY,OLV/GRN,DKBRNTKY	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	TANTRKY\|NULL\|NULL,OLV/GRN\|NULL\|NULL,DKBRNTKY\|NULL\|NULL	0	4.49	0	4.49	[empty string]	4.49	[empty string]	CLOUSER CRAYFISH	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]	64	5-AND-under	0.00	[empty string]	Clouser Crayfish	[empty string]	[empty string]	N	4.49	4.49	08,06,10	[empty string]	[empty string]	1000	CLOUSER CRAYFISH	303868	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/clouser-crayfish-303868	1
33	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	MOUSERAT BLACK 06	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]	10	5-to-10	0.00	[empty string]	Mouserat Black 06	[empty string]	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	10535-00	304674	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/mouserat-black-06-304674	1
34	DIRTYOLV,BRN	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	DIRTYOLV\|NULL\|NULL,BRN\|NULL\|NULL	0	7.99	0	7.99	[empty string]	7.99	[empty string]	NEAR NUFF CRAYFISH	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]	43	5-to-10	0.00	[empty string]	Near Nuff Crayfish	[empty string]	[empty string]	N	7.99	7.99	6,8	[empty string]	[empty string]	1000	NEAR NUFF CRAYFISH	304675	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/near-nuff-crayfish-304675	1
35	NAT,BLK	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	NAT\|NULL\|NULL,BLK\|NULL\|NULL	0	6.99	0	6.99	[empty string]	6.99	[empty string]	MOUSERAT	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]	100	5-to-10	0.00	[empty string]	Mouserat	[empty string]	[empty string]	N	6.99	6.99	6	[empty string]	[empty string]	1000	MOUSERAT	304699	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/mouserat-304699	1
36	NAT	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	NAT\|NULL\|NULL	0	5.99	0	5.99	[empty string]	5.99	[empty string]	MINI MOUSE	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]	41	5-to-10	0.00	[empty string]	Mini Mouse	[empty string]	[empty string]	N	5.99	5.99	10	[empty string]	[empty string]	1000	MINI MOUSE	304700	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/mini-mouse-304700	1
37	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Tools	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	RIVER GRIP TUNGSTEN CARBIDE NIPPER ORANGE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	River Grip Tungsten Carbide Nipper Orange	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	32055	310502	FLY FISHING	TOOLS	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/river-grip-tungsten-carbide-nipper-orange-310502	1
38	GRAY	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Gear Storage>Tackle Boxes	GRAY\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	UPG LT STANDARD BOX	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Upg Lt Standard Box	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	30870	318675	TACKLE BOXES	EMPTY	EMPTY	0	0	0	GEAR STORAGE	[empty string]	umpqua-feather-merchants/upg-lt-standard-box-318675	1
39	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	MURDICH WIGGLER ROOT BEER SZ.2	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]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Murdich Wiggler Root Beer Sz.2	[empty string]	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	18107	329672	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/murdich-wiggler-root-beer-sz-2-329672	1
40	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	8.99	0	8.99	[empty string]	8.99	[empty string]	MURDICH MINNOW CHRT/WHT 1/0	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]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Murdich Minnow Chrt/wht 1/0	[empty string]	[empty string]	N	8.99	8.99	[empty string]	[empty string]	[empty string]	1000	10800	329673	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/murdich-minnow-chrt-wht-1-0-329673	1
41	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	[empty string]	0	5.49	0	5.49	[empty string]	5.49	[empty string]	CLEAR WING SPINNER HEX	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]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	24	5-to-10	0.00	[empty string]	Clear Wing Spinner Hex	[empty string]	[empty string]	N	5.49	5.49	6	[empty string]	[empty string]	1000	19438	329675	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/clear-wing-spinner-hex-329675	1
42	[empty string]	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Line and Leader>Fly Lines, Leaders, and Tippet	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	TIPPET RINGS 2MM 10PK	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	25	10-to-15	0.00	[empty string]	Tippet Rings 2mm 10pk	[empty string]	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	59195	329701	FLY LINES, LEADERS, AND TIPPET	EMPTY	EMPTY	0	0	0	LINE AND LEADER	[empty string]	umpqua-feather-merchants/tippet-rings-2mm-10pk-329701	1
43	NATURAL	UMPQUA FEATHER MERCHANTS	Umpqua Feather Merchants	FISHING	Fishing>Specialty>Fly Fishing>Flies	NATURAL\|NULL\|NULL	0	5.49	0	5.49	[empty string]	5.49	[empty string]	SLUMP BUSTER 10 BARRS	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	5-to-10	0.00	[empty string]	Slump Buster 10 Barrs	[empty string]	[empty string]	N	5.49	5.49	10	[empty string]	[empty string]	1000	13539	334175	FLY FISHING	FLIES	EMPTY	0	0	0	SPECIALTY	[empty string]	umpqua-feather-merchants/slump-buster-10-barrs-334175	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

Beginners Fly Tying Kit

Upg Retractor Small

Upg Retractor Large

Insta- Set Indicator Red Large

Baby Boat Box

River Grip Scissor Clamp - 6 Inch

Bug Flote

Tmc Shimazaki Dry Shake

Hc Streamer Cruiser Chart- White 2- 0

Hc Streamer Game Changer Pearl- Wht.2- 0

Hc Streamer Game Changer Rainbow 2- 0

Hc Streamer Murdich Wiggler Tan Sz.2

Hc Streamer Big Fish Deceiver Blu- Wht 3-

River Grip Tungsten Carbide Nipper

Bass Popper Sz.6 Mr.Midnight

Bass Popper Sz.6 Mr.Minnow

Bass Popper Sz.6 Moss Man

Bass Popper Sz.6 Orange Splatter

Dreamstream Clamp 5 In.Straight Blk.

Dreamstream 5 In.Curve Black

Dream Stream Nipper Nkt

Dream Stream Hook File

Stay Hungry Streamer Chart/White Sz.2

Slump Buster Barrs