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	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	[empty string]	0	99.99	0	99.99	[empty string]	99.99	[empty string]	M BURLY CLASSIC 18IN	N	5 MAIDA	[empty string]	[empty string]	[empty string]	A	[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]	13	50-to-100	0.00	[empty string]	Burly - 18 Inch - Men`s	<p>The Burly Classic is made from LaCroose`s proven ZXT Rubber and built to perform under the harshest of conditions. The perfect boots you can call on to get the job done.</p>	[empty string]	N	99.99	99.99	8,14,7,11,13,9	[empty string]	[empty string]	1000	266040	36925	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-burly-classic-18in-36925	1
2	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Accessories>Insoles	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	WOOL FELT 9MM INSOLES	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]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	13	5-to-10	0.00	[empty string]	Felt Insoles - 9mm	<p>Keep your feet comfortable and insulated with these insoles.</p>	[empty string]	N	7.99	7.99	11,9	[empty string]	[empty string]	1000	902201	36943	INSOLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	lacrosse/wool-felt-9mm-insoles-36943	1
3	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Accessories>Insoles	[empty string]	0	31.99	0	31.99	[empty string]	31.99	[empty string]	ICEMAN REPLACEMENT LINER 9MM WOOL FELT	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]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Iceman Liner - 9mm Felt	<p>These felt liners provide insulation in cold environments to keep you warm so you can be out longer.</p>	[empty string]	N	31.99	31.99	14,10,7,15,8,9	[empty string]	[empty string]	1000	904000	36944	INSOLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	lacrosse/iceman-replacement-liner-9mm-wool-felt-36944	1
4	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Accessories>Care Products	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	RUBBER CONDITIONER	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]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	23	10-to-15	0.00	[empty string]	Rubber Conditioning Spray	<p>This Rubber Conditioning Spray is specially formulated to rejuvenate rubber while preventing UV damage and color fading.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	980000	36947	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	lacrosse/rubber-conditioner-36947	1
5	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Accessories>Insoles	[empty string]	0	33.99	0	33.99	[empty string]	33.99	[empty string]	ICE KING REPLACEMENT LINER	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]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	24	25-to-50	0.00	[empty string]	Ice King Liner - 3/4 Inch	<p>The Ice King Liner will keep your LaCrosse Ice King or Alpha Ice King 800G pac boots nice and warm in the coldest temps.</p>	[empty string]	N	33.99	33.99	12,7,10,9,8,11,13	[empty string]	[empty string]	1000	918220	87374	INSOLES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	lacrosse/ice-king-replacement-liner-87374	1
6	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	Y LIL BURLY	N	5 MAIDA	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	10	50-to-100	0.00	[empty string]	Lil` Burly - 9 Inch - Youth	<p>No nonsense waterproof protection for the kids wanting to follow in Mom and Dad’s footsteps. The Lil’ Burly features the same high quality, scent-free rubber as LaCrosse`s classic Burly. Durable, flexible, and comfortable these are the boots that will help pass on the tradition of mud filled days in the outdoors.</p>	[empty string]	N	64.99	64.99	1,5,12,13,11,4	[empty string]	[empty string]	1000	266003	108870	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/y-lil-burly-108870	1
7	BLACK	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.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]	17	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	169.99	169.99	10,7,9,12,11,15	[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
8	BROWN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	179.99	0	179.99	[empty string]	179.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]	11	150-to-200	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	179.99	179.99	9,14,15,8,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
9	BREAKUP	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BREAKUP\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.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]	6	150-to-200	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	199.99	199.99	8,9,10,12,14	[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
10	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Accessories>Care Products	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	BOOT N WADER REPAIR KIT	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]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	16	10-to-15	0.00	[empty string]	Boot And Wader Repair Kit	<p>This kit contains everything you need to repair minor tears and holes. A reusable case includes a 3/4 oz tube of Aquaseal, a brush for application, and two heavy-duty patches.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	907022	145440	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	lacrosse/boot-n-wader-repair-kit-145440	1
11	BROWN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.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]	17	100-to-150	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	139.99	139.99	10,8,13,9,11,12,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
12	BLACK	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.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	109.99	109.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
13	RTXTRA	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	RTXTRA\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	M 4X ALPHA 7MM 16IN	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]	13	150-to-200	0.00	[empty string]	4xalpha - Men`s	<p>Everything you need and nothing you don`t. That`s what LaCrosse`s 4xAlpha hunting boot is all about - the essentials and only the essentials. Every bit as comfortable as it is durable; LaCrosse built the 4xAlpha for serious hunters who don`t want to drop serious cash when it comes to a premium hunting boot.</p>	[empty string]	N	159.99	159.99	8,9,13,12,14,15	[empty string]	[empty string]	1000	376103	252959	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-4x-alpha-7mm-16in-252959	1
14	BLACK	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	BLACK\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	M ALPHA THERMAL 16IN 7MM	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	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Alpha Thermal - 16 Inch - Men`s	<p>Whether they`re for work or play, one thing is for certain: the Alpha Thermal keeps feet warm with 7mm of insulating neoprene and fleece lining. Built for comfort and durability, these boots plow through snow, sleet, slush, ice and whatever else is in your wintery path. So when the mercury drops and the snow piles up, Jack Frost can nip all he wants at your nose, but he won`t be touching your toes.</p>	[empty string]	N	169.99	169.99	8,12	[empty string]	[empty string]	1000	644101	268736	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-alpha-thermal-16in-7mm-268736	1
15	BLACK/CERULEAN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	BLACK/CERULEAN\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	W ALPHA THERMAL 16IN 7MM	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]	12	150-to-200	0.00	[empty string]	Alpha Thermal - Women`s	<p>Whether they`re for work or play, one thing is for certain: the Alpha Thermal keeps feet warm with 7mm of insulating neoprene and an extra plush fleece lining. Built for comfort and durability, these boots plow through snow, sleet, slush, ice and whatever else is in your wintery path. So when the mercury drops and the snow piles up, Jack Frost can nip all he wants at your nose, but he won`t be touching your toes.</p>	[empty string]	N	169.99	169.99	6,7,8,9,10,11	[empty string]	[empty string]	1000	644105	268737	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/w-alpha-thermal-16in-7mm-268737	1
16	OPTIFADE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	OPTIFADE\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	M ALPHABURLY PRO 800G	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	150-to-200	0.00	[empty string]	Alphaburly Pro - Men`s	<p>Built from a proud tradition of innovation, the Alphaburly Pro is LaCrosse`s premium hunting boot. Combining high quality, scent-free rubber with naturally insulating neoprene, the Alphaburly Pro fears nothing. Not the cold. Not the harsh terrain. Not the challenges of a grueling hunt.</p>	[empty string]	N	199.99	199.99	14	[empty string]	[empty string]	1000	376035	286744	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-alphaburly-pro-800g-286744	1
17	MOBUC	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	MOBUC\|NULL\|NULL	0	219.99	0	219.99	[empty string]	219.99	[empty string]	W ALPHA BURLY PRO 1600GR MOBUC	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]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	11	200-to-250	0.00	[empty string]	Alphaburly Pro - Women`s	<p>Combining high quality, scent-free rubber with naturally insulating neoprene, the Alphaburly Pro fears nothing. Not the cold. Not the harsh terrain. Not the challenges of a grueling hunt. It features a thick cushioning EVA midsole for added comfort. An embossed liner for better air circulation. And an adjustable rear gusset for the perfect fit.</p>	[empty string]	N	219.99	219.99	10,9,7,11	[empty string]	[empty string]	1000	376031	286746	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/w-alpha-burly-pro-1600gr-mobuc-286746	1
18	GREY/BALSAM	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	GREY/BALSAM\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	W ALPHA LITE 14INCH 5MM	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]	8	100-to-150	0.00	[empty string]	Alpha Lite - Women`s	<p>Lacrosse has made this pull-on your new go-to. From daily chores to walking the dog, the Alpha Lite easily pulls on and off to get you out and on your way faster. With LaCrosse`s premium, natural rubber over insulating neoprene, you can trust that your feet will stay dry and comfortable for any task the day may bring.</p>	[empty string]	N	109.99	109.99	6,7,11,10	[empty string]	[empty string]	1000	610034	294826	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/w-alpha-lite-14inch-5mm-294826	1
19	BROWN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	BROWN\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	M ALPHA MUDDY 3.5MM 4.5IN	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]	8	100-to-150	0.00	[empty string]	Alpha Muddy - Men`s	<p>Dog walking, bringing in the firewood, taking out the trash, trekking around hunt camp, and all the daily chores in-between, the Alpha Muddy is you go-to for a boot that is effortless to pull on and slip off. Built with LaCrosse`s premium, waterproof rubber and a cushioning neoprene interior, the Alpha Muddy is every bit as comfortable as it is durable. </p>	[empty string]	N	109.99	109.99	9,10,8,14	[empty string]	[empty string]	1000	612441	294833	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-alpha-muddy-3-5mm-4-5in-294833	1
20	BLACK	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	BLACK\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M ALPHA RANGE 14IN 5MM	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]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Alpha Range - Men`s	<p>The Alpha Range continues the tradition by combining premium rubber and neoprene for a boot that’s comfortable, functional and ready to work. Built with ZXT Rubber - the same proven rubber used in the Grange and Burly - these boots offer time-tested durability with the flexibility to roll them down when the temperature rises. The Alpha Range is made to keep you going from dawn to dusk because there`s no time for discomfort when there`s work to be done. </p>	[empty string]	N	139.99	139.99	14,11,13	[empty string]	[empty string]	1000	602240	294834	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-alpha-range-14in-5mm-294834	1
21	CHOC/PLUM	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	CHOC/PLUM\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	W ALPHA THERMAL 16IN 7MM	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]	15	150-to-200	0.00	[empty string]	Alpha Thermal - Women`s	<p>Whether they`re for work or play, one thing is for certain: the Alpha Thermal keeps feet warm with 7mm of insulating neoprene and an extra plush fleece lining. Built for comfort and durability, these boots plow through snow, sleet, slush, ice and whatever else is in your wintery path. So when the mercury drops and the snow piles up, Jack Frost can nip all he wants at your nose, but he won`t be touching your toes.</p>	[empty string]	N	169.99	169.99	6,7,8,9,10,11	[empty string]	[empty string]	1000	644104	307926	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/w-alpha-thermal-16in-7mm-307926	1
22	MOBUC	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	MOBUC\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	M COLD SNAP 8IN 1200 GRAM MOBUC	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]	15	150-to-200	0.00	[empty string]	Cold Snap - 1200g	<p>Whether for late season hunting, ice fishing, or just getting outdoors in the winter, Irish`s Cold Snap boots are sure to keep your feet warm and dry. Featuring Thinsulate Ultra Insulation, their own Dry-Core waterproof lining and a specially formulated outsole that’s made for cold weather traction, the Cold Snap is ready for whatever Old Man Winter can throw your way.</p>	[empty string]	N	159.99	159.99	12,11,10.5,8.5,11.5,13,9,9.5	[empty string]	[empty string]	1000	566710	309147	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-cold-snap-8in-1200-gram-mobuc-309147	1
23	GRAY	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Leisure and Casual	GRAY\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	M MUDDY MULE	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]	6	50-to-100	0.00	[empty string]	Alpha Muddy Mule - Men`s	<p>Dog walking, bringing in the firewood, taking out the trash, trekking around hunt camp, and all the daily chores in-between, the Alpha Muddy is your go-to for a boot that is effortless to pull on and slip off. Built with Lacrosse`s premium, waterproof rubber and a cushioning neoprene interior, the Alpha Muddy is every bit as comfortable as it is durable.</p>	[empty string]	N	99.99	99.99	12,13,8,9,10	[empty string]	[empty string]	1000	612420	310664	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	lacrosse/m-muddy-mule-310664	1
24	RTE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTE\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	M AEROHEAD SPORT 16` REALTREE EDGE 7.0MM	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]	29	150-to-200	0.00	[empty string]	Aerohead Sport - Men`s	<p>The AeroHead Sport completely changes what a rubber hunting boot can be by replacing the rubber shell with one made of extremely durable, lightweight and insulating polyurethane. Designed for optimal fit and flexibility, the waterproof AeroHead Sport is built for ultimate comfort and will keep hunters light on their feet. Its Brush Tuff material stands up to unforgiving brush and briers while an abrasion resistant shin guard offers extra protection without added bulk.</p>	[empty string]	N	199.99	199.99	12,14,10,11,13,8,9	[empty string]	[empty string]	1000	340230	316141	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-aerohead-sport-16-realtree-edge-7-0mm-316141	1
25	RTE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTE\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	M PHA AGILITY 17` REALTREE EDGE	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]	2021	[empty string]	MENS	SELL THRU	ONLINE	[empty string]	[empty string]	9	100-to-150	0.00	[empty string]	Alpha Agility - Men`s	<p>This boot was made to move you much further and much faster thanks to its light weight, flexibility, and comfort. It begins with premium hand-laid rubber over 5mm of naturally insulating neoprene so you know they`ll be waterproof and durable. And of course, LaCrosse`s signature adjustable gusset fits any size calf snugly and securely.</p>	[empty string]	N	129.99	129.99	14,8,7	[empty string]	[empty string]	1000	302440	316149	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-pha-agility-17-realtree-edge-316149	1
26	MOBUC	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	MOBUC\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M ALPHA AG 800G 17` MOBU COUNTRY	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]	2021	[empty string]	MENS	SELL THRU	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Alpha Agility - 800g - Men`s	<p>This boot was made to move you much further and much faster thanks to its light weight, flexibility, and comfort. It begins with premium hand-laid rubber over 5mm of naturally insulating neoprene so you know they`ll be waterproof and durable. And of course, LaCrosse`s signature adjustable gusset fits any size calf snugly and securely.</p>	[empty string]	N	139.99	139.99	15	[empty string]	[empty string]	1000	302441	316153	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-alpha-ag-800g-17-mobu-country-316153	1
27	RTE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTE\|NULL\|NULL	0	189.99	0	189.99	[empty string]	189.99	[empty string]	W ALPHA BURLY PRO 15` REALTREE EDGE	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]	6	150-to-200	0.00	[empty string]	Alphaburly Pro - Women`s	<p>Built from a proud tradition of innovation, the Alphaburly Pro is LaCrosse`s premium hunting boot. Combining high quality, scent-free rubber with naturally insulating neoprene, the Alphaburly Pro fears nothing. Not the cold. Not the harsh terrain. Not the challenges of a grueling hunt. It features a thick cushioning EVA midsole for added comfort. An embossed liner for better air circulation. And an adjustable rear gusset for the perfect fit.</p>	[empty string]	N	189.99	189.99	6,10,11,7	[empty string]	[empty string]	1000	376026	316154	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/w-alpha-burly-pro-15-realtree-edge-316154	1
28	RTE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTE\|NULL\|NULL	0	219.99	0	219.99	[empty string]	219.99	[empty string]	M ALPHA BURLY PRO 18` RT EDGE 1600G	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]	36	200-to-250	0.00	[empty string]	Alphaburly Pro - 18` - 1600g - Men`s	<p>Built from a proud tradition of innovation, the Alphaburly Pro is LaCrosse`s premium hunting boot. Combining high quality, scent-free rubber with naturally insulating neoprene, the Alphaburly Pro fears nothing. Not the cold. Not the harsh terrain. Not the challenges of a grueling hunt. It features a thick cushioning EVA midsole for added comfort. An embossed liner for better air circulation. And an adjustable rear gusset for the perfect fit.</p>	[empty string]	N	219.99	219.99	11,12,10,14,15,8,9	[empty string]	[empty string]	1000	376032	316155	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-alpha-burly-pro-18-rt-edge-1600g-316155	1
29	RTE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTE\|NULL\|NULL	0	219.99	0	219.99	[empty string]	219.99	[empty string]	M ALPHA BURLY PRO ZIP 18` 1000G RTE	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]	2	200-to-250	0.00	[empty string]	Alphaburly Pro Side Zip - 1000g - 18` - Men`s	<p>Built from a proud tradition of innovation, the Alphaburly Pro is LaCrosse`s premium hunting boot. Combining high quality, scent-free rubber with naturally insulating neoprene, the Alphaburly Pro fears nothing. Not the cold. Not the harsh terrain. Not the challenges of a grueling hunt. It features a thick cushioning EVA midsole for added comfort. An embossed liner for better air circulation. And an adjustable rear gusset for the perfect fit.</p>	[empty string]	N	219.99	219.99	10	[empty string]	[empty string]	1000	376030	316156	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-alpha-burly-pro-zip-18-1000g-rte-316156	1
30	BLK/TAN	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	BLK/TAN\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	W ALPHA LITE 14` BLK/TAN 5.0MM	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]	17	100-to-150	0.00	[empty string]	Alpha Lite - Women`s	<p>From daily chores to walking the dog, the Alpha Lite easily pulls on and off to get you out and on your way faster. With LaCrosse`s premium, natural rubber over insulating neoprene, you can trust that your feet will stay dry and comfortable for any task the day may bring.</p>	[empty string]	N	109.99	109.99	8,6,7,10,9,11	[empty string]	[empty string]	1000	610037	316158	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/w-alpha-lite-14-blk-tan-5-0mm-316158	1
31	RTE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTE\|NULL\|NULL	0	189.99	0	189.99	[empty string]	189.99	[empty string]	M AEROHEAD SPORT 16` REALTREE EDGE 3.5MM	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]	2021	[empty string]	MENS	SELL THRU	ONLINE	[empty string]	[empty string]	10	150-to-200	0.00	[empty string]	Aerohead Sport - 16` - Men`s	<p>The AeroHead Sport completely changes what a rubber hunting boot can be by replacing the rubber shell with one made of extremely durable, lightweight and insulating polyurethane. Designed for optimal fit and flexibility, the waterproof AeroHead Sport is built for ultimate comfort and will keep hunters light on their feet.</p>	[empty string]	N	189.99	189.99	11,8,7,9,12,13	[empty string]	[empty string]	1000	340228	327449	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-aerohead-sport-16-realtree-edge-3-5mm-327449	1
32	TIMBER	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	TIMBER\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	M BURLY CLASSIC 18IN REALTREE TIMBER	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	[empty string]	[empty string]	[empty string]	12	100-to-150	0.00	[empty string]	M Burly Classic 18in Realtree Timber	[empty string]	[empty string]	N	109.99	109.99	7,8,11,15,12,14,10	[empty string]	[empty string]	1000	266041	335481	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-burly-classic-18in-realtree-timber-335481	1
33	REALTREE XTRA	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	REALTREE XTRA\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	Y LIL ALPHA LITE 1000G REALTREE EXTRA	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	11	100-to-150	0.00	[empty string]	Y Lil Alpha Lite 1000g Realtree Extra	[empty string]	[empty string]	N	109.99	109.99	13,12,6,11,1,2,5	[empty string]	[empty string]	1000	610247	335486	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/y-lil-alpha-lite-1000g-realtree-extra-335486	1
34	RTED	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTED\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	M WINDROSE 8IN 1000G WP 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	[empty string]	[empty string]	[empty string]	10	150-to-200	0.00	[empty string]	M Windrose 8in 1000g Wp Boot	[empty string]	[empty string]	N	169.99	169.99	10,10.5,11,11.5,12,13,8.5	[empty string]	[empty string]	1000	513362	335820	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-windrose-8in-1000g-wp-boot-335820	1
35	RTED	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	RTED\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	W WINDROSE 600G 8IN HUNT 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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	23	150-to-200	0.00	[empty string]	W Windrose 600g 8in Hunt Boot	[empty string]	[empty string]	N	159.99	159.99	11,7.5,9,9.5,8,8.5,6.5,7,10	[empty string]	[empty string]	1000	513364	335821	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/w-windrose-600g-8in-hunt-boot-335821	1
36	REALTREE XTRA	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	REALTREE XTRA\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	Y LIL ALPHA LITE 5.0MM REALTREE EXTRA	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]	9	50-to-100	0.00	[empty string]	Y Lil Alpha Lite 5.0mm Realtree Extra	[empty string]	[empty string]	N	99.99	99.99	11,12,6Y,13,3Y,4Y	[empty string]	[empty string]	1000	610245	348939	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/y-lil-alpha-lite-5-0mm-realtree-extra-348939	1
37	CAMO	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	CAMO\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	M ALPHA AGILITY 800G	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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	M Alpha Agility 800g	[empty string]	[empty string]	N	149.99	149.99	10,9,11,12,13	[empty string]	[empty string]	1000	339074	355444	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-alpha-agility-800g-355444	1
38	CAMO	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Hunting Boots	CAMO\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M CLEAR SHOT NI 8IN	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	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	M Clear Shot Ni 8in	[empty string]	[empty string]	N	139.99	139.99	10.5,11.5,10	[empty string]	[empty string]	1000	542160	355445	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	lacrosse/m-clear-shot-ni-8in-355445	1
39	RTE	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Rubber Boots	RTE\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M BURLY TRAC LITE 800G	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	HOTSHOW	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	31	100-to-150	0.00	[empty string]	M Burly Trac Lite 800g	[empty string]	[empty string]	N	139.99	139.99	12,9,14,13,10,11,8,15,7	[empty string]	[empty string]	1000	266061	355446	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	lacrosse/m-burly-trac-lite-800g-355446	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

2 1

Filter By

Size

1
10
10.5
11
11.5
12
12.5
13
13.5
14
15
2
3
3Y
4
4Y
5
5Y
6
6.5
6Y
7
7.5
8
8.5
9
9.5
NA

Filter

2 1

Filter By

Price

Categories

Brand

Size

Burly - 18 Inch - Men's

Felt Insoles - 9mm

Iceman Liner - 9mm Felt

Rubber Conditioning Spray

Ice King Liner - 3/4 Inch

Lil ` Burly - 9 Inch - Youth

Iceman Pac Boot - Men's

Ice King - Men's

Hunt Pac Extreme - Men's

Boot And Wader Repair Kit

Mesquite - Men's

Outpost Ii - Women's

4xalpha - Men's

Alpha Thermal - 16 Inch - Men's

Alpha Thermal - Women's

Alphaburly Pro - Men's

Alphaburly Pro - Women's

Alpha Lite - Women's

Alpha Muddy - Men's

Alpha Range - Men's

Alpha Thermal - Women's

Cold Snap - 1200g

Alpha Muddy Mule - Men's

Aerohead Sport - Men's