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,DNA,TRAGILA	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDG\|NULL\|NULL,DNA\|NULL\|NULL,TRAGILA\|NULL\|NULL	1	44.99	0	44.99	99485-DEFAULT-l.jpg	44.99	99485-DEFAULT-m.jpg	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]	2023	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	70	25-to-50	0.00	[empty string]	POP-TOP GLOVE	<p>Bulky gloves can virtually ruin the shot of a lifetime. These Pop-Top gloves keep hands exceptionally warm and allow for extreme dexterity when shooting, and include a magnetic closure.</p> <p> </p> <ul> <li><strong>Carbon Alloy</strong> <strong>technology </strong>combines activated carbon, treated carbon, and zeolite for maximum odor adsorption & scent control</li> <li><strong>A versatile flip-up mitt </strong>allows you to stay warm in the stand while maintaining dexterity</li> <li><strong>Magnetic closure </strong>keeps the mitt secure when you're anchoring a shot</li> <li><strong>Palm grip design </strong>provides confidence in your grip</li> </ul>	[empty string]	N	44.99	44.99	M,L,XL	99485-DEFAULT-s.jpg	[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]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	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	M,XL	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]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	11	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	M,L,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	ELV2	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV2\|NULL\|NULL	0	159	0	159	[empty string]	159	[empty string]	INCINERATOR FLIP MITT	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]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	Incinerator Flip Mitt - Elevated Ii	<p>The best defense against numb fingers in a biting cold, the Incinerator Flip Mitt wraps your digits together in a WINDSTOPPER laminate barrier insulated with Primaloft Down Blend Gold. When you need your fingers free, just flip off the mitt — the wet-printed Micro-Fleece face fabric makes it deadly silent. </p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Insulated Flip Over Mitt:  The insulated flip over mitt keeps your hands warm and relaxed with a 100% windproof GORE® WINDSTOPPER® membrane surrounded by PrimaLoft Gold down insulation blend. </p> <p> </p> <p>-Articulated Fingers:  For ultimate dexterity and precision. </p> <p> </p> <p>-Leather Palms:  For added protection and a no-slip grip.</p> <p> </p> <p>-WINDSTOPPER Technology:  WINDSTOPPER products shelter hunters from the adverse effects of bone-chilling winds. The WINDSTOPPER membrane works with our base layers to prevent overheating and perspiration build-up by allowing moisture vapor to easily escape.</p> <p> </p> <p>-POLYGIENE Technology:  Layering is a science with our CORE system of next-to-skin products. Each of the fabric weights—light, mid, and heavy—wicks away moisture to keep you warm and dry, while Polygiene technology safely and permanently neutralizes odors using naturally antimicrobial silver salt.</p> <p> </p>	[empty string]	N	159	159	L,M	[empty string]	[empty string]	1000	90091	253436	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/incinerator-flip-mitt-253436	1
5	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]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	4	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	L	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
6	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]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	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	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
7	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]	19	50-to-100	0.00	[empty string]	Be1 Fortress Glove	[empty string]	[empty string]	N	69.99	69.99	XL,M,L	[empty string]	[empty string]	1000	2110632	337475	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/be1-fortress-glove-337475	1
8	DNA,EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	DNA\|NULL\|NULL,EDGE\|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]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	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
9	223,225	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	223\|NULL\|NULL,225\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	BE1 DEXPRO 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]	3	25-to-50	0.00	[empty string]	Be1 Dexpro Glove	[empty string]	[empty string]	N	39.99	39.99	M,L	[empty string]	[empty string]	1000	2110730	356087	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/be1-dexpro-glove-356087	1
10	SUBA,BLK,ELV	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	SUBA\|NULL\|NULL,BLK\|NULL\|NULL,ELV\|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]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	8	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	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

L
M
XL

Filter