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>Waders	[empty string]	1	12.99	0	12.99	97087-DEFAULT-l.jpg	12.99	97087-DEFAULT-m.jpg	LAC WADER SUSPENDRS-H BAC	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	26	10-to-15	0.00	[empty string]	H-BACK SUSPENDERS	<p>With a traditional H-back construction, LaCrosse's suspenders are designed to work seamlessly with their waders. We use a wide strap to relieve pressure from holding up heavier materials. Durable leather fasteners button into waders and pants, giving you a more secure connection.</p> <p> </p> <ul> <li>Leather Fasteners</li> <li>Button-on Braces</li> <li>Done Right</li> <li>Perfect Match</li> </ul> <p> </p> <ul> <li>Weight: 0.3 lb</li> <li>Materials: Elastic, Leather</li> </ul>	[empty string]	N	12.99	12.99	[empty string]	97087-DEFAULT-s.jpg	[empty string]	1000	90825	36964	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/h-back-suspenders-36964	1
2	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	249.99	0	249.99	97089-DEFAULT-l.jpg	249.99	97089-DEFAULT-m.jpg	YOUTH MALLARD WADER	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	200-to-250	0.00	[empty string]	MALLARD II - REALTREE MAX-5 1000G - YOUTH	<p>LaCrosse focused on the essentials and only the essentials for the serious waterfowler who needs a premium wader, but doesn’t want to drop serious cash. As comfortable as it is durable, they built their Mallard II to be slightly lighter in weight, but still insulated enough to keep you warm in cold and wet conditions.</p> <p> </p> <ul> <li>Double Stitched Seams</li> <li>1000g Thinsulate Ultra</li> <li>Brush Tuff</li> <li>Realtree Max-5</li> <li>Stretch Neoprene</li> <li>Swamp-lite Outsole</li> <li>Buckled Straps</li> <li>Top Pocket</li> </ul> <p> </p> <ul> <li>Weight: 4 lbs</li> <li>Height: Chest</li> <li>Insulation: 1000G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: 3.5mm neoprene</li> <li>Traction: Best for Mud, Snow</li> <li>Footbed: EVA</li> <li>Shank: Steel</li> <li>Best For: Whitetail Hunting, Turkey Hunting</li> <li>Last Type: LP-2</li> <li>Lining: Waterproof</li> <li>Liner: Jersey</li> <li>Toe Protection: Plain Toe</li> </ul>	[empty string]	N	249.99	249.99	8,7,6	97089-DEFAULT-s.jpg	[empty string]	1000	700320	183661	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/mallard-ii-realtree-max-5-1000g-youth-183661	1
3	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	309.99	0	309.99	97090-DEFAULT-l.jpg	309.99	97090-DEFAULT-m.jpg	MALLARD EXPANDABLE WADER	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	28	300-to-350	0.00	[empty string]	MALLARD II EXPANDABLE - REALTREE MAX-5 1000G	<p>LaCrosse focused on the essentials and only the essentials for the serious waterfowler who needs a premium wader, but doesn’t want to drop serious cash. As comfortable as it is durable, they built their Mallard II to be slightly lighter in weight, but still insulated enough to keep you warm in cold and wet conditions.</p> <p> </p> <ul> <li>Double Stitched Seams</li> <li>1000g Thinsulate Ultra</li> <li>Brush Tuff</li> <li>Realtree Max-5</li> <li>Stretch Neoprene</li> <li>Expandable Waders</li> <li>Swamp-lite Outsole</li> <li>Buckled Straps</li> <li>Top Pocket</li> </ul> <p> </p> <ul> <li>Weight: 10 lbs</li> <li>Height: Chest</li> <li>Insulation: 1000G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: 3.5mm Upper</li> <li>Traction: Best for Mud</li> <li>Footbed: EVA</li> <li>Shank: Steel</li> <li>Last Type: LP-2</li> <li>Lining: Waterproof</li> <li>Liner: Jersey</li> <li>Toe Protection: Plain Toe</li> </ul>	[empty string]	N	309.99	309.99	9,11,12,13,14,10,8,15	97090-DEFAULT-s.jpg	[empty string]	1000	700316	242004	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/mallard-ii-expandable-realtree-max-5-1000g-242004	1
4	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	359.99	0	359.99	97091-DEFAULT-l.jpg	359.99	97091-DEFAULT-m.jpg	BRUSH TUFF EXTREME ATS WADER	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	32	350-to-400	0.00	[empty string]	BRUSH TUFF EXTREME - REALTREE MAX-5 1600G	<p>Through needle grass and thickets, mud and ice, LaCrosse's Brush Tuff Extreme prevails. We use heavy duty neoprene and their highly abrasion-resistant materials to make sure your waders last season after season.</p> <p> </p> <ul> <li>Double Stitched Seams</li> <li>1600g Thinsulate Wader</li> <li>5mm Neoprene & Fleece</li> <li>Brush Tuff</li> <li>Realtree Max-5</li> <li>Ankle Fit</li> <li>Ats Outsole</li> <li>Built-in Shell Holder And Pockets</li> <li>Convertible Straps</li> </ul> <p> </p> <ul> <li>Weight: 12.5 lbs</li> <li>Height: Chest</li> <li>Insulation: 1600G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: 5mm Upper</li> <li>Traction: Best for Mud, Snow</li> <li>Footbed: EVA</li> <li>Shank: Steel</li> <li>Last Type: Factory Last</li> <li>Lining: Waterproof</li> <li>Liner: Fleece</li> <li>Toe Protection: Plain Toe</li> </ul>	[empty string]	N	359.99	359.99	11,12,10,13,14,9,8	97091-DEFAULT-s.jpg	[empty string]	1000	700055	242005	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/brush-tuff-extreme-realtree-max-5-1600g-242005	1
5	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	299.99	0	299.99	97092-DEFAULT-l.jpg	299.99	97092-DEFAULT-m.jpg	MALLARD MAX 5 1000GRAM	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	27	250-to-300	0.00	[empty string]	MALLARD II - REALTREE MAX-5 1000G	<p>LaCrosse focused on the essentials and only the essentials for the serious waterfowler who needs a premium wader, but doesn’t want to drop serious cash. As comfortable as it is durable, they built their Mallard II to be slightly lighter in weight, but still insulated enough to keep you warm in cold and wet conditions.</p> <p> </p> <ul> <li>1000g Thinsulate Ultra</li> <li>A Unique Combination Of Spandex And Lycra Is Layered Over Neoprene For Extra Durability</li> <li>Realtree Max-5</li> <li>Stretch Neoprene</li> <li>Pu Protective Coating</li> <li>Swamp-lite Outsole</li> <li>Convertible Straps</li> <li>Frontal top loading pocket and a call holder to provide ample accessible storage</li> <li>Spot to stow your hands when it's cold</li> </ul> <p> </p> <ul> <li>Weight: 8.8 lbs</li> <li>Height: Chest</li> <li>Insulation: 1000G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: 3.5mm Upper</li> <li>Traction: Best for Mud</li> <li>Footbed: EVA</li> <li>Shank: Steel</li> <li>Last Type: LP-2</li> <li>Lining: Waterproof</li> <li>Liner: Jersey</li> <li>Toe Protection: Plain Toe</li> </ul>	[empty string]	N	299.99	299.99	14,11,7,10,13,15,8,12,9	97092-DEFAULT-s.jpg	[empty string]	1000	700312	266220	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/mallard-ii-realtree-max-5-1000g-266220	1
6	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	329.99	0	329.99	97093-DEFAULT-l.jpg	329.99	97093-DEFAULT-m.jpg	SUPER BRUSH TUFF WADER	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	37	300-to-350	0.00	[empty string]	SUPER BRUSH TUFF - REALTREE MAX -5 1200G	<p>Warmth and durability - these are the features LaCrosse's waterfowlers look for most in a wader. They build the Super Brush Tuff with abrasion-resistant material and added reinforcement on the knees and seat. With naturally insulating neoprene, 1200 grams of Thinsulate Ultra, and felt midsoles, their waders keep you dry and comfortable in conditions that are far from it.</p> <p> </p> <ul> <li>Armor Weld</li> <li>1200g Thinsulate Ultra Insulation</li> <li>5mm Neoprene</li> <li>Brush Tuff</li> <li>Realtree Max-5</li> <li>Pu Protective Coating</li> <li>Trac-lite Outsole</li> <li>Convertible Straps</li> <li>Top Pocket</li> </ul> <p> </p> <ul> <li>Weight: 10.8 lbs</li> <li>Height: Chest</li> <li>Insulation: 1200G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: 5mm Upper</li> <li>Traction: Best for Mud</li> <li>Footbed: EVA</li> <li>Shank: Steel</li> <li>Last Type: Factory Last</li> <li>Lining: Waterproof</li> <li>Liner: Jersey</li> <li>Toe Protection: Plain Toe</li> </ul>	[empty string]	N	329.99	329.99	12,9,10,11,14,8,13	97093-DEFAULT-s.jpg	[empty string]	1000	700152	275771	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/super-brush-tuff-realtree-max-5-1200g-275771	1
7	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	359.99	0	359.99	97094-DEFAULT-l.jpg	359.99	97094-DEFAULT-m.jpg	WETLANDINSULATED BREATHABLE BOOTFOOT	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	27	350-to-400	0.00	[empty string]	WETLANDS - REALTREE MAX-5 1600G	<p>When it comes to the two most important features in a wader, keeping you warm and dry, the Wetlands breathable waders have you covered. Featuring durable, lightweight, abrasion-resistant nylon with double stitched and taped seams, these waders are made for long days in the water. And LaCrosse Alpha boots mean your feet are wrapped in premium rubber and cushioning neoprene with Thinsulate Ultra Insulation for all day comfort.</p> <p> </p> <ul> <li>1600g Thinsulate Ultra</li> <li>Realtree Max-5</li> <li>Breathable Nylon Upper</li> <li>Active Fit</li> <li>60g Quilted Insulation</li> <li>Adjustable Options</li> <li>Swamp-lite Outsole</li> <li>Top Pocket</li> </ul> <p> </p> <ul> <li>Weight: 8.3 lbs</li> <li>Height: Chest</li> <li>Insulation: 1600G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: Breathable Nylon</li> <li>Footbed: EVA</li> <li>Shank: Steel</li> <li>Last Type: ST-MU-2</li> <li>Lining: Waterproof</li> <li>Liner: Nylon Fabric</li> <li>Toe Protection: Plain Toe</li> </ul>	[empty string]	N	359.99	359.99	12,9,10,11,14,13,15,8	97094-DEFAULT-s.jpg	[empty string]	1000	736121 REG	306842	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/wetlands-realtree-max-5-1600g-306842	1
8	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	359.99	0	359.99	97095-DEFAULT-l.jpg	359.99	97095-DEFAULT-m.jpg	WETLANDINSULATED STOUT BREATHABLE BOOTFOOT	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	350-to-400	0.00	[empty string]	WETLANDS - REALTREE MAX-5 1600G	<p>When it comes to the two most important features in a wader, keeping you warm and dry, the Wetlands breathable waders have you covered. Featuring durable, lightweight, abrasion-resistant nylon with double stitched and taped seams, these waders are made for long days in the water. And LaCrosse Alpha boots mean your feet are wrapped in premium rubber and cushioning neoprene with Thinsulate Ultra Insulation for all day comfort.</p> <p> </p> <ul> <li>1600g Thinsulate Ultra</li> <li>Realtree Max-5</li> <li>Breathable Nylon Upper</li> <li>Active Fit</li> <li>60g Quilted Insulation</li> <li>Adjustable Options</li> <li>Swamp-lite Outsole</li> <li>Top Pocket</li> </ul> <p> </p> <ul> <li>Weight: 8.3 lbs</li> <li>Height: Chest</li> <li>Insulation: 1600G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: Breathable Nylon</li> <li>Footbed: EVA</li> <li>Shank: Steel</li> <li>Last Type: ST-MU-2</li> <li>Lining: Waterproof</li> <li>Liner: Nylon Fabric</li> <li>Toe Protection: Plain Toe</li> </ul>	[empty string]	N	359.99	359.99	10,11,12,8,9	97095-DEFAULT-s.jpg	[empty string]	1000	736121 STOUT	310826	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/wetlands-realtree-max-5-1600g-310826	1
9	[empty string]	LACROSSE	Lacrosse	FOOTWEAR	Footwear>Waders	[empty string]	1	689.99	0	689.99	97096-DEFAULT-l.jpg	689.99	97096-DEFAULT-m.jpg	ALPHA AGILITYSELECT WADER	N	7.1 RANDY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	500-or-more	0.00	[empty string]	ALPHA AGILITY SELECT WADERS - FRONT ZIP - REALTREE MAX-5	<p>If your best days are spent hip deep in the water blowing a duck call, LaCrosse created these premium chest waders for you. The Alpha Agility Select is built on the same platform as our popular Alpha Agility knee boots to give you the most lightweight and comfortable wader boot possible. A front zip gets you in and out of the waders with ease, and a quilted liner zips out so you can wear them when the weather warms up. A waterproof pocket with electrostatic technology lets you check the weather or migration stats without having to take your phone out of the sleeve.</p> <p> </p> <ul> <li>Alpha Agility Wader Boot</li> <li>1600g Thinsulate Wader</li> <li>Breathable Nylon Upper</li> <li>Removable Liner</li> <li>Realtree Max-5</li> <li>Breathable Nylon Upper</li> <li>Active Fit</li> <li>Agility Outsole</li> <li>Tech Pouch</li> </ul> <p> </p> <ul> <li>Height: Chest</li> <li>Insulation: 1600G Thinsulate Ultra</li> <li>Camo Pattern: Realtree Max-5</li> <li>Wader Upper Material: Breathable Nylon, 120G Quilted Insulation</li> <li>Footbed: Polyurethane</li> <li>Shank: Nylon</li> <li>Last Type: JBJR</li> <li>Lining: Waterproof</li> <li>Liner: Jersey</li> </ul>	[empty string]	N	689.99	689.99	9,10,11,12,13,14	97096-DEFAULT-s.jpg	[empty string]	1000	725360	360692	EMPTY	EMPTY	EMPTY	0	0	0	WADERS	[empty string]	lacrosse/alpha-agility-select-waders-front-zip-realtree-max-5-360692	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts143 ORDER BY sortposition asc

Footwear

Sort By:

Items per page:

Filter