Simmons' 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	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH
1	OLIVE_DRAB_GREEN	LACROSSE	Lacrosse	CLOTHING	Clothing	OLIVE_DRAB_GREEN\|NULL\|NULL	1	119.99	1	99.99	3548-DEFAULT-l.jpg	119.99	3548-DEFAULT-m.jpg	LACROSSE MNS GRANGE 18 BOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMNSGRANGE18INBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Lacrosse Men's Grange 18" Boots	<p> </p><ul><li>100% ozone-resistant and scent-free premium rubber.</li><li>Chevron cleated outsole.</li><li>EVA removable footbed.</li><li>Fiberglass shank.</li><li>Weight 4.5 lbs. per pair.</li></ul>	[empty string]	Y	99.99	99.99	13,7,12,6,5,14	3548-DEFAULT-s.jpg	[empty string]	1000	1000	150040	75218	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-grange-18-boots-75218	150040	0
2	OLIVE_DRAB_GREEN	LACROSSE	Lacrosse	CLOTHING	Clothing	OLIVE_DRAB_GREEN\|NULL\|NULL	1	129.99	1	109.99	17870-DEFAULT-l.jpg	129.99	17870-DEFAULT-m.jpg	LACROSSE MNS BURLY CLASSIC 18	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMENSBURLY18IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Lacrosse Men's Burly Classic 18" Boots	<p>In 1957 we introduced the Grange. A non-insulated, do-it-all rubber boot that our customers knew they could always trust. Six years later, an insulated version of the Grange came to be - the Burly. Today, these boots are alive and well. They're still made from our proven ZXT Rubber. They're still built to perform under the harshest of conditions. And they're still the boots you can call on to get the job done.</p><p><strong>100% WATERPROOF PROTECTION</strong><br />Rubber is naturally waterproof and with our proven formulas, our rubber remains durable and waterproof year after year.<br /><strong>REALTREE TIMBER </strong><br />Using a realistic bark pattern featuring deep, dark cuts for added depth, Realtree Timber is the most effective and lifelike camo pattern for flooded timber.<br /><strong>ADJUSTABLE TOP STRAP</strong><br />Customizable for a secure fit around your calf.<br /><strong>ANKLE FIT</strong><br />Our revolutionary fit ensures a secure and comfortable fit around your ankles, while gripping the top of your foot and locking your heel in place.</p><p><br /><strong>SPECIFICATIONS</strong></p><ul><li>Style 266041</li><li>Weight 4.5 lbs per pair</li><li>Height 18"</li><li>Insulation Foam</li><li>Color Realtree Timber</li><li>Camo Pattern Realtree Timber </li><li>Traction Best for All-Terrain, Slip Resistant</li><li>Footbed EVA</li><li>Shank Fiberglass</li><li>Last Type Factory Last</li><li>Lining Waterproof</li><li>Liner Nylon Fabric</li><li>Country of Origin China</li><li>Manufacturing Imported</li><li>Toe Protection Plain Toe</li></ul>	[empty string]	Y	109.99	109.99	8,12,13,14	17870-DEFAULT-s.jpg	[empty string]	1000	1000	266040	75225	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-burly-classic-18-boots-75225	266040	0
3	REALTREE_TIMBER	LACROSSE	Lacrosse	CLOTHING	Clothing	REALTREE_TIMBER\|NULL\|NULL	1	139.99	1	129.99	4635-DEFAULT-l.jpg	139.99	4635-DEFAULT-m.jpg	LACROSSE MNS BURLY CLASSIC 18	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMENSBURLY18IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	25	100-to-150	0.00	[empty string]	Lacrosse Men's Burly Classic 18" Boots	<p>In 1957 we introduced the Grange. A non-insulated, do-it-all rubber boot that our customers knew they could always trust. Six years later, an insulated version of the Grange came to be - the Burly. Today, these boots are alive and well. They're still made from our proven ZXT Rubber. They're still built to perform under the harshest of conditions. And they're still the boots you can call on to get the job done.</p><p><strong>100% WATERPROOF PROTECTION</strong><br />Rubber is naturally waterproof and with our proven formulas, our rubber remains durable and waterproof year after year.<br /><strong>REALTREE TIMBER </strong><br />Using a realistic bark pattern featuring deep, dark cuts for added depth, Realtree Timber is the most effective and lifelike camo pattern for flooded timber.<br /><strong>ADJUSTABLE TOP STRAP</strong><br />Customizable for a secure fit around your calf.<br /><strong>ANKLE FIT</strong><br />Our revolutionary fit ensures a secure and comfortable fit around your ankles, while gripping the top of your foot and locking your heel in place.</p><p><br /><strong>SPECIFICATIONS</strong></p><ul><li>Style 266041</li><li>Weight 4.5 lbs per pair</li><li>Height 18"</li><li>Insulation Foam</li><li>Color Realtree Timber</li><li>Camo Pattern Realtree Timber </li><li>Traction Best for All-Terrain, Slip Resistant</li><li>Footbed EVA</li><li>Shank Fiberglass</li><li>Last Type Factory Last</li><li>Lining Waterproof</li><li>Liner Nylon Fabric</li><li>Country of Origin China</li><li>Manufacturing Imported</li><li>Toe Protection Plain Toe</li></ul>	[empty string]	Y	129.99	129.99	8,10,11,12,13,14,6,15	4635-DEFAULT-s.jpg	[empty string]	1000	1000	266041	75226	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-burly-classic-18-boots-75226	266041	0
4	BROWN	LACROSSE	Lacrosse	CLOTHING	Clothing	BROWN\|NULL\|NULL	1	139.99	0	139.99	703-DEFAULT-l.jpg	139.99	703-DEFAULT-m.jpg	LACROSSE MNS TREKKER II 7	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMENSTREKKERII7IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	14	100-to-150	0.00	[empty string]	Lacrosse Men's Trekker II 7" Boots	<p><strong>TRIED AND TRUE IN THE COLD AND WET.</strong><br />No beans about it, these boots were made for cold, wet conditions. The Trekker was designed to pull on with ease so you can slip them on and go anywhere. The full-grain leather upper and natural, hand-laid rubber bottom are waterproof and durable and provide just enough warmth to keep you comfortable while you take care of cold weather work (or play).</p>	[empty string]	N	139.99	139.99	12,8,7,11,9,14	703-DEFAULT-s.jpg	[empty string]	1000	1000	273120	75228	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-trekker-ii-7-boots-75228	273120	0
5	BROWN	LACROSSE	Lacrosse	CLOTHING	Clothing	BROWN\|NULL\|NULL	1	159.99	1	69.99	705-DEFAULT-l.jpg	159.99	705-DEFAULT-m.jpg	LACROSSE MNS UPLANDER II 10	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMNSUPLANDERII10IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Lacrosse Men's Uplander II 10" Boots	<p>No beans about it, these boots were made for cold, wet conditions. With it's full lace-up design, we originally built this boot for late season bird hunting. Since then, it's been adopted as the go-to winter boot. The full-grain leather upper and natural, hand-laid rubber bottom are waterproof and durable to last season after season. Extended sizes available for women.<br></p>	[empty string]	Y	69.99	69.99	12,13	705-DEFAULT-s.jpg	[empty string]	1000	1000	273122	75229	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-uplander-ii-10-boots-75229	273122	0
6	BROWN	LACROSSE	Lacrosse	CLOTHING	Clothing	BROWN\|NULL\|NULL	1	169.99	0	169.99	707-DEFAULT-l.jpg	169.99	707-DEFAULT-m.jpg	LACROSSE MNS MESQUITE II 10	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMENSMESQUITEII10IN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	Lacrosse Men's Mesquite II 10" Boots	<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, our 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.<br></p>	[empty string]	N	169.99	169.99	12,9,10,11,13,14,15	707-DEFAULT-s.jpg	[empty string]	1000	1000	273124	75230	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-mesquite-ii-10-boots-75230	273124	0
7	BROWN	LACROSSE	Lacrosse	CLOTHING	Clothing	BROWN\|NULL\|NULL	1	209.99	0	209.99	13087-DEFAULT-l.jpg	209.99	13087-DEFAULT-m.jpg	LACROSSE MNS AGILITY SNAKEBOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMNSAGILITYSNAKEBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	200-to-250	0.00	[empty string]	Lacrosse Men's Agility Snakeboot	<ul><li>Style 302420</li><li>Weight 4.9 lbs per pair</li><li>Height 17"</li><li>Insulation Non-Insulated</li><li>Color Brown</li><li>Footbed EVA</li><li>Shank Nylon</li><li>Best For Turkey Hunting, Hunt Solids</li><li>Protection Snake Guard</li><li>Last Type JBJR</li><li>Lining Waterproof</li><li>Liner Jersey</li><li>Manufacturing Imported</li><li>Materials Rubber/PU</li></ul><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, our signature adjustable gusset fits any size calf snugly and securely.</p><p><strong>ALPHA CONSTRUCTION</strong><br />Built with hand-laid premium, natural rubber over insulating neoprene for durability, flexibility and complete waterproof protection.<br /><strong>COMFORT LINER</strong><br />Quick drying and moisture wicking, our jersey knit liner will keep your feet dry and comfortable.<br /><strong>ACTIVE FIT</strong><br />With a comfortable, secure fit to keep your foot in place while on the move, boots with Active Fit also go on and come off with ease.<br /><strong>KICK-OFF HEEL PLATE</strong><br />For easy hands-free removal.<br /><strong>SNAKE GUARD</strong><br />We use a flexible snake protection fabric in between the liner and exterior of the boot to give you complete snake protection without weighing you down. <br /><strong>AGILITY OUTSOLE</strong><br />The durable rubber outsole of the Alpha Agility is paired with a midsole constructed from our lightweight LXA compound for optimal rebound and comfort.</p>	[empty string]	N	209.99	209.99	12,9,11,8,13,14,7	13087-DEFAULT-s.jpg	[empty string]	1000	1000	302420	75232	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-agility-snakeboot-75232	302420	0
8	BROWN_GREEN	LACROSSE	Lacrosse	CLOTHING	Clothing	BROWN_GREEN\|NULL\|NULL	1	209.99	0	209.99	17353-DEFAULT-l.jpg	209.99	17353-DEFAULT-m.jpg	LACROSSE WMS AGILITY SNAKEBOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEWMSAGILITYSNAKEBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	Lacrosse Womens Agility Snakeboot	<ul><li>Style 302421</li><li>Weight 3.8 lbs per pair</li><li>Height 15"</li><li>Insulation Non-Insulated</li><li>Color Brown/Green</li><li>Footbed EVA</li><li>Shank Nylon</li><li>Best For Turkey Hunting, Hunt Solids</li><li>Protection Snake Guard</li><li>Last Type JBJR</li><li>Lining Waterproof</li><li>Liner Jersey</li><li>Manufacturing Imported</li></ul>	[empty string]	N	209.99	209.99	5,9,10,8	17353-DEFAULT-s.jpg	[empty string]	1000	1000	302421	75233	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-womens-agility-snakeboot-75233	302421	0
9	BROWN	LACROSSE	Lacrosse	CLOTHING	Clothing	BROWN\|NULL\|NULL	1	169.99	0	169.99	4640-DEFAULT-l.jpg	169.99	4640-DEFAULT-m.jpg	LACROSSE WMS ALPHA AGILITY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEWMSALPHAAGILITY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	150-to-200	0.00	[empty string]	Lacrosse Women's Alpha Agility Boots	<p><strong>ATHLETIC SHOE AGILITY MEETS RUBBER BOOT UTILITY</strong><br />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, our signature adjustable gusset fits any size calf snugly and securely.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>Hand-laid premium rubber over a 5mm neoprene core for flexible, waterproof comfort</li><li>Moisture-wicking and quick-drying polyester jersey liner</li><li>Multilayer rubber provides support and durability with added texture in high-wear areas</li><li>Active Fit locks the heel in place and back gusset is adjustable for a comfortable, secure fit</li><li>Specially formulated LXA compound gives athletic shoe-like agility and cushion for all-day use</li><li>Kick-off heel plate allows easy hands-free removal</li></ul>	[empty string]	N	169.99	169.99	6,9,7,8,11	4640-DEFAULT-s.jpg	[empty string]	1000	1000	302443	75234	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-women-s-alpha-agility-boots-75234	302443	0
10	NWTF_BOTTOMLAND	LACROSSE	Lacrosse	CLOTHING	Clothing	NWTF_BOTTOMLAND\|NULL\|NULL	1	139.99	1	119.99	3551-DEFAULT-l.jpg	139.99	3551-DEFAULT-m.jpg	LACROSSE MNS GRANGE 18 BOOT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	368	.LACROSSEMNSGRANGE18INBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	26	100-to-150	0.00	[empty string]	Lacrosse Men's Grange 18" Boots	<p> </p><ul><li>100% ozone-resistant and scent-free premium rubber.</li><li>Chevron cleated outsole.</li><li>EVA removable footbed.</li><li>Fiberglass shank.</li><li>Weight 4.5 lbs. per pair.</li></ul>	[empty string]	Y	119.99	119.99	12,13,8,10,9,11,7	3551-DEFAULT-s.jpg	[empty string]	1000	1000	322142	75236	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lacrosse/lacrosse-men-s-grange-18-boots-75236	322142	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts143 ORDER BY sortposition asc