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	BUFF	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BUFF\|NULL\|NULL	1	199.99	0	199.99	109794-DEFAULT-l.jpg	199.99	109794-DEFAULT-m.jpg	W CARIBOU BOOT	N	5 EMILY	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	21	150-to-200	0.00	[empty string]	CARIBOU BOOT - WOMEN'S	<p>The Caribou is a favorite for everyday cold weather activities. This ultra comfortable boot features seam-sealed waterproof construction, with a suede and ballistic nylon upper. Iconic Caribou lug design provides proven traction on various terrain.</p> <p> </p> <ul> <li>Upper:</li> <li>  Waterproof Nubuck Upper</li> <li>  Seam-Sealed Waterproof Construction<br />   Laces Are Not Waterproof</li> <li>Insulation: Removable 9 Mm Washable Recycled Felt Inner Boot With Sherpa Pile Snow Cuff</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Handcrafted Waterproof Vulcanized Rubber Shell With Sorel Aero-Trac Non Loading Outsole</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/4"</li> <li>Platform Height: 3/4"</li> <li>Shaft Height: 8 1/2"</li> <li>Lace Length: 43"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	199.99	199.99	10,8,9,7,6,11,10.5	109794-DEFAULT-s.jpg	[empty string]	1000	1003812-280	104693	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/caribou-boot-women-s-104693	1
2	BLK/QUARRY	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLK/QUARRY\|NULL\|NULL	1	114.99	0	114.99	109799-DEFAULT-l.jpg	114.99	109799-DEFAULT-m.jpg	YOUTH TOFINO II	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	19	100-to-150	0.00	[empty string]	TOFINO II BOOT - YOUTH	<p>Fun is in the forecast with the stylish and fully waterproof Youth Tofino II boot. The tall silhouette with stitch detail offers a stylish boot that stands up to the elements, featuring a faux fur top cuff, cozy fleece lining and 100g insulation for warmth.</p> <p> </p> <ul> <li>Upper:</li> <li>  Waterproof Textile Upper With Pu Coated Leather Overlays</li> <li>  Faux Fur Cuff</li> <li>  Waterproof Breathable Membrane Construction</li> <li>  Fleece Lining</li> <li>Insulation: 100g Insulation</li> <li>Footbed: Removable Molded Eva Footbed, Microfleece Topcover</li> <li>Midsole: Rubber</li> <li>Outsole: Molded Rubber</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> <li>Uses: Light Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2".</li> <li>Platform Height: 1"</li> <li>Shaft Height: 8 3/4"</li> <li>Lace Length: 36"</li> <li>Measurements Based On Size 1</li> </ul> <p> </p>	[empty string]	N	114.99	114.99	6,7,5,4	109799-DEFAULT-s.jpg	[empty string]	1000	1690541-010	321722	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/tofino-ii-boot-youth-321722	1
3	DELTA/BLK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	DELTA/BLK\|NULL\|NULL	1	149.99	0	149.99	109784-DEFAULT-l.jpg	149.99	109784-DEFAULT-m.jpg	M BUXTON PULL-ON	N	5 EMILY	[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]	37	100-to-150	0.00	[empty string]	BUXTON PULL ON BOOT - MEN'S	<p>Whether you're heading out of town for a weekend trip or just bundling up for a day in the city streets, the Buxton Pull On snow boot will have you prepared for the elements. Waterproof suede and injection-molded thermal rubber upper. 200g insulating fabric lining, plus padded collar and tongue for extra comfort. Rubber sole with 2.5mm bonded felt frost plug keeps cold out and heat in.</p> <p> </p> <ul> <li>Upper:</li> <li>  Waterproof Suede Leather And Textile Upper</li> <li>  Seam-Sealed Waterproof Construction</li> <li>  Textile Lining</li> <li>Insulation: 200g Insulation</li> <li>Footbed: Removable Eva Footbed. Textile Topcover</li> <li>Outsole: Injection-Molded, Waterproof Thermal-Rubber Shell</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 3 3/4"</li> <li>Platform Height: 3 1/4"</li> <li>Shaft Height: 7"</li> <li>Shaft Circumference: 13 1/4"</li> <li>Measurements based on size 9</li> </ul>	[empty string]	N	149.99	149.99	10,11,12,13,9,8	109784-DEFAULT-s.jpg	[empty string]	1000	1760171-257	321755	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/buxton-pull-on-boot-men-s-321755	1
4	BLACK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	1	139.99	0	139.99	109855-DEFAULT-l.jpg	139.99	109855-DEFAULT-m.jpg	W WHITNEY SHORT LACE	N	5 EMILY	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	12	100-to-150	0.00	[empty string]	WHITNEY II SHORT LACE BOOT - WOMEN'S - BLACK	<p>A sporty winter boot with a lightweight fit. On top of being fully waterproof, it's filled with 200g insulation and lined in warm microfleece. The cushioned footbed and rubber sole is made for miles and miles of comfortable wear.</p> <p> </p> <ul> <li>Upper:</li> <li>  Waterproof Nylon Upper And Pu Coated Synthetic Overlays</li> <li>  Faux Fur Cuff Or Textile Cuff</li> <li>  Microfleece Lining</li> <li>  Waterproof Bootie Construction</li> <li>  Nylon Heel Pull Tab</li> <li>  Laces Are Not Waterproof</li> <li>Insulation: 200g Insulation</li> <li>Footbed: Removable Molded Pu-Like Eva Footbed, Microfleece Topcover</li> <li>Outsole: Molded Rubber. Molded Rubber Cupsole Construction</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> <li>Uses: Light Snow</li> </ul> <p> </p> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 3/4"</li> <li>Shaft Height: 6"</li> <li>Lace Length: 40"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	139.99	139.99	7,8,9,10,11	109855-DEFAULT-s.jpg	[empty string]	1000	1916841-010	335738	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/whitney-ii-short-lace-boot-women-s-black-335738	1
5	TAFFY/BLK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	TAFFY/BLK\|NULL\|NULL	1	129.99	0	129.99	109797-DEFAULT-l.jpg	129.99	109797-DEFAULT-m.jpg	W OUT N ABOUT III CLASSIC WP	N	5 EMILY	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	32	100-to-150	0.00	[empty string]	OUT N ABOUT III CLASSIC BOOT - WOMEN'S	<p>When it pours, the Out N About III Classic shines. This SOREL best seller features waterproof construction and an all-day comfort footbed. A thick sole with enhanced traction helps keep you elevated above the elements — just one more reason this is the ultimate rain boot.</p> <p> </p> <ul> <li>Upper:</li> <li>  Available In Waterproof Full Grain Leather & Suede Or Waterproof Suede & Felt</li> <li>  Textile Lining</li> <li>  Waterproof Bootie Construction</li> <li>  Waterproof Vulcanized Rubber Shell</li> <li>  Laces Are Not Waterproof</li> <li>Footbed: Removable Molded Eva, Textile Topcover</li> <li>Midsole: Internal Pu Midsole With Vulcanized Rubber Foxing Tape</li> <li>Outsole: Molded Rubber</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> </ul> <p> </p> <ul> <li>Heel Height: 3/4"</li> <li>Platform Height: 1/4"</li> <li>Shaft Height: 4 1/4"</li> <li>Lace Length: 37"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	129.99	129.99	8.5,9,9.5,8,7.5,10,11,7	109797-DEFAULT-s.jpg	[empty string]	1000	1951331-243	363738	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/out-n-about-iii-classic-boot-women-s-363738	1
6	QUARRY	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	QUARRY\|NULL\|NULL	1	149.99	0	149.99	109853-DEFAULT-l.jpg	149.99	109853-DEFAULT-m.jpg	W WHITNEY II TALL LACE WP	N	5 EMILY	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	20	100-to-150	0.00	[empty string]	WHITNEY II TALL LACE BOOT - WOMEN'S - QUARRY	<p>The ultimate in winter style. Lace up and take on the cold weather with confidence. A unique padded outer, durable waterproof construction and warm microfleece lining round out the reliably comfortable seasonal essential.</p> <p> </p> <ul> <li>Upper:</li> <li>  Waterproof Nylon Upper And Pu Coated Synthetic Overlays</li> <li>  Faux Fur Cuff Or Textile Cuff</li> <li>  Microfleece Lining</li> <li>  Waterproof Bootie Construction</li> <li>  Nylon Heel Pull Tab</li> <li>  Laces Are Not Waterproof</li> <li>Insulation: 200g Insulation</li> <li>Footbed: Removable Molded Pu-Like Eva Footbed, Microfleece Topcover</li> <li>Outsole: Molded Rubber Cupsole Construction</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> <li>Uses: Light Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 3/4"</li> <li>Shaft Height: 9 3/4"</li> <li>Lace Length: 45"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	149.99	149.99	8,9,10,11,7	109853-DEFAULT-s.jpg	[empty string]	1000	1921351-052	363747	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/whitney-ii-tall-lace-boot-women-s-quarry-363747	1
7	BLK/GUM	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLK/GUM\|NULL\|NULL	1	189.99	0	189.99	109851-DEFAULT-l.jpg	189.99	109851-DEFAULT-m.jpg	W TOFINO II WP	N	5 EMILY	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	13	150-to-200	0.00	[empty string]	TOFINO II BOOT - WOMEN'S - BLACK/GUM	<p>The Tofino II boot is a stylish and practical addition to your winter wardrobe. It offers a perfect balance of protection and style with a waterproof nylon upper, microfleece lining and 100g insulation, while the molded rubber outsole provides excellent traction.</p> <p> </p> <ul> <li>Upper:</li> <li>  A Pu Coated Leather And Felt Combination</li> <li>  Faux Fur Cuff. Microfleece Lining</li> <li>  Waterproof Breathable Membrane Construction</li> <li>  Laces Are Not Waterproof</li> <li>Insulation: 100g Insulation</li> <li>Footbed: Removable Molded Eva Footbed, Microfleece Topcover</li> <li>Midsole: Rubber</li> <li>Outsole: Molded Rubber</li> <li>Uses: Heavy Snow</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> </ul> <p> </p> <p> </p> <ul> <li>Heel Height: 1 3/4"</li> <li>Platform Height: 1"</li> <li>Shaft Height: 10 1/4"</li> <li>Lace Length: 42"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	189.99	189.99	8,10,7,9,11	109851-DEFAULT-s.jpg	[empty string]	1000	1959341-010	363758	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/tofino-ii-boot-women-s-black-gum-363758	1
8	TOBACCO/BLACK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	TOBACCO/BLACK\|NULL\|NULL	1	179.99	0	179.99	109786-DEFAULT-l.jpg	179.99	109786-DEFAULT-m.jpg	M 1964 PAC NYLON WP	N	5 EMILY	[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]	18	150-to-200	0.00	[empty string]	1964 PAC NYLON BOOT - WATERPROOF - MEN'S	<p>The 1964 Pac Nylon offers a stylish addition to your winter wardrobe while also providing serious protection from the elements. This boot features a timeless silhouette that looks great paired with layers, and all-weather construction that will keep you comfortable no matter the conditions outside.</p> <p> </p> <ul> <li>Upper: Waterproof Nylon Upper. Seam-Sealed Waterproof Construction. Laces Are Not Waterproof</li> <li>Insulation: Removable 9 Mm Washable Recycled Felt Inner Boot With Sherpa Pile Snow Cuff</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Handcrafted Waterproof Vulcanized Rubber Shell With Herringbone Outsole</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 3/4"</li> <li>Shaft Height: 10 1/4"</li> <li>Lace Length: 42"</li> <li>Please note: Laces and zippers incorporated in SOREL footwear are not waterproof.</li> <li>Measurements based on size 9</li> </ul>	[empty string]	N	179.99	179.99	9,10,13,11,12	109786-DEFAULT-s.jpg	[empty string]	1000	1855191-256	363768	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/1964-pac-nylon-boot-waterproof-men-s-363768	1
9	MAJOR/BLK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	MAJOR/BLK\|NULL\|NULL	1	149.99	0	149.99	109790-DEFAULT-l.jpg	149.99	109790-DEFAULT-m.jpg	M BUXTON LACE	N	5 EMILY	[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]	20	100-to-150	0.00	[empty string]	BUXTON LACE BOOT - MEN'S	<p>The style of a sneaker meets the warmth and protection of a winter boot. The waterproof suede and injection-molded thermal rubber upper includes 200g insulating fabric lining with a padded collar and tongue for extra comfort. The rubber sole with 2.5mm bonded felt frost plug keeps cold out and heat in.</p> <p> </p> <ul> <li>Upper:</li> <li>  Waterproof Suede Leather And Textile Upper</li> <li>  Seam-Sealed Waterproof Construction</li> <li>  Textile Lining</li> <li>Insulation: 200g Insulation</li> <li>Footbed: Removable Eva Footbed. Textile Topcover</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection-Molded, Waterproof Thermal-Rubber Shell</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 3 3/4"</li> <li>Platform Height: 3 1/4"</li> <li>Shaft Height: 7"</li> <li>Shaft Circumference: 11 3/4"</li> <li>Lace Length: 50"</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof.</li> <li>Measurements Based On Size 9</li> </ul>	[empty string]	N	149.99	149.99	10,11,12,9,13	109790-DEFAULT-s.jpg	[empty string]	1000	1760181-245	363769	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/buxton-lace-boot-men-s-363769	1
10	PULSE/BLK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	PULSE/BLK\|NULL\|NULL	1	89.99	0	89.99	109800-DEFAULT-l.jpg	89.99	109800-DEFAULT-m.jpg	Y YOOT PAC NYLON WP	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	34	50-to-100	0.00	[empty string]	YOOT PAC NYLON BOOT - YOUTH	<p>With waterproof nylon upper, seam-sealed construction and cozy insulation, cold weather doesn't stand a chance. Also, there's no need to tie these conveniently toggled laces. The inner liner with a sherpa collar is removable and washable.</p> <p> </p> <ul> <li>Upper:</li> <li>  Waterproof Nylon Upper</li> <li>  Seam-Sealed Waterproof Construction</li> <li>  Laces Are Not Waterproof</li> <li>Insulation: Removable 9 Mm Washable Recycled Felt Inner Boot With Sherpa Pile Snow Cuff</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Handcrafted Waterproof Vulcanized Rubber Shell With Sorel Aero-Trac Non-Loading Outsole</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/4"</li> <li>Platform Height: 3/4"</li> <li>Shaft Height: 8 3/4"</li> <li>Lace Length: 24"</li> <li>Measurements Based On Size 1</li> </ul> <p> </p>	[empty string]	N	89.99	89.99	2,3,4,5,6,1,7	109800-DEFAULT-s.jpg	[empty string]	1000	1855211-561	363773	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/yoot-pac-nylon-boot-youth-363773	1
11	BLACK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	1	64.99	0	64.99	109803-DEFAULT-l.jpg	64.99	109803-DEFAULT-m.jpg	C SNOW COMMANDER	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	27	50-to-100	0.00	[empty string]	SNOW COMMANDER BOOT - CHILDREN'S - BLACK/CHARCOAL	<p>With a waterproof synthetic exterior and 200g insulation, this winter boot keeps feet warm and dry. Plus, it’s packed with traction for playing in the snow, mud and grass.</p> <p> </p> <ul> <li>Upper: Pu Backed Synthetic Textile Upper. Fleece Lining</li> <li>Insulation: 200g Insulation</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection Molded Waterproof Thermal Rubber Shell With Multi-Directional Lug Outsole For Enhanced Traction</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 1"</li> <li>Shaft Height: 6 3/4"</li> <li>Measurements Based On Size 8</li> </ul>	[empty string]	N	64.99	64.99	9,12,8,11,10,13	109803-DEFAULT-s.jpg	[empty string]	1000	1869561-010	363778	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/snow-commander-boot-children-s-black-charcoal-363778	1
12	OCEAN	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	OCEAN\|NULL\|NULL	1	64.99	0	64.99	109805-DEFAULT-l.jpg	64.99	109805-DEFAULT-m.jpg	C SNOW COMMANDER	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	SNOW COMMANDER BOOT - CHILDREN'S - OCEAN SURF/CACTUS PINK	<p>With a waterproof synthetic exterior and 200g insulation, this winter boot keeps feet warm and dry. Plus, it’s packed with traction for playing in the snow, mud and grass.</p> <p> </p> <ul> <li>Upper: Pu Backed Synthetic Textile Upper. Fleece Lining</li> <li>Insulation: 200g Insulation</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection Molded Waterproof Thermal Rubber Shell With Multi-Directional Lug Outsole For Enhanced Traction</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 1"</li> <li>Shaft Height: 6 3/4"</li> <li>Measurements Based On Size 8</li> </ul>	[empty string]	N	64.99	64.99	8,9,10,13,11,12	109805-DEFAULT-s.jpg	[empty string]	1000	1869561-428	363779	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/snow-commander-boot-children-s-ocean-surf-cactus-pink-363779	1
13	BLACK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	1	54.99	0	54.99	109807-DEFAULT-l.jpg	54.99	109807-DEFAULT-m.jpg	T SNOW COMMANDER	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	SNOW COMMANDER BOOT - TODDLER - BLACK/CHARCOAL	<p>With a waterproof synthetic exterior and 200g insulation, this winter boot keeps feet warm and dry. Plus, it’s packed with traction for playing in the snow, mud, and grass.</p> <p> </p> <ul> <li>Upper: Pu Backed Synthetic Textile Upper. Fleece Lining</li> <li>Insulation: 200g Insulation</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection Molded Waterproof Thermal Rubber Shell With Multi-Directional Lug Outsole For Enhanced Traction</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 1"</li> <li>Shaft Height: 5 1/2"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	54.99	54.99	6,4,5,7	109807-DEFAULT-s.jpg	[empty string]	1000	1869562-010	363780	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/snow-commander-boot-toddler-black-charcoal-363780	1
14	OCEAN	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	OCEAN\|NULL\|NULL	1	54.99	0	54.99	109808-DEFAULT-l.jpg	54.99	109808-DEFAULT-m.jpg	T SNOW COMMANDER	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	SNOW COMMANDER BOOT - TODDLER - OCEAN SURF/CACTUS PINK	<p>With a waterproof synthetic exterior and 200g insulation, this winter boot keeps feet warm and dry. Plus, it’s packed with traction for playing in the snow, mud, and grass.</p> <p> </p> <ul> <li>Upper: Pu Backed Synthetic Textile Upper. Fleece Lining</li> <li>Insulation: 200g Insulation</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection Molded Waterproof Thermal Rubber Shell With Multi-Directional Lug Outsole For Enhanced Traction</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 1"</li> <li>Shaft Height: 5 1/2"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	54.99	54.99	5,7,4,6	109808-DEFAULT-s.jpg	[empty string]	1000	1869562-428	363781	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/snow-commander-boot-toddler-ocean-surf-cactus-pink-363781	1
15	STONEGREEN/ALPINE	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	STONEGREEN/ALPINE\|NULL\|NULL	1	154.99	0	154.99	109798-DEFAULT-l.jpg	154.99	109798-DEFAULT-m.jpg	W EXPLORER NEXT JOAN WP	N	5 EMILY	[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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	18	150-to-200	0.00	[empty string]	EXPLORER NEXT JOAN BOOT - WOMEN'S	<p>Featuring an updated fit for the season, this super lightweight Joan combines the fit and feel of a sneaker with the warmth of a boot. The waterproof upper is made with leather/suede or felt and features 100g cozy insulation. Underfoot, the EVA footbed supports all-day comfort while the rubber EVA sole offers grip for slick streets.</p> <p> </p> <ul> <li>Upper:</li> <li>  Available In Waterproof Suede With Faux Fur Cuff Or Waterproof Suede With Pu Leather Rand And Felt Tongue And Vamp</li> <li>  Microfleece Lining</li> <li>  Waterproof Bootie Construction</li> <li>  Laces Are Not Waterproof</li> <li>Insulation: 100g Insulation</li> <li>Footbed: Removable Molded Eva With Microfleece Topcover</li> <li>Midsole: Molded Eva With Rubber Heel Logo</li> <li>Outsole: Molded Rubber With Ground Contact Eva</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> </ul> <p> </p> <ul> <li>Shaft Height: 6 1/2"</li> <li>Lace Length: 42"</li> <li>Measurements Based On Size 7</li> </ul>	[empty string]	N	154.99	154.99	8,9,8.5,7.5,9.5,10,7	109798-DEFAULT-s.jpg	[empty string]	1000	2068791-397	378019	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/explorer-next-joan-boot-women-s-378019	1
16	STONEGREEN/BLK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	STONEGREEN/BLK\|NULL\|NULL	1	69.99	0	69.99	109878-DEFAULT-l.jpg	69.99	109878-DEFAULT-m.jpg	C FLURRY PRINT PAC BOOT	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	20	50-to-100	0.00	[empty string]	FLURRY PRINT BOOT - YOUTH - STONE GREEN/BLACK	<p>The perfect boot for deep snow, the upper blocks out water plus wind and also features a felt inner boot for supreme warmth. You can count on the multi-directional lug sole to keep them steady in slick conditions — plus, this boot is oh-so easy to get on and off.</p> <p> </p> <ul> <li>Upper:</li> <li>  Durable Water And Wind Resistant Pu Backed Synthetic Textile Upper</li> <li>  Built In Gaiter With Barrel Lock Closure System and Fixed Elastic Instep Strap</li> <li>Insulation: Removable 6 Mm Washable Recycled Felt Inner Boot</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection Molded Waterproof Thermal Rubber Shell With Multi-Directional Lug Outsole For Enhanced Traction</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 1/2"</li> <li>Shaft Height: 9 1/2"</li> <li>Shaft Circumference: 13 3/4"</li> <li>Measurements Based On Size 1</li> </ul>	[empty string]	N	69.99	69.99	12,13,10,11	109878-DEFAULT-s.jpg	[empty string]	1000	1888102-397	378035	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/flurry-print-boot-youth-stone-green-black-378035	1
17	SPRUCE/GRILL	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	SPRUCE/GRILL\|NULL\|NULL	1	69.99	0	69.99	109811-DEFAULT-l.jpg	69.99	109811-DEFAULT-m.jpg	Y FLURRY PAC BOOT	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	24	50-to-100	0.00	[empty string]	FLURRY BOOT - YOUTH - SPRUCE/GRILL	<p>The perfect boot for deep snow, the upper blocks out water plus wind and also features a felt inner boot for supreme warmth. You can count on the multi-directional lug sole to keep them steady in slick conditions — plus, this boot is oh-so easy to get on and off.</p> <p> </p> <ul> <li>Upper:</li> <li>  Durable Water And Wind Resistant Pu Backed Synthetic Textile Upper</li> <li>  Built In Gaiter With Barrel Lock Closure System and Fixed Elastic Instep Strap</li> <li>Insulation: Removable 6 Mm Washable Recycled Felt Inner Boot</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection Molded Waterproof Thermal Rubber Shell With Multi-Directional Lug Outsole For Enhanced Traction</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 1/2"</li> <li>Shaft Height: 9 1/2"</li> <li>Shaft Circumference: 13 3/4"</li> <li>Measurements Based On Size 1</li> </ul>	[empty string]	N	69.99	69.99	1,2,3,4,5,6	109811-DEFAULT-s.jpg	[empty string]	1000	1855251-370	378036	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/flurry-boot-youth-spruce-grill-378036	1
18	BLACK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	1	69.99	0	69.99	109813-DEFAULT-l.jpg	69.99	109813-DEFAULT-m.jpg	C FLURRY PRINT PAC BOOT	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	20	50-to-100	0.00	[empty string]	FLURRY PRINT BOOT - CHILDREN'S - BLACK	<p>The perfect boot for deep snow, the upper blocks out water plus wind and also features a felt inner boot for supreme warmth. You can count on the multi-directional lug sole to keep steady in slick conditions — plus, this boot is oh-so easy to get on and off.</p> <p> </p> <ul> <li>Upper:</li> <li>  Durable Water And Wind Resistant Pu Backed Synthetic Textile Upper</li> <li>  Built In Gaiter With Barrel Lock Closure System And Fixed Elastic Instep Strap</li> <li>Insulation: Removable 6 Mm Washable Recycled Felt Inner Boot</li> <li>Midsole: 2.5 Mm Bonded Felt Frost Plug</li> <li>Outsole: Injection Molded Waterproof Thermal Rubber Shell With Multi-Directional Lug Outsole For Enhanced Traction</li> <li>Uses: Heavy Snow</li> </ul> <p> </p> <ul> <li>Heel Height: 1 1/2"</li> <li>Platform Height: 1/2"</li> <li>Shaft Height: 7"</li> <li>Measurements Based On Size 8</li> </ul>	[empty string]	N	69.99	69.99	12,13,10,11	109813-DEFAULT-s.jpg	[empty string]	1000	1888092-010	378039	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/flurry-print-boot-children-s-black-378039	1
19	CHALK/BLACK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	CHALK/BLACK\|NULL\|NULL	1	94.99	0	94.99	109880-DEFAULT-l.jpg	94.99	109880-DEFAULT-m.jpg	Y SOREL EXPLORER WP	N	5 EMILY	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	EXPLORER LACE BOOT - YOUTH - CHALK/BLACK	<p>A storm-stomping boot that feels like a sneaker. Waterproof construction, cozy 100g insulation and soft EVA underfoot support all-day play. The sporty aesthetic is complete with a molded rubber sole.</p> <p> </p> <ul> <li>Heel Height: 1"</li> <li>Platform Height: 1"</li> <li>Shaft Height: 6 1/4"</li> <li>Lace Length: 36"</li> <li>Insulation: 100g</li> <li>Please Note: Laces And Zippers Incorporated In Sorel Footwear Are Not Waterproof</li> <li>Measurements Based On Size 1</li> </ul>	[empty string]	N	94.99	94.99	3,4,5,6	109880-DEFAULT-s.jpg	[empty string]	1000	2020621-191	378041	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/explorer-lace-boot-youth-chalk-black-378041	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Size

12
13
2
3
4
5
1
7.5
8.5
9.5
6
7
8
9
10
10.5
11

Filter

Filter By

Price

Categories

Brand

Size

Gender

Caribou Boot - Women's

Tofino Ii Boot - Youth

Buxton Pull On Boot - Men's

Whitney Ii Short Lace Boot - Women's - Black

Out N About Iii Classic Boot - Women's

Whitney Ii Tall Lace Boot - Women's - Quarry

Tofino Ii Boot - Women's - Black/Gum

1964 Pac Nylon Boot - Waterproof - Men's

Buxton Lace Boot - Men's

Yoot Pac Nylon Boot - Youth

Snow Commander Boot - Children's - Black/Charcoal

Snow Commander Boot - Children's - Ocean Surf/Cactus Pink

Snow Commander Boot - Toddler - Black/Charcoal

Snow Commander Boot - Toddler - Ocean Surf/Cactus Pink

Explorer Next Joan Boot - Women's

Flurry Print Boot - Youth - Stone Green/Black

Flurry Boot - Youth - Spruce/Grill

Flurry Print Boot - Children's - Black

Explorer Lace Boot - Youth - Chalk/Black