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]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	1	19.99	0	19.99	95599-DEFAULT-l.jpg	19.99	95599-DEFAULT-m.jpg	BLACK WATCH CAP	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]	98	15-to-20	0.00	[empty string]	ACRYLIC WATCH HAT - BLACK	<p>Originally designed as a workwear essential, it can now be found at construction sites and campgrounds, state fairs and football stadiums.</p> <p> </p> <ul> <li>100% acrylic rib knit</li> <li>Fold-up cuff with Carhartt patch</li> <li>Country of Origin: Imported</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	95599-DEFAULT-s.jpg	[empty string]	1000	A18BLK	12494	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/acrylic-watch-hat-black-12494	1
2	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	1	19.99	0	19.99	95619-DEFAULT-l.jpg	19.99	95619-DEFAULT-m.jpg	LIME WATCH CAP	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]	24	15-to-20	0.00	[empty string]	ACRYLIC WATCH HAT - LIME	<p>Originally designed as a workwear essential, it can now be found at construction sites and campgrounds, state fairs and football stadiums.</p> <p> </p> <ul> <li>100% acrylic rib knit</li> <li>Fold-up cuff with Carhartt patch</li> <li>Model No. A18</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	95619-DEFAULT-s.jpg	[empty string]	1000	A18BLM	12495	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/acrylic-watch-hat-lime-12495	1
3	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	1	19.99	0	19.99	95620-DEFAULT-l.jpg	19.99	95620-DEFAULT-m.jpg	BROWN WATCH CAP	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]	127	15-to-20	0.00	[empty string]	ACRYLIC WATCH HAT - BROWN	<p>Originally designed as a workwear essential, it can now be found at construction sites and campgrounds, state fairs and football stadiums.</p> <p> </p> <ul> <li>100% acrylic rib knit</li> <li>Fold-up cuff with Carhartt patch</li> <li>Model No. A18</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	95620-DEFAULT-s.jpg	[empty string]	1000	A18BRN	12496	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/acrylic-watch-hat-brown-12496	1
4	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	COAL HEATHER WATCH CAP	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]	7	15-to-20	0.00	[empty string]	Acrylic Watch Hat - Coal Heather	Made of stretchable, 100% acrylic rib-knit fabric, Carhartt`s Acrylic Watch Hat is designed for warmth and comfort.<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	A18CLH	12497	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/coal-heather-watch-cap-12497	1
5	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	1	19.99	0	19.99	95621-DEFAULT-l.jpg	19.99	95621-DEFAULT-m.jpg	NAVY WATCH CAP	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]	14	15-to-20	0.00	[empty string]	ACRYLIC WATCH HAT - NAVY	<p>Originally designed as a workwear essential, it can now be found at construction sites and campgrounds, state fairs and football stadiums.</p> <p> </p> <ul> <li>100% acrylic rib knit</li> <li>Fold-up cuff with Carhartt patch</li> <li>Model No. A18</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	95621-DEFAULT-s.jpg	[empty string]	1000	A18NVY	12499	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/acrylic-watch-hat-navy-12499	1
6	DARK BROWN	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	DARK BROWN\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	FLEECE 2N1 HEADWEAR	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]	Fleece 2-in-1 Headwear - Dark Brown	With the 2-in-1 Fleece Headwear from Carhartt you can either combine the fleece hat with the pull-down face mask or tuck the face mask up into the hat when not needed.<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	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	A202DKB	100433	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/fleece-2n1-headwear-100433	1
7	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	BRIGHT ORANGE WATCH HAT	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]	1	15-to-20	0.00	[empty string]	Acrylic Watch Hat - Bright Orange	Made of stretchable, 100% acrylic rib-knit fabric, Carhartt`s Acrylic Watch Hat is designed for warmth and comfort.<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	A18BOG	103575	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/bright-orange-watch-hat-103575	1
8	DNA,TRAGILA,EDGE	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Hats	DNA\|NULL\|NULL,TRAGILA\|NULL\|NULL,EDGE\|NULL\|NULL	1	29.99	0	29.99	97150-DEFAULT-l.jpg	29.99	97150-DEFAULT-m.jpg	SKULL CAP BEANIE	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]	14	25-to-50	0.00	[empty string]	FULL SEASON SKULL CAP	<p><strong>• Carbon Alloy</strong> <strong>technology</strong><br />     Provides maximum odor adsorption & scent control<br /> •<strong> DWR Finish</strong><br />      Sheds light moisture<br /> <strong>• Wicking treatment</strong><br />      To wick sweat and keep you cool<br /> <strong>• Fleece paneling over the ears and neck</strong><br />      For a bit of added warmth<br /> <strong>• Two Way stretch fabric</strong><br />     For comfort in the field</p>	[empty string]	N	29.99	29.99	ONE SZ FITS ALL	97150-DEFAULT-s.jpg	[empty string]	1000	2110041	166844	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	scentlok/full-season-skull-cap-166844	1
9	SBA	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Hats	SBA\|NULL\|NULL	1	49	0	49	96592-DEFAULT-l.jpg	49	96592-DEFAULT-m.jpg	SUN HAT	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	NOT ONLINE	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	SITKA SUN HAT	<p>The SITKA Sun Hat is ideal for long hours behind glass. The brim has a dark underside to limit eye strain in bright conditions, and a soft, contour that won’t interfere with bow strings.</p> <p> </p> <ul> <li> <p><strong>Quick Dry:</strong> CORDURA nylon fabric easily dries out sweat and rain.</p> </li> <li> <p><strong>Dark Underbrim:</strong> The dark underbrim refracts the light for reduced exposure and eye strain.</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	49	49	S/M	96592-DEFAULT-s.jpg	[empty string]	1000	90173	284021	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/sitka-sun-hat-284021	1
10	BLZ	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Hats	BLZ\|NULL\|NULL	1	30	0	30	96598-DEFAULT-l.jpg	30	96598-DEFAULT-m.jpg	SITKA TRUCKER	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]	SITKA TRUCKER	<p>The classic trucker features a mesh back for added breathability.</p> <p> </p> <ul> <li> <p><strong>Imported</strong></p> </li> </ul>	[empty string]	N	30	30	ONE SZ FITS ALL	96598-DEFAULT-s.jpg	[empty string]	1000	90188	284023	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/sitka-trucker-284023	1
11	[empty string]	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	1	19.99	0	19.99	96304-DEFAULT-l.jpg	19.99	96304-DEFAULT-m.jpg	BLACK WHITE WATCH CAP	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	15-to-20	0.00	[empty string]	ACRYLIC WATCH HAT - BLK/WHT	<p>Originally designed as a workwear essential, this warm, comfy hat can now be found at construction sites and campgrounds, state fairs and football stadiums. </p> <p> </p> <ul> <li>100% acrylic rib knit</li> <li>Fold-up cuff with Carhartt patch</li> </ul>	[empty string]	N	19.99	19.99	ONE SZ FITS ALL	96304-DEFAULT-s.jpg	[empty string]	1000	A18BLK/WHT	289442	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/acrylic-watch-hat-blk-wht-289442	1
12	GILA	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Hats	GILA\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	BOWHUNTER ELITE HEADCOVER	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]	1	25-to-50	0.00	[empty string]	Bowhunter Elite Headcover	[empty string]	[empty string]	N	39.99	39.99	ONE SZ FITS ALL	[empty string]	[empty string]	1000	2110644	318160	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	scentlok/bowhunter-elite-headcover-318160	1
13	223,225	SCENTLOK	Scentlok	CLOTHING	Clothing>Mens>Accessories>Hats	223\|NULL\|NULL,225\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	BE:1 CAP RT EXCAPE	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]	36	25-to-50	0.00	[empty string]	Gamechanger Heavyweight Jacket	FEATURES:<br/> -ScentLok Carbon Alloy technology<br/> -Moisture wicking treated<br/> -Removable hood with magnet closures<br/> -Single hand cinch hood adjusters<br/> -Two chest pockets for gear storage<br/> -Two large waist pockets<br/> -One hand hood cinch adjuster<br/> -Hidden zipper when hood is removed<br/> -Safety harness access opening<br/> -Sleeve zippers with gussets<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	29.99	29.99	O/S	[empty string]	[empty string]	1000	2110640	324869	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	scentlok/be-1-cap-rt-excape-324869	1
14	[empty string]	FISH POND	Fish Pond	CLOTHING	Clothing>Mens>Accessories>Hats	[empty string]	1	22.99	0	22.99	102940-DEFAULT-l.jpg	22.99	102940-DEFAULT-m.jpg	RAINBOW TROUT HAT OLIVE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Rainbow Trout Hat - Olive	<p>Take your shade with you. Fishpond hats look as good on the water as they do at the evening watering hole. Sun protection meets style.</p>	[empty string]	N	22.99	22.99	[empty string]	102940-DEFAULT-s.jpg	[empty string]	1000	RTH-O	327649	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	fish-pond/rainbow-trout-hat-olive-327649	1
15	ELV	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Hats	ELV\|NULL\|NULL	1	89	0	89	97015-DEFAULT-l.jpg	89	97015-DEFAULT-m.jpg	FANATIC BEANIE	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]	7	50-to-100	0.00	[empty string]	FANATIC BEANIE	<p>The Fanatic beanie offers whitetail hunters the ultimate in warmth and silence for frigid tree stand hunts with GORE-TEX INFINIUM WINDSTOPPER Technology, PrimaLoft Insulation and acoustic hearing ports to hear deer approaching earlier.</p>	[empty string]	N	89	89	L/XL,M/L	97015-DEFAULT-s.jpg	[empty string]	1000	90289	339242	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/fanatic-beanie-339242	1
16	CHARCOAL/SLATE	FISH POND	Fish Pond	CLOTHING	Clothing>Mens>Accessories>Hats	CHARCOAL/SLATE\|NULL\|NULL	1	24.99	0	24.99	102935-DEFAULT-l.jpg	24.99	102935-DEFAULT-m.jpg	MEATHEAD HAT	N	7 BRYAN	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Savage Creek Chest Pack - Cutthroat Green	<p>ake your shade with you. Fishpond hats look as good on the water as they do at the evening watering hole. Sun protection meets style.</p>	[empty string]	N	24.99	24.99	[empty string]	102935-DEFAULT-s.jpg	[empty string]	1000	MHH-C/S	344308	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	fish-pond/meathead-hat-344308	1
17	V52,HA9,G60	CARHARTT INC	Carhartt Inc	CLOTHING	Clothing>Mens>Accessories>Hats	V52\|NULL\|NULL,HA9\|NULL\|NULL,G60\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	CANVAS CAP	N	6 AMBER	[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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	22	20-to-25	0.00	[empty string]	CANVAS CAP	<p>Fights odors. Wicks away sweat. </p> <p> </p> <ul> <li>100% cotton washed canvas</li> <li>Force sweatband has FastDry technology that wicks away sweat for comfort</li> <li>Light-structured, medium-profile cap with pre-curved visor</li> <li>Adjustable fit with hook-and-loop closure</li> <li>Leatherette Carhartt label sewn on front</li> <li>Force sweatband fights odors</li> </ul>	[empty string]	N	24.99	24.99	ONE SZ FITS ALL	[empty string]	[empty string]	1000	100289	347010	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	carhartt-inc/canvas-cap-347010	1
18	A91,HDC,37U,OC5	NORTH FACE	NORTH FACE	CLOTHING	Clothing>Mens>Accessories>Hats	A91\|NULL\|NULL,HDC\|NULL\|NULL,37U\|NULL\|NULL,OC5\|NULL\|NULL	0	45	0	45	[empty string]	45	[empty string]	HORIZON BREEZE BRIMMER HAT	N	6.1 AMBER	[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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	29	25-to-50	0.00	[empty string]	HORIZON BREEZE BRIMMER HAT	<p>The Horizon Breeze Brimmer Hat is an airy full-brim hat, with sweat-wicking FlashDry, and UPF 40+ protection. It’s perfect for long, memorable days in the summer sun. It’s proudly recommended by The Skin Cancer Foundation, earning their Seal of Recommendation for safe and effective UV protection.</p> <p> </p> <ul> <li>Body made with recycled nylon and lining made with recycled polyester</li> <li>Sweatband features FlashDry-Pro materials that actively pull moisture away from the body to keep you feeling dry and comfortable during activity</li> <li>Adjustable chin strap with a cord lock made with recycled plastic</li> <li>Ultraviolet Protection Factor (UPF) 40+</li> <li>Proudly recommended by The Skin Cancer Foundation, earning their Seal of Recommendation for safe and effective UV protection</li> <li>Heat transfer logo</li> </ul>	[empty string]	N	45	45	S/M,L/XL	[empty string]	[empty string]	1000	NF0A5FX6	364789	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	north-face/horizon-breeze-brimmer-hat-364789	1
19	WTF,ELV,SUBA,DPLCN	SITKA GEAR	Sitka Gear	CLOTHING	Clothing>Mens>Accessories>Hats	WTF\|NULL\|NULL,ELV\|NULL\|NULL,SUBA\|NULL\|NULL,DPLCN\|NULL\|NULL	1	35	0	35	97012-DEFAULT-l.jpg	35	97012-DEFAULT-m.jpg	TRAVERSE CAP	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]	14	25-to-50	0.00	[empty string]	TRAVERSE CAP	<p>A versatile hat for every pursuit, the Traverse Hat is constructed of textiles made from recycled materials. An adjustable back lets you dial in the fit, and a durable water repellent finish sheds light precipitation.</p> <p> </p> <p> </p> <ul> <li> <p>Recycled light stretch woven fabric (90% recycled polyester, 10% elastane)</p> </li> <li> <p>Durable water repellent finish sheds light precipitation and keeps fabric from wetting out</p> </li> <li> <p>Adjustable back</p> </li> </ul>	[empty string]	N	35	35	ONE SZ FITS ALL	97012-DEFAULT-s.jpg	[empty string]	1000	600031	371204	ACCESSORIES	HATS	EMPTY	0	0	0	MENS	[empty string]	sitka-gear/traverse-cap-371204	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts619 ORDER BY sortposition asc

Clothing

Sort By:

Items per page:

Filter

Filter By

Price

Brand

Size

Acrylic Watch Hat - Black

Acrylic Watch Hat - Lime

Acrylic Watch Hat - Brown

Acrylic Watch Hat - Coal Heather

Acrylic Watch Hat - Navy

Fleece 2- In- 1 Headwear - Dark Brown

Acrylic Watch Hat - Bright Orange

Full Season Skull Cap

Sitka Sun Hat

Sitka Trucker

Acrylic Watch Hat - Blk/Wht

Bowhunter Elite Headcover

Gamechanger Heavyweight Jacket

Rainbow Trout Hat - Olive

Fanatic Beanie

Savage Creek Chest Pack - Cutthroat Green

Canvas Cap

Horizon Breeze Brimmer Hat

Traverse Cap