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	DSXCAMO	XENEK	Xenek	HUNTING	Hunting>Blinds>Pop Up Blinds	DSXCAMO\|NULL\|NULL	1	449.99	0	449.99	92761-DEFAULT-l.jpg	449.99	92761-DEFAULT-m.jpg	XENEK ASCENT GROUND BLIND W BACK PACK	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	400-to-450	0.00	[empty string]	Xenek Ascent Ground Blind W Back Pack	<p>The Ascent ground blind from XENEK is loaded with patented innovation.</p> <p> </p> <ul> <li>Xenek's DSX camp pattern</li> <li>600 Denier Polyester skin with black Polyurethane backing</li> <li>Patented window adjustment system</li> <li>Patent pending hub coupling system</li> <li>Patent pending tripod slots</li> <li>Silent screens</li> <li>Overall durability</li> <li>One-way vision panels</li> <li>Complete backpack system</li> </ul>	[empty string]	N	449.99	449.99	[empty string]	92761-DEFAULT-s.jpg	[empty string]	1000	1000-GB-DSX	345474	POP UP BLINDS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-ascent-ground-blind-w-back-pack-345474	1
2	VERDE2.0	XENEK	Xenek	HUNTING	Hunting>Blinds>Pop Up Blinds	VERDE2.0\|NULL\|NULL	1	449.99	0	449.99	92762-DEFAULT-l.jpg	449.99	92762-DEFAULT-m.jpg	XENEK ASCENT GROUND BLIND W BACK PACK	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	400-to-450	0.00	[empty string]	Xenek Ascent Ground Blind W Back Pack	[empty string]	[empty string]	N	449.99	449.99	[empty string]	92762-DEFAULT-s.jpg	[empty string]	1000	1001-GB-VERDE	345475	POP UP BLINDS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-ascent-ground-blind-w-back-pack-345475	1
3	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	19.99	0	19.99	92763-DEFAULT-l.jpg	19.99	92763-DEFAULT-m.jpg	XENEK MINI MOUNT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	10	15-to-20	0.00	[empty string]	Xenek Mini Mount	<p>XENEK’s Mini-Mount is a compact, lightweight, and durable camera mounting solution that is ideally suited to work with game cameras and point-of-view cameras. When used with the XENEK Tree Screw, it provides a very fast and highly adjustable mounting system to trees, fence posts, and even shrubbery. Additionally, it attaches to the hub (inside or outside) of all XENEK ground blinds, and other brands of hub-style ground blinds with the use (and one-time installation) of XENEK’s Mini-Mount Coupler.</p> <p> </p> <ul> <li>Mini-Mount Weight: 3 oz.</li> <li>Mini-Mount Folded Size: 1 ¼” x 1 ¾” x 3 ½”</li> <li>Mini-Mount Extended Length: 6”</li> <li>Materials: Glass-filled polypropylene body and stainless steel hardware</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	92763-DEFAULT-s.jpg	[empty string]	1000	2000-MM	345476	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-mini-mount-345476	1
4	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	9.99	0	9.99	92764-DEFAULT-l.jpg	9.99	92764-DEFAULT-m.jpg	UNIVERSAL CELL PHONE ADAPTER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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	5-to-10	0.00	[empty string]	Universal Cell Phone Adapter	<p>XENEK’s Universal Smart Phone adapter allows hunters to attach their smart phone to XENEK Mini-Mounts (camera mounts) or a tripod. The Universal Smart Phone adapter quickly adjusts to securely clamp onto every size of smart phone on the market.</p>	[empty string]	N	9.99	9.99	[empty string]	92764-DEFAULT-s.jpg	[empty string]	1000	2001-UPA	345477	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/universal-cell-phone-adapter-345477	1
5	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	9.99	0	9.99	92765-DEFAULT-l.jpg	9.99	92765-DEFAULT-m.jpg	XENEK TREE SCREW	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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	5-to-10	0.00	[empty string]	Xenek Tree Screw	<p>The XENEK Tree Screw creates an attachment point for XENEK’s Mini-Mount. This small, highly adjustable camera mount allows hunters to film their hunt from the tree stand or hang their trail cams in any shaped tree thanks to the wide range of adjustments the Mini-Mount provides. The Tree Screw is easily installed with the Mini-Mount when it is threaded into the side of the Tree Screw. In addition to using it in a tree, the Tree Screw and Mini-Mount (total weight less than 4 oz.) can be used as a tripod on the ground when screwed into a limb, a log, or other thick brush located at ground level.</p>	[empty string]	N	9.99	9.99	[empty string]	92765-DEFAULT-s.jpg	[empty string]	1000	2002-TS	345478	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-tree-screw-345478	1
6	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	9.99	0	9.99	92777-DEFAULT-l.jpg	9.99	92777-DEFAULT-m.jpg	XENEK STABILIZER COUPLER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	8	5-to-10	0.00	[empty string]	Xenek Stabilizer Coupler	<p>The XENEK Stabilizer Coupler allows XENEK’s Mini-Mounts (camera mounts) to attach directly to a compound bow.  The Stabilizer Coupler is compatible with all stabilizers and can also be used without a stabilizer. It attaches close to the riser of the bow to reduce vibration in the camera at the shot and to keep the effects of any added weight to an absolute minimum. It provides 4 locations to install Mini-Mounts, which accommodates multiple cameras and allows for ambidextrous use.</p>	[empty string]	N	9.99	9.99	[empty string]	92777-DEFAULT-s.jpg	[empty string]	1000	2003-SC	345479	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-stabilizer-coupler-345479	1
7	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	19.99	0	19.99	92766-DEFAULT-l.jpg	19.99	92766-DEFAULT-m.jpg	XENEK GROUND BLIND BOW HANGER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	6	15-to-20	0.00	[empty string]	Xenek Ground Blind Bow Hanger	<p>XENEK’s Bow Hanger provides hunters with a quiet, convenient, and secure location to place their bow.  Compatible with XENEK ground blinds only, this compact holder attaches in seconds to the ceiling hub.  The bow hook is rubber coated and rotates 360 degrees to allow for proper placement of the bow.</p> <p> </p> <ul> <li>Length: 4"</li> <li>Weight: 1.1 oz</li> <li>Materials: Aluminum Body with Rubber Coated Hook</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	92766-DEFAULT-s.jpg	[empty string]	1000	2004-BH	345480	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-ground-blind-bow-hanger-345480	1
8	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	39.99	0	39.99	92767-DEFAULT-l.jpg	39.99	92767-DEFAULT-m.jpg	UNIVERSAL GROUND BLIND SUPPORT POST	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	Universal Ground Blind Support Post	<p>Increase the life of your ground blind by avoiding an untimely collapse from snow and the disappointment of a missed hunting opportunity. XENEK’s Universal Support Post, made of lightweight aluminum, installs in seconds and adjusts in height from 48 to 81 inches with the use of a twist lock.</p> <p> </p> <ul> <li>48″ fully collapsed</li> <li>81″ fully extended (Roughly 5″ taller than most posts on the market)</li> <li>16 ounces</li> <li>7075 aluminum</li> <li>Quick set-up and release</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	92767-DEFAULT-s.jpg	[empty string]	1000	2005-USP	345481	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/universal-ground-blind-support-post-345481	1
9	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	29.99	0	29.99	92770-DEFAULT-l.jpg	29.99	92770-DEFAULT-m.jpg	XENEK TREESTAND COMBO MINI MOUNT AND TREE SCREW	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	10	25-to-50	0.00	[empty string]	Xenek Treestand Combo Mini Mount And Tree Screw	<p>XENEK’s ‘Tree Stand Film Your Hunt Combo’ includes XENEK’s Mini-Mount and Tree Screw. Collectively, these two pieces represent a lightweight and adjustable system for tree stand hunters that want to video their hunts with small frame cameras and Point of View cameras like Go-Pros. This combo also works great for mounting game cameras in trees of any shape due to the adjustability that the Mini-Mount provides. This compact combination sets up in less than a minute with no additional tools required.</p> <p> </p> <ul> <li>Mini-Mount:</li> <li>Mini-Mount Weight: 2.4 oz</li> <li>Mini-Mount Folded Size: 1 ¼” x 1 ¾” x 3 ½”</li> <li>Mini-Mount Extended Length: 6”</li> <li>Materials: Glass-filled polypropylene body and stainless steel hardware</li> </ul> <p> </p> <ul> <li>Tree Screw:</li> <li>Weight: 0.7 oz</li> <li>Material: Machined and Anodized 6061 Aluminum Alloy</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	92770-DEFAULT-s.jpg	[empty string]	1000	2201-MMTS	345485	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-treestand-combo-mini-mount-and-tree-screw-345485	1
10	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	29.99	0	29.99	92771-DEFAULT-l.jpg	29.99	92771-DEFAULT-m.jpg	XENEK BOW COMBO STABILIZER AND MINI MOUNT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	11	25-to-50	0.00	[empty string]	Xenek Bow Combo Stabilizer And Mini Mount	<p>XENEK’s ‘Film Your Hunt Bow Combo’ includes one Mini-Mount and Stabilizer Coupler (some images show multiple Mini-Mounts and a Universal Phone Adapter that is not included in this combo). Collectively, these two pieces represent the lightest, most adjustable system available to bowhunters that want to video their hunts with devices that range from smart phones to Point of View cameras like Go-Pros. This 5.2 ounce combination sets up in minutes.</p> <p> </p> <ul> <li>Mini-Mount:</li> <li>Mini-Mount Weight: 2.4 oz</li> <li>Mini-Mount Folded Size: 1 ¼” x 1 ¾” x 3 ½”</li> <li>Mini-Mount Extended Length: 6”</li> <li>Materials: Glass-filled polypropylene body and stainless steel hardware</li> </ul> <p> </p> <ul> <li>Stabilizer Coupler:</li> <li>Weight: 2.2 oz</li> <li>Dimensions: 2″ Long by 1” Diameter</li> <li>Material: Machined and Anodized 6061 Aluminum Alloy</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	92771-DEFAULT-s.jpg	[empty string]	1000	2202-MMSC	345486	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-bow-combo-stabilizer-and-mini-mount-345486	1
11	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	39.99	0	39.99	92772-DEFAULT-l.jpg	39.99	92772-DEFAULT-m.jpg	XENEK BOW BUNDLE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	7	25-to-50	0.00	[empty string]	Xenek Bow Bundle	<p>XENEK’s Bow Film Your Hunt Bundle’ turns your bow into an outdoor studio in minutes with the addition of three components that weigh 6.1 ounces (excluding camera weight). XENEK’s Stabilizer Coupler, Mini-Mount, and Universal Phone Adapter attach to your bow and allow you to mount everything from your smart phone to Point of View cameras like Go-Pros in an intuitive and highly adjustable location to permanently capture the memories from your hunts so that they can be relived for generations to come. Once the Stabilizer Coupler is attached to the bow, the Mini-Mount and the Universal Smart Phone adapter can be attached in seconds.</p> <p> </p> <ul> <li>Mini-Mount:</li> <li>Mini-Mount Weight: 2.4 oz</li> <li>Mini-Mount Folded Size: 1 ¼” x 1 ¾” x 3 ½”</li> <li>Mini-Mount Extended Length: 6”</li> <li>Materials: Glass-filled polypropylene body and stainless steel hardware</li> </ul> <p> </p> <ul> <li>Stabilizer Coupler:</li> <li>Weight: 2.2 oz</li> <li>Dimensions: 2″ Long by 1” Diameter</li> <li>Material: Machined and Anodized 6061 Aluminum Alloy</li> </ul> <p> </p> <ul> <li>Universal Smart Phone Adapter:</li> <li>Weight: 1.5 oz</li> <li>Dimensions: 1″ x 1 3/8” x 3 1/4”</li> <li>Material: Injection Molded Polymer</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	92772-DEFAULT-s.jpg	[empty string]	1000	2301-FYH-BOW	345487	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-bow-bundle-345487	1
12	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	29.99	0	29.99	92774-DEFAULT-l.jpg	29.99	92774-DEFAULT-m.jpg	XENEK BLIND BUNDLE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	10	25-to-50	0.00	[empty string]	Xenek Blind Bundle	<p>XENEK’s ‘Ground Blind Film Your Hunt Bundle’ turns your ground blind into an outdoor studio in minutes with the addition of two quick-attach components that weigh 4.5 ounces (excluding camera weight). The XENEK Mini-Mount attaches to the hub of your XENEK blind in seconds and allows you to mount everything from your smart phone (with use of the included Universal Phone Adapter) to Point of View cameras like Go-Pros in an intuitive and highly adjustable location to permanently capture the memories from your hunts so that they can be relived for generations to come.</p> <p> </p> <ul> <li>Mini-Mount:</li> <li>Mini-Mount Weight: 2.4 oz</li> <li>Mini-Mount Folded Size: 1 ¼” x 1 ¾” x 3 ½”</li> <li>Mini-Mount Extended Length: 6”</li> <li>Materials: Glass-filled polypropylene body and stainless steel hardware</li> </ul> <p> </p> <ul> <li>Universal Smart Phone Adapter:</li> <li>Weight: 1.5 oz</li> <li>Dimensions: 1″ x 1 3/8” x 3 1/4”</li> <li>Material: Injection Molded Polymer</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	92774-DEFAULT-s.jpg	[empty string]	1000	2302-FYH-BLIND	345488	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-blind-bundle-345488	1
13	[empty string]	XENEK	Xenek	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	39.99	0	39.99	92776-DEFAULT-l.jpg	39.99	92776-DEFAULT-m.jpg	XENEK TREESTAND BUNDLE	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[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]	4	25-to-50	0.00	[empty string]	Xenek Treestand Bundle	<p>XENEK’s Tree Stand Film Your Hunt Bundle turns your tree stand set-up into an outdoor studio in minutes with the addition of three quick-attach components that weigh less than 6 ounces (excluding camera weight). XENEK’s Tree Screw, Mini-Mount, and Universal Phone Adapter attach to a tree and allow you to mount everything from your smart phone to Point of View cameras like Go-Pros in an intuitive and highly adjustable location to permanently capture the memories from your hunts so that they can be relived for generations to come. Once the Tree Screw is attached to the tree, the Mini-Mount and the Universal Smart Phone adapter can be attached in seconds.</p> <p> </p> <ul> <li>Mini-Mount:</li> <li>Mini-Mount Weight: 2.4 oz</li> <li>Mini-Mount Folded Size: 1 ¼” x 1 ¾” x 3 ½”</li> <li>Mini-Mount Extended Length: 6”</li> <li>Materials: Glass-filled polypropylene body and stainless steel hardware</li> </ul> <p> </p> <ul> <li>Tree Screw:</li> <li>Weight: 0.7 oz</li> <li>Material: Machined and Anodized 6061 Aluminum Alloy</li> </ul> <p> </p> <ul> <li>Universal Smart Phone Adapter:</li> <li>Weight: 1.5 oz</li> <li>Dimensions: 1″ x 1 3/8” x 3 1/4”</li> <li>Material: Injection Molded Polymer</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	92776-DEFAULT-s.jpg	[empty string]	1000	2300-FYH-TS	345489	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	xenek/xenek-treestand-bundle-345489	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter