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]	XOP	Xop	HUNTING	Hunting>Treestands>Stands	[empty string]	1	29.99	0	29.99	96773-DEFAULT-l.jpg	29.99	96773-DEFAULT-m.jpg	QUICK CONNECT BRACKET	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	OFFSET QUICK CONNECT BRACKET	<p>XOP's Offset Quick Connect Bracket features a unique design with various slots at different degrees of angles to accommodate for crooked trees. This product is constructed with cast aluminum and is compatible with any XOP tree stand, simply remove the 6-point bracket prior to use. Not only does the Offset Quick Connect offer an effortless hanging experience it gives you the ability to have various stand locations ready to hunt with only one hang-on!</p>	[empty string]	N	29.99	29.99	[empty string]	96773-DEFAULT-s.jpg	[empty string]	1000	XOP-ADJQC	251916	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/offset-quick-connect-bracket-251916	1
2	[empty string]	XOP	Xop	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	QUICK CONNECT BRACKET 3 PACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	2	50-to-100	0.00	[empty string]	Quick Connect Bracket 3 Pack	[empty string]	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	XOP-ADJQC3	343108	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/quick-connect-bracket-3-pack-343108	1
3	[empty string]	XOP	Xop	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	CLIMBING STICK CARRIER KIT 5 PIECE	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	23	10-to-15	0.00	[empty string]	Climbing Stick Carrier Kit 5 Piece	[empty string]	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	XOP-STKBRK-SET	343386	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/climbing-stick-carrier-kit-5-piece-343386	1
4	[empty string]	XOP	Xop	HUNTING	Hunting>Treestands>Stands	[empty string]	1	149.99	0	149.99	96776-DEFAULT-l.jpg	149.99	96776-DEFAULT-m.jpg	ULTRA SERIES EDGE SADDLE PLATFORM	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	INSTORE PICK UP ONLY	[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]	4	100-to-150	0.00	[empty string]	ULTRA SERIES EDGE SADDLE STAND	<p>At XOP we know how important it is to shave ounces when packing deep into the timber. The Edge treestand was designed to take on your most intense and mobile saddle hunts. By utilizing a shortened version of XOP's ultra-light I-Beam and a smaller more streamlined platform we were able to decrease weight and increase portability. The Edge uses Slot-Lock technology to easily carry your climbing tools. Ultra-Grip texture increases traction between your boot and the surface of the platform. Additionally, the Edge leveling system allows you to stand on a surface adjustable to the pitch of any tree.</p> <p> </p> <ul> <li>Indestructible Heat-treated steel Fast strap attachment buttons for added strength and durability</li> <li>Heavy Duty UV treated full polyester attachment straps for a prolonged in-field life</li> <li>In cast accessory hooks for Binos and other hunting gear</li> <li>Fully leaving platform for trees leaning/ crooked trees</li> <li>Integrates with XOP Climbing sticks for a quick efficient mobile hunting system</li> <li>XOP’s patented I-Beam technology replaces the hollow tube for stronger stand support that eliminates all resonation of sound</li> <li>Ultimate offset 6-point bracket for advanced leveling capability</li> </ul> <p> </p> <ul> <li>Weight: 5.4 lbs</li> <li>Weight Rating: 350 lbs</li> <li>Platform Dimensions: 13.75" x 11"</li> <li>I-Beam Height: 9.5"</li> <li>Material: Cast Aluminum</li> <li>Finish: Powder Coated</li> <li>Grip: Ultra-Grip Traction</li> <li>Adjustment: Fully Leveling Platform</li> <li>Certifications: ASTM-Certified, TMA-Recognized</li> </ul> <p> </p> <ul> <li>Includes:</li> <li>The Edge Platform</li> <li>Cam Strap</li> <li>Pack Straps</li> <li>Safety Harness</li> <li>Six Point Bracket</li> <li>Warnings and Users Manual</li> </ul>	[empty string]	N	149.99	149.99	[empty string]	96776-DEFAULT-s.jpg	[empty string]	1000	XOP-EDGE	348790	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/ultra-series-edge-saddle-stand-348790	1
5	[empty string]	XOP	Xop	HUNTING	Hunting>Treestands>Stands	[empty string]	1	199.99	0	199.99	96780-DEFAULT-l.jpg	199.99	96780-DEFAULT-m.jpg	VANISH EVOLUTION SMALL HANG-ON STAND	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[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	150-to-200	0.00	[empty string]	VANISH EVOLUTION	<p>A perfect lightweight and compact choice for the run and gun hunter. Vanish Evolution is specifically designed for those hunters who are looking to take their mobile hunting game to the next level. Equipped with a fully leveling seat and platform, a tight V taper for hunting heavy cover, and built to integrate with XOP climbing sticks for quick and easy transport. VANISH weighs only 10.8lb thanks to a newly designed foot platform and an ultra-light advanced I-Beam.</p> <p> </p> <ul> <li>Dual-action seat cushion provides a convenient lean-to pad when standing & eliminates noise during transport</li> <li>Indestructible Heat-treated steel Fast strap attachment buttons for added strength and durability</li> <li>Heavy Duty UV treated full polyester attachment straps for a prolonged in-field life</li> <li>In cast accessory hooks for Binos and other hunting gear</li> <li>Quick connect bracket capability (XOP's Exclusive offset Leveling design)</li> <li>Fully leaving seat and platform for trees leaning/ crooked trees</li> <li>Integrates with XOP Climbing sticks for a quick efficient mobile hunting system</li> <li>XOP’s patented I-Beam technology replaces the hollow tube for stronger stand support that eliminates all resonation of sound</li> <li>Ultimate offset 6-point bracket for advanced leveling capability</li> </ul> <p> </p> <ul> <li>Weight: 10.5 lbs</li> <li>Weight Rating: 350 lbs</li> <li>Platform Dimensions: 27" x 19"</li> <li>Seat Height: 21"</li> <li>Seat Dimensions: 14" x 12"</li> <li>Material: Cast Aluminum</li> <li>Finish: Powder Coated</li> <li>Grip: EVO-TRAC</li> <li>Adjustment: Fully Adjustable Seat and Platform</li> <li>Seat Cushion: Dual Action Seat Cusion</li> <li>Classification: Hang-On</li> <li>Certifications: ASTM-Certified, TMA-Recognized</li> </ul> <p> </p> <ul> <li>Includes:</li> <li>Vanish Evolution Stand</li> <li>2 Cam Straps</li> <li>Tri-layer Seat Cushion</li> <li>Adjustable Carry Straps</li> <li>Ultra-light Safety Harness</li> <li>Six Point Bracket</li> <li>Warnings and Users Manual</li> </ul>	[empty string]	N	199.99	199.99	SMALL	96780-DEFAULT-s.jpg	[empty string]	1000	XOP-VAN-NM	349998	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/vanish-evolution-349998	1
6	GREY/GREEN	XOP	Xop	HUNTING	Hunting>Treestands>Stands	GREY/GREEN\|NULL\|NULL	1	179.99	0	179.99	96782-DEFAULT-l.jpg	179.99	96782-DEFAULT-m.jpg	4PACK LOCKING CLIMBING STICKS	N	9 BILL	[empty string]	[empty string]	[empty string]	TREE SADDLES	INSTORE PICK UP ONLY	[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]	16	150-to-200	0.00	[empty string]	LOCKING 3 STEP LONG	<p>Utilize XOP's patented quarter turn locking mechanism which allows you to lock your sticks together for transport with no additional straps or tie-downs. Their climbing sticks not only pack together great they also feature longer arched steps and increased standoff from the tree. The Long Locking 3 Step climbing sticks are very light weight and easy to set up. Perfect for making semi-permanent sets easier to hang or to gain extra height in your mobile set ups.</p> <p> </p> <ul> <li>Patented arch step technology forms to your boots</li> <li>Heat treated steel fast strap buttons for effortless hanging</li> <li>Deep stand-off bracket offers more space between your boot and the tree</li> <li>Patented Lock tight stick stacking system - no strap needed</li> <li>Sticks stack and attach neatly to all hang-ons for ultimate portability</li> </ul> <p> </p> <ul> <li>Weight: 3.3 lbs</li> <li>Weight Rating: 350 lbs</li> <li>Step to Step: 15"</li> <li>Step width: 5"</li> <li>Material: 6061 Aluminum</li> <li>Finish: Powder Coated</li> <li>Total Height: 34"</li> <li>Classification: Rotating Single Step</li> <li>Certifications: ASTM-Certified, TMA-Recognized</li> </ul> <p> </p> <ul> <li>Includes:</li> <li>4 climbing sticks</li> <li>4 Cam Straps</li> <li>Warnings and Users Manual</li> </ul>	[empty string]	N	179.99	179.99	4PK	96782-DEFAULT-s.jpg	[empty string]	1000	XOP-LMO4-NM	350002	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/locking-3-step-long-350002	1
7	[empty string]	XOP	Xop	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	PREMIUM TRESSTAND BACK PACK STRAPS	N	9 BILL	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Premium Tresstand Back Pack Straps	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	XOP-BPS	355970	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/premium-tresstand-back-pack-straps-355970	1
8	[empty string]	XOP	Xop	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	UNIVERSAL CONNECTION STRAP SET FOR USE W TTS	N	9 BILL	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	17	20-to-25	0.00	[empty string]	Universal Connection Strap Set For Use W Tts	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	XOP-UCS	355971	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/universal-connection-strap-set-for-use-w-tts-355971	1
9	[empty string]	XOP	Xop	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	TREESTAND TRANSPORT SYSTEM	N	9 BILL	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Treestand Transport System	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	XOG-TTS-1	355972	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	xop/treestand-transport-system-355972	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

4PK
SMALL

Filter