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]	CRISPI	Crispi	FOOTWEAR	Footwear>Hunting Boots	[empty string]	1	374.99	0	374.99	108916-DEFAULT-l.jpg	374.99	108916-DEFAULT-m.jpg	M COLORADO II GTX	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NO CART WITH PRICE	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	11	350-to-400	0.00	[empty string]	COLORADO II GTX - MEN'S - OLIVE/GREY	<p>Named after the state where success is typically found in the high country around 13,000 feet, the Crispi Colorado II GTX is built to get you there, help you succeed, and get you home with a heavy pack. The Colorado II breathes extremely well, thanks to high performance PUtek and suede materials. PUtek is a nylon base material woven with threads of polyurethane. This allows the boot to stay lightweight and breathable while increasing durability and puncture resistance of the boot. It is lined with Gore-Tex full surround bootie to ensure maximum waterproof and breathable performance. With steep technical terrain in mind the Colorado II GTX utilizes the Crispi Ankle Bone Support System (ABSS) to provide optimum ankle support for side hilling and when carrying a heavy pack.  A full surround polyurethane coated leather rand is triple stitched around the base of the boot to protect the foot from abrasion and sharp stones often found in technical mountain terrain. Like many of the crispi hunting boots, the Colorado II GTX is supported by a dual density polyurethane Vibram midsole to provide increased comfort, exceptional stability and long lasting impact absorption which are key for those times when coming out of the mountains with a heavy pack is on the menu. The Vibram sole features a tread pattern and sole compound ideal for technical and rugged terrain to keep you secure and stable as you move through the nastiest of conditions.</p> <p> </p> <p> </p> <ul> <li>Gore-Tex Performance Comfort Footwear Lining</li> <li>Vibram sole with dual-density polyurethane shock absorbing midsole</li> <li>4 Flex Rating</li> <li>ABSS Ankle Support System</li> <li>Board Lasting Mechanical Construction</li> <li>Insulated: No</li> <li>Upper: Water Repellant Suede. High resistant, breathable PUtek Fabric</li> <li>Removable Footbed: CRISPI Air Mesh. Outstanding Breathability and antiperspiration / anti-odour action.</li> <li>Protection: Kevlar Triple-stitching, polyurethane coated leather rand</li> </ul> <p> </p> <ul> <li>Height: 8"</li> <li>Weight (one boot, size 10): 1.6 lbs</li> </ul>	[empty string]	N	374.99	374.99	10,10.5,11.5,12,13,11,9	108916-DEFAULT-s.jpg	[empty string]	1000	2695-2860	389639	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	crispi/colorado-ii-gtx-men-s-olive-grey-389639	1
2	NUTRIA	CRISPI	Crispi	FOOTWEAR	Footwear>Leisure and Casual	NUTRIA\|NULL\|NULL	1	244.99	0	244.99	108920-DEFAULT-l.jpg	244.99	108920-DEFAULT-m.jpg	M MONACO GTX	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NO CART WITH PRICE	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	8	200-to-250	0.00	[empty string]	MONACO GTX - MEN'S - NUTRIA	<p dir="ltr">The Monaco GTX offers unmatched comfort, ideal for those who are on their feet all day. This mid-cut shoe is well suited for light hikes and city walks. The Monaco GTX upper is constructed with high-quality, water-repellent Nubuk leather and offers a tough, stitched-on rand, providing protection against abrasions. With Crispi’s Vibram soles, shock-absorbing inserts and Gore-Tex® Performance Lining, you can rest assured that your feet will stay dry and comfortable day in and day out.</p> <p dir="ltr"> </p> <ul dir="ltr"> <li>Gore-Tex Performance Comfort Footwear Lining</li> <li>Vibram Sole with Super-Grip Compound and EVA midsole</li> <li>2 Flex Rating</li> <li>Board Lasting Mechanical Construction</li> <li>Insulated: No</li> <li>Upper: Water repellent nubuck leather</li> <li>Removable Footbed: CRISPI Air Mesh. Outstanding Breathability and antiperspiration / anti-odour action</li> <li>Protection: Triple-stitched, polyurethane coated leather rand</li> </ul> <p> </p> <ul dir="ltr"> <li>Height: 6"</li> <li>Weight (one boot, size 10): 1.1 lbs</li> </ul>	[empty string]	N	244.99	244.99	11,11.5,12,10,10.5	108920-DEFAULT-s.jpg	[empty string]	1000	5600-2300	389641	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	crispi/monaco-gtx-men-s-nutria-389641	1
3	GREY	CRISPI	Crispi	FOOTWEAR	Footwear>Hunting Boots	GREY\|NULL\|NULL	1	419.99	0	419.99	108915-DEFAULT-l.jpg	419.99	108915-DEFAULT-m.jpg	M BRIKSDAL MTN GTX	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NO CART WITH PRICE	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	8	400-to-450	0.00	[empty string]	BRIKSDAL MTN GTX - MEN'S - GREY/BLACK	<p>The Briksdal MTN GTX is a lightweight, full synthetic mountain boot with all the structure and support of a full leather boot. The upper is built using brushed microfiber synthetic combined with high-performance and rugged PUtek fabric to provide structure, breathability, and abrasion resistance. A GORE-Tex full-surround lining ensures your feet stay completely dry while maintaining breathability to handle a wide variety of temperatures and terrains. The asymmetrical lacing system increases the ability to customize the fit of the boot. Using the Crispi exclusive EFX midsole and a VIBRAM Megagrip outsole, along with their most versatile 3-flex board last the Briksdal MTN GTX boot comfortably supports your feet and lower legs for those long, heavy pack-outs we all hope for.</p> <p> </p> <ul> <li>Gore-Tex Comfort Footwear Lining</li> <li>Vibram sole with polyurethane shock-absorbing EFX midsole</li> <li>3 Flex Rating</li> <li>ABSS Ankle Support System</li> <li>Board Lasting Mechanical Construction</li> <li>Insulated: No Insulation</li> <li>Upper: Microfiber Synthetic with a brushed finish. PUtek Spider Fabric</li> <li>Protection: Full Rubber Rand</li> <li>Tongue: Strech nylon material for added comfort</li> </ul> <p> </p> <ul> <li>Height: 9"</li> <li>Weight (one boot, size 10): 1.7 lbs</li> </ul>	[empty string]	N	419.99	419.99	10,11,11.5,12,13,9.5	108915-DEFAULT-s.jpg	[empty string]	1000	2284-6007	389646	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	crispi/briksdal-mtn-gtx-men-s-grey-black-389646	1
4	[empty string]	CRISPI	Crispi	FOOTWEAR	Footwear>Hunting Boots	[empty string]	1	439.99	0	439.99	108923-DEFAULT-l.jpg	439.99	108923-DEFAULT-m.jpg	M NEVADA LEGEND GTX 200G	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NO CART WITH PRICE	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	11	400-to-450	0.00	[empty string]	NEVADA LEGEND GTX - 200 G - MEN'S - BROWN	<p>The story of the Nevada GTX goes back over 40 years ago when Alessandro Marcolin started hand-constructing Crispi boots. The Nevada has been a staple in Crispi’s lineup ever since. Add the latest cutting-edge technology in footwear with the handcrafted precision and comfort they are known for and you get the hands-down best hunting boot on the planet. With 200 grams of Gore-Tex insulation and a waterproof membrane, there is nowhere this boot cannot take you. No wonder why the Nevada has withstood the test of time and continues to conquer every mountain it faces.</p> <p> </p> <ul> <li>Gore-Tex Insulated Comfort Footwear Lining</li> <li>Vibram sole with polyurethane shock absorbing CCF midsole</li> <li>3 Flex Rating</li> <li>ABSS Ankle Support System</li> <li>Board Lasting Mechanical Construction</li> <li>Crispi Crossbow Frame</li> <li>Dual Tech Lining</li> <li>Insulated: Yes - Gore (~200 g)</li> <li>Upper: Water-repellent Nubuk</li> <li>Removable Footbed: CRISPI Air Mesh. Outstanding Breathability and antiperspiration / anti-odour action.</li> <li>Protection: Rubber rand</li> </ul> <p> </p> <ul> <li>Height: 8"</li> <li>Weight (one boot, size 10): 1.9 lbs</li> </ul>	[empty string]	N	439.99	439.99	10.5,11.5,12,13,11,9,9.5	108923-DEFAULT-s.jpg	[empty string]	1000	5845-4203	389653	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	crispi/nevada-legend-gtx-200-g-men-s-brown-389653	1
5	[empty string]	CRISPI	Crispi	FOOTWEAR	Footwear>Hunting Boots	[empty string]	1	489.99	0	489.99	108918-DEFAULT-l.jpg	489.99	108918-DEFAULT-m.jpg	M GUIDE GTX 10IN 200G	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NO CART WITH PRICE	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	14	450-to-500	0.00	[empty string]	GUIDE GTX - MEN'S - BROWN	<p>When you think about mountain hunting, think of the Guide GTX on your feet. With all the same features and technologies as its little brother, the Nevada, this boot takes it up a notch with an extra 2” of ankle support. No more needing to worry about busted up ankles during long, heavy packouts. The Guide GTX has got you (and your ankles) covered.</p> <p> </p> <ul> <li>Gore-Tex Insulated Comfort Footwear Lining</li> <li>Vibram sole with polyurethane shock absorbing CCF midsole</li> <li>3 Flex Rating</li> <li>ABSS Ankle Support System</li> <li>Board Lasting Mechanical Construction</li> <li>Crispi Crossbow Frame</li> <li>Insulated: Yes - Gore (~200 g)</li> <li>Upper: Water-repellent Nubuk</li> <li>Removable Footbed: CRISPI Air Mesh. Outstanding Breathability and antiperspiration / anti-odour action</li> <li>Protection: Rubber rand</li> </ul> <p> </p> <ul> <li>Height: 10"</li> <li>Weight (one boot, size 10): 2.1 lbs</li> </ul>	[empty string]	N	489.99	489.99	10,10.5,11,11.5,12,13,9,9.5	108918-DEFAULT-s.jpg	[empty string]	1000	4200-4203	389654	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	crispi/guide-gtx-men-s-brown-389654	1
6	BROWN	CRISPI	Crispi	FOOTWEAR	Footwear>Hunting Boots	BROWN\|NULL\|NULL	1	354.99	0	354.99	108913-DEFAULT-l.jpg	354.99	108913-DEFAULT-m.jpg	M ALTITUDE GTX	N	5 EMILY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NO CART WITH PRICE	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2023	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	5	350-to-400	0.00	[empty string]	ALTITUDE GTX - MEN'S - BROWN	<p>The Crispi Altitude GTX was conceived and built with a desire for the breathability and technical fit found in models like the Attiva Mid, combined with the foundation and long lasting comfort of the EFX dual density polyurethane midsole that hunters rely upon when long miles and the occasional heavy load is expected. With a constant and even flexing board last construction (Flex 2.5 rating) and their exclusive Vibram Megagrip outsole, makes traversing variable terrain a breeze. They've added features like the ultra soft leather and synthetic upper, the Crispi Thermo Wire Technology, and a full PU coated leather rand to ensure the Altitude GTX will endure well whatever hunt or adventure you embark upon. The Altitude GTX is a new kind of hunting boot ready to provide all day comfort, optimal performance, and ground feel that traditional boots haven’t been able to deliver.</p> <p> </p> <ul> <li>Gore-Tex waterproof lining</li> <li>Vibram Megagrip outsole with EFX dual-density polyurethane shock-absorbing midsole</li> <li>2.5 Flex Rating</li> <li>Board Lasting Mechanical Construction</li> <li>Crispi Crossbow Frame</li> <li>Insulated: No</li> <li>Upper: Greased water-repellent Nubuk, breathable synthetic</li> <li>Footbed: Removeable CRISPI Air Mesh insole</li> <li>Protection: Double stitched PU (polyurethane) coated leather full rand</li> </ul> <p> </p> <ul> <li>Height: 8"</li> <li>Weight (one boot, size 10): 1.45 lbs</li> </ul>	[empty string]	N	354.99	354.99	10,10.5,11,11.5,12	108913-DEFAULT-s.jpg	[empty string]	1000	1425-4300	389965	EMPTY	EMPTY	EMPTY	0	0	0	HUNTING BOOTS	[empty string]	crispi/altitude-gtx-men-s-brown-389965	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

10
10.5
11
11.5
12
13
9
9.5

Filter