Jay's Sporting Goods

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	EUCLYTP,SAND	SUNDAY	Sunday	CLOTHING	Clothing>Mens>Accessories>Hats	EUCLYTP\|NULL\|NULL,SAND\|NULL\|NULL	1	40	0	40	105114-DEFAULT-l.jpg	40	105114-DEFAULT-m.jpg	ORIGINAL ADVENTURE 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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	16	25-to-50	0.00	[empty string]	ADVENTURE HAT	<p>Every inch of this hat is engineered for FUNctional sun protection: smart fabrics, customizable sizing, innovative features, and a sun-conscious design. Wherever your adventures take you—trekking, running rapids, or a date with some salted caramel ice cream on a sunny patio—the Adventure Hat has you covered.</p>	[empty string]	N	40	40	L/XL,S/M	105114-DEFAULT-s.jpg	[empty string]	1000	S2A01001	365417	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	sunday/adventure-hat-365417	1
2	JADE/PUMC,LVNR/PUMC	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories>Hats	JADE/PUMC\|NULL\|NULL,LVNR/PUMC\|NULL\|NULL	1	42	0	42	104936-DEFAULT-l.jpg	42	104936-DEFAULT-m.jpg	CLEAR CREEK BOONIE	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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	CLEAR CREEK BOONIE	<p>The reversible Clear Creek Boonie  give's you two looks in one. Take one side out for a ramble through the wilderness, then flip it over when you get to the café—both sides feature high performance fabrics that look and feel great. The adjustable cordlock dials in your custom, comfy fit. The chinstrap holds it close when you’re on the move but detaches when it’s time to kick back.The Clear Creek packs completely flat with your travel itinerary.</p> <p> </p> <ul> <li>UPF 50+ Sun Rating</li> <li>3" Crushable Brim</li> <li>Reversible for Two Color Options</li> <li>Packs for Travel</li> <li>Removable Chinstrap</li> <li>Adjustable Sizing</li> <li>Weight: 3.1 ounces/87.9 grams</li> </ul>	[empty string]	N	42	42	M	104936-DEFAULT-s.jpg	[empty string]	1000	S2C11395	365419	EMPTY	HATS	EMPTY	0	0	0	WOMEN	[empty string]	sunday/clear-creek-boonie-365419	1
3	BEACH/SEA,GRASS/LILAC	SUNDAY	Sunday	CLOTHING	Clothing>Youth>Accessories>Hats	BEACH/SEA\|NULL\|NULL,GRASS/LILAC\|NULL\|NULL	1	22	0	22	105116-DEFAULT-l.jpg	22	105116-DEFAULT-m.jpg	INF SUNSKIPPER BUCKET	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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	12	20-to-25	0.00	[empty string]	INFANT SUNSKIPPER BUCKET	<p>Made from 100% recycled bluesign certified wicking fabric not treated with any chemicals for safety. The short, flexible brim allows for maximum visibility and comfort. Reversible design makes for two hats in one and a velcro tabbed chinstrap breaks away easily to keep kids safe.</p>	[empty string]	N	22	22	6/12,0/6	105116-DEFAULT-s.jpg	[empty string]	1000	S2F03808	365421	EMPTY	HATS	EMPTY	0	0	0	YOUTH	[empty string]	sunday/infant-sunskipper-bucket-365421	1
4	BUTTRFLY	SUNDAY	Sunday	CLOTHING	Clothing>Youth>Accessories>Hats	BUTTRFLY\|NULL\|NULL	1	29	0	29	104930-DEFAULT-l.jpg	29	104930-DEFAULT-m.jpg	KIDS FUN BUCKET	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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	KIDS' FUN BUCKET	<p>A simple hat for kids’ simple needs. Crushable, floatable, water and stain resistant, and breathable. They don’t even have to know it’s sun protective, but you’ll have that peace of mind. With its go everywhere design, kids won’t forget their Fun Bucket.</p> <p> </p> <ul> <li>2 ½" Flexible Down-Sloped Brim With Floatable Foam Core</li> <li>UPF 50+ Certified Sun Rating (Mesh Vents Not Rated)</li> <li>Strategic Mesh Ventilation Panels On Child And Youth Sizes</li> <li>Water Repellent / Stain Resistant</li> <li>Floats In Water</li> <li>Packs Flat For Travel</li> <li>Smartstrap Breakaway Chinstrap Technology</li> <li>External Sizing Band For Custom Fit</li> <li>Stroller Friendly</li> <li>Designed In The USA</li> <li>Weight: 2.4 Ounces/68.0 grams</li> </ul>	[empty string]	N	29	29	S,M	104930-DEFAULT-s.jpg	[empty string]	1000	S2D03037	365422	EMPTY	HATS	EMPTY	0	0	0	YOUTH	[empty string]	sunday/kids-fun-bucket-365422	1
5	SAND	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories>Hats	SAND\|NULL\|NULL	1	44	0	44	104939-DEFAULT-l.jpg	44	104939-DEFAULT-m.jpg	LATITUDE 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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	LATITUDE HAT	<p>Full sun protection in a stylish profile, the Latitude Hat offers remarkably broad coverage with folding Reverse Split Brim technology. Shades stay put front or back with Sunglass Lock feature, and a signature moisture-wicking sweatband makes this hat the perfect companion for any outdoor activity.</p>	[empty string]	N	44	44	M,L,XL	104939-DEFAULT-s.jpg	[empty string]	1000	S2A02609	365424	EMPTY	HATS	EMPTY	0	0	0	WOMEN	[empty string]	sunday/latitude-hat-365424	1
6	SEA	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories>Hats	SEA\|NULL\|NULL	1	36	0	36	104933-DEFAULT-l.jpg	36	104933-DEFAULT-m.jpg	SOL SEEKER 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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	SOL SEEKER HAT	<p>An on-trend floppy brim, a mixed weave color palette, and a hint of detail on the leatherette hatband all add up to one charismatic sun hat. The Sol Seeker has you covered for those long days of summer where sun protection and looking great are essential, from the U-Pick farm to that outdoor concert to the spontaneous hike to a mountain meadow picnic. Packable construction ensures it tags along in a backpack or tote bag. The soft interior sweatband keeps you comfortable and holds an adjustable sizing tie so you can customize the fit. </p> <p> </p> <ul> <li>UPF 50+ Sun Rating</li> <li>3 ½" Brim</li> <li>Breathable Polyester/Paper Braid</li> <li>Packs for Travel</li> <li>Decorative Hatband</li> <li>Comfort Sweatband</li> <li>Internal Adjustable Sizing</li> <li>Avoid Rain/WetConditions</li> <li>Weight: 5.5 ounces/155.9 grams</li> </ul>	[empty string]	N	36	36	L,M	104933-DEFAULT-s.jpg	[empty string]	1000	S2C86496	365426	EMPTY	HATS	EMPTY	0	0	0	WOMEN	[empty string]	sunday/sol-seeker-hat-365426	1
7	PUMC,HORZN	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories>Hats	PUMC\|NULL\|NULL,HORZN\|NULL\|NULL	1	42	0	42	105117-DEFAULT-l.jpg	42	105117-DEFAULT-m.jpg	ULTRA ADVENTURE 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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	ULTRA ADVENTURE HAT	<ul> <li>UPF 50+ Sun Rating (includes mesh)</li> <li>3¼" Brim and 6" Neck Cape</li> <li>Sunglass Lock™ Keeps Glasses in Place</li> <li>Wicking Sweatband</li> <li>PFA-free durable water repellent finish</li> <li>Adjustable Sizing</li> <li>bluesign  certified main body fabric, mesh, and sweatband</li> <li>Reverse Split Brim   packs small and flat</li> <li>Weight: 2.6 ounces/73.7 grams</li> </ul>	[empty string]	N	42	42	L/XL,S/M	105117-DEFAULT-s.jpg	[empty string]	1000	S2A01392	365429	EMPTY	HATS	EMPTY	0	0	0	WOMEN	[empty string]	sunday/ultra-adventure-hat-365429	1
8	CARML	SUNDAY	Sunday	CLOTHING	Clothing>Mens>Accessories>Hats	CARML\|NULL\|NULL	1	48	0	48	104938-DEFAULT-l.jpg	48	104938-DEFAULT-m.jpg	UNWIND 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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	UNWIND HAT	<p>Take your chill to a whole new level with the Unwind hat. This mid-size fedora is made from 100% natural Mexican tripilla straw and has a 3” brim for excellent UPF 50+ sun protection. The elasticized sweatband ensures a comfortable fit while the genuine leather hatband adds a classy touch. Dress it up for an evening out, or keep it casual for an afternoon by the pool, just relax and unwind.</p> <p> </p> <ul> <li>UPF 50+ sun rating</li> <li>3" (8cm) brim fedora</li> <li>100% natural tripilla straw</li> <li>Genuine leather hatband</li> <li>Elasticized sweatband for custom fit</li> <li>Made in Mexico from local fibers</li> <li>Weight: 7.4 ounces/210 grams</li> </ul>	[empty string]	N	48	48	L,M	104938-DEFAULT-s.jpg	[empty string]	1000	S2A22904	365431	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	sunday/unwind-hat-365431	1
9	CREM/SAND	SUNDAY	Sunday	CLOTHING	Clothing>Mens>Accessories>Hats	CREM/SAND\|NULL\|NULL	1	50	0	50	105110-DEFAULT-l.jpg	50	105110-DEFAULT-m.jpg	CHARTER 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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	CHARTER HAT	<p>Because the trails of life lead through uncharted territory, the Charter Hat is ready for anything. All the sun protection you expect from Sunday Afternoons, plus strategic ventilation and a moisture wicking sweatband keep you cool while you wander. The Charter is such a good companion, it even holds your sunglasses for you.</p>	[empty string]	N	50	50	M,L	105110-DEFAULT-s.jpg	[empty string]	1000	S2A09016	376710	EMPTY	HATS	EMPTY	0	0	0	MENS	[empty string]	sunday/charter-hat-376710	1
10	SALT	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories>Hats	SALT\|NULL\|NULL	1	44	0	44	104935-DEFAULT-l.jpg	44	104935-DEFAULT-m.jpg	VOYAGE 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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	VOYAGE HAT	<p>With a simple, four-panel crown and a broad, round brim, the Voyage Hat is your go-to for fun in the sun. Made from lightweight, bluesign-certified fabric, the strategic crown ventilation, adjustable sizing, and wicking sweatband ensure comfort and a great fit. Plus, the Sunglass Lock helps keep track of those glasses!</p> <p> </p> <ul> <li>UPF 50+ sun rating (mesh not rated)</li> <li>3.25"" (8.5cm) brim</li> <li>Sunglass Lock keeps glasses in place</li> <li>Strategic crown ventilation</li> <li>Adjustable chinstrap</li> <li>Adjustable sizing</li> <li>Floats in water</li> <li>Wicking sweatband</li> <li>bluesign certified main body fabric, mesh and sweatband</li> </ul>	[empty string]	N	44	44	M,L	104935-DEFAULT-s.jpg	[empty string]	1000	S2C02962	376713	EMPTY	HATS	EMPTY	0	0	0	WOMEN	[empty string]	sunday/voyage-hat-376713	1
11	CREAM	SUNDAY	Sunday	CLOTHING	Clothing>Women>Accessories>Hats	CREAM\|NULL\|NULL	1	39.99	0	39.99	104934-DEFAULT-l.jpg	39.99	104934-DEFAULT-m.jpg	WANDERLUST FEDORA	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	WANDERLUST FEDORA	<p>Ready for sunny adventures far away or close to home, the Wanderlust Fedora is a playful take on a classic style. Offering UPF 50+ sun protection and a decorative, beaded hatband, this hat is made from breathable poly/paper braid. The bluesign-certified sweatband and internal adjustable sizing offer comfort and a custom fit.</p> <p> </p> <ul> <li>UPF 50+ sun rating</li> <li>2.75" (7cm) brim fedora</li> <li>Breathable polyester/paper braid*</li> <li>Decorative beaded hatband</li> <li>Internal adjustable sizing</li> <li>Wicking sweatband</li> <li>bluesign certified sweatband</li> <li>Avoid rain / wet conditions</li> </ul>	[empty string]	N	39.99	39.99	S/M	104934-DEFAULT-s.jpg	[empty string]	1000	S2C27963	376714	EMPTY	HATS	EMPTY	0	0	0	WOMEN	[empty string]	sunday/wanderlust-fedora-376714	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

0/6
6/12
L
L/XL
M
S
S/M
XL

Filter