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]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	19.99	0	19.99	95899-DEFAULT-l.jpg	19.99	95899-DEFAULT-m.jpg	CLASSIC DUMP POUCH	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	15-to-20	0.00	[empty string]	CLASSIC DUMP POUCH	<p>Sized slightly smaller than Latitude's Method Dump Pouch, the Classic Dump Pouch was purpose built for the minimalist saddle hunter. Designed for those who need just enough storage space to bring the essentials, an extra wide opening and a robust mesh construction make adding and removing gear very easy. Sized to fit two 8mm ropes.</p> <p> </p> <ul> <li>Compact Size</li> <li>Easy Access</li> <li>Heavy Duty Construction</li> </ul> <p> </p> <ul> <li>Weight: 3 oz</li> <li>Dimensions: 8" tall x 7" wide</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	95899-DEFAULT-s.jpg	[empty string]	1000	CDP	339777	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/classic-dump-pouch-339777	1
2	ROPEBELT	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	ROPEBELT\|NULL\|NULL	1	289.99	0	289.99	95901-DEFAULT-l.jpg	289.99	95901-DEFAULT-m.jpg	METHOD 2 SADDLE REG	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	18	250-to-300	0.00	[empty string]	THE METHOD 2	<p>Latitude's two-panel saddle technology is more efficient, streamline, and comfortable than ever before. Inspired by the need to eliminate the choice between streamline or comfortable saddle options, the Method 2 saddle is ultra-compact while navigating the timber, yet more supportive in the tree than traditional designs. The Method 2 adapts to your personal hunting style from the moment you step out of your vehicle, minimizing bulk when you need to move fast and optimizing comfort during an all-day sit....because both are necessary for consistent year over year success.</p> <p> </p> <ul> <li>Two Panel?Flexibility</li> <li>Dynamic Weight Distribution</li> <li>Quick Connect Panel System</li> <li>Metal Free Construction</li> <li>Free Floating Belt</li> <li>Fade Loops</li> <li>Contoured Vertical Support?Skeleton?(VSS)</li> <li>Removable Leg Straps</li> <li>Adjustable Bridge</li> </ul> <p> </p> <ul> <li>Saddle: 28 oz</li> <li>Leg Straps: 3 oz</li> <li>Weight Rating: 300 lbs?</li> <li>Up to 37" waist</li> </ul>	[empty string]	N	289.99	289.99	[empty string]	95901-DEFAULT-s.jpg	[empty string]	1000	M2S	354294	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/the-method-2-354294	1
3	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	229.99	0	229.99	92986-DEFAULT-l.jpg	229.99	92986-DEFAULT-m.jpg	CLASSIC 2 SADDLE	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	22	200-to-250	0.00	[empty string]	THE CLASSIC 2	<p>The Classic 2 is a great third party tested, metal free single panel saddle. Premium features and industry leading weight displacement technology in an ultra-light, metal-free, 20oz package, create a radically comfortable fit and feel. The Classic 2 is streamline, comfortable, and easy to operate. It's so good at what it does, you are likely to forget you're even wearing it. </p> <p> </p> <ul> <li>Metal Free</li> <li>Free Floating Belt</li> <li>Vertical Support Skeleton (VSS)</li> <li>Optimized Fit</li> <li>Adjustable Amsteel Bridge</li> <li>Removable Leg Straps</li> </ul> <p> </p> <ul> <li>Saddle: 20 oz</li> <li>Leg Straps: 3 oz</li> <li>Weight Rating: 300 lbs</li> <li>One size fits most</li> </ul>	[empty string]	N	229.99	229.99	[empty string]	92986-DEFAULT-s.jpg	[empty string]	1000	C2S	354295	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/the-classic-2-354295	1
4	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	29.99	0	29.99	95903-DEFAULT-l.jpg	29.99	95903-DEFAULT-m.jpg	GEAR STRAP/ GEAR HANGER	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	19	25-to-50	0.00	[empty string]	GEAR STRAP	<p>At only 3 oz, the Gear Strap packs into a tiny package, but organizes all of your necessities in the tree. It comes with 5 removable loops so you can customize your strap and reduce bulk by eliminating unused material. A dedicated backpack attachment provides single-handed adjustability so you can change the height of your pack on the fly and Latitude's gated G-hook ensures the strap and your valuable gear are securely fastened to the tree.</p> <p> </p> <ul> <li>Customizable</li> <li>Adjustable Loops</li> <li>Dedicated Backpack Hanger</li> <li>Secure Attachment</li> </ul> <p> </p> <ul> <li>Total Weight: 3 oz (even lighter if you do not run all 5 loops)</li> <li>Strap Length: 6.5'</li> <li>Movable loops rated for 1500 lbs</li> <li>Back pack adjuster rated for up to 200 lbs</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	95903-DEFAULT-s.jpg	[empty string]	1000	GS	354296	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/gear-strap-354296	1
5	ROPEBELT	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	ROPEBELT\|NULL\|NULL	1	289.99	0	289.99	95902-DEFAULT-l.jpg	289.99	95902-DEFAULT-m.jpg	METHOD 2 SADDLE XL	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	30	250-to-300	0.00	[empty string]	THE METHOD 2 - XL	<p>The Method 2 XL saddle renders Latitude's industry leading two-panel saddle technology more efficient, streamline, and comfortable than ever before. Inspired by the need to eliminate the choice between streamline or comfortable saddle options, the Method 2 saddle is ultra-compact while navigating the timber, yet more supportive in the tree than traditional designs. The Method 2 adapts to your personal hunting style from the moment you step out of your vehicle, minimizing bulk when you need to move fast and optimizing comfort during an all-day sit....because both are necessary for consistent year over year success.</p> <p> </p> <ul> <li>Two Panel Flexibility</li> <li>Dynamic Weight Distribution</li> <li>Quick Connect Panel System</li> <li>Metal Free Construction</li> <li>Free Floating Belt</li> <li>Fade Loops</li> <li>Contoured Vertical Support?Skeleton?(VSS)</li> <li>Removable Leg Straps</li> <li>Adjustable Bridge</li> </ul> <p> </p> <ul> <li>Saddle: 30 oz</li> <li>Leg Straps: 3 oz</li> <li>Weight Rating: 300 lbs?</li> <li>Waist sizes: 37" and up</li> </ul>	[empty string]	N	289.99	289.99	XL	95902-DEFAULT-s.jpg	[empty string]	1000	M2SXL	355175	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/the-method-2-xl-355175	1
6	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	29.99	0	29.99	95904-DEFAULT-l.jpg	29.99	95904-DEFAULT-m.jpg	BACK BAND FOR LATITUDE SADDLE	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	33	25-to-50	0.00	[empty string]	BACK BAND	<p>The Back Band is contoured to fit the body's natural shape, clips into your carabiner in a snap, and easily adjusts to find the extra support you need where you need it. Compatible with all saddles, this a must have item if you prefer a single-panel style saddle system or if you want to take a pre-dawn nap in your two-panel saddle. </p> <p> </p> <ul> <li>Weight: 3 oz</li> <li>Sizing: For shirt sizes Small through XL</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	95904-DEFAULT-s.jpg	[empty string]	1000	BB	358481	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/back-band-358481	1
7	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	69.99	0	69.99	95905-DEFAULT-l.jpg	69.99	95905-DEFAULT-m.jpg	METHOD 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]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	34	50-to-100	0.00	[empty string]	METHOD KNEE PADS	<p>The Method Knee Pads were designed to perform whether your feet are on the ground or in a tree.</p> <p> </p> <ul> <li>Vibram grip cap provides 360-degree, silent traction in wet or dry conditions for ninja-like maneuvers and accurate shots.</li> <li>Extra thick, recovery foam won't bottom out and keeps knees comfortable all day in the tree.</li> <li>Jointed, ergonomic design will not loosen or fall down while hiking but also packs very small if you prefer to carry your knee pads in.</li> <li>Metal free and velcro free construction eliminates the potential for noise and military grade components ensure you can focus on the hunt.</li> </ul> <p> </p> <ul> <li>Weight: 13 oz per pair </li> </ul>	[empty string]	N	69.99	69.99	[empty string]	95905-DEFAULT-s.jpg	[empty string]	1000	MKP	358482	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/method-knee-pads-358482	1
8	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	14.99	0	14.99	95908-DEFAULT-l.jpg	14.99	95908-DEFAULT-m.jpg	TWO PANEL STRAPS	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	11	10-to-15	0.00	[empty string]	TWO-PANEL STRAPS	<p>If you prefer a two-panel saddle once in the tree but want to lock in the distance between panels, Latitude now have you covered. Dedicated attachment points on the lower panel of the Method 2 integrate with our Two-Panel Straps to provide a "set it and forget it" distance between panels. If you are using a 1-stick method to climb the tree, this is an important accessory to add to your system. Compatible with both the Method and Method 2 saddles.</p> <p> </p> <ul> <li>Weight: 3 oz per pair</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	95908-DEFAULT-s.jpg	[empty string]	1000	TPS	358483	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/two-panel-straps-358483	1
9	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	9.99	0	9.99	95909-DEFAULT-l.jpg	9.99	95909-DEFAULT-m.jpg	G-HOOKSS FOR LATITUDE SADDLE 2PACK	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	27	5-to-10	0.00	[empty string]	G-HOOKS - 2 PACK	<p>Two-pack of the upgraded, custom designed G-Hooks used on the leg straps of Latitude's Method 2, Method 2 XL, and Classic 2 saddles. Their worry free design will not come unhooked when you least expect it, yet they are extremely easy to remove. They are a great option to upgrade existing leg straps or for a multitude of DIY projects.</p>	[empty string]	N	9.99	9.99	[empty string]	95909-DEFAULT-s.jpg	[empty string]	1000	GH2P	358484	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/g-hooks-2-pack-358484	1
10	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	69.99	0	69.99	95910-DEFAULT-l.jpg	69.99	95910-DEFAULT-m.jpg	VAPOR LINE SADDLE TETHER 1 BINER	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	43	50-to-100	0.00	[empty string]	VAPOR LINE - 8MM TETHER	<p>Designed to deliver maximum strength, durability, and water resistance in the most compact package, the Vapor Line 8mm Tether packs incredibly small, includes a premium carabiner, and is rigged for single-handed operation out of the package so you can minimize bulk without sacrificing safety. Vapor Line 8mm ropes feature a core built from a proprietary blend of Ultra High Molecular Weight Polyethylene (commonly referred to as Amsteel) that is pound-for-pound stronger than steel and impervious to water absorption and floats. The exterior is constructed of a tightly woven, high-tenacity, 100% polyester sheath, providing both high UV and abrasion resistance and naturally hydrophobic characteristics.</p> <p> </p> <ul> <li>Length: 8.5'</li> <li>Loop Size: 6"</li> <li>Diameter: 8 mm</li> <li>MBS Rating: 5672 lbs</li> <li>Weight: 2.8 lbs/100'</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	95910-DEFAULT-s.jpg	[empty string]	1000	VST	361223	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/vapor-line-8mm-tether-361223	1
11	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	79.99	0	79.99	95911-DEFAULT-l.jpg	79.99	95911-DEFAULT-m.jpg	VAPOR LINEMAN`S ROPE BELT 2 BINER	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	48	50-to-100	0.00	[empty string]	VAPOR LINE - 8MM LINEMAN BELT	<p>Designed to deliver maximum strength, durability, and water resistance in the most compact package, the Vapor Line 8mm Lineman packs incredibly small, includes 2 premium carabiners, and is rigged for single-handed operation out of the package so you can minimize bulk without sacrificing safety. Vapor Line 8mm ropes feature a core built from a proprietary blend of Ultra High Molecular Weight Polyethylene (commonly referred to as Amsteel) that is pound-for-pound stronger than steel and impervious to water absorption and floats. The exterior is constructed of a tightly woven, high-tenacity, 100% polyester sheath, providing both high UV and abrasion resistance and naturally hydrophobic characteristics.</p> <p> </p> <ul> <li>Length: 8.5'</li> <li>Loop Size: 6"</li> <li>Diameter: 8 mm</li> <li>MBS Rating: 5672 lbs</li> <li>Weight: 2.8 lbs/100ft</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	95911-DEFAULT-s.jpg	[empty string]	1000	VLR	361224	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/vapor-line-8mm-lineman-belt-361224	1
12	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	24.99	0	24.99	95900-DEFAULT-l.jpg	24.99	95900-DEFAULT-m.jpg	METHOD XL DUMP POUCH	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]	28	20-to-25	0.00	[empty string]	THE METHOD DUMP POUCH	<p>Latitude got tired of using dump pouches that were either loud, flimsy in construction, too small, or have pocket options that just aren't practical for navigating the woods in the dark. The result was their own unique rendition on the traditional saddle hunting dump pouch. This pouch is big enough to fit a 40', 8-9mm rappel rope no problem.</p> <p> </p> <ul> <li>Larger Size</li> <li>Zippered Pocket</li> <li>Heavy Duty Construction</li> <li>D-Ring</li> </ul> <p> </p> <ul> <li>Weight: 3.5 oz </li> <li>Dimensions: 12" tall x 7" wide</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	95900-DEFAULT-s.jpg	[empty string]	1000	MDP	363172	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/the-method-dump-pouch-363172	1
13	[empty string]	LATTITUDE OUTDOORS	LATTITUDE OUTDOORS	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	14.99	0	14.99	95912-DEFAULT-l.jpg	14.99	95912-DEFAULT-m.jpg	WEBBING DAISEY CHAIN	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]	24	10-to-15	0.00	[empty string]	WEBBING DAISY CHAIN	<p>Webbing Daisy Chains have quickly become the preferred replacement for bulky, metal, cam buckle straps on sticks and platforms. They are a light weight, compact, and simple-to-use attachment method that packs up and deploys quietly. The woven construction using an Ultra High Molecular Weight Polyethylene webbing (same material as Amsteel) on these 8' daisy chains is ~50% stronger than most cam straps but only weighs 1oz. The 2.5" wide loops are compatible with any climbing stick or saddle platform that uses a versa button-style attachment point. </p> <p> </p> <p>Compatible with the following Sticks and Platforms: Hunting Beast, Lone Wolf Custom Gear, Shikar, Tethrd One, Tethrd Skeletor, Tethrd Predator, Hawk Helium, Novix, Trophyline, and more.</p> <p> </p> <ul> <li>Weight: 1.12 oz per strap</li> <li>Length: 8'</li> <li>Average Breaking Strength: 1500 lbs</li> <li>Width of Webbing: 3/4" </li> </ul>	[empty string]	N	14.99	14.99	[empty string]	95912-DEFAULT-s.jpg	[empty string]	1000	WDC	365205	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	lattitude-outdoors/webbing-daisy-chain-365205	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter