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	EDG,TRAGILA	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDG\|NULL\|NULL,TRAGILA\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	POP TOP GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	35	25-to-50	0.00	[empty string]	Pop-top Glove - Realtree Xtra	Don`t let a pair of bulkly gloves ruin a shot of a lifetime. The ScentLok Pop-Top gloves keep your hands exceptionally warm and allows for extreme dexterity when shooting and features a magnetic closure and Realtree Xtra Camo.<br/>	[empty string]	N	44.99	44.99	XL,M,L	[empty string]	[empty string]	1000	2110034	151663	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/pop-top-glove-151663	1
2	ELV2	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV2\|NULL\|NULL	1	40	0	40	96564-DEFAULT-l.jpg	40	96564-DEFAULT-m.jpg	FANATIC GLOVE	N	6 AMBER	[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]	14	25-to-50	0.00	[empty string]	FANATIC GLOVE	<p>Built from 4-way stretch-woven polyester, the Fanatic Glove offers a perfect balance of warmth and dexterity, specifically for use with the front hand muff built into Fanatic system pieces. The half-finger design on the forefinger and thumb frees up your primary digits for release triggers and touchscreens.</p> <p> </p> <ul> <li> <p><strong>GORE OPTIFADE Concealment Elevated II </strong>is designed for whitetail hunters in an elevated position.</p> </li> <li> <p><strong>Weight:</strong> 1.6 oz.</p> </li> <li> <p><strong>Fabric:</strong> Stretch polyester knit.</p> </li> <li> <p><strong>Leather Pull:</strong> Durable leather pull provides an easy on/off.</p> </li> <li> <p><strong>Half-Finger Design:</strong> Half-finger design on the forefinger and thumb enables greater accuracy and the ability to use a touch screen GPS or phone on the fly.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	40	40	L,XL,M	96564-DEFAULT-s.jpg	[empty string]	1000	90089	253434	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/fanatic-glove-253434	1
3	ELV2	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV2\|NULL\|NULL	1	129	0	129	96565-DEFAULT-l.jpg	129	96565-DEFAULT-m.jpg	STRATUS GLOVE	N	6 AMBER	[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]	20	100-to-150	0.00	[empty string]	STRATUS GLOVE	<p>The Stratus Glove will keep your fingers warm and agile when the moment of truth strikes. The 100% windproof GORE-TEX INFINIUM with WINDSTOPPER membrane shields a micro-grid fleece lining to keep your digits comfortable while the stretch-woven shell moves with you for optimal dexterity. With a textured oil tac leather palm and goat leather thumb, pointer and middle finger, the Stratus glove will become an essential for long days in the blind.</p> <p> </p> <ul> <li> <p><strong>GORE OPTIFADE Concealment Elevated II </strong>is designed for whitetail hunters in an elevated position.</p> </li> <li> <p><strong>Weight:</strong> 4.8 oz. // Size: L</p> </li> <li> <p><strong>Fabric:</strong> GORE-TEX INFINIUM with WINDSTOPPER Technology, Polyester Micro-Fleece Knit Face, Polyester Micro-Grid Fleece Knit Backer.</p> </li> <li> <p><strong>GORE-TEX INFINIUM with WINDSTOPPER:</strong> Offers complete windproof protection through a durable, lightweight, and breathable membrane.</p> </li> <li> <p><strong>Articulated Fingers:</strong> The articulated patterning provides ultimate dexterity and precision.</p> </li> <li> <p><strong>Pittard's Oiltac Leather Palms:</strong> High-grip leather palm gives you complete control of your weapon.</p> </li> <li> <p><strong>Leather Pull:</strong> Durable leather pull provides an easy on/off.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	129	129	L,M,XL	96565-DEFAULT-s.jpg	[empty string]	1000	90093	253435	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/stratus-glove-253435	1
4	TAN	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	TAN\|NULL\|NULL	1	109	0	109	96579-DEFAULT-l.jpg	109	96579-DEFAULT-m.jpg	GUNNER WS GLOVE	N	6 AMBER	[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]	15	100-to-150	0.00	[empty string]	GUNNER WS GLOVE	<p>Sitka built the Gunner WINDSTOPPER Glove to maximize trigger feel while keeping your fingers from going numb late into the season. Durable, supple and dexterous, the goatskin leather outer is fixed to a super smooth, seamless GORE-TEX INFINIUM with WINDSTOPPER liner. The stretch-woven forefinger gives you precise trigger control, while the reinforced Pusher Thumb withstands pushing thousands of rounds into the chamber.</p> <p> </p> <ul> <li> <p><strong>Weight:</strong> 5.30 oz.</p> </li> <li> <p><strong>Fabric:</strong> GORE-TEX INFINIUM with WINDSTOPPER Technology, Water-Resistant Goat Leather with Knit Infinium with WINDSTOPPER Technology Liner</p> </li> <li> <p><strong>Adjustable Closure:</strong> The quiet velcro closure offers a custom fit and further seals out the elements.</p> </li> <li> <p><strong>GORE-TEX INFINIUM with WINDSTOPPER:</strong> Offers complete windproof protection through a durable, lightweight, and breathable membrane.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	109	109	XL,L,M	96579-DEFAULT-s.jpg	[empty string]	1000	90162	270673	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/gunner-ws-glove-270673	1
5	WTRF	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	WTRF\|NULL\|NULL	1	139	0	139	96588-DEFAULT-l.jpg	139	96588-DEFAULT-m.jpg	PANTANAL GTX GLOVE	N	6 AMBER	[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]	10	100-to-150	0.00	[empty string]	PANTANAL GTX GLOVE	<p>The Pantanal Glove will keep your hands dry and warm in the wettest conditions. 100% waterproof with a breathable GORE-TEX membrane that’s bonded all the way through with +Grip for a non-slip grip and PrimaLoft Silver insulation for warmth. Goat leather palm and fingertips provide durability and dexterity while the stretch-woven polyester face fabric ensures the optimal range of motion for all shooting conditions.</p> <p> </p> <ul> <li> <p><strong>GORE OPTIFADE Concealment Waterfowl Marsh</strong> is designed for layout and blind hunting in the marsh, standing crops, and cut stubble fields.</p> </li> <li> <p><strong>Weight:</strong> 8 oz.</p> </li> <li> <p><strong>Fabric:</strong> Waterproof GORE-TEX membrane, Stretch-woven polyester.</p> </li> <li> <p><strong>Insulation:</strong> PrimaLoft Silver Insulation</p> </li> <li> <p><strong>GORE-TEX 3-Layer Harshell:</strong> Waterproof and breathable GORE-TEX 3-layer laminate provides 100% waterproof protection.</p> </li> <li> <p><strong>Leather Palm and Fingers:</strong> For exceptional dexterity and durability.</p> </li> <li> <p><strong>Articulated Fingers:</strong> The articulated patterning of the Pantanal GTX Glove minimizes bulk for maximum dexterity.</p> </li> <li> <p><strong>Backhand Absorbent Pad:</strong> Keeps a runny nose under control.</p> </li> <li> <p><strong>GORE-TEX Technology:</strong> Garments made with GORE-TEX fabrics are durably waterproof, lightweight, and extremely breathable.</p> </li> <li> <p><strong>PrimaLoft Technology:</strong> PrimaLoft products are the ultimate in insulation technology for hunters. Ultra-fine fibers are engineered to retain maximum warmth even when wet.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	139	139	L,XL,M	96588-DEFAULT-s.jpg	[empty string]	1000	90142	270686	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/pantanal-gtx-glove-270686	1
6	MRSH	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	MRSH\|NULL\|NULL	1	109	0	109	96591-DEFAULT-l.jpg	109	96591-DEFAULT-m.jpg	CALLERS GLOVE	N	6 AMBER	[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	100-to-150	0.00	[empty string]	CALLERS GLOVE - LEFT HAND	<p>An innovative glove sold in singles (not pairs) the Caller’s Glove lets you keep one hand free for better calling and trigger control. Between waves, keep your trigger hand warm in the highly insulated, Berber-lined hand muff, which is bonded to the back of an ultra-warm GORE-TEX glove. NOTE: Right-handed shooters will need to purchase the left-handed glove, and vice versa.</p> <p> </p> <ul> <li> <p><strong>GORE OPTIFADE Concealment Waterfowl Marsh</strong> is designed for layout and blind hunting in the marsh, standing crops, and cut stubble fields.</p> </li> <li> <p><strong>Weight:</strong> 7.1 oz.</p> </li> <li> <p><strong>Fabric:</strong> Waterproof GORE-TEX Membrane, Durable Polyester Twill With Woven Backer.</p> </li> <li> <p><strong>GORE-TEX Technology:</strong> Garments made with GORE-TEX fabrics are durably waterproof, lightweight, and extremely breathable.</p> </li> <li> <p><strong>PrimaLoft Technology:</strong> PrimaLoft products are the ultimate in insulation technology for hunters. Ultra-fine fibers are engineered to retain maximum warmth even when wet.</p> </li> <li> <p>High Grip Synthetic Palm & Adjustable Muff Opening</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	109	109	L,XL	96591-DEFAULT-s.jpg	[empty string]	1000	90147	270689	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/callers-glove-left-hand-270689	1
7	ELV	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV\|NULL\|NULL	1	49	0	49	96626-DEFAULT-l.jpg	49	96626-DEFAULT-m.jpg	MERINO GLOVE	N	6 AMBER	[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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	MERINO GLOVE	<p>Combining the comfort and warmth of wool with the durability and elasticity of nylon, the Merino Glove is a heat-retaining liner to keep your hands comfortable without being clammy in the mid to late season.</p> <p> </p> <ul> <li> <p><strong>GORE OPTIFADE Concealment Elevated II </strong>is designed for whitetail hunters in an elevated position.</p> </li> <li> <p><strong>Weight:</strong> 2.40 oz.</p> </li> <li> <p><strong>Fabric:</strong> 54% Nylon Face, 46% 230-gram 17.5 Micron Merino Wool Interior.</p> </li> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	49	49	2X,L	96626-DEFAULT-s.jpg	[empty string]	1000	90250	300372	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/merino-glove-300372	1
8	EDG	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDG\|NULL\|NULL	1	44.99	0	44.99	76779-DEFAULT-l.jpg	44.99	76779-DEFAULT-m.jpg	FULL SEASON RELEASE GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	47	25-to-50	0.00	[empty string]	Full Season Release Glove	<p>The ultimate Full Season Midweight Glove with all the features you need, without the bulk.</p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong> </p> <p> </p> <p>-Carbon Alloy Technology: Provides maximum odor adsorption</p> <p> </p> <p>-Wicking Treatment: To wick sweat and keep you cool</p> <p> </p> <p>-Polyester Interlock Fabric: For next-to-skin comfort</p> <p> </p> <p>-Silicon printed palm: Designed to provide a better grip</p> <p> </p> <p>-DWR Finish: Sheds light moisture</p> <p> </p> <p>-Palm opening: Allows release to stay put and ready at all times</p> <p> </p> <p>-Touch Tech Finger Tips: For use with touch screen devices</p> <p> </p> <p>-Micro-Fleece Inter Fabric: For warmth</p> <p> </p>	[empty string]	N	44.99	44.99	M,L,XL	76779-DEFAULT-s.jpg	[empty string]	1000	2110331	302344	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/full-season-release-glove-302344	1
9	EXCP,GILA	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EXCP\|NULL\|NULL,GILA\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	BE1 FORTRESS GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Be1 Fortress Glove	[empty string]	[empty string]	N	69.99	69.99	L,M	[empty string]	[empty string]	1000	2110632	337475	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/be1-fortress-glove-337475	1
10	EDGE,DNA	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDGE\|NULL\|NULL,DNA\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.99	[empty string]	SCENTLOK CUSTOM GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	79	25-to-50	0.00	[empty string]	Scentlok Custom Glove	[empty string]	[empty string]	N	34.99	34.99	L,XL,M	[empty string]	[empty string]	1000	2105231	352633	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/scentlok-custom-glove-352633	1
11	ELV,SUBA,WTF,BLK	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV\|NULL\|NULL,SUBA\|NULL\|NULL,WTF\|NULL\|NULL,BLK\|NULL\|NULL	1	40	0	40	97009-DEFAULT-l.jpg	40	97009-DEFAULT-m.jpg	TRAVERSE GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	85	25-to-50	0.00	[empty string]	Traverse Glove	<p>Designed for comfort without the loss of dexterity, the Traverse Glove provides a soft, stretchy feel. Touchscreen compatibility allows you to easily use your phone or GPS, while a light silicone print on the palm provides grip on your treestand ladder, firearm or bow. Fabrics used in the glove are constructed from recycled materials.</p> <p> </p> <p> </p> <ul> <li> <p>Recycled stretch poly fleece fabric (98% recycled polyester, 2% elastane)</p> </li> <li> <p>Durable water repellent finish sheds light precipitation and resists staining</p> </li> <li> <p>Ax Suede touchscreen compatible index finger and thumb</p> </li> <li> <p>Light silicone print on palm for enhanced grip</p> </li> <li> <p>Total weight: 2 oz.</p> </li> </ul>	[empty string]	N	40	40	M,L,XL	97009-DEFAULT-s.jpg	[empty string]	1000	600032	371205	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/traverse-glove-371205	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts618 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Close

Filter By

Size

2X
L
M
S
XL

Filter