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]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	[empty string]	0	234.99	0	234.99	[empty string]	234.99	[empty string]	M ELK TRACKER GTX 1000GR	N	5 MAIDA	[empty string]	[empty string]	[empty string]	E	[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]	2	200-to-250	0.00	[empty string]	Elk Tracker - Men`s	<p>Bring on the toughest terrain, where the biggest bulls rule. Elk Tracker boots will get you there and back. With an aggressive sole for excellent traction, shock absorbing cork midsole for long-lasting comfort and full-grain waterproof leather for support, you can go all day for your trophy.</p>	[empty string]	N	234.99	234.99	8D,14EE	[empty string]	[empty string]	1000	860	33099	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-elk-tracker-gtx-1000gr-33099	1
2	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	[empty string]	0	164.99	0	164.99	[empty string]	164.99	[empty string]	M TRAILBLAZER NI BOOT	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]	2021	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	10	150-to-200	0.00	[empty string]	Trailblazer - Waterproof - Leather - 7` - Men`s	<p>At home on a hiking trail, trekking through timber, or working on the Back 40, Trailblazers are an excellent high-performance boot. The uppers feature our UltraDry lining and ScentBan technology. The Bulls-Eye Air Bob Carbon Rubber soles gain traction on rough terrain, thanks to an aggressive lug pattern, while an EVA midsole reduces weight and provides underfoot cushioning.<br />  </p>	[empty string]	N	164.99	164.99	14D,9D,14EE,9.5EE,8D,13EE	[empty string]	[empty string]	1000	878	33101	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-trailblazer-ni-boot-33101	1
3	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	[empty string]	0	154.99	0	154.99	[empty string]	154.99	[empty string]	M SOFT PAW CHUKKA	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	SELL THRU	ONLINE	[empty string]	[empty string]	31	150-to-200	0.00	[empty string]	Soft Paw - Men`s	<p>Perfectly suited to a camp or your workplace, the Soft Paw collection, features the Soft Paw II sole which facilitates the release of mud and dirt. The EVA midsole reduces weight and provides underfoot cushioning.</p>	[empty string]	N	154.99	154.99	10.5,11,11.5,9.5,8,14,8.5,9,13	[empty string]	[empty string]	1000	3875	94341	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-soft-paw-chukka-94341	1
4	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	174.99	0	174.99	[empty string]	174.99	[empty string]	M WINGSHOOTER 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]	32	150-to-200	0.00	[empty string]	Wingshooter - Waterproof - 9 Inch - Men`s	<p>Designed and crafted for the most demanding Upland hunters, iconic Wingshooter boots feature waterproof leather combined with the UltraDry waterproofing system and a cushioned, debris-shedding sole so you can cover the miles in comfort.</p>	[empty string]	N	174.99	174.99	8.5,10,11,9,11.5,14,9.5,8	[empty string]	[empty string]	1000	894	98672	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-wingshooter-boot-98672	1
5	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	M WINGSHOOTER BOOT 400GR	N	5 MAIDA	[empty string]	[empty string]	[empty string]	E	[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]	12	150-to-200	0.00	[empty string]	Wingshooter - Waterproof & Insulated - Leather - 9` - Men`s	<p>Designed and crafted for the most demanding Upland hunters, iconic Wingshooter boots feature waterproof leather combined with the UltraDry waterproofing system and a cushioned, debris-shedding sole so you can cover the miles in comfort.</p>	[empty string]	N	199.99	199.99	14,9.5,8,7,10.5,8.5	[empty string]	[empty string]	1000	896	98699	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-wingshooter-boot-400gr-98699	1
6	BROWN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	BROWN\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	W WINGSHOOTER 7IN ULTRADRY NI	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]	29	150-to-200	0.00	[empty string]	Wingshooter - Waterproof - Leather - 7` - Men`s	<p>This Wingshooter boot features a full-grain waterproof leather upper combined with excellent traction for a classic upland hunting boot.</p>	[empty string]	N	159.99	159.99	12,14,11.5,8.5,9,9.5,10.5,13	[empty string]	[empty string]	1000	807	126679	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/w-wingshooter-7in-ultradry-ni-126679	1
7	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	174.99	0	174.99	[empty string]	174.99	[empty string]	W WINGSHOOTER 9IN NON-INSULATED	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]	26	150-to-200	0.00	[empty string]	Wingshooter - Waterproof - Leather - 9 Inch - Men`s	<p>Designed and crafted for the most demanding Upland hunters, iconic Wingshooter boots feature waterproof leather combined with the UltraDry waterproofing system and a cushioned, debris-shedding sole so you can cover the miles in comfort.</p>	[empty string]	N	174.99	174.99	8,14,9.5,11.5,12,8.5,9,13	[empty string]	[empty string]	1000	808	138507	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/w-wingshooter-9in-non-insulated-138507	1
8	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	[empty string]	0	234.99	0	234.99	[empty string]	234.99	[empty string]	M ELK TRACKER 12 GTX IN BOOT 600GR	N	5 MAIDA	[empty string]	[empty string]	[empty string]	E	[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	200-to-250	0.00	[empty string]	Elk Tracker - Waterproof - Leather And Insulated - 12` - Men`s	<p>Bring on the toughest terrain, where the biggest bulls rule. Elk Tracker boots will get you there and back. With an aggressive sole for excellent traction, shock absorbing cork midsole for long-lasting comfort and full-grain waterproof leather for support, you can go all day for your trophy.</p>	[empty string]	N	234.99	234.99	8,8.5,9.5,12,13	[empty string]	[empty string]	1000	882	142658	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-elk-tracker-12-gtx-in-boot-600gr-142658	1
9	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	[empty string]	0	154.99	0	154.99	[empty string]	154.99	[empty string]	M BORDERLAND OXFORD	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]	4	150-to-200	0.00	[empty string]	Borderland - Oxford - Men`s	<p>The boots in Irish`s Borderland family are perfectly suited for casual use or light duty work. The upper features Irish Setter`s USA-made, waterproof, full grain Trout Brook leather. The Borderland sole is slip-resistant, with a tread design that facilitates the release of mud and dirt.</p>	[empty string]	N	154.99	154.99	13,8.5,9.5	[empty string]	[empty string]	1000	3864	158330	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-borderland-oxford-158330	1
10	INFINITY	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	INFINITY\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M GUNFLINT 1000GRAM 10IN	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	ACTIVE	ONLINE	[empty string]	[empty string]	11	100-to-150	0.00	[empty string]	Gunflint Ii - Waterproof And Insulated - 10` - Men`s	<p>Brutal cold and deep snow are no match for the Gunflint ll. The King Toe toe box means extra room for extra warmth. Full-grain waterproof leather and abrasion-resistant nylon uppers enhance support and add durability. And an aggressive lug pattern on the sole provides excellent stability and traction.</p>	[empty string]	N	139.99	139.99	8,8.5,9.5,10,11,11.5,12,14	[empty string]	[empty string]	1000	2813	176630	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-gunflint-1000gram-10in-176630	1
11	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	[empty string]	0	104.99	0	104.99	[empty string]	104.99	[empty string]	M LAKESIDE FISHING SHOE	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]	25	100-to-150	0.00	[empty string]	Lakeside - Men`s	<p>The perfect combination of great looks and total comfort, thanks to an upper that features full-grain leather and abrasion-resistant nylon. Irish Setter`s Siped Pod Grip sole not only performs well on wet surfaces, it features molded cushion zones for added underfoot comfort.</p>	[empty string]	N	104.99	104.99	8,9,11.5,9.5,10.5,11,8.5,10,12,14	[empty string]	[empty string]	1000	3819	249597	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-lakeside-fishing-shoe-249597	1
12	STONE	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	STONE\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	M RAVINE 7IN NI WP STONE	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]	8	150-to-200	0.00	[empty string]	Ravine - Waterproof - Leather - 7` - Men`s	<p>Wherever you`re going, Ravine boots will get you there. Whether you`re hunting, hiking or just enjoying the great outdoors, this boot`s ready for any adventure. The unique torsion-control chassis, innovative dual-density midsole, energy-returning core and multi-tied lugs add up to comfort, support and traction on rocky or uneven terrain.</p>	[empty string]	N	169.99	169.99	9,8.5,11.5,13	[empty string]	[empty string]	1000	2884	287637	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-ravine-7in-ni-wp-stone-287637	1
13	BROWN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	BROWN\|NULL\|NULL	0	179.99	0	179.99	[empty string]	179.99	[empty string]	M WINGSHOOTER SAFETY TOE NM 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	ONLINE	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	Wingshooter St - Waterproof - Safety Toe - 8 Inch - Men`s	<p>Wingshooter ST boots deliver superior comfort and support on the job. The iconic amber leather and white sole combine to create the distinctive Irish Setter look. A lightweight safety toe cap ensures roomy protection. UltraDry waterproofing keeps your feet dry, and the wedge sole offers best-in-class slip resistance.</p>	[empty string]	N	179.99	179.99	10.5,10,8.5,14,8,9,9.5	[empty string]	[empty string]	1000	83832	287640	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-wingshooter-safety-toe-nm-8in-287640	1
14	TAN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	TAN\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	M TRAVELER CHUKKA	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]	[empty string]	SELL THRU	ONLINE	[empty string]	[empty string]	16	100-to-150	0.00	[empty string]	Traveler - Men`s	<p>The versatile Traveler can take you from the cabin to the campfire, or from outdoors to the office. Comfort and style combine in this casual family that gives you the look of a traditional boot and the lightweight feel of an athletic shoe. Rustic yet stylish, the Traveler delivers all-day comfort with a rugged RPM sole, supple full-grain leathers, and a cushy, open cell foam footbed.</p>	[empty string]	N	109.99	109.99	9,10.5,9.5,11.5,13,10,11	[empty string]	[empty string]	1000	3805	294852	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-traveler-chukka-294852	1
15	BROWN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	BROWN\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	M TRAVELER OXFORD	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]	[empty string]	SELL THRU	ONLINE	[empty string]	[empty string]	26	50-to-100	0.00	[empty string]	Traveler - Men`s	<p>The versatile Traveler can take you from the cabin to the campfire, or from outdoors to the office. Comfort and style combine in this casual family that gives you the look of a traditional boot and the lightweight feel of an athletic shoe. Rustic yet stylish, the Traveler delivers all-day comfort with a rugged RPM sole, supple full-grain leathers, and a cushy, open cell foam footbed.</p>	[empty string]	N	99.99	99.99	10,10.5,11,11.5,9,9.5,13,12,14	[empty string]	[empty string]	1000	3806	294853	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-traveler-oxford-294853	1
16	GREY	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	GREY\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	M DRIFTER SLIPON	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]	[empty string]	SELL THRU	ONLINE	[empty string]	[empty string]	34	100-to-150	0.00	[empty string]	Drifter - Men`s	<p>Drifter boots are purpose-built for maximum durability with minimum weight – they’re the lightest weight trail/hunting boots Irish Setter has ever made. The full-grain leather upper combined with abrasion resistant mesh results in maximum comfort and breathability. Quick-dry linings wick away foot moisture and ArmaTec technology adds abrasion resistance to high wear areas of the heel. This combined with the Venturist outsole and contoured fit make this product perfect for whatever trail you take.</p>	[empty string]	N	109.99	109.99	9.5,10,10.5,11.5,12,11,8.5,9	[empty string]	[empty string]	1000	2806	294859	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-drifter-slipon-294859	1
17	BROWN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	BROWN\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	M RAVINE 400G WITH BOA	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]	2	150-to-200	0.00	[empty string]	Ravine - Waterproof - Leather And Insulated - 9` - Men`s	<p>Wherever you`re going, Ravine boots will get you there. Whether you`re hunting, hiking or just enjoying the great outdoors, this boot`s ready for any adventure. The unique torsion-control chassis, innovative dual-density midsole, energy-returning core and multi-tied lugs add up to comfort, support and traction on rocky or uneven terrain.</p>	[empty string]	N	199.99	199.99	13,14	[empty string]	[empty string]	1000	2891	305454	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-ravine-400g-with-boa-305454	1
18	BROWN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	BROWN\|NULL\|NULL	0	154.99	0	154.99	[empty string]	154.99	[empty string]	W WINGSHOOTER 7IN	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]	8	150-to-200	0.00	[empty string]	Wingshooter - Waterproof Leather - 7` - Women`s	<p>Designed and crafted for the most demanding Upland hunters, iconic Wingshooter boots feature waterproof leather combined with the UltraDry waterproofing system and a cushioned, debris-shedding sole so you can cover the miles in comfort.</p>	[empty string]	N	154.99	154.99	7.5,9.5,7,10	[empty string]	[empty string]	1000	890	305456	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/w-wingshooter-7in-305456	1
19	BLACK	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	BLACK\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	M WINGSHOOTER BOOT 7IN 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]	31	150-to-200	0.00	[empty string]	Wingshooter - Waterproof - 7 Inch - Men`s	<p>Designed and crafted for the most demanding Upland hunters, iconic Wingshooter boots feature waterproof leather combined with the UltraDry waterproofing system and a cushioned, debris-shedding sole so you can cover the miles in comfort.</p>	[empty string]	N	159.99	159.99	10,10.5,9.5,11.5,12,13,14,8,8.5,9	[empty string]	[empty string]	1000	845	310959	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-wingshooter-boot-7in-black-310959	1
20	BROWN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	BROWN\|NULL\|NULL	0	89.99	0	89.99	[empty string]	89.99	[empty string]	M TRAVELER CHUKKA	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SUMMER	[empty string]	2021	[empty string]	MENS	SELL THRU	ONLINE	[empty string]	[empty string]	24	50-to-100	0.00	[empty string]	Traveler - Chukka - Men`s	<p>The versatile Traveler can take you from the cabin to the campfire, or from outdoors to the office. Comfort and style combine in this casual family that gives you the look of a traditional boot and the lightweight feel of an athletic shoe.</p>	[empty string]	N	89.99	89.99	12,11.5,9.5,10,8.5,11,9,10.5,13,14	[empty string]	[empty string]	1000	3815	310960	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-traveler-chukka-310960	1
21	TAN	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	TAN\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	M TRAVELER SLIPON	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]	23	50-to-100	0.00	[empty string]	Traveler - Canvas Slip-on - Men`s	<p>The versatile Traveler can take you from the cabin to the campfire, or from outdoors to the office. Comfort and style combine in this casual family that gives you the look of a traditional boot and the lightweight feel of an athletic shoe.</p>	[empty string]	N	79.99	79.99	13,14,9,8.5,11.5,12,9.5,10,10.5,11	[empty string]	[empty string]	1000	3822	310961	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-traveler-slipon-310961	1
22	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	184.99	0	184.99	[empty string]	184.99	[empty string]	M RAMSEY 2.0 AT PULLON SAFETY TOE	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]	Ramsey 2.0 - Pull-on - Waterproof Leather - 11 Inch - Men`s	<p>Combining traditional styling with rugged durability, Ramsey 2.0 work boots are outfitted with the technologies you need for go-all-day comfort and protection. Layer by layer, these features provide a unique blend of support, stability and long-lasting reliability. So your feet are protected from jobsite hazards and harsh conditions.</p>	[empty string]	N	184.99	184.99	10,13,9.5,10.5,11.5	[empty string]	[empty string]	1000	83952	310962	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-ramsey-2-0-at-pullon-safety-toe-310962	1
23	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	M RAMSEY PULLON SOFT TOE	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	150-to-200	0.00	[empty string]	Ramsey 2.0 - Waterproof Leather - Pull-on - 11` - Men`s	<p>Combining traditional styling with rugged durability, Ramsey 2.0 work boots are outfitted with the technologies you need for go-all-day comfort and protection. Layer by layer, these features provide a unique blend of support, stability and long-lasting reliability. So your feet are protected from jobsite hazards and harsh conditions.</p>	[empty string]	N	179.99	179.99	10,13,14,12,9,9.5	[empty string]	[empty string]	1000	83939	310963	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-ramsey-pullon-soft-toe-310963	1
24	MOBUC	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	MOBUC\|NULL\|NULL	0	204.99	0	204.99	[empty string]	204.99	[empty string]	M ICETREK 12IN 1600G MOBUC 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]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	16	200-to-250	0.00	[empty string]	Icetrek - Waterproof & Insulated - 12` - Men`s	<p>When your pursuits include winter hunts, ice fishing, snowmobiling or other cold weather activities, rely on IceTrek boots with innovative ThermalBoost technology to keep your feet warm on even the most brutal, bitter days.</p>	[empty string]	N	204.99	204.99	9.5,14,13,9,10,11.5	[empty string]	[empty string]	1000	3896	321192	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-icetrek-12in-1600g-mobuc-wp-321192	1
25	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	[empty string]	0	159.99	0	159.99	[empty string]	159.99	[empty string]	M WINGSHOOTER 7IN AMVER	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]	21	150-to-200	0.00	[empty string]	Wingshooter - Waterproof Leather - 7` - Men`s	<p>Designed and crafted for the most demanding Upland hunters, iconic Wingshooter boots feature waterproof leather combined with the UltraDry waterproofing system and a cushioned, debris-shedding sole so you can cover the miles in comfort.</p>	[empty string]	N	159.99	159.99	9.5,14,10,9,11.5,13,11	[empty string]	[empty string]	1000	838	321338	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-wingshooter-7in-amver-321338	1
26	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hiking Boots	[empty string]	0	154.99	0	154.99	[empty string]	154.99	[empty string]	M CANYONS HIKER WP LEATHER	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]	28	150-to-200	0.00	[empty string]	Canyons - Men`s	<p>A durable hiker with full-grain waterproof leather, a lightweight midsole for underfoot cushioning, and a Vibram Beehive sole that sheds mud and dirt.</p>	[empty string]	N	154.99	154.99	10.5,11,14,8,9,10,11.5,12,13,9.5,8.5	[empty string]	[empty string]	1000	2897	327437	EMPTY	EMPTY	EMPTY	0	0	0	HIKING BOOTS	[empty string]	irish-setter/m-canyons-hiker-wp-leather-327437	1
27	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	M WINGSHOOTER ST 6IN BOOT WP LEATHER	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]	Wingshooter St - Waterproof Leather - Safety Toe - 6` - Men`s	<p>Wingshooter ST boots deliver superior comfort and support on the job. The iconic amber leather and white sole combine to create the distinctive Irish Setter look. A lightweight safety toe cap ensures roomy protection. UltraDry waterproofing keeps your feet dry, and the wedge sole offers best-in-class slip resistance.</p>	[empty string]	N	169.99	169.99	8.5,10,13,14	[empty string]	[empty string]	1000	83620	327444	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-wingshooter-st-6in-boot-wp-leather-327444	1
28	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	M WINGSHOOTER ST 11IN PULL-ON BOOT WP LEATHER	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]	Wingshooter St - Waterproof Leather - 11` - Men`s	<p>Wingshooter ST boots deliver superior comfort and support on the job. The iconic amber leather and white sole combine to create the distinctive Irish Setter look. A lightweight safety toe cap ensures roomy protection. UltraDry waterproofing keeps your feet dry, and the wedge sole offers best-in-class slip resistance.</p>	[empty string]	N	179.99	179.99	9,9.5,10.5,11,10,11.5,12,13,8.5	[empty string]	[empty string]	1000	83962	327445	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-wingshooter-st-11in-pull-on-boot-wp-leather-327445	1
29	MOBUC	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	MOBUC\|NULL\|NULL	0	154.99	0	154.99	[empty string]	154.99	[empty string]	W VAPRTREK 400G	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]	2021	[empty string]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	16	150-to-200	0.00	[empty string]	W Vaprtrek 400g	[empty string]	[empty string]	N	154.99	154.99	7,7.5,8,8.5,6,6.5,10,9.5	[empty string]	[empty string]	1000	2839	335847	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/w-vaprtrek-400g-335847	1
30	MOBUC	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Rubber Boots	MOBUC\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	MUDTREK 17IN ATHLETIC FIT UNISEX	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	9	150-to-200	0.00	[empty string]	Mudtrek 17in Athletic Fit Unisex	[empty string]	[empty string]	N	159.99	159.99	5,6,4,13	[empty string]	[empty string]	1000	4844	335848	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	irish-setter/mudtrek-17in-athletic-fit-unisex-335848	1
31	RTEDGE	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Rubber Boots	RTEDGE\|NULL\|NULL	0	169.99	0	169.99	[empty string]	169.99	[empty string]	MUDTREK 17IN ATHLETIC FIT 400G UNISEX	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Mudtrek 17in Athletic Fit 400g Unisex	[empty string]	[empty string]	N	169.99	169.99	13,14,9,12	[empty string]	[empty string]	1000	4846	335849	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	irish-setter/mudtrek-17in-athletic-fit-400g-unisex-335849	1
32	RTEDGE	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Rubber Boots	RTEDGE\|NULL\|NULL	0	179.99	0	179.99	[empty string]	179.99	[empty string]	MUDTREK 17IN FULL FIT UNISEX 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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	15	150-to-200	0.00	[empty string]	Mudtrek 17in Full Fit Unisex 800g	[empty string]	[empty string]	N	179.99	179.99	5,14,13,6,7,8,15	[empty string]	[empty string]	1000	4849	335850	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	irish-setter/mudtrek-17in-full-fit-unisex-800g-335850	1
33	MOBUC	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Rubber Boots	MOBUC\|NULL\|NULL	0	189.99	0	189.99	[empty string]	189.99	[empty string]	MUDTREK FULL FIT 5MM 17IN 1200G	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	16	150-to-200	0.00	[empty string]	Mudtrek Full Fit 5mm 17in 1200g	[empty string]	[empty string]	N	189.99	189.99	4,5,14,7,13	[empty string]	[empty string]	1000	4854	335851	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	irish-setter/mudtrek-full-fit-5mm-17in-1200g-335851	1
34	TIMBER	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Rubber Boots	TIMBER\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	MUDTREK 17IN FULL FIT UNISEX	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]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	13	150-to-200	0.00	[empty string]	Mudtrek 17in Full Fit Unisex	[empty string]	[empty string]	N	159.99	159.99	14,12,13,7,8,15	[empty string]	[empty string]	1000	4856	335852	EMPTY	EMPTY	EMPTY	0	0	0	RUBBER BOOTS	[empty string]	irish-setter/mudtrek-17in-full-fit-unisex-335852	1
35	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	169.99	0	169.99	[empty string]	169.99	[empty string]	M WINGSHOOTER 6IN SAFETY TOE	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]	22	150-to-200	0.00	[empty string]	M Wingshooter 6in Safety Toe	[empty string]	[empty string]	N	169.99	169.99	9.5,8.5,10.5,11,9,12,13,11.5,10	[empty string]	[empty string]	1000	83622	342336	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-wingshooter-6in-safety-toe-342336	1
36	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	[empty string]	0	204.99	0	204.99	[empty string]	204.99	[empty string]	W PINNACLE 800GRAM 10IN	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]	11	200-to-250	0.00	[empty string]	W Pinnacle 800gram 10in	[empty string]	[empty string]	N	204.99	204.99	8,9.5,10,8.5,9,11,7,7.5	[empty string]	[empty string]	1000	2708	349536	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/w-pinnacle-800gram-10in-349536	1
37	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Leisure and Casual	[empty string]	0	134.99	0	134.99	[empty string]	134.99	[empty string]	M SOFT PAW II SOLE	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]	32	100-to-150	0.00	[empty string]	M Soft Paw Ii Sole	[empty string]	[empty string]	N	134.99	134.99	10.5,11.5,11,10,8.5,9,9.5,8,12,13,14	[empty string]	[empty string]	1000	3906	351730	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	irish-setter/m-soft-paw-ii-sole-351730	1
38	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	M KITTSON 6IN STEEL TOE	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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	13	100-to-150	0.00	[empty string]	M Kittson 6in Steel Toe	[empty string]	[empty string]	N	119.99	119.99	9.5,10,11.5,12,13,11,9	[empty string]	[empty string]	1000	83666	351732	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/m-kittson-6in-steel-toe-351732	1
39	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Work Boots	[empty string]	0	114.99	0	114.99	[empty string]	114.99	[empty string]	W KITTSON 6IN STEEL TOE	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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	7	100-to-150	0.00	[empty string]	W Kittson 6in Steel Toe	[empty string]	[empty string]	N	114.99	114.99	6.5,7,7.5,8,8.5,9	[empty string]	[empty string]	1000	83240	351733	EMPTY	EMPTY	EMPTY	0	0	0	WORK BOOTS	[empty string]	irish-setter/w-kittson-6in-steel-toe-351733	1
40	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	[empty string]	0	199.99	0	199.99	[empty string]	199.99	[empty string]	M PINNACLE 9IN 400G WP SCENTBAN	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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	15	150-to-200	0.00	[empty string]	M Pinnacle 9in 400g Wp Scentban	[empty string]	[empty string]	N	199.99	199.99	9.5,11,11.5,13,14,8.5,9,10,10.5	[empty string]	[empty string]	1000	2704	352785	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-pinnacle-9in-400g-wp-scentban-352785	1
41	[empty string]	IRISH SETTER	Irish Setter	FOOTWEAR	Footwear>Hunting Boots	[empty string]	0	214.99	0	214.99	[empty string]	214.99	[empty string]	M PINNACLE 111IN 800G WP SCENTBAN	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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	13	200-to-250	0.00	[empty string]	M Pinnacle 111in 800g Wp Scentban	[empty string]	[empty string]	N	214.99	214.99	9,9.5,10,10.5,11,12,11.5	[empty string]	[empty string]	1000	2710	352786	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	irish-setter/m-pinnacle-111in-800g-wp-scentban-352786	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Categories

Brand

Size

Elk Tracker - Men's

Trailblazer - Waterproof - Leather - 7 `- Men's

Soft Paw - Men's

Wingshooter - Waterproof - 9 Inch - Men's

Wingshooter - Waterproof & Insulated - Leather - 9 `- Men's

Wingshooter - Waterproof - Leather - 7 `- Men's

Wingshooter - Waterproof - Leather - 9 Inch - Men's

Elk Tracker - Waterproof - Leather And Insulated - 12 `- Men's

Borderland - Oxford - Men's

Gunflint Ii - Waterproof And Insulated - 10 `- Men's

Lakeside - Men's

Ravine - Waterproof - Leather - 7 `- Men's

Wingshooter St - Waterproof - Safety Toe - 8 Inch - Men's

Traveler - Men's

Traveler - Men's

Drifter - Men's

Ravine - Waterproof - Leather And Insulated - 9 `- Men's

Wingshooter - Waterproof Leather - 7 `- Women's

Wingshooter - Waterproof - 7 Inch - Men's

Traveler - Chukka - Men's

Traveler - Canvas Slip- On - Men's

Ramsey 2.0 - Pull- On - Waterproof Leather - 11 Inch - Men's

Ramsey 2.0 - Waterproof Leather - Pull- On - 11 `- Men's

Icetrek - Waterproof & Insulated - 12 `- Men's