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]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	9.99	0	9.99	106017-DEFAULT-l.jpg	9.99	106017-DEFAULT-m.jpg	FAST FILL ADAPTERS FOR HYDRATION PACKS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	5-to-10	0.00	[empty string]	FAST FILL ADAPTER FOR HYDRATION PACKS	<p>Fill your hydration pack directly from your screw on/off filter without removing it from your backpack with this accessory.</p>	[empty string]	N	9.99	9.99	[empty string]	106017-DEFAULT-s.jpg	[empty string]	1000	SP115	177479	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/fast-fill-adapter-for-hydration-packs-177479	1
2	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	7.99	0	7.99	106016-DEFAULT-l.jpg	7.99	106016-DEFAULT-m.jpg	INLINE ADAPTERS FOR SCREW ON FILTERS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	5-to-10	0.00	[empty string]	INLINE ADAPTER	<p>Inline Hydration Pack Adapters for the Sawyer Screw On Filter that will allow you to install your filter on your hydration pack line to filter your water on the go.</p>	[empty string]	N	7.99	7.99	[empty string]	106016-DEFAULT-s.jpg	[empty string]	1000	SP110	177480	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/inline-adapter-177480	1
3	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	39.99	0	39.99	106028-DEFAULT-l.jpg	39.99	106028-DEFAULT-m.jpg	POINT ONE SQUEEZE WATER FILTER SYSTEM	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	SQUEEZE WATER FILTRATION SYSTEM	<p>The Squeeze Filter is our workhorse model and is the filter of choice for heavy users and those who need long term reliability.</p> <p> </p> <ul> <li>Ideal for hiking, camping, hunting, fishing, emergency prep, or traveling abroad, Sawyer's Squeeze Water Filter ensures access to clean water in the backcountry or anywhere in the world. Rated to 0.1 micron absolute filtration, the Squeeze Filter removes 99.99999% of bacteria such as salmonella, cholera, leptospirosis, and e. Coli, and removes 99. 9999% of  protozoa such as giardia and cryptosporidium (independent testing laboratory Hydration, LLC.; microbiological report S05-03). The Squeeze Filter also filters out 100% of microplastics.</li> <li>To use, simply fill up the reusable pouch (included on most models) at any water source, screw the filter onto the pouch, and drink directly from the filter or squeeze water into a water bottle. The Squeeze Filter is backed by a manufacturer's limited lifetime warranty. Sawyer individually tests each and every Squeeze Filter three times to performance standards before packaging.</li> </ul> <p> </p> <ul> <li>Filter Material: Hollow Fiber</li> <li>Removes: Bacteria, protozoa, E. Coli, giardia, vibrio cholerea, Salmonella typhi, and microplastics</li> <li>Height: 5.5"</li> <li>Width: 1.9"</li> <li>Length: 1.9"</li> <li>Weight: 2.5 oz</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	106028-DEFAULT-s.jpg	[empty string]	1000	SP129	177481	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/squeeze-water-filtration-system-177481	1
4	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	1	18.99	0	18.99	77315-DEFAULT-l.jpg	18.99	77315-DEFAULT-m.jpg	PERMETHRIN INSCECT 24OZ TRIGGER SPRAY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	60	15-to-20	0.00	[empty string]	Permethrin Insect Repellant - For Clothing Gear And Tents - 24 Oz	<p>For use on clothing, tents, sleeping bags, and other outdoor gear, Sawyer Permethrin is more than just an insect repellent — it actually kills ticks, mosquitoes, spiders, chiggers, mites, and more than 55 other kinds of insects. Permethrin is also effective against the Yellow Fever Mosquito, which can transmit the Zika Virus.</p>	[empty string]	N	18.99	18.99	[empty string]	77315-DEFAULT-s.jpg	[empty string]	1000	SP657	177486	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/permethrin-inscect-24oz-trigger-spray-177486	1
5	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	0	10.49	0	10.49	[empty string]	10.49	[empty string]	PICARIDIN INSECT 6OZ SPRAY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	18	10-to-15	0.00	[empty string]	Picaridin Insect Repellant - 6 Oz	<p>Highly effective at deterring a wide array of insects including mosquitoes and ticks, Sawyer’s 20% Picaridin insect repellent is more effective at repelling biting flies than Deet. Safe for use on the whole family, the non-greasy Picaridin offers all day protection, has a pleasant low citrus odor, and won’t damage plastics or synthetic coatings.</p>	[empty string]	N	10.49	10.49	[empty string]	[empty string]	[empty string]	1000	SP576	177497	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/picaridin-insect-6oz-spray-177497	1
6	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	1	13.99	0	13.99	54421-DEFAULT-l.jpg	13.99	54421-DEFAULT-m.jpg	CLOTHING INSECT REPELLENT 12OZ	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	80	10-to-15	0.00	[empty string]	Permethrin Insect Repellant - For Clothing Gear And Tents - 12 Oz	<p>For use on clothing, tents, sleeping bags, and other outdoor gear, Sawyer Permethrin is more than just an insect repellent — it actually kills ticks, mosquitoes, spiders, chiggers, mites, and more than 55 other kinds of insects. Permethrin is also effective against the Yellow Fever Mosquito, which can transmit the Zika Virus.</p>	[empty string]	N	13.99	13.99	[empty string]	54421-DEFAULT-s.jpg	[empty string]	1000	SP649	252685	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/clothing-insect-repellent-12oz-252685	1
7	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	PICARIDIN SPRAY PUMP 4OZ	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	5-to-10	0.00	[empty string]	Picaridin Insect Repellant - 4 Oz Spray	<p>Sawyer ``Fisherman’s Formula`` Picaridin Insect Repellent is gear safe and effective against mosquitoes, ticks, and flies. Their 20% Picaridin insect repellent is safe for use during pregnancy and on kids as young as six months of age.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	SP544	260139	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/picaridin-spray-pump-4oz-260139	1
8	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	1	10.99	0	10.99	77316-DEFAULT-l.jpg	10.99	77316-DEFAULT-m.jpg	MAXI-DEET 100% 4OZ CONTINOUS SPRAY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	43	10-to-15	0.00	[empty string]	Maxi-deet Topical Insect Repellent - 4 Oz	<p>Offering Deet in its purest form, Sawyer Maxi-Deet is ideal for defending yourself from mosquitoes, chiggers, fleas, gnats, and ticks in areas of extreme bug density. With its high potency, Maxi-Deet gives you more control on how much you apply and requires fewer re-applications (compared to other lower-dosage Deet aerosol sprays).</p>	[empty string]	N	10.99	10.99	[empty string]	77316-DEFAULT-s.jpg	[empty string]	1000	SP714	321293	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/maxi-deet-100-4oz-continous-spray-321293	1
9	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	28.99	0	28.99	105947-DEFAULT-l.jpg	28.99	105947-DEFAULT-m.jpg	MICRO SQUEEZE WATER FILTER SYSTEM	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	MICRO SQUEEZE WATER FILTRATION SYSTEM	<p>Enjoy clean and safe drinking water wherever you roam with the ultra-compact, lightweight, reusable Sawyer Micro Squeeze Water Filtration System — from backcountry adventures to everyday office work and from domestic and international travel to emergency prepping.</p> <p> </p> <ul> <li>With a total field weight of 2 ounces, this tiny filter fits in the palm of your hand. While small in size, the powerful Micro Squeeze removes 99.99999% of bacteria (salmonella, cholera, and E. coli) and 99.9999% of protozoa (cryptosporidium and giardia) — exceeding EPA recommendations for removal rates. The Micro Squeeze also filters out 100% of microplastics.</li> <li>Attach the Micro Squeeze to the included drinking pouch, use the included straw to drink directly from your water source, connect it to hydration pack tubing (sold separately), or screw it onto standard disposable bottles (28mm thread). Made of a strong, soft material, the included 32-ounce (1-liter) Squeeze Pouch features a redesigned gusset for easy filling and stability. Perfect for adding to your disaster preparedness kit to ensure access to clean water during emergencies, the Micro Squeeze is great for removing harmful pathogens from residential water when boil alerts are issued.</li> <li>The Micro Squeeze 0.1 micron absolute filter houses a cluster of micro-fibrous tubes which use similar technology found in medical dialysis. As water passes through the side walls of the tubes, harmful bacteria and protozoa are trapped on the outer walls so you can be confident your water is safe to drink. The Sawyer Micro Squeeze Water Filter is rated up to 100,000 gallons.</li> <li>Each Micro Squeeze comes with a 32-ounce reusable squeeze pouch, drinking straw, cleaning coupling, spare gasket, and cleaning plunger. Sawyer individually tests each and every Micro Squeeze three times to performance standards before packaging.</li> </ul> <p> </p> <ul> <li>Filter Material: Hollow Fiber Membrane</li> <li>Longevity: up to 100,000 Gallons</li> <li>Removes: Bacteria, Protozoa, and Cysts, including E. Coli, giardia, vibrio cholerea, Salmonella typhi, and microplastics</li> <li>Height: 4.15"</li> <li>Width: 1.55"</li> <li>Length: 1.55"</li> <li>Weight: 1.8 oz</li> </ul>	[empty string]	N	28.99	28.99	[empty string]	105947-DEFAULT-s.jpg	[empty string]	1000	SP2129	321294	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/micro-squeeze-water-filtration-system-321294	1
10	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Bug Spray	[empty string]	1	6.99	0	6.99	86247-DEFAULT-l.jpg	6.99	86247-DEFAULT-m.jpg	FAMILY INSECT REPELLENT 4OZ LOTION	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	5-to-10	0.00	[empty string]	Family Insect Repellent 4oz Lotion	[empty string]	[empty string]	N	6.99	6.99	[empty string]	86247-DEFAULT-s.jpg	[empty string]	1000	SP520	336850	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/family-insect-repellent-4oz-lotion-336850	1
11	GREEN,BLACK,BLUE,CAMO	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	GREEN\|NULL\|NULL,BLACK\|NULL\|NULL,BLUE\|NULL\|NULL,CAMO\|NULL\|NULL	1	24.99	0	24.99	106007-DEFAULT-l.jpg	24.99	106007-DEFAULT-m.jpg	MINI WATER FILTRATION SYSTEM	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	20-to-25	0.00	[empty string]	MINI WATER FILTRATION SYSTEM	<p>The MINI filter is a great choice for outdoor enthusiasts and emergency preparedness. These systems are affordable, highly versatile, and come ready to go on your next adventure.</p> <p> </p> <ul> <li>A lightweight, versatile personal filtration system, the second-generation Sawyer MINI Water Filter fits in the palm of your hand and has a total field weight of just 2 ounces. Perfect for everything from camping with the kids to traveling abroad where tap and bottle water can't be trusted, the tiny MINI provides 0.1 micron absolute filtration for clean drinking water on the go — filtering out bacteria, protozoa, and microplastics.</li> <li>The MINI filter removes 7 log (99.99999%) of bacteria (like salmonella) as well as other harmful bacteria which causes cholera and E. coli and 6 log (99.9999%) of protozoa such as giardia and cryptosporidium. These removal rates equal or exceed other filter options. EPA guidelines allow ten times more protozoa left in the water than Sawyer MINI filters allow. The MINI also filters out 100% of microplastics.</li> <li>The MINI 0.1 micron absolute filter houses a cluster of micro-fibrous tubes which use similar technology found in medical dialysis. As water passes through the side walls of the tubes, harmful bacteria and protozoa are trapped on the outer walls so you can be confident your water is safe to drink.</li> <li>Great for outdoor recreation, hiking, camping, scouting, domestic and international travel, and emergency prepping, the Sawyer MINI gives you a number of ways to access clean water.Attach it to the included drinking pouch, use the included straw to drink directly from your water source, connect it to hydration pack tubing (sold separately), or screw it onto standard disposable bottles (28mm thread).</li> </ul> <p> </p> <ul> <li>Filter Material: Hollow Fiber</li> <li>Longevity: Up to 100,000 gallons</li> <li>Removes: Bacteria, Protozoa, E. Coli, Giardia, Vibrio cholerea, Salmonella Typhi, Leptospirosis, and microplastics</li> <li>Height: 5.35"</li> <li>Width: 1.35"</li> <li>Length: 1.35"</li> <li>Weight: 1.4 oz</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	106007-DEFAULT-s.jpg	[empty string]	1000	SP1FC	369176	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/mini-water-filtration-system-369176	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter