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]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	73	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	M,L,XL	[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 MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV2\|NULL\|NULL	0	40	0	40	[empty string]	40	[empty string]	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	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Fanatic Glove - Elevated Ii	<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 Series pieces. The half-finger design on the forefinger and thumb frees up your primary digits for release triggers and touchscreens.</p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Leather Pull:  Durable leather pull provides an easy on/off.</p> <p> </p> <p>-Half-Finger Design:  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> <p> </p>	[empty string]	N	40	40	L	[empty string]	[empty string]	1000	90089	253434	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/fanatic-glove-253434	1
3	ELV2	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV2\|NULL\|NULL	0	89	0	89	[empty string]	89	[empty string]	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]	3	50-to-100	0.00	[empty string]	Stratus Glove - Elevated Ii	<p>The Stratus Glove will keep your fingers warm and agile when the moment of truth strikes. The 100% windproof 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 your best friend for long days in the blind.</p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES: </strong></p> <p> </p> <p>-Complete Windproof Protection:  A 100% windproof GORE WINDSTOPPER membrane with a soft micro-grid fleece liner seals out the cold.</p> <p> </p> <p>-Articulated Fingers:  The articulated patterning provides ultimate dexterity and precision.</p> <p> </p> <p>-Pittard`s Oiltac Leather Palms:  High-grip leather palm gives you complete control of your weapon.</p> <p> </p> <p>-Leather Pull:  Durable leather pull provides an easy on/off.</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>	[empty string]	N	89	89	M	[empty string]	[empty string]	1000	90093	253435	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/stratus-glove-253435	1
4	ELV2	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV2\|NULL\|NULL	0	149	0	149	[empty string]	149	[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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	100-to-150	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	149	149	L,M,XL	[empty string]	[empty string]	1000	90091	253436	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/incinerator-flip-mitt-253436	1
5	TAN	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	TAN\|NULL\|NULL	0	99	0	99	[empty string]	99	[empty string]	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]	8	50-to-100	0.00	[empty string]	Gunner Ws Glove	<p>We 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 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> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Adjustable Closure:  The quiet velcro closure offers a custom fit and further seals out the elements.</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>	[empty string]	N	99	99	M,L,XL	[empty string]	[empty string]	1000	90162	270673	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/gunner-ws-glove-270673	1
6	WTRF	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	WTRF\|NULL\|NULL	0	129	0	129	[empty string]	129	[empty string]	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]	1	100-to-150	0.00	[empty string]	Pantanal Gtx Glove	<p>The Pantanal Glove keeps your hands dry and functioning in the wettest weather imaginable, deploying a 100% waterproof, breathable GORE-TEX membrane that’s bonded all the way through with +Grip for a non-slip grip. Goat leather fingertips add durability and dexterity. The outer stretch-woven polyester face fabric moves with you, while an absorbent back pad keeps a cold, runny nose contained. </p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-GORE-TEX 3-Layer Harshell:  Waterproof and breathable GORE-TEX 3-layer laminate provides 100% waterproof protection.</p> <p> </p> <p>-Leather Palm and Fingers:  For exceptional dexterity and durability.</p> <p> </p> <p>-Articulated Fingers:  The articulated patterning of the Pantanal GTX Glove minimizes bulk for maximum dexterity.</p> <p> </p> <p>-Backhand Absorbent Pad:  Keeps a runny nose under control.</p> <p> </p> <p>-GORE-TEX Technology:  Garments engineered with GORE-TEX fabrics are durably waterproof and windproof and very breathable — guaranteed. They provide reliable weather protection and maximized comfort in all weather conditions. Excellent management of perspiration leads to...</p> <p> </p> <p>-PRIMALOFT Technology:  PrimaLoft products are the ultimate in insulation technology for hunters. Ultra-fine fibers are engineered to retain maximum warmth even when wet, and create a product that is quiet and less bulky, allowing for greater freedom of movement.</p> <p> </p>	[empty string]	N	129	129	M	[empty string]	[empty string]	1000	90142	270686	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/pantanal-gtx-glove-270686	1
7	MRSH	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	MRSH\|NULL\|NULL	0	99	0	99	[empty string]	99	[empty string]	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	ONLINE	[empty string]	[empty string]	1	50-to-100	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. </p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-GORE-TEX Technology:  Garments engineered with GORE-TEX fabrics are durably waterproof and windproof and very breathable — guaranteed. They provide reliable weather protection and maximized comfort in all weather conditions. Excellent management of perspiration leads to...</p> <p> </p> <p>-PRIMALOFT Technology:  PrimaLoft products are the ultimate in insulation technology for hunters. Ultra-fine fibers are engineered to retain maximum warmth even when wet, and create a product that is quiet and less bulky, allowing for greater freedom of movement.</p> <p> </p>	[empty string]	N	99	99	L	[empty string]	[empty string]	1000	90147	270689	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/callers-glove-270689	1
8	EDG	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDG\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	WATERPROOF INSUL GLOVE	N	6 AMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	WATERPROOF	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Waterproof Insul Glove	[empty string]	[empty string]	N	49.99	49.99	M,XL	[empty string]	[empty string]	1000	2120033	285367	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/waterproof-insul-glove-285367	1
9	ELV	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	ELV\|NULL\|NULL	0	49	0	49	[empty string]	49	[empty string]	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]	6	25-to-50	0.00	[empty string]	Merino Glove	[empty string]	[empty string]	N	49	49	XL,L,2X	[empty string]	[empty string]	1000	90250	300372	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/merino-glove-300372	1
10	EDG	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	EDG\|NULL\|NULL	1	39.99	0	39.99	76779-DEFAULT-l.jpg	39.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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	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	39.99	39.99	L,M	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
11	SBAP	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	SBAP\|NULL\|NULL	0	40	0	40	[empty string]	40	[empty string]	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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Traverse Glove	[empty string]	[empty string]	N	40	40	L,M	[empty string]	[empty string]	1000	90177	316454	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/traverse-glove-316454	1
12	WTFM	SITKA MOUNTAIN GEAR	Sitka Mountain Gear	CLOTHING	Clothing>Mens>Accessories>Gloves	WTFM\|NULL\|NULL	0	40	0	40	[empty string]	40	[empty string]	GRADIENT 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]	5	25-to-50	0.00	[empty string]	Gradient Glove	[empty string]	[empty string]	N	40	40	M,L	[empty string]	[empty string]	1000	90185	336395	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	sitka-mountain-gear/gradient-glove-336395	1
13	GILA,EXCP	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	GILA\|NULL\|NULL,EXCP\|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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	21	50-to-100	0.00	[empty string]	Be1 Fortress Glove	[empty string]	[empty string]	N	69.99	69.99	L,XL,M	[empty string]	[empty string]	1000	2110632	337475	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/be1-fortress-glove-337475	1
14	DNA,EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	DNA\|NULL\|NULL,EDGE\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	Scentlok Custom Glove	[empty string]	[empty string]	N	29.99	29.99	M,L	[empty string]	[empty string]	1000	2105231	352633	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/scentlok-custom-glove-352633	1
15	225,223	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Gloves	225\|NULL\|NULL,223\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.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]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	Be1 Dexpro Glove	[empty string]	[empty string]	N	34.99	34.99	M,L,XL	[empty string]	[empty string]	1000	2110730	356087	ACCESSORIES	GLOVES	EMPTY	0	0	0	MENS	[empty string]	scentlok/be1-dexpro-glove-356087	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