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]	CAMELBAK	Camelbak	CAMPING	Camping>Packs and Bags>Hydration Packs	[empty string]	1	64.99	0	64.99	101379-DEFAULT-l.jpg	64.99	101379-DEFAULT-m.jpg	CLASSIC LIGHT 70OZ GUNMETAL/HYDRO	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	CLASSIC LIGHT - 70 OZ	<p>The Classic Light is exactly what your everyday ride has been missing. Lightweight meets heavy-duty for a pack that is durable, adaptable, and comfortable for any length adventure. The sleek design features a 2-liter Crux Reservoir with Quicklink disconnect and an extra 2-liters of cargo space. The Air Support Light Back Panel and a ventilated harness ensure effective cooling and ultimate breathability. The bungee overflow allows you to quickly stash an extra layer without missing a beat. With a secured zippered pocket to store your keys and phone, plus an adjustable sternum strap for a custom fit and increased stability, you have everything you need to hit the trail, stay hydrated, and have fun out there.</p> <p> </p> <ul> <li>Lightweight and Durable Materials</li> <li>Air Support Light Back Panel: Designed with body mapping technology for efficient ventilation and lightweight comfort</li> <li>Ventilated Harness: Lightweight and breathable</li> <li>Integrated Tool Organization</li> <li>Secure Zippered Pocket: Perfect for keys, phone, or other essentials</li> <li>Bungee Overflow: Quickly stash or shed an extra layer</li> <li>Adjustable Sternum Strap: Offers a range of adjustments for a custom fit and increased stability</li> <li>Tube Trap Management: Keeps your tube secure and accessible when you need it.</li> <li>Light Loop: Clip on a light to make the ride to and from the trailhead safe</li> <li>Helmet Carry: Stow and secure helmet</li> <li>Reflectivity: For low light safety</li> </ul> <p> </p> <ul> <li>User Group: Unisex</li> <li>BPA/BPS/BPF Free: True</li> <li>Quick Link: True</li> <li>Pack Weight: 7 oz</li> <li>Hydration Type: CRUX Reservoir with Quicklink System</li> <li>Gear Capacity: 2L (230 cu in)</li> <li>Hydration Capacity: 2L (70 oz)</li> </ul>	[empty string]	N	64.99	64.99	[empty string]	101379-DEFAULT-s.jpg	[empty string]	1000	2404001000	352728	HYDRATION PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	camelbak/classic-light-70-oz-352728	1
2	MOUNTAIN,MIRAGE,SKYE,DRYEARTH	EBERLESTOCK	Eberlestock	CAMPING	Camping>Packs and Bags>Hydration Packs	MOUNTAIN\|NULL\|NULL,MIRAGE\|NULL\|NULL,SKYE\|NULL\|NULL,DRYEARTH\|NULL\|NULL	1	169.99	0	169.99	96199-DEFAULT-l.jpg	169.99	96199-DEFAULT-m.jpg	MINI ME HYDRO PACK 400/900CI	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	150-to-200	0.00	[empty string]	MINI-ME HYDRATION PACK	<p>The H1 Mini-Me includes a 2L Source hydration bladder to keep you in the field longer. It has multiple internal organizational pockets and features for compartmentalizing gear and a large main compartment for bulky items like clothing. Unzip the scabbard tunnel to allow the integration of our A2LS Scabbard in order to comfortably and securely carry a rifle or shotgun. An included mesh bird bag can be deployed from the underside of the pack.</p> <p> </p> <ul> <li>Comes standard with 3 liter (100 oz) Source hydration bladder</li> <li>Four zippered compartments (One full depth spotting scope pocket)</li> <li>Wrap around zipper opens scabbard tunnel</li> <li>Secret compartment with deployable Bird Bag</li> <li>Pull-out hip belt</li> <li>Grapple compression strap</li> </ul> <p> </p> <ul> <li>Volume: 600 c.i.</li> <li>Weight: 2.50 lbs</li> <li>Dimensions: 17.5H x 8W x 4.5D</li> </ul>	[empty string]	N	169.99	169.99	[empty string]	96199-DEFAULT-s.jpg	[empty string]	1000	H1	369003	HYDRATION PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	eberlestock/mini-me-hydration-pack-369003	1
3	[empty string]	CAMELBAK	Camelbak	CAMPING	Camping>Packs and Bags>Hydration Packs	[empty string]	1	134.99	0	134.99	101363-DEFAULT-l.jpg	134.99	101363-DEFAULT-m.jpg	AMBUSH 3L MILITARY CRUX MULTICAM	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	AMBUSH MIL SPEC CRUX - 100 OZ - MULTICAM	<p>Designed for the USMC, this low-profile pack features the Crux Short 3L Reservoir, offering a low stack height and optimum fit on a broad range of torso sizes.  External fill means you can rapidly add water without having to remove the reservoir or tube from the pack. With 3L of cargo in the lower zip pocket and top fill flap, you can take along your small essentials while staying light and maneuverable.</p> <p> </p> <ul> <li>External fill for rapid refill without having to remove reservoir from pack</li> <li>Uses 500D Double-rip Cordura Fabric for the ultimate combination of strength and durability</li> <li>Top and bottom external zip pockets hold your essentials</li> <li>Low-profile Mountain MOLLE on bottom pocket</li> <li>Side-release shoulder straps for rapid removal</li> <li>Side zippers allows easy access to the reservoir fill port</li> <li>D-Rings for tube management</li> <li>Lightweight webbing harness</li> <li>Adjustable sternum strap</li> <li>Hook-and-loop strap management</li> <li>Add or remove name tags and unit badges quickly with integrated hook-and-loop panel</li> <li>Ergonomic webbing grab handle</li> <li>Drain hole on hydration compartment</li> </ul> <h2> </h2> <ul> <li>User Group: Unisex</li> <li>BPA/BPS/BPF Free: true</li> <li>Dimensions: 16" x 10" x 6"</li> <li>Quick Link: True</li> <li>Pack Weight: 1.7 lb</li> <li>Hydration Type: Mil Spec CRUX Reservoir with Quicklink System</li> <li>Gear Capacity: 6 L (366 cu in)</li> </ul>	[empty string]	N	134.99	134.99	[empty string]	101363-DEFAULT-s.jpg	[empty string]	1000	1724901000	380181	HYDRATION PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	camelbak/ambush-mil-spec-crux-100-oz-multicam-380181	1
4	[empty string]	CAMELBAK	Camelbak	CAMPING	Camping>Packs and Bags>Hydration Packs	[empty string]	1	99.99	0	99.99	101367-DEFAULT-l.jpg	99.99	101367-DEFAULT-m.jpg	THERMOBAK 3L MILITARY CRUX MULTICAM	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	THERMOBAK MIL SPEC CRUX - 3L - 100 OZ - MULTICAM	<p>The ThermoBak 3L continues to impress with updated features and technology. The 3L, 100oz Mil Spec Crux Reservoir delivers 25% more water per sip while the style maintains the ergonomics and optimal infrared reflectivity it's famous for.</p> <p> </p> <ul> <li>External fill allows for easy access to the Crux reservoir for easy filling, cleaning and ice addition</li> <li>Two-zipper fill cover provides top or bottom of reservoir compartment entry points</li> <li>Quick-release shoulder straps unclip for easy removal and stow away inside built-in pocket</li> <li>Adjustable sternum strap</li> <li>Hook-and-loop strap management</li> <li>Six D-ring points for attaching to any armor vest or pack with MOLLE</li> <li>Fully insulated reservoir compartment using 5 mm closed cell foam</li> <li>Add or remove name tags and unit badges quickly with integrated hook-and-loop</li> <li>Grommet drain holes located at bottom of main compartment</li> <li>Uses 500D Double-rip Cordura® Fabric for the ultimate combination of strength and durability</li> </ul> <p> </p> <ul> <li>User Group: Unisex</li> <li>BPA/BPS/BPF Free: true</li> <li>Dimensions: 17.3" x 9.4" x 4.3"</li> <li>Quick Link: True</li> <li>Pack Weight: 1.4 lb</li> <li>Hydration Type: Mil Spec CRUX Reservoir with Quicklink System</li> <li>Hydration Capacity: 3L (100 oz)</li> </ul>	[empty string]	N	99.99	99.99	[empty string]	101367-DEFAULT-s.jpg	[empty string]	1000	1718901000	380184	HYDRATION PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	camelbak/thermobak-mil-spec-crux-3l-100-oz-multicam-380184	1
5	[empty string]	CAMELBAK	Camelbak	CAMPING	Camping>Packs and Bags>Hydration Packs	[empty string]	1	94.99	0	94.99	101366-DEFAULT-l.jpg	94.99	101366-DEFAULT-m.jpg	THERMOBAK 3L MILITARY CRUX COYOTE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WINTER	[empty string]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	THERMOBAK MIL SPEC CRUX - 3L - 100 OZ - COYOTE	<p>The ThermoBak 3L continues to impress with updated features and technology. The 3L, 100oz Mil Spec Crux Reservoir delivers 25% more water per sip while the style maintains the ergonomics and optimal infrared reflectivity it's famous for.</p> <p> </p> <ul> <li>External fill allows for easy access to the Crux reservoir for easy filling, cleaning and ice addition</li> <li>Two-zipper fill cover provides top or bottom of reservoir compartment entry points</li> <li>Quick-release shoulder straps unclip for easy removal and stow away inside built-in pocket</li> <li>Adjustable sternum strap</li> <li>Hook-and-loop strap management</li> <li>Six D-ring points for attaching to any armor vest or pack with MOLLE</li> <li>Fully insulated reservoir compartment using 5 mm closed cell foam</li> <li>Add or remove name tags and unit badges quickly with integrated hook-and-loop</li> <li>Grommet drain holes located at bottom of main compartment</li> <li>Uses 500D Double-rip Cordura® Fabric for the ultimate combination of strength and durability</li> </ul> <p> </p> <ul> <li>User Group: Unisex</li> <li>BPA/BPS/BPF Free: true</li> <li>Dimensions: 17.3" x 9.4" x 4.3"</li> <li>Quick Link: True</li> <li>Pack Weight: 1.4 lb</li> <li>Hydration Type: Mil Spec CRUX Reservoir with Quicklink System</li> <li>Hydration Capacity: 3L (100 oz)</li> </ul>	[empty string]	N	94.99	94.99	[empty string]	101366-DEFAULT-s.jpg	[empty string]	1000	1717201000	380185	HYDRATION PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	camelbak/thermobak-mil-spec-crux-3l-100-oz-coyote-380185	1
6	[empty string]	CAMELBAK	Camelbak	CAMPING	Camping>Packs and Bags>Hydration Packs	[empty string]	1	69.99	0	69.99	101368-DEFAULT-l.jpg	69.99	101368-DEFAULT-m.jpg	ARETE 18 50OZ REFL BLACK	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]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	ARETE 18 HYDRATION PACK - 50 OZ	<p>Even though our new hike pack compresses to pack away during an endurance hike, this versatile hike pack still packs a punch: with room for a 15” laptop and zip pockets in top lid, you'll have all the essentials for a hiking commute.</p> <p> </p> <ul> <li>Lightweight and breathable materials: Designed for all-day comfort</li> <li>3D Vent Mesh Harness: Lightweight and breathable with added cargo</li> <li>Laptop Sleeve: Keep your 15" laptop protected</li> <li>Secure Phone Pocket: Conveniently located with a zipper closure for secured quick access</li> <li>Side Stretch Pocket: Expands for extra water bottle or essentials</li> <li>Adjustable Sternum Strap: Offers a range of adjustments for a custom fit and increased stability</li> </ul> <p> </p> <ul> <li>User Group: Unisex</li> <li>BPA/BPS/BPF Free: True</li> <li>Dimensions: 17.7" x 9.5" x 8.6"</li> <li>Weight: 22.5 oz</li> <li>Pack Weight: 11 oz</li> <li>Hydration Type: CRUX Reservoir</li> <li>Torso Fit Range: 15" x 21"</li> <li>Gear Capacity: 16.5 L (1000 cu in.)</li> <li>Hydration Capacity: 1.5 L (50 oz)</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	101368-DEFAULT-s.jpg	[empty string]	1000	2528005000	380976	HYDRATION PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	camelbak/arete-18-hydration-pack-50-oz-380976	1
7	[empty string]	CAMELBAK	Camelbak	CAMPING	Camping>Packs and Bags>Hydration Packs	[empty string]	1	49.99	0	49.99	101371-DEFAULT-l.jpg	49.99	101371-DEFAULT-m.jpg	MINI M.U.L.E. 50OZ CAMO	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]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	KID'S MINI M.U.L.E. HYDRATION PACK WITH CRUX - 1.5L RESERVIOR - 50 OZ	<p>Bright, energetic and fun, Mini M.U.L.E. packs a big punch in a smaller container. Designed with kids and compact-framed people in mind, this durable and sustainably built pack still has room for every riding need. The sleek and adjustable build encourages your little adventurer to ride confidently, without any unnecessary baggage weighing them down.</p> <p> </p> <ul> <li>Gold Sustainability: Made with recycled materials and safer chemicals, designed to preserve resources and diminish disposables</li> <li>Stretch Overflow pocket: Gives you more space to pack all of your exploring essentials, plus any little goodies and gems you find along the trail.</li> <li>Integrated Tool Organization: A place for everything and everything in its place. Keep all of your favorite things handy and well-organized.</li> <li>Secure Zippered Pocket: Making sure your most special of treasures are safe and sound</li> <li>Ventilated Harness: This cooling harness let's the air hit ya when you're out adventuring</li> <li>Lightweight and Durable Materials: Go on wild adventures, explore new worlds, get rough and dirty—you'll stay comfortable and your pack won't get ruined.</li> <li>Breathable Air Mesh: Keeps you cool and free from yucky sweat, so you can play and explore even more</li> <li>Adjustable Sternum Strap: Make your pack fit you just right! Uniquely made to adjust to your unique self</li> <li>Reflectivity: High-shine areas that let people see you and keep you safe, even when it's dark out</li> <li>Safety Whistle: If you're in trouble, need help, or need to let someone know you're coming close to them on your bike</li> </ul> <p> </p> <ul> <li>User Group: Youth</li> <li>BPA/BPS/BPF Free: True</li> <li>Dimensions: 14.2" x 7.5" x 5.9"</li> <li>Material: Recycled 200D Poly, C0 DWR</li> <li>Back Panel: Air Mesh</li> <li>Pack Weight: 15 oz</li> <li>Color Family: 300 Green</li> <li>Hydration Type: Crux 1.5L Reservoir</li> <li>Torso Fit Range: 12" - 16"</li> <li>Gear Capacity: 5L</li> <li>Hydration Capacity: 1.5L</li> </ul>	[empty string]	N	49.99	49.99	[empty string]	101371-DEFAULT-s.jpg	[empty string]	1000	2814302000	380997	HYDRATION PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	camelbak/kid-s-mini-m-u-l-e-hydration-pack-with-crux-1-5l-reservior-50-oz-380997	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts307 ORDER BY sortposition asc

Camping

Sort By:

Items per page:

Filter