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]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	0	0	5.99	[empty string]	0	[empty string]	PLATY BITE VALVE COVER	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2018	[empty string]	[empty string]	SIDEWALK	[empty string]	[empty string]	[empty string]	4	5-to-10	0.00	[empty string]	Bite Valve Cover	Protect your bit valve and yourself from dirt, debris and whatever else might get on it with this Bite Valve Cover. Fits all Platypus Bite Valves.<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	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	07046	13696	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/platy-bite-valve-cover-13696	1
2	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	MINIWORKS EX WATER FILTER	N	4 MAIDA	[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	50-to-100	0.00	[empty string]	Miniworks Ex Microfilter	The Miniworks Ex Microfilter is a field-maintainable water filtration device that delivers long-lasting, field-maintainable water filtration in demanding environments. Engineered for frequent and heavy use, it utilizes our workhorse Marathon EX carbon/ceramic element to ensure clean, reliable and taste-free water. Thanks to its innovative AirSpring Accumulator, it`s capable of pumping one liter per minute and the flow rate can be renewed easily and repeatedly in the field—no tools required. It’s lightweight and compact and, most importantly, been proven reliable by thousands of adventurers just like you.<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	99.99	99.99	[empty string]	[empty string]	[empty string]	1000	56425	13939	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/miniworks-ex-water-filter-13939	1
3	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	HYPERFLOW REPL CARTRIDGE	N	4 MAIDA	[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]	SELL THRU	NOT ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Hyperflow Microfilter Cartridge Replacement	This replacement cartridge will restore flow rates in your HyperFlow Microfilter with fresh, new Hollow Fiber media.<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	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	56506	13946	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/hyperflow-repl-cartridge-13946	1
4	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	HYPERFLOW MAINTENANCE KIT	N	4 MAIDA	[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]	SELL THRU	NOT ONLINE	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Hyperflow Microfilter Maintenance Kit	The Hyperflow Microfilter Maintenence Kit is a complete kit for periodic maintenance of your HyperFlow Microfilter pump.<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	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	56508	13948	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/hyperflow-maintenance-kit-13948	1
5	[empty string]	COGHLANS	Coghlans	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	1	12.99	0	12.99	31020-DEFAULT-l.jpg	12.99	31020-DEFAULT-m.jpg	TWO STEP DRINKING WATER TREATMENT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	PICK-UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	9	10-to-15	0.00	[empty string]	Two Step Drinking Water Treatment	<p>FEATURES:<br /> -Intended for emergency disinfection of drinking water<br /> -Make most water bacteriologically suitable for drinking<br /> -Not to be used on a continuous basis<br /> -For short term or limited emergency use only<br /> -Easy to use. No unpleasant taste<br /> -Iodine-based compound (no chlorine)</p>	[empty string]	N	12.99	12.99	[empty string]	31020-DEFAULT-s.jpg	[empty string]	1000	9586	15047	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	coghlans/two-step-drinking-water-treatment-15047	1
6	[empty string]	KATADYN	KATADYN	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	COMBI REPLACEMENT CARBON 2PK	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2019	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	Combi Replacement Carbon	Activated Carbon Refill Pack. Activated carbon reduces chlorine and other malodorous, health endangering chemicals.	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	8013624	35370	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	katadyn/combi-replacement-carbon-2pk-35370	1
7	[empty string]	KATADYN	KATADYN	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	0	0	14.99	[empty string]	0	[empty string]	VARIO CERAMIC DISK	N	4 MAIDA	[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	10-to-15	0.00	[empty string]	Vario Replacement Disc - Ceramic	<p>Your Vario will always make sure your water tastes really good with a replacement ceramic disk handy, just in case.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	8015035	35389	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	katadyn/vario-ceramic-disk-35389	1
8	[empty string]	RELIANCE	Reliance	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	BLACK SPIGOT ASSEMBLY	N	4 MAIDA	[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]	SELL THRU	ONLINE	[empty string]	[empty string]	10	5-AND-under	0.00	[empty string]	Replacement Black Spigot Assembly	<p>Have this Replacement Black Spigot Assembly handy in case something happens to your original spigot when you`re in the middle of the woods.<br />  </p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	7210-13	139144	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	reliance/black-spigot-assembly-139144	1
9	[empty string]	KATADYN	KATADYN	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	HIKER MICROFILTER	N	4 MAIDA	[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	50-to-100	0.00	[empty string]	Hiker Microfilter	<p>The Katadyn Hiker is the best selling microfilter in the US Outdoor Market. Lightweight and easy to use design is the best choice for all around use. Unique, pleated cartridge design provides fast and easy pumping.</p>	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	8018270	146431	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	katadyn/hiker-microfilter-146431	1
10	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	GRAVITY WORKS CARBON ELEMENT	N	4 MAIDA	[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]	2	15-to-20	0.00	[empty string]	Gravityworks Carbon Element	The GravityWorks Carbon Element will maximize the Platypus clean water experience. It easily splices in after the GravityWorks hollow fiber element with an included hose segment, helping to remove flavors, odors, and many organic compounds from filtered water for the best taste possible.<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	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	06700	148827	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/gravity-works-carbon-element-148827	1
11	[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 MAIDA	[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	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	CAMP ESSENTIALS	[empty string]	sawyer/mini-water-filtration-system-blue-177477	1
12	[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 MAIDA	[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]	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	CAMP ESSENTIALS	[empty string]	sawyer/fast-fill-adapters-for-hydration-packs-177479	1
13	[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 MAIDA	[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	CAMP ESSENTIALS	[empty string]	sawyer/inline-adapters-for-screw-on-filters-177480	1
14	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	109.99	0	109.99	[empty string]	109.99	[empty string]	GRAVITY WORKS 4L COMPLETE KIT	N	4 MAIDA	[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	100-to-150	0.00	[empty string]	Gravityworks Water Filter - Complete Kit - 4 Liters	The GravityWorks Water Filter 4L Complete Kit delivers four liters of filtered water is just 2.5 minutes with no pumping. Ideal for bigger groups, the system`s eight-liter capacity eliminates both the worry and hassle of keeping plenty of water around for anything you need.<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	109.99	109.99	[empty string]	[empty string]	[empty string]	1000	03135	184018	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/gravity-works-4l-complete-kit-184018	1
15	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 MAIDA	[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]	5	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	CAMP ESSENTIALS	[empty string]	sawyer/mini-water-filtration-system-246048	1
16	BIGADVENTURE,CLEARBLU	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	BIGADVENTURE\|NULL\|NULL,CLEARBLU\|NULL\|NULL	0	46.99	0	46.99	[empty string]	46.99	[empty string]	LIFESTRAW GO	N	4 MAIDA	[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]	Lifestraw Go	<p>Lifestraw Go is an advanced water filter bottle ideal for travel, outdoor sports and emergencies.</p>	[empty string]	N	46.99	46.99	[empty string]	[empty string]	[empty string]	1000	LSGOV2CR	274320	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-go-274320	1
17	[empty string]	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	LIFESTRAW CARBON REPLACEMENT	N	4 MAIDA	[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	5-to-10	0.00	[empty string]	Lifestraw Carbon Filter Replacement - 2 Pack	<p>The Lifestraw Carbon Filter Replacement is compatible with LifeStraw Go, LifeStraw Steel, LifeStraw Universal, LifeStraw Play.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	LSCARB410	274322	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-carbon-replacement-274322	1
18	[empty string]	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	LIFESTRAW GO FILTER REPLACEMENT	N	4 MAIDA	[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]	3	20-to-25	0.00	[empty string]	Lifestraw 2-stage Replacement Filter	<p>The Lifestraw 2-Stage Replacement Filter is compatible with LifeStraw Go and LifeStraw Universal.</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	LSGOSPCCB	274323	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-go-filter-replacement-274323	1
19	[empty string]	KATADYN	KATADYN	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	SHOWER ADAPTER	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	3	5-to-10	0.00	[empty string]	Shower Adapter	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	8019256	275931	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	katadyn/shower-adapter-275931	1
20	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	TRAILSHOT MICROFILTER	N	4 MAIDA	[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	25-to-50	0.00	[empty string]	Trailshot Microfilter	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	09385	282805	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/trailshot-microfilter-282805	1
21	[empty string]	KATADYN	KATADYN	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	84.99	0	84.99	[empty string]	84.99	[empty string]	HIKER PRO MICROFILTER TRANSPARENT	N	4 MAIDA	[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]	1	50-to-100	0.00	[empty string]	Hiker Pro Transparent	<p>Lightweight is your demand, but pumping performance is also a must. Katadyn's lightest filter, the compact Katadyn Hiker Pro Transparent, steps up as your best choice for safe hydration and great-tasting refreshment on the trail. Just a quick stop at a stream or lake nets you 1 liter/minute. The quick-connect fittings enable the simplicity of one-step filtering directly into most reservoirs or bottles.</p>	[empty string]	N	84.99	84.99	[empty string]	[empty string]	[empty string]	1000	8019857	290825	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	katadyn/hiker-pro-microfilter-transparent-290825	1
22	[empty string]	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	UNIVERSAL WATER FILTER	N	4 MAIDA	[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]	1	25-to-50	0.00	[empty string]	Lifestraw Universal	<p>Turn your favorite water bottle into a powerful filter removing bacteria, parasites and chemicals.</p>	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	LSUN01FK01	291036	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/universal-water-filter-291036	1
23	SKY	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	SKY\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	KIDS LIFESTRAW PLAY WATER FILTER	N	4 MAIDA	[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]	1	25-to-50	0.00	[empty string]	Kids Lifestraw Play Water Filter	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	PLAY	291037	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/kids-lifestraw-play-water-filter-291037	1
24	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	139.99	0	139.99	[empty string]	139.99	[empty string]	TRAIL BASE WATER FILTER KIT 2L	N	4 MAIDA	[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	100-to-150	0.00	[empty string]	Trail Base Water Filter Kit 2l	[empty string]	[empty string]	N	139.99	139.99	[empty string]	[empty string]	[empty string]	1000	10372	301063	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/trail-base-water-filter-kit-2l-301063	1
25	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	TRAILSHOT REPLACEMENT CARTRIDGE	N	4 MAIDA	[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]	2	25-to-50	0.00	[empty string]	Trailshot Replacement Cartridge	[empty string]	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	09592	305335	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/trailshot-replacement-cartridge-305335	1
26	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	PLATYPUS BIG ZIP EVO 3.0L	N	4 MAIDA	[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]	1	25-to-50	0.00	[empty string]	Platypus Big Zip Evo 3.0l	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	10857	312697	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/platypus-big-zip-evo-3-0l-312697	1
27	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	GRAVITYWORKS 2L REPLACEMENT RESEVOIR	N	4 MAIDA	[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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Gravityworks 2l Replacement Resevoir	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	06953	336829	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/gravityworks-2l-replacement-resevoir-336829	1
28	[empty string]	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	LIFESTRAW GO FILTER REPLACEMENT	N	4 MAIDA	[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]	1	20-to-25	0.00	[empty string]	Lifestraw 2-stage Replacement Filter	<p>The Lifestraw 2-Stage Replacement Filter isnbsp;compatible with LifeStraw Go and LifeStraw Universal.</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	LSGOSPCCT	340992	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-go-filter-replacement-340992	1
29	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	METABOTTLE W/FILTER 1L CORAL	N	4 MAIDA	[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]	SELL THRU	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Metabottle W/filter 1l Coral	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	10453	341613	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/metabottle-w-filter-1l-coral-341613	1
30	GREY	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	GREY\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	LIFESTRAW GO STAINLESS STEEL 24OZ	N	4 MAIDA	[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]	1	50-to-100	0.00	[empty string]	Lifestraw 2-stage Replacement Filter	<p>The Lifestraw 2-Stage Replacement Filter isnbsp;compatible with LifeStraw Go and LifeStraw Universal.</p>	[empty string]	N	69.99	69.99	24OZ	[empty string]	[empty string]	1000	LSGOSS	345071	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/lifestraw-go-stainless-steel-24oz-345071	1
31	[empty string]	LIFESTRAW	Lifestraw	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	UNIVERSAL WATER FILTER	N	4 MAIDA	[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]	1	25-to-50	0.00	[empty string]	Universal Water Filter	[empty string]	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	LSUN02FK01	345076	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	lifestraw/universal-water-filter-345076	1
32	[empty string]	KATADYN	KATADYN	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	BE FREE GRAVITY CAMP UPGRADE KIT	N	4 MAIDA	[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	15-to-20	0.00	[empty string]	Be Free Gravity Camp Upgrade Kit	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	8020861	345410	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	katadyn/be-free-gravity-camp-upgrade-kit-345410	1
33	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	TRAIL BASE WATER FILTER KIT 4L	N	4 MAIDA	[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]	1	100-to-150	0.00	[empty string]	Trail Base Water Filter Kit 4l	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	10943	348085	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/trail-base-water-filter-kit-4l-348085	1
34	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	PLATY QUICKDRAW WATER FILTER 1L	N	4 MAIDA	[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]	1	25-to-50	0.00	[empty string]	Platy Quickdraw Water Filter 1l	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	11459	348093	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/platy-quickdraw-water-filter-1l-348093	1
35	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	EMERGENCY HOME WATER FILTER SYSTEM	N	4 MAIDA	[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]	Emergency Home Water Filter System	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	13237	348104	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/emergency-home-water-filter-system-348104	1
36	[empty string]	MSR MOUNTAIN SAFETY RESEARCH	Msr Mountain Safety Research	CAMPING	Camping>Camp Essentials>Water Treatment	[empty string]	0	5.99	0	5.99	[empty string]	5.99	[empty string]	BITE VALVE COVER	N	4 MAIDA	[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]	3	5-to-10	0.00	[empty string]	Bite Valve Cover	[empty string]	[empty string]	N	5.99	5.99	[empty string]	[empty string]	[empty string]	1000	11008	353521	WATER TREATMENT	EMPTY	EMPTY	0	0	0	CAMP ESSENTIALS	[empty string]	msr-mountain-safety-research/bite-valve-cover-353521	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts288 ORDER BY sortposition asc

Camping

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Brand

Size

Bite Valve Cover

Miniworks Ex Microfilter

Hyperflow Microfilter Cartridge Replacement

Hyperflow Microfilter Maintenance Kit

Two Step Drinking Water Treatment

Combi Replacement Carbon

Vario Replacement Disc - Ceramic

Replacement Black Spigot Assembly

Hiker Microfilter

Gravityworks Carbon Element

Mini Water Filtration System - Blue

Fast Fill Adapters For Hydration Packs

Inline Hydration Pack Adapters

Gravityworks Water Filter - Complete Kit - 4 Liters

Mini Water Filtration System - Pink

Lifestraw Go

Lifestraw Carbon Filter Replacement - 2 Pack

Lifestraw 2- Stage Replacement Filter

Shower Adapter

Trailshot Microfilter

Hiker Pro Transparent

Lifestraw Universal

Kids Lifestraw Play Water Filter

Trail Base Water Filter Kit 2l