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	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	74.99	0	74.99	[empty string]	74.99	[empty string]	JR MUSTANG PAC BOOT	N	5 MAIDA	[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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Mustang - Juniors	<p>FEATURES:<br /> -Removable, multi-layer inner boot system liner<br /> -Arctic Rubber base<br /> -Locking snow collar<br /> -Ankle height Velcro strap for fastening<br /> -Rip-stop nylon upper</p>	[empty string]	N	74.99	74.99	3,4	[empty string]	[empty string]	1000	4820-0068	105064	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/jr-mustang-pac-boot-105064	1
2	BLACK	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	M ICEMAN PAC BOOT 10IN BLACK	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Iceman Pac Boot - Men`s	<p>Worn by Iditarod dogsled winners, the Iceman has a long history of providing warmth in the harshest conditions. Its double insulation construction, combined with Lacrosse`s premium, natural rubber keeps you dry and warm throughout winter.</p>	[empty string]	N	199.99	199.99	10,15,9	[empty string]	[empty string]	1000	600008	109993	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	lacrosse/m-iceman-pac-boot-10in-black-109993	1
3	BROWN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	209.99	0	209.99	[empty string]	209.99	[empty string]	M ICE KING PAC BOOT 10IN BRN 400G	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	10	200-to-250	0.00	[empty string]	Ice King - Men`s	<p>The Ice King is a LaCrosse classic that has stood the test of time. Thriving in places where temperatures drop below -20 degrees and annual snowfall hits 200+ inches, this is the boot of choice for the outdoorsman who doesn`t call it quits because of the weather. For those days spent fishing on the ice or sitting in the frigid tree stand, we`ve got you covered.</p>	[empty string]	N	209.99	209.99	9,12,13,14,15,7	[empty string]	[empty string]	1000	600014	109994	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	lacrosse/m-ice-king-pac-boot-10in-brn-400g-109994	1
4	BREAKUP	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BREAKUP\|NULL\|NULL	0	229.99	0	229.99	[empty string]	229.99	[empty string]	M HUNT PAC EXTREME MOBU 10IN 2000G	N	5 MAIDA	[empty string]	[empty string]	[empty string]	C	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	16	200-to-250	0.00	[empty string]	Hunt Pac Extreme - Men`s	<p>Some of the best hunting happens in the worst weather, which is why LaCrosse built the Hunt Pac Extreme. With 2000 grams of insulation, a thick insulating midsole underfoot and a fully waterproof liner, this is the boot you`ll want to be wearing when temperatures drop well below zero.</p>	[empty string]	N	229.99	229.99	10,11,12,8,9	[empty string]	[empty string]	1000	283160	109998	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	lacrosse/m-hunt-pac-extreme-mobu-10in-2000g-109998	1
5	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	JR EIGER PAC BOOT	N	5 MAIDA	[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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Eiger - Junior`s	<p>FEATURES:<br /> -Removable, multi-layer inner boot system<br /> -Waffle-comb foot-bed<br /> -Arctic Rubber base<br /> -Double-strap Velcro fastening<br /> -Waterproof nylon snow collar</p>	[empty string]	N	94.99	94.99	3	[empty string]	[empty string]	1000	EPIC-J001	117895	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/jr-eiger-pac-boot-117895	1
6	BLACK/BARK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK/BARK\|NULL\|NULL	0	249.99	0	249.99	[empty string]	249.99	[empty string]	MNS APEX	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Apex - Men'S	<p>FEATURES:<br /> -Waterproof base<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Double B-Tek insulation<br /> -Double aluminum insole<br /> -Waffle-comb foot-bed<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Speed-lace front fastening system<br /> -Full length tongue for ease-of-entry<br /> -Waterproof leather upper</p>	[empty string]	N	249.99	249.99	9	[empty string]	[empty string]	1000	4000-1305-455	159388	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/mns-apex-159388	1
7	BROWN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	M MESQUITE II 200G PACK BOOT	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	26	150-to-200	0.00	[empty string]	Mesquite - Men`s	<p>No beans about it, these boots were made for cold, wet conditions. Featuring a convenient side-zipper that allows for easy-on, easy-off, LaCrosse`s Mesquite is built for quick exits in snowy conditions. The full-grain leather upper and natural, hand-laid rubber bottom are waterproof and durable to last season after season.</p>	[empty string]	N	169.99	169.99	10,13,14,11,12,8,9,15	[empty string]	[empty string]	1000	273124	212798	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	lacrosse/m-mesquite-ii-200g-pack-boot-212798	1
8	BROWN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M OUTPOST II PAC	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Outpost Ii - Men`s	<p>The Outpost is built to withstand any one of Mother Nature’s hissy fits. These boots feature a removable foam liner that allows you to customize the amount of insulation needed. LaCrosse uses their premium, hand-laid rubber for the bottom and a combination of full-grain leather and nylon for the upper. This gives the boot the waterproofing and durability needed to last snow after snow.</p>	[empty string]	N	139.99	139.99	10	[empty string]	[empty string]	1000	600801	212799	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	lacrosse/m-outpost-ii-pac-212799	1
9	BLACK	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	W OUTPOST II PAC	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Outpost Ii - Women`s	<p>The Outpost is built to withstand any one of Mother Nature`s hissy fits. These boots feature a removable foam liner that allows you to customize the amount of insulation needed. Lacrosse uses their premium, hand-laid rubber for the bottom and a combination of full-grain leather and nylon for the upper. This gives the boot the waterproofing and durability needed to last snow after snow.</p>	[empty string]	N	139.99	139.99	6	[empty string]	[empty string]	1000	600803	212800	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	lacrosse/w-outpost-ii-pac-212800	1
10	CAL	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	CAL\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	W SAGE	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Sage - Women`s	<p>FEATURES:<br /> -B-Tek Lite<br /> -Liner: Body-heat mouldable, removable liner<br /> -Base: Superlite Shell, AirGrip Midsole and Outsole with Polar Rubber contact points <br /> -Hiker height for improved agility<br /> -Waterproof PU coated leather and nylon<br /> -Speed-lace front fastening system with toggle</p>	[empty string]	N	159.99	159.99	9,10	[empty string]	[empty string]	1000	LITE-W006-CAL	254103	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-sage-254103	1
11	CHARCOAL	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	CHARCOAL\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	W SNOWGOOSE	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Snogoose - Women`s	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole and Polar Rubber Outsole designed for a women’s foot<br /> -Side-to-side lace fastening with toggle<br /> -Waterproof nylon snow collar<br /> -Waterproof 900 Denier nylon upper</p>	[empty string]	N	139.99	139.99	7	[empty string]	[empty string]	1000	4510-1330-GY2	254106	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-snowgoose-254106	1
12	TAUPE	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	TAUPE\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	W CHOLE	N	5 MAIDA	[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]	1	150-to-200	0.00	[empty string]	Chloe - Women`s	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole and Polar Rubber Outsole designed for a women’s foot<br /> -D-Ring front lace fastening system<br /> -Faux-fur collar and sidepiece<br /> -Waterproof suede leather upper</p>	[empty string]	N	159.99	159.99	6	[empty string]	[empty string]	1000	4510-0185-BG4	254107	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-chole-254107	1
13	BLACK	MUCK BOOT	Muck Boot	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	W ARCTIC SPORT II MID BLACK	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	14	100-to-150	0.00	[empty string]	Arctic Sport Ii Mid - Women`s	<p>The warmest women’s Muck Boot has been upgraded for improved warmth and comfort for use in some of the coldest conditions. Redesigned for durability and a better fit, the Arctic Sport II works well in the barn, on the mountains, on country roads or city streets.</p>	[empty string]	N	149.99	149.99	8,9,11,10,7,6	[empty string]	[empty string]	1000	AS2M-000	254308	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	muck-boot/w-arctic-sport-ii-mid-black-254308	1
14	FUSHIA,GRPHVOLT,SHARK	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	FUSHIA\|NULL\|NULL,GRPHVOLT\|NULL\|NULL,SHARK\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	Y CHILDS POWDERBUG II PRINT	N	5 MAIDA	[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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Y Childs Powderbug Ii Print	[empty string]	[empty string]	N	59.99	59.99	10,9	[empty string]	[empty string]	1000	1637882	286725	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/y-childs-powderbug-ii-print-286725	1
15	BLK/SAGE	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	BLK/SAGE\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	W HEAVENLY SLIP II OMNI-HEAT	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Heavenly Slip Ii - Omni-heat - Women`s	<p>Slip into these warm, waterproof-breathable boots on a cold winter day for comfort and warmth. An easy pull-on design with thermal-reflective lining uses your own body heat to keep you warm. The sturdy rubber sole with advanced traction helps keep your balance on slippery terrain out on the trail or out on the street.</p>	[empty string]	N	129.99	129.99	6,7,8.5	[empty string]	[empty string]	1000	1753381-010	286736	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/w-heavenly-slip-ii-omni-heat-286736	1
16	ANTH/GREY	VASQUE FOOTWEAR	Vasque Footwear	FOOTWEAR	Footwear>Pac Boots	ANTH/GREY\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	W COLDSPARK ULTRADRY	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Coldspark Ultradry - Insulated & Waterproof - Women`s	<p>The Coldspark UltraDry is a winter boot engineered for hiking and other active cold weather pursuits. 200g of 3M Thinsulate insulation and an UltraDry waterproof membrane keep feet comfortable while on the move during the winter. A multi-directional outsole lug pattern maximizes traction in icy and wet conditions. Free from cumbersome winter boots, there’s no limit to where you can explore.</p>	[empty string]	N	139.99	139.99	10	[empty string]	[empty string]	1000	7845	287219	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	vasque-footwear/w-coldspark-ultradry-287219	1
17	BLACK/PINK	MUCK BOOT	Muck Boot	FOOTWEAR	Footwear>Pac Boots	BLACK/PINK\|NULL\|NULL	0	184.99	0	184.99	[empty string]	184.99	[empty string]	W ARCTIC ICE TALL	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	13	150-to-200	0.00	[empty string]	Arctic Ice - Tall - Women`s	<p>The winter can be unpredictable, but your footwear shouldn`t be. That is why Muck Boot developed the Arctic Ice AG. These winter high-performance sport boots step up the warmth factor with 5mm neoprene inner boot layered with cozy fleece lining for ultimate warmth in extreme conditions.</p>	[empty string]	N	184.99	184.99	7,8,9,10,11,6	[empty string]	[empty string]	1000	ASVTA-404	287323	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	muck-boot/w-arctic-ice-tall-287323	1
18	WINE,FUSHIA,DISCBLUSH,BLACK	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	WINE\|NULL\|NULL,FUSHIA\|NULL\|NULL,DISCBLUSH\|NULL\|NULL,BLACK\|NULL\|NULL	0	64.99	1	59.99	[empty string]	64.99	[empty string]	Y POWDERBUG FORTY	N	5 MAIDA	[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]	12	50-to-100	0.00	[empty string]	Powderbug Forty Boot - Big Kid`s	<p>Is it snow time? It is if your kid is sporting a pair of these super warm, waterproof winter boots with solid coloring. From its washable and recycled felt liner to its -40F/-40C rating, these boots will keep your child warm, dry and protected in the elements.</p>	[empty string]	N	59.99	64.99	3,4,5,6,2,1	[empty string]	[empty string]	1000	1637901	304613	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/y-powderbug-forty-304613	1
19	BLK	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	BLK\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	Y CHILDS POWDERBUG	N	5 MAIDA	[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]	4	50-to-100	0.00	[empty string]	Powderbug Plus Ii Snow Boot - Little Kid`s	<p>These super warm, waterproof winter boots are also perfect for slush time and rain time. From its washable and recycled felt liner to its -25F/-32C rating, these boots will keep your child warm, dry, and protected from the elements.</p>	[empty string]	N	59.99	59.99	9,11,12,13	[empty string]	[empty string]	1000	1637872	304614	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/y-childs-powderbug-304614	1
20	ELK/FOSSIL,GRAPHITE	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	ELK/FOSSIL\|NULL\|NULL,GRAPHITE\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	W MINX OMNI HEAT	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Minx Slipper - Omni-heat - Women`s	<p>The ultimate indoor-outdoor cool-weather slippers. The eye-catching upper features suede leather and faux fur cuff while the thermal-reflective lining retains warmth. A removable, contoured footbed delivers soft cushioning while the high-grip traction outsole carries you through the day in sure-footed comfort.</p>	[empty string]	N	59.99	59.99	9.5,11,6.5	[empty string]	[empty string]	1000	1791371	304642	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/w-minx-omni-heat-304642	1
21	NORI/KHA	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	NORI/KHA\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	W MINX SHORTY III	N	5 MAIDA	[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]	1	100-to-150	0.00	[empty string]	W Minx Shorty Iii	[empty string]	[empty string]	N	109.99	109.99	7	[empty string]	[empty string]	1000	1803151	304643	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/w-minx-shorty-iii-304643	1
22	QUARRY/BLK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	QUARRY/BLK\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	W WINTER CARNIVAL	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Winter Carnival Boot - Women`s	<p>Meet one of Sorel`s winter legends—featuring seam-sealed waterproof construction, rubber sole for never-slip traction, and insulation that withstands freezing temperatures.</p>	[empty string]	N	149.99	149.99	6	[empty string]	[empty string]	1000	1855081-052	321726	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/w-winter-carnival-321726	1
23	ANTH/GREY	VASQUE FOOTWEAR	Vasque Footwear	FOOTWEAR	Footwear>Pac Boots	ANTH/GREY\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M COLDSPARK ULTRA DRY	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Coldspark Ultradry - Men`s	<p>The Coldspark UltraDry is a winter boot engineered for hiking and other active cold weather pursuits. 200g of 3M Thinsulate insulation and Vasque`s proprietary UltraDry waterproof membrane keep feet comfortable while on the move during the winter. A multi-directional outsole lug pattern maximizes traction in icy and wet conditions.</p>	[empty string]	N	139.99	139.99	9.5	[empty string]	[empty string]	1000	7850	322907	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	vasque-footwear/m-coldspark-ultra-dry-322907	1
24	BLACK	KORKERS	Korkers	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	SNOWMAGEDDON W/SNOWTRAC ICETRAC SOLES	N	5 MAIDA	[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	ONLINE	[empty string]	[empty string]	8	150-to-200	0.00	[empty string]	Snowmageddon - Men`s	<p>The Snowmageddon Boot is warm and waterproof, with twice the traction.</p>	[empty string]	N	199.99	199.99	10.5,10,9,11.5,12	[empty string]	[empty string]	1000	OB9520BK	323919	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	korkers/snowmageddon-w-snowtrac-icetrac-soles-323919	1
25	PETROL/FUSH	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	PETROL/FUSH\|NULL\|NULL	0	64.99	0	64.99	[empty string]	64.99	[empty string]	Y POWDERBUG FORTY PRINT	N	5 MAIDA	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Y Powderbug Forty Print	[empty string]	[empty string]	N	64.99	64.99	3,4	[empty string]	[empty string]	1000	1637861	335667	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/y-powderbug-forty-print-335667	1
26	DKFUSHIA	COLUMBIA SPORTSWEAR	Columbia Sportswear	FOOTWEAR	Footwear>Pac Boots	DKFUSHIA\|NULL\|NULL	0	119.99	0	119.99	[empty string]	119.99	[empty string]	W SLOPE SIDE VILLAGE HI	N	5 MAIDA	[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]	1	100-to-150	0.00	[empty string]	W Slope Side Village Hi	[empty string]	[empty string]	N	119.99	119.99	6.5	[empty string]	[empty string]	1000	193906-408	335676	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	columbia-sportswear/w-slope-side-village-hi-335676	1
27	DKEARTH/GOLDBRN	KEEN	Keen	FOOTWEAR	Footwear>Pac Boots	DKEARTH/GOLDBRN\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	C TARGHEE MID WP	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	C Targhee Mid Wp	[empty string]	[empty string]	N	79.99	79.99	11,12,13	[empty string]	[empty string]	1000	1019831	336748	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	keen/c-targhee-mid-wp-336748	1
28	STEELGREY/IRISHGREEN	KEEN	Keen	FOOTWEAR	Footwear>Pac Boots	STEELGREY/IRISHGREEN\|NULL\|NULL	0	74.99	0	74.99	[empty string]	74.99	[empty string]	Y TARGHEE LOW WP	N	5 MAIDA	[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]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Y Targhee Low Wp	[empty string]	[empty string]	N	74.99	74.99	7,4,5	[empty string]	[empty string]	1000	1024011	336756	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	keen/y-targhee-low-wp-336756	1
29	BLACK	MUCK BOOT	Muck Boot	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	184.99	0	184.99	[empty string]	184.99	[empty string]	W ARCTIC ICE TALL	N	5 MAIDA	[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]	14	150-to-200	0.00	[empty string]	W Arctic Ice Tall	[empty string]	[empty string]	N	184.99	184.99	8,9,10,7	[empty string]	[empty string]	1000	ASVTA-100	353127	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	muck-boot/w-arctic-ice-tall-353127	1
30	MOSS/CAMO	MUCK BOOT	Muck Boot	FOOTWEAR	Footwear>Pac Boots	MOSS/CAMO\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	W ARCTIC ICE ARCTIC GRIP	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	W Arctic Ice Arctic Grip	[empty string]	[empty string]	N	169.99	169.99	9,10,11,6,7,8	[empty string]	[empty string]	1000	ASVMA-300	353133	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	muck-boot/w-arctic-ice-arctic-grip-353133	1
31	MOBDNA	MUCK BOOT	Muck Boot	FOOTWEAR	Footwear>Pac Boots	MOBDNA\|NULL\|NULL	0	189.99	0	189.99	[empty string]	189.99	[empty string]	M ARCTIC ICE ARCTIC GRIP	N	5 MAIDA	[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]	22	150-to-200	0.00	[empty string]	M Arctic Ice Arctic Grip	[empty string]	[empty string]	N	189.99	189.99	9,10,14,7,8,11,12,13	[empty string]	[empty string]	1000	AVTVA-MDNA	353136	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	muck-boot/m-arctic-ice-arctic-grip-353136	1
32	OLIVE	MUCK BOOT	Muck Boot	FOOTWEAR	Footwear>Pac Boots	OLIVE\|NULL\|NULL	0	154.99	0	154.99	[empty string]	154.99	[empty string]	W ARCTIC SPORT TALL HERRINGBONE	N	5 MAIDA	[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]	7	150-to-200	0.00	[empty string]	W Arctic Sport Tall Herringbone	[empty string]	[empty string]	N	154.99	154.99	8,9,10,7	[empty string]	[empty string]	1000	AS2T-3TW	353158	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	muck-boot/w-arctic-sport-tall-herringbone-353158	1
33	DNA/BARK	MUCK BOOT	Muck Boot	FOOTWEAR	Footwear>Pac Boots	DNA/BARK\|NULL\|NULL	0	179.99	0	179.99	[empty string]	179.99	[empty string]	M ARCTIC ICE ARCTIC GRIP	N	5 MAIDA	[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]	3	150-to-200	0.00	[empty string]	M Arctic Ice Arctic Grip	[empty string]	[empty string]	N	179.99	179.99	14,13	[empty string]	[empty string]	1000	APMT-MDNA	353164	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	muck-boot/m-arctic-ice-arctic-grip-353164	1
34	BROWN	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	W YELLOWKNIFE	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	W Yellowknife	[empty string]	[empty string]	N	149.99	149.99	6	[empty string]	[empty string]	1000	CANA-W001-BBJ	356240	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-yellowknife-356240	1
35	AMBER	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	AMBER\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	W EMELIE II CHELSEA	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	W Emelie Ii Chelsea	[empty string]	[empty string]	N	149.99	149.99	7,7.5,9,10	[empty string]	[empty string]	1000	1977581-242	356256	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/w-emelie-ii-chelsea-356256	1
36	BLK/SEA	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLK/SEA\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	W OUT N ABOUT III CONQUEST	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	W Out N About Iii Conquest	[empty string]	[empty string]	N	129.99	129.99	7	[empty string]	[empty string]	1000	1977201-010	356257	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/w-out-n-about-iii-conquest-356257	1
37	BLACK	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	W SLIMPACK III LACE	N	5 MAIDA	[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]	1	100-to-150	0.00	[empty string]	W Slimpack Iii Lace	[empty string]	[empty string]	N	149.99	149.99	6	[empty string]	[empty string]	1000	1915691-010	356259	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/w-slimpack-iii-lace-356259	1
38	TAUPE	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	TAUPE\|NULL\|NULL	0	194.99	0	194.99	[empty string]	194.99	[empty string]	W TIVOLO IV PARC BOOT	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	W Tivolo Iv Parc Boot	[empty string]	[empty string]	N	194.99	194.99	7	[empty string]	[empty string]	1000	1930311-264	356261	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/w-tivolo-iv-parc-boot-356261	1
39	FAWN	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	FAWN\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	W TOFINO II	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	W Tofino Ii	[empty string]	[empty string]	N	169.99	169.99	6	[empty string]	[empty string]	1000	1959351-920	356264	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/w-tofino-ii-356264	1
40	TOBACCO	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	TOBACCO\|NULL\|NULL	0	154.99	0	154.99	[empty string]	154.99	[empty string]	M ANKENY II MID OD	N	5 MAIDA	[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]	2	150-to-200	0.00	[empty string]	M Ankeny Ii Mid Od	[empty string]	[empty string]	N	154.99	154.99	9,11	[empty string]	[empty string]	1000	1915101-256	356273	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/m-ankeny-ii-mid-od-356273	1
41	KHAKI	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	KHAKI\|NULL\|NULL	0	194.99	0	194.99	[empty string]	194.99	[empty string]	M KEZAR MOC WP	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2022	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	M Kezar Moc Wp	[empty string]	[empty string]	N	194.99	194.99	9.5,10.5	[empty string]	[empty string]	1000	1930891-297	356274	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/m-kezar-moc-wp-356274	1
42	QUARRY,COAL	SOREL FOOTWEAR	Sorel Footwear	FOOTWEAR	Footwear>Pac Boots	QUARRY\|NULL\|NULL,COAL\|NULL\|NULL	0	74.99	0	74.99	[empty string]	74.99	[empty string]	Y WHITNEY II SHORT LACE	N	5 MAIDA	[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]	10	50-to-100	0.00	[empty string]	Y Whitney Ii Short Lace	[empty string]	[empty string]	N	74.99	74.99	4,5,7	[empty string]	[empty string]	1000	1921401	356275	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	sorel-footwear/y-whitney-ii-short-lace-356275	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts129 ORDER BY sortposition asc

Footwear

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Brand

Size

Mustang - Juniors

Iceman Pac Boot - Men's

Ice King - Men's

Hunt Pac Extreme - Men's

Eiger - Junior's

Apex - Men's

Mesquite - Men's

Outpost Ii - Men's

Outpost Ii - Women's

Sage - Women's

Snogoose - Women's

Chloe - Women's

Arctic Sport Ii Mid - Women's

Y Childs Powderbug Ii Print

Heavenly Slip Ii - Omni- Heat - Women's

Coldspark Ultradry - Insulated & Waterproof - Women's

Arctic Ice - Tall - Women's

Powderbug Forty Boot - Big Kid's

Powderbug Plus Ii Snow Boot - Little Kid's

Minx Slipper - Omni- Heat - Women's

W Minx Shorty Iii

Winter Carnival Boot - Women's

Coldspark Ultradry - Men's

Snowmageddon - Men's