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]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Stands	[empty string]	1	329.99	0	329.99	96765-DEFAULT-l.jpg	329.99	96765-DEFAULT-m.jpg	THE DUKE X 20FT LADDER STAND W LOCK JAW	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]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	20	300-to-350	0.00	[empty string]	THE DUKE - 20 FEET	<p>The Duke X is a 20′ single-person ladderstand featuring our revolutionary Safety System. Hunt at ease knowing that your stand is safe and secure before you leave the ground. Comfort-fleX mesh seat flips up and out of the way for full use of the platform. The Duke also includes padded armrest and a footrest for added comfort. Adjustable padded shooting rail can flip back or be removed. Stealth Silencers – self-lubricating nylon washers for no metal on metal contact, along with X-Force expanded metal for added strength, durability, traction and silencing. The Duke also uses our HeliX oval tubing giving this stand extreme strength and sturdiness. Powder coated with our Weather Defender to protect against the elements and help eliminate sound.</p> <p> </p> <ul> <li>Special powder coating spray</li> <li>Unique and captivating 3D camouflage pattern</li> <li>Oval tubing easy to grip – Adds Strength and Stability</li> <li>Weather-resistant Mesh – Added comfort by contouring to your body</li> <li>Self-lubricating Nylong washers – Eliminate noisy metal on metal contact</li> <li>Heavy Duty expanded gates – Adds strength, silence and traction</li> <li>Revolutionary Safety Feature – Secures your stand at ground level. 2 Gripping Jaws clamp around the tree for the ultimate stability</li> </ul> <p> </p> <ul> <li>Weight Capacity: 300 lbs</li> <li>Construction: Steel</li> <li>Stand Height: 20’ to Shooting Rail</li> <li>Platform Size: 18” Wide x 26” Deep</li> <li>Seat Size: 22” Wide x 16” Deep</li> <li>Seat Cushion: Comfort-FleX</li> <li>Stand Weight: 79 lbs</li> <li>Safety Harness: One 4-pt full-body harness</li> </ul>	[empty string]	Y	329.99	329.99	[empty string]	96765-DEFAULT-s.jpg	[empty string]	1000	XSLS544	250252	STANDS	EMPTY	EMPTY	1	329.99	299.99	TREESTANDS	[empty string]	x-stand-treestands/the-duke-20-feet-250252	1
2	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Stands	[empty string]	1	269.99	0	269.99	96766-DEFAULT-l.jpg	269.99	96766-DEFAULT-m.jpg	THE JESTER ALUMINUM HANG-ON 17LBS	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]	2017	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	3	250-to-300	0.00	[empty string]	THE JESTER	<p>Lightweight and comfort come together in the ultimate hunting partner. The Jester features X-Stand's comfort flex seat and RelaX – high quality comfortable backrest and padded armrest. Flip up seat for full use of the large platform and built-in footrest.</p> <p> </p> <ul> <li>Seat flips up Backrest flips down</li> <li>Quick hitch receiver easily adjustable to level the entire stand seat and platform</li> <li>Unique and captivating 3D camouflage pattern</li> <li>Lightest and Strongest Aluminum Series</li> <li>Self-lubricating Nylong washers – Eliminate noisy metal on metal contact</li> <li>Weather-resistant Mesh – Added comfort by contouring to your body</li> <li>High quality comfortable backrest with high arch technology for all day comfort</li> <li>Quick and Easy Attachment for hang-ons – Levels the entire stand seat and platform at the same time</li> </ul> <p> </p> <ul> <li>Weight Capacity: 350 lbs</li> <li>Construction: T6 60/61 aircraft aluminum</li> <li>Platform Size: 23.5" wide x 32" deep</li> <li>Seat Size: 19" wide x 13" deep</li> <li>Net Weight: 17 lbs</li> <li>Safety Harness: One 4-pt. full-body harness</li> </ul>	[empty string]	N	269.99	269.99	[empty string]	96766-DEFAULT-s.jpg	[empty string]	1000	XSFP436	293002	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/the-jester-293002	1
3	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	6.99	0	6.99	99688-DEFAULT-l.jpg	6.99	99688-DEFAULT-m.jpg	RATCHET STRAP 8FT	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]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	14	5-to-10	0.00	[empty string]	RATCHET STRAP	<p>8’ long. Multi-use ratchet strap made of high strength webbing with super strong hardened hooks. Approved for use to help stabilize ladderstands, or can be used for tying down equipment.</p>	[empty string]	N	6.99	6.99	8FT	99688-DEFAULT-s.jpg	[empty string]	1000	XASA980	298066	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/ratchet-strap-298066	1
4	4PACK	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	4PACK\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	RATCHET STRAP 8FT 4-PACK	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]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Ratchet Strap - 4 Pack	<p>Multi-use ratchet strap made of high strength webbing with super strong hardened hooks. Approved for use to help stabilize ladderstands, or can be used for tying down equipment.</p>	[empty string]	N	19.99	19.99	8FT	[empty string]	[empty string]	1000	XASA980-4	298067	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/ratchet-strap-8ft-4-pack-298067	1
5	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	14.99	0	14.99	99689-DEFAULT-l.jpg	14.99	99689-DEFAULT-m.jpg	HEAVY DUTY RATCHET STRAP 8FT	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]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	18	10-to-15	0.00	[empty string]	HD RATCHET STRAP	<p>A long heavy duty ratchet strap made for heavy duty jobs. Uses 2″ wide nylon webbing.</p>	[empty string]	N	14.99	14.99	8FT	99689-DEFAULT-s.jpg	[empty string]	1000	XASA990	298068	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/hd-ratchet-strap-298068	1
6	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	7.99	0	7.99	99690-DEFAULT-l.jpg	7.99	99690-DEFAULT-m.jpg	BOW BUDDY FOLDING BOW HOLDER	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]	2018	PROMO	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	BOW BUDDY	<ul> <li>This hanger allows for easy access to your bow and other accessories</li> <li>Fold-up design for easy storage and backpacking</li> <li>Special twist-in tip allows you to easily screw Bow Buddy into the tree with no tools required!</li> <li>Large main hook is designed to hold most any bow with its vinyl coating adding additional protection for your gear</li> <li>2 additional accessories hooks</li> </ul>	[empty string]	N	7.99	7.99	[empty string]	99690-DEFAULT-s.jpg	[empty string]	1000	XATA750	298069	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/bow-buddy-298069	1
7	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Stands	[empty string]	1	149.99	0	149.99	96769-DEFAULT-l.jpg	149.99	96769-DEFAULT-m.jpg	VELOCITY STICKS 4-PACK CLIMBING STICKS	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]	2019	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	VELOCITY STICKS - 4 PACK	<ul> <li>Lightest and Strongest Aluminum Series</li> <li>Self-lubricating Nylong washers – Eliminate noisy metal on metal contact</li> </ul> <p> </p> <ul> <li>Construction: Aluminum</li> <li>Weight: 2.8 lbs each</li> <li>Sections: 4</li> <li>Fasteners: 1-1" Cam-Buckle Strap per section</li> <li>Fold-Up Steps: 4.5" wide x 1.25" deep</li> <li>Height: 26"</li> <li>Packable: Designed to pack with several compatible hang-on stands</li> <li>Tree Size: Minimum 9"</li> <li>Weight Capacity: 300 lbs</li> </ul>	[empty string]	N	149.99	149.99	[empty string]	96769-DEFAULT-s.jpg	[empty string]	1000	XSCS209-4	314974	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/velocity-sticks-4-pack-314974	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter