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]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	MINI WATER FILTRATION SYSTEM BLUE	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]	2	20-to-25	0.00	[empty string]	Mini Water Filtration System - Blue	<p>Sawyer`s most popular filter just got smaller and lighter. The Mini weighs just 2 ounces and filters up to 100,000 gallons! What`s special about Sawyer filters is they filter to 0.1 micron, exceeding EPA and NSF recommendations. Did we mention you can drink directly from the Mini, attach it to Sawyer Squeeze Pouches, use inline on a hydration pack, or attach it to the top of almost any bottled water? How about that for versatility? And like all Sawyer Filters; they are backflushable almost indefinitely. That means no expensive cartridges to replace, ever.<br />  </p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	SP128	177477	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/mini-water-filtration-system-blue-177477	1
2	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	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]	6	5-to-10	0.00	[empty string]	Fast Fill Adapters For Hydration Packs	<p>The Fast Fill Hydration Pack Adapters allow you to fill your hydration pack reservoir directly from your screw on/off filter without removing it from your backpack.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	SP115	177479	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/fast-fill-adapters-for-hydration-packs-177479	1
3	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	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]	4	5-to-10	0.00	[empty string]	Inline Hydration Pack Adapters	The Inline Hydration Pack Adapter turns your Sawyer screw on/off filter into an inline filtration system for your hydration pack. Compatible with the Sawyer Squeeze Filter and the All in One Filter.<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	7.99	7.99	[empty string]	[empty string]	[empty string]	1000	SP110	177480	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/inline-adapters-for-screw-on-filters-177480	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	ONLINE	[empty string]	[empty string]	15	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]	PERMETHRIN INSCECT 9OZ SPRAY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	7	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/permethrin-inscect-9oz-spray-177497	1
6	PINK	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	PINK\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	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]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	Mini Water Filtration System - Pink	<p>Sawyer's lightest and most versatile personal water filtration system, the Sawyer MINI weighs just 2 ounces, fits in the palm of your hand, and provides 0.1 micron absolute filtration — removing 99.99999% of all bacteria, such as salmonella, cholera and E.coli, removing 99.9999% of all protozoa (such as giardia and cryptosporidium), and removing 100% of microplastics.</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	SP102	246048	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/mini-water-filtration-system-246048	1
7	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	POINT ONE SQUEEZE FILTER WITH 3 POUCHES	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]	5	25-to-50	0.00	[empty string]	Squeeze Filter System	<p>The Sawyer PointOne squeeze water filter is one of the lightest and most versatile filtration systems available. With a total field weight of only 3-ounces this compact filter rolls up to take minimal space in your pack.</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	SP131	252683	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/point-one-squeeze-filter-with-3-pouches-252683	1
8	[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	ONLINE	[empty string]	[empty string]	11	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
9	[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
10	[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]	10	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
11	[empty string]	SAWYER	Sawyer	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	44.99	0	44.99	[empty string]	44.99	[empty string]	1 GALLON GRAVITY 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]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	1 Gallon Gravity Filtration System	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	SP160	321295	WATER TREATMENT	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	sawyer/1-gallon-gravity-filtration-system-321295	1
12	[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]	12	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter