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]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands	[empty string]	1	59.99	0	59.99	96251-DEFAULT-l.jpg	59.99	96251-DEFAULT-m.jpg	TREE TETHER W/CARIBINER	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	50	50-to-100	0.00	[empty string]	TREE TETHER - 11MM	<p>The Tree Tether is one of the most important pieces of kit in your arsenal. The Tether safely connects you to the tree and enables you to maneuver for a shot.</p> <p> </p> <ul> <li>Includes:</li> <li>8′ rope with one 5″ factory-spliced eye</li> <li>1 ultra lite carabiner</li> <li>Prusik cord</li> </ul> <p> </p> <ul> <li>Strength: 5,000 lbs</li> <li>Size: 1/2" x 8′ double braid</li> <li>Loop: 5" Factory-spliced/sewn</li> <li>Color: Timber Brown/Orange</li> </ul>	[empty string]	N	59.99	59.99	[empty string]	96251-DEFAULT-s.jpg	[empty string]	1000	TT2	347180	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/tree-tether-11mm-347180	1
2	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands	[empty string]	1	64.99	0	64.99	96254-DEFAULT-l.jpg	64.99	96254-DEFAULT-m.jpg	LINEMANS ROPE W/CARIBINERS	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	68	50-to-100	0.00	[empty string]	LINEMAN BELT - 11MM	<p>The Lineman Belt is one of the most important pieces of kit in your arsenal. The Lineman Belt safely connects you to the tree while you climb, to help reduce the risk of a fall.</p> <p> </p> <ul> <li>Includes:</li> <li>8′ rope with one 2″ factory-spliced eye</li> <li>2 ultra lite carabiners</li> <li>Prusik cord</li> </ul> <p> </p> <ul> <li>Strength: 5,000 lbs</li> <li>Size: 1/2" x 8' double braid</li> <li>Loop: 2" Factory-spliced/sewn</li> <li>Color: Foliage Green/Black</li> </ul>	[empty string]	N	64.99	64.99	[empty string]	96254-DEFAULT-s.jpg	[empty string]	1000	LR2	347181	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/lineman-belt-11mm-347181	1
3	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands	[empty string]	1	26.99	0	26.99	96237-DEFAULT-l.jpg	26.99	96237-DEFAULT-m.jpg	HYS STRAP	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	HYS STRAP	<p>The patent pending Tethrd HYS Strap is the ultimate public land legal gear hanger. You can hang it. You can girth hitch it. You can T-Hook it. You can wrap it around a tree trunk. You can wrap it around a branch. Whatever works for you.</p> <p> </p> <p>The HYS Strap is made of high strength, mildew and rot resistant polyester that enables you to hang your stuff in whatever way makes sense to you. Put some stuff around the back side of the tree, some on the left, and some on the right. You can easily move your gear and position it wherever it makes sense for your style of hunting. To attach it, simply girth hitch it with any of the existing loops, or use the included T-hook for a quick connection. If you hunt small trees, cut it to length. You won’t hurt anything.</p> <p> </p> <ul> <li>7′ long can be cut to length for hunter preference</li> <li>Ultra-light at 6 ounces</li> <li>3/4" webbing for ultra-packability</li> <li>1.75" distance between “links”</li> <li>T-Hook included</li> <li>Coyote tan for maximum concealment</li> </ul> <p> </p> <ul> <li>Weight: 3.648 oz</li> <li>Dimensions: 12" x 5.5" x 1.5"</li> </ul>	[empty string]	N	26.99	26.99	[empty string]	96237-DEFAULT-s.jpg	[empty string]	1000	HYSS	347182	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/hys-strap-347182	1
4	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands	[empty string]	1	22.99	0	22.99	96238-DEFAULT-l.jpg	22.99	96238-DEFAULT-m.jpg	SYS HAULER ES-OG	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	SYS HAULER ES OG	<p>The SYS Hauler system is the OG ultralight saddle hunting storage system. With Tethrd's simple, 1 handed quick connect method, your SYS Hauler can ride comfortably on your saddle for every hunt, or get left in the truck when you need to be light and fast. Pick the SYS Hauler that’s right for you and you’ll be able to store all the stuff you need for your saddle hunt.</p> <p> </p> <ul> <li>Minimalist option for saddle hunters. It has the quick-disconnect modular attachment system, and is built with silent worry-free fabrics</li> <li>All the same features as the standard hauler, but adds 2 exterior pockets for quick access</li> <li>Adds to the ES 1.0 with 3 exterior compartments, and multiple interior pockets for organization</li> </ul> <p> </p> <ul> <li>Weight: 5.38 oz</li> <li>Color: Olive Green, Coyote Brown</li> </ul>	[empty string]	N	22.99	22.99	[empty string]	96238-DEFAULT-s.jpg	[empty string]	1000	SYSHOG	347186	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/sys-hauler-es-og-347186	1
5	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands	[empty string]	1	16.99	0	16.99	96240-DEFAULT-l.jpg	16.99	96240-DEFAULT-m.jpg	SYS HAULER	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	17	15-to-20	0.00	[empty string]	SYS HAULER	<p>The SYS Hauler system is the OG ultralight saddle hunting storage system. With Tethrd's simple, 1 handed quick connect method, your SYS Hauler can ride comfortably on your saddle for every hunt, or get left in the truck when you need to be light and fast. Pick the SYS Hauler that’s right for you and you’ll be able to store all the stuff you need for your saddle hunt.</p> <p> </p> <ul> <li>Minimalist option for saddle hunters. It has the quick-disconnect modular attachment system, and is built with silent worry-free fabrics</li> <li>All the same features as the standard hauler, but adds 2 exterior pockets for quick access</li> <li>Adds to the ES 1.0 with 3 exterior compartments, and multiple interior pockets for organization</li> </ul> <p> </p> <ul> <li>Weight: 5.38 oz</li> <li>Color: Olive Green, Coyote Brown</li> </ul>	[empty string]	N	16.99	16.99	[empty string]	96240-DEFAULT-s.jpg	[empty string]	1000	SYSH	347187	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/sys-hauler-347187	1
6	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands	[empty string]	1	32.99	0	32.99	96242-DEFAULT-l.jpg	32.99	96242-DEFAULT-m.jpg	RECLINER BACK SUPPORT	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	RECLINER	<p>The Recliner is a perfect accessory for saddle hunting comfort. The great thing about the Recliner is that it provides incredible comfort without being heavy or bulky. Tethrd designed the Recliner to fit easily into the SYS Hauler so you can carry it with you on every single hunt. Plus, with the redesigned hook-up method, all you have to do is clip into your carabiner…easy-peasy. It only weighs 4 ounces and packs up to the size of a tennis ball. There’s no downsides to this thing.</p> <p> </p> <ul> <li>Weight: 3.94 oz</li> <li>Dimensions: 12" x 5.75" x 1"</li> </ul>	[empty string]	N	32.99	32.99	[empty string]	96242-DEFAULT-s.jpg	[empty string]	1000	RCL	347188	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/recliner-347188	1
7	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands	[empty string]	1	69.99	0	69.99	96243-DEFAULT-l.jpg	69.99	96243-DEFAULT-m.jpg	KNEE PADS	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	KNEE PADS	<p>The Tethrd Knee Pads are the new standard in saddle hunting knee protection. Whether you’re a new saddle hunter, or an OG, the knee pad can make or break your hunt. We took the best pads on the market, doubled the padding, added grippiness, and made them more hunter friendly.</p> <p> </p> <ul> <li>Designed with a double dose of comfortable closed-cell foam padding</li> <li>Cushion and strength exactly where you need them</li> <li>Engineered a raised honeycomb gripping surface to provide more bite and leverage during your hunt</li> <li>One-of-a-kind camo process ensuring every single one is uniquely camouflaged</li> <li>Stretch straps allow you to put them on at the truck and walk to your tree</li> <li>Light and small enough to pack in if you don’t like wearing knee pads while walking</li> </ul> <p> </p> <ul> <li>Weight: 11 oz total weight (pair)</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	96243-DEFAULT-s.jpg	[empty string]	1000	KP1	347254	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/knee-pads-347254	1
8	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands>Safety Harnesses	[empty string]	1	399.99	0	399.99	96247-DEFAULT-l.jpg	399.99	96247-DEFAULT-m.jpg	PHANTOM SADDLE KIT 11MM ROPES AND BINERS	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	350-to-400	0.00	[empty string]	PHANTOM STARTER KIT	<p>The Phantom Starter Kit includes the Phantom saddle, Tether and Lineman belt. This is everything you need to get hunting. The Predator platform is not essential if you already have some sort of platform to rest your feet on at hunting height. This could be a ring of strap on steps, screw in steps, or DIY solution. The Phantom is 100% Made In the USA.</p> <p> </p> <ul> <li>Weight: 40 oz</li> </ul>	[empty string]	N	399.99	399.99	[empty string]	96247-DEFAULT-s.jpg	[empty string]	1000	PSK	364600	SAFETY HARNESSES	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/phantom-starter-kit-364600	1
9	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands>Safety Harnesses	[empty string]	1	419.99	0	419.99	96250-DEFAULT-l.jpg	419.99	96250-DEFAULT-m.jpg	PHANTOM SADDLE XL KIT 11MM ROPES AND BINERS	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	30	400-to-450	0.00	[empty string]	PHANTOM STARTER KIT - 11MM - XL	<p>The Phantom Starter Kit includes the XL Phantom saddle, Tether and Lineman belt. It's not only does it work for big guys (or gals) with a 38+ inch waist, but it's unquestionably most comfortable & technologically advanced. The Predator platform is not essential if you already have some sort of platform to rest your feet on at hunting height. This could be a ring of strap on steps, screw in steps, or DIY solution. The Phantom is 100% Made In the USA.</p> <p> </p> <ul> <li>Weight: 40 oz</li> </ul>	[empty string]	N	419.99	419.99	XL	96250-DEFAULT-s.jpg	[empty string]	1000	PSK-XL	364601	SAFETY HARNESSES	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/phantom-starter-kit-11mm-xl-364601	1
10	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands>Stands	[empty string]	1	179.99	0	179.99	96228-DEFAULT-l.jpg	179.99	96228-DEFAULT-m.jpg	PREDATOR PLATFORM	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	PREDATOR PLATFORM	<p>The Predator Platform allows hunters to shoot 360 degrees around the tree and remain comfortable all day long. The Predator can be installed on nearly any tree that will hold your weight. It gives the saddle hunter an extreme advantage when it comes to versatility and bulk reduction. The Predator is the original ultralight saddle hunting platform. It’s the standard against which all other saddle hunting platforms are measured. Weighing only 3 lbs, and packing flat for transport, it’s the lightest, least bulky, full-featured saddle hunting platform ever designed.</p> <p> </p> <ul> <li>Die-cast aluminum construction for superior strength and minimal noise.</li> <li>Rock solid, yet whisper quiet installation with our ZipCam strap and button.</li> <li>Easy adjustment for leaning trees or foot positions with adjustable platform leveling.</li> <li>Patented Traction Tread & Toe Wings for easy maneuverability and side pressure.</li> </ul> <p> </p> <ul> <li>Weight: 3 lbs</li> <li>Rating: 300 lbs</li> </ul>	[empty string]	N	179.99	179.99	[empty string]	96228-DEFAULT-s.jpg	[empty string]	1000	PRED	364602	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/predator-platform-364602	1
11	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands>Stands	[empty string]	1	199.99	0	199.99	96230-DEFAULT-l.jpg	199.99	96230-DEFAULT-m.jpg	PREDATOR XL PLATFORM	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	150-to-200	0.00	[empty string]	PREDATOR PLATFORM - XL	<p>The Predator XL allows hunters to shoot 360 degrees around the tree and remain comfortable all day long. The Predator XL can be installed on nearly any tree that will hold your weight. It gives the saddle hunter an extreme advantage when it comes to versatility and bulk reduction. The Predator Platform is the original ultralight saddle hunting platform. It’s the standard against which all other saddle hunting platforms are measured. The Predator XL adds to the OG Predator’s legacy by adding more real estate for saddle hunters that want it.</p> <p> </p> <ul> <li>40% larger than original Predator Platform</li> <li>Improved side and top traction</li> <li>Upgraded leveling bolt</li> <li>Cast aluminum construction for superior strength and minimal noise</li> <li>Rock solid, yet whisper quiet installation with our ZipCam strap and button</li> <li>Easy adjustment for leaning trees or foot positions with adjustable platform leveling</li> </ul> <p> </p> <ul> <li>Weight: 4 lbs</li> <li>Rating: 300 lbs</li> </ul>	[empty string]	N	199.99	199.99	XL	96230-DEFAULT-s.jpg	[empty string]	1000	PRED-XL	364603	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/predator-platform-xl-364603	1
12	[empty string]	TETHRD NATION	Tethrd Nation	HUNTING	Hunting>Treestands>Steps	[empty string]	1	239.99	0	239.99	96245-DEFAULT-l.jpg	239.99	96245-DEFAULT-m.jpg	SKELETORS 4 PACK CLIMBING STICKS	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	29	200-to-250	0.00	[empty string]	SKELETORS	<p>The Skeletors are built with a folding dual step design that folds away from the tree. Folding away from the tree gives the hunter more room for their feet when climbing. The Skeletors attach to the tree with Tethrd's patented DynaLite rope and tab. It’s the most user friendly, lightweight, simple, and fast connection method in history. There are no heavy buckles. There are no mechanical pieces. There is no fiddle factor. Stacking your Skeletors for transport is a breeze with Tethrd's built in StickLoc pin system. Simply align the pins and stack away. Also, the patent-pending RCS (Rope Containment System) manages your DynaLite ropes quickly and easily with a Roll-Tide-Simple RCS.</p> <p> </p> <ul> <li>Total Length (packed): 24"</li> <li>Total Length (deployed): 20"</li> <li>Total Length (4-pack): 27"</li> <li>Step-to-Step height: 18"</li> <li>Total Weight: (single): 2 lbs</li> <li>Total Weight: (4 pack): 8 lbs</li> <li>Dynalight Rope: 8.5'</li> <li>Weight Limit: 300 lb</li> </ul>	[empty string]	N	239.99	239.99	[empty string]	96245-DEFAULT-s.jpg	[empty string]	1000	SKELETORS	364604	STEPS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	tethrd-nation/skeletors-364604	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter