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]	0	379.99	0	379.99	[empty string]	379.99	[empty string]	THE JAYHAWK 2-MAN STAND WITH LOCKJAW	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]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	1	350-to-400	0.00	[empty string]	The Jayhawk - 20 Feet	<p>The Jayhawk is a 20′ two-man ladder stand featuring our revolutionary Safety System. Hunt at ease knowing that your stand is safe and secure before you leave the ground.</p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Comfort-fleX mesh seat flips up and out of the way for full use of the platform</p> <p>-Padded armrest for added comfort and a footrest that flips back</p> <p>-Adjustable padded shooting rail can flip back or be removed</p> <p>-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</p> <p>-Uses X-Stand`s HeliX oval tubing giving this stand extreme strength and sturdiness</p> <p>-Powder coated with X-Stand`s Weather Defender to protect against the elements and help eliminate sound</p> <p>-Comes standard with two complimentary drink holders and two accessory hooks</p> <p> </p>	[empty string]	N	379.99	379.99	[empty string]	[empty string]	[empty string]	1000	XSLS624	250246	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/the-jayhawk-2-man-stand-with-lockjaw-250246	1
2	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Stands	[empty string]	0	299.99	0	299.99	[empty string]	299.99	[empty string]	THE DUKE X 20FT LADDER STAND W LOCK JAW	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]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	18	250-to-300	0.00	[empty string]	The Duke - 20 Feet	<p><font size=`2`>The Duke is a 20′ single-person ladderstand featuring X-Stand`s revolutionary Safety System. Hunt at ease knowing that your stand is safe and secure before you leave the ground.</font></p>	[empty string]	N	299.99	299.99	[empty string]	[empty string]	[empty string]	1000	XSLS544	250252	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/the-duke-x-20ft-ladder-stand-w-lock-jaw-250252	1
3	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	7.99	0	7.99	[empty string]	7.99	[empty string]	SILENT SNAP PINS 10 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]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	14	5-to-10	0.00	[empty string]	Silent Snap Pins - 10 Pack	<p>Snap pin specially designed to eliminate noise. Fits most ladderstands.</p>	[empty string]	N	7.99	7.99	10PK	[empty string]	[empty string]	1000	XATA670	250273	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/silent-snap-pins-10-pack-250273	1
4	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Stands	[empty string]	0	269.99	0	269.99	[empty string]	269.99	[empty string]	THE JESTER ALUMINUM HANG-ON 17LBS	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]	2017	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	5	250-to-300	0.00	[empty string]	The Jester Aluminum Hang-on Treestand	<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> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Unique and captivating 3D camouflage pattern</p> <p>-Lightest and Strongest Aluminum Series</p> <p>-Self-lubricating Nylong washers eliminates noisy metal on metal contact</p> <p>-Weather-resistant Mesh for added comfort by contouring to your body</p> <p>-High quality comfortable backrest with high arch technology for all day comfort</p> <p>-Quick and Easy Attachment for hang-ons levels the entire stand seat and platform at the same time</p> <p> </p>	[empty string]	N	269.99	269.99	[empty string]	[empty string]	[empty string]	1000	XSFP436	293002	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/the-jester-aluminum-hang-on-17lbs-293002	1
5	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	TRIPOD ANCHOR KIT 3 ANCHORS AND 3 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]	2018	[empty string]	[empty string]	SIDEWALK	ONLINE	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Tripod Anchor Kit	<p>Tie your Tripod down for added safety and stability with these auger stakes.</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	XASA940	298064	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/tripod-anchor-kit-3-anchors-and-3-straps-298064	1
6	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	LADDERSTAND INSALLATION KIT	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	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	Ladderstand Insallation Kit	[empty string]	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	XASA950	298065	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/ladderstand-insallation-kit-298065	1
7	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	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]	28	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	[empty string]	[empty string]	1000	XASA990	298068	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/heavy-duty-ratchet-strap-8ft-298068	1
8	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	THE WING MAN 25` TWIST LIFT STRAP	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]	12	5-AND-under	0.00	[empty string]	The Wingman - 25 Feet	<p>With The Wingman you get two convenient products in 1: 25’ of Hoisting Rope and The Assitant’s rubber wire for a knot free/noise free gear tie up.</p>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	XALT570	298071	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/the-wing-man-25-twist-lift-strap-298071	1
9	[empty string]	XSTAND TREESTANDS	X Stand Treestands	OPTICS	Optics>Night Vision	[empty string]	0	279.99	0	279.99	[empty string]	279.99	[empty string]	DIGITAL NIGHT VISION HANDS FREE PRO SNIPER	N	8 TOM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	Digital Night Vision Hands Free Pro Sniper	[empty string]	[empty string]	N	279.99	279.99	[empty string]	[empty string]	[empty string]	1000	XANB40	300202	EMPTY	EMPTY	EMPTY	0	0	0	NIGHT VISION	[empty string]	x-stand-treestands/digital-night-vision-hands-free-pro-sniper-300202	1
10	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Stands	[empty string]	0	329.99	0	329.99	[empty string]	329.99	[empty string]	THE GENERAL X 22FT LADDER STAND W LOCK JAW	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]	2019	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	9	300-to-350	0.00	[empty string]	General X	<p>The General XT is a 22′ single person ladderstand featuring our revolutionary Jaw Safety System. Hunt at ease knowing that your stand is safe and secure before you leave the ground.</p> <p> </p> <p> </p> <p><strong>PRODUCT FEATURES:</strong></p> <p> </p> <p>-Roomy Comfort-fleX mesh seat flips up and out of the way for full use of the platform</p> <p>-RelaX – high quality comfortable backrest with high arch technology for all day comfort</p> <p>-Padded armrest and a flip out footrest</p> <p>-Adjustable padded shooting rail can flip back or be removed</p> <p>-Stealth Silencers – self-lubricating nylon washers for no metal on metal contact</p> <p>-X-Force expanded metal for added strength, durability, traction and silencing</p> <p>-HeliX oval tubing giving this stand extreme strength and sturdiness</p> <p>-Powder coated with the Weather Defender to protect against the elements and help eliminate sound</p> <p> </p>	[empty string]	N	329.99	329.99	22FT	[empty string]	[empty string]	1000	XSLS578	314965	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/the-general-x-22ft-ladder-stand-w-lock-jaw-314965	1
11	[empty string]	XSTAND TREESTANDS	X Stand Treestands	HUNTING	Hunting>Treestands>Stands	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	VELOCITY STICKS 4-PACK CLIMBING STICKS	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]	2019	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	11	100-to-150	0.00	[empty string]	Velocity Sticks - 4 Pack	<p>The Velocity Sticks are light, strong and self lubricating.</p>	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	XSCS209-4	314974	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	x-stand-treestands/velocity-sticks-4-pack-climbing-sticks-314974	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter