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	LADDER	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Stands	LADDER\|NULL\|NULL	1	439.99	0	439.99	96718-DEFAULT-l.jpg	439.99	96718-DEFAULT-m.jpg	2-MAN DOUBLE LADDER STAND 18FT	N	9 BILL	[empty string]	[empty string]	[empty string]	B	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2011	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	10	400-to-450	0.00	[empty string]	L220 DOUBLE LADDER STAND - 18 FEET	<p>The L220 has all the features of the L200, but with a platform that’s twice as big. It also has fold-up comfortMAX seats. Those features give hunting teams more flexibility with weapon choice and shot angles, and provide more room for the extra gear young hunters can use to have a great time on their hunts. Like the L200, this stand is also height adjustable; simply add or subtract ladder section to put the stand at the height you want, from 7 to 18 feet off the ground. The steelTOUGH construction will give you a solid, safe place for two hunters, and the adjustable, padded shooting rail and fold-out foot rest give young hunters the adjustment options they need to make shots at game easy and comfortable.</p> <p> </p> <ul> <li>SafeLink included</li> <li>Double-sized platform</li> <li>Folding footrest</li> <li>Durable powder coat finish</li> <li>Comfortable, quiet, easy setup</li> <li>Stabilizing strap secures stand to tree</li> <li>Exclusive, patented comfortMAX contoured, tight sling seat</li> <li>Double rail rigid ladder requires no brace</li> <li>Adjustable padded shooting rail & arm rests</li> <li>2 Full body harness (meets or exceeds industry standards recognized by TMA)</li> <li>Product meets or exceeds industry standards recognized by TMA</li> </ul> <p> </p> <ul> <li>Material: Steel</li> <li>Capacity: 500 lbs</li> <li>Weight: 103 lbs</li> <li>Platform: W 40” x D 32”</li> <li>Seat Size: W 40” x D 17”</li> <li>Seat Height: 17”</li> </ul>	[empty string]	N	439.99	439.99	18FT	96718-DEFAULT-s.jpg	[empty string]	1000	L-220-SL	129017	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/l220-double-ladder-stand-18-feet-129017	1
2	SEAT	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Blinds>Blind Accessories	SEAT\|NULL\|NULL	1	99.99	0	99.99	61040-DEFAULT-l.jpg	99.99	61040-DEFAULT-m.jpg	HANG-ON GROUND CHAIR-TREE SEAT	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]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	15	50-to-100	0.00	[empty string]	M300 TREE SEAT	<ul> <li>Material: Aluminum</li> <li>Capacity: 300 lbs</li> <li>Weight: 4 lbs</li> <li>Seat Size: 20” W x 17” D</li> </ul>	[empty string]	N	99.99	99.99	[empty string]	61040-DEFAULT-s.jpg	[empty string]	1000	M-300	129019	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	millennium-treestand/m300-tree-seat-129019	1
3	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	36.99	0	36.99	78305-DEFAULT-l.jpg	36.99	78305-DEFAULT-m.jpg	HANG-0N TREESTAND RECEIVER	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]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	M102 Receiver Mount	<p>Use the M102 Receiver Mount with M7, M50, M60U, M100U & M150 Stands. Use additional M102 camLOCK Receivers to set up multiple stand locations.</p>	[empty string]	N	36.99	36.99	[empty string]	78305-DEFAULT-s.jpg	[empty string]	1000	M-102	129542	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/hang-0n-treestand-receiver-129542	1
4	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	SPRING PINS	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]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	19	10-to-15	0.00	[empty string]	M203 Spring Pins - 4 Pack	<p>Replacement spring pins for L-Series Ladder Stands.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	M-203	129544	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/spring-pins-129544	1
5	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Accessories	[empty string]	1	39.99	0	39.99	78307-DEFAULT-l.jpg	39.99	78307-DEFAULT-m.jpg	CAM LOC RATCHET STRAP FOR M-50 AND M-100	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]	2012	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	22	25-to-50	0.00	[empty string]	M102s Receiver Camlock	<p>CamLOCK Ratchet Strap Receiver is used for M7, M50, M60U, M100U & M150 Stands.</p>	[empty string]	N	39.99	39.99	[empty string]	78307-DEFAULT-s.jpg	[empty string]	1000	M-102S	145586	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/cam-loc-ratchet-strap-for-m-50-and-m-100-145586	1
6	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Stands	[empty string]	1	269.99	0	269.99	32086-DEFAULT-l.jpg	269.99	32086-DEFAULT-m.jpg	MONSTER HANG-ON TREESTAND	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]	2013	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	14	250-to-300	0.00	[empty string]	M150 MONSTER	<p>If standard seat heights don’t fit you, the M150 Monster provides a solution: the ComfortMAX seat on this tree stand is adjustable from a height of 16 inches up to 20 inches off the platform, and it has a full backrest and side straps for solid comfort. The wide platform and fold-up seat give bowhunters maximum flexibility in positioning for a shot. The optional M101 shooting rail gives gun hunters a solid rest. This tree stand can be further adjusted so that it provides a level sit even on trees that lean as much as 15 degrees off vertical. Adjustable, flexible and built to last — the M150 Monster fits you and any style of hunting you like.</p> <p> </p> <ul> <li>SafeLink included</li> <li>Large Platform</li> <li>Adjustable seat height</li> <li>Durable powder coat finish</li> <li>Comfortable, quiet, easy setup</li> <li>Backpack straps included</li> <li>Exclusive, patented comfortMAX contoured, tight sling seat</li> <li>Seat folds up for standing shots</li> <li>Easily folds flat for backpacking</li> <li>Adjusts to leaning trees up to 15°</li> <li>Full body harness (meets or exceeds industry standards recognized by TMA)</li> <li>Product meets or exceeds industry standards recognized by TMA</li> </ul> <p> </p> <ul> <li>Material: Aluminum</li> <li>Capacity: 300 lbs</li> <li>Weight: 19.5 lbs</li> <li>Platform: 24” W x 37” D</li> <li>Seat Size: 20” W x 17” D</li> <li>Seat Height: 16”- 20”</li> </ul>	[empty string]	N	269.99	269.99	[empty string]	32086-DEFAULT-s.jpg	[empty string]	1000	M-150	160647	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/m150-monster-160647	1
7	HANGON	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Stands	HANGON\|NULL\|NULL	1	249.99	0	249.99	96719-DEFAULT-l.jpg	249.99	96719-DEFAULT-m.jpg	M-100U HANG-ON TREESTAND	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]	2014	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	9	200-to-250	0.00	[empty string]	M100U ULTRALITE	<p>The M100 is one of the classic and most popular trees stand designs ever made; the M100U combines those design features with an aluminum-frame construction, giving it a weight of only 13.5 pounds — 20 percent lighter than the original M100. The M100U has the patented ComfortMAX seat with a back and side straps, providing the hunter a comfortable, stable seat that won’t collect water. While the seat folds up for bowhunters who want a stand-up shot, the M100U can be mounted with the M101 optional shooting rail for gun or crossbow hunters. And when it’s time to switch to a new stand site, the M100U folds flat and is easily carried with the included backpack straps. This is a stand that does it all, for bow or gun hunters, season after season.</p> <p> </p> <ul> <li>SafeLink included</li> <li>20% lighter than the original M100</li> <li>CamLock Chain Receiver included</li> <li>Durable powder coat finish</li> <li>Comfortable, quiet, easy setup</li> <li>Exclusive, patented comfortMAX contoured, tight sling seat</li> <li>Seat folds up for standing shots</li> <li>Easily folds flat for backpacking</li> <li>Backpack straps included</li> <li>Full body harness (meets or exceeds industry standards recognized by TMA)</li> <li>Product meets or exceeds industry standards recognized by TMA</li> </ul> <p> </p> <ul> <li>Material: Aluminum</li> <li>Capacity: 300 lbs</li> <li>Weight: 14.5 lbs</li> <li>Platform: 20” W x 38” D</li> <li>Seat Size: 20” W x 16” D</li> <li>Seat Height: 17”</li> </ul>	[empty string]	N	249.99	249.99	[empty string]	96719-DEFAULT-s.jpg	[empty string]	1000	M-100-SL	179027	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/m100u-ultralite-179027	1
8	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	199.99	0	199.99	92716-DEFAULT-l.jpg	199.99	92716-DEFAULT-m.jpg	BLIND CHAIR	N	9 BILL	[empty string]	[empty string]	[empty string]	C	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	G100 Shooting Chair	<p>With adjustable tripod legs, folding design and full-back ComfortMAX seat, the G100 chair is perfect for ground blind applications in any season. The G100 gives you a combination of comfort, quiet, and excellent positioning - the height adjustment can be made from 13" to 18". No matter what blind you are in, you will be in a good position to see the game and take your best shot. It’s also pre-drilled to hold the G101 optional shooting stick or can match up with the optional M600 bow-holder.</p>	[empty string]	N	199.99	199.99	[empty string]	92716-DEFAULT-s.jpg	[empty string]	1000	G-100	243913	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	millennium-treestand/blind-chair-243913	1
9	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Blinds>Blind Accessories	[empty string]	1	169.99	0	169.99	50776-DEFAULT-l.jpg	169.99	50776-DEFAULT-m.jpg	SHOOTING SHACK CHAIR	N	9 BILL	[empty string]	[empty string]	[empty string]	C	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	G200 Shooting Chair	<p>The G200 meets all the needs of tower stand hunters. The G200’s Millennium ComfortMAX seat design make for the most versatile and comfortable all-day hunting shooting house chair on the market. A folding seat that also reclines, independently adjustable feet for leveling, adjustable seat height of 18 to 23 inches that allows you to choose the best height for visibility from your stand are some of the features that set this chair apart from all others. The steel and aluminum design provide stability and durability.</p>	[empty string]	N	169.99	169.99	[empty string]	50776-DEFAULT-s.jpg	[empty string]	1000	G-200	243914	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	millennium-treestand/shooting-shack-chair-243914	1
10	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Stands	[empty string]	1	369.99	0	369.99	96720-DEFAULT-l.jpg	369.99	96720-DEFAULT-m.jpg	SINGLE MAN LADDER STAND 21FT WITH SAFE L	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]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	350-to-400	0.00	[empty string]	L110 SINGLE LADDER - 21 FEET	<p>The L110 has the same features as the L100 but with a deeper, more generous foot platform and a fold-up seat that makes it an ideal choice for bowhunters. The double-rail rigid ladder system also allows the stand to be placed at different heights, from 8 feet to 21 feet, giving bow or gun hunters flexibility to get in the best possible position for a shot given the habitat and terrain. Like the L100, the L110 is built tough and to meet the needs of hunters in real-world conditions, season after season.</p> <p> </p> <ul> <li>SafeLink included</li> <li>Double-sized platform</li> <li>Folding footrest</li> <li>Durable powder coat finish</li> <li>Comfortable, quiet, easy setup</li> <li>Stabilizing strap secures stand to tree</li> <li>Exclusive, patented comfortMAX contoured, tight sling seat</li> <li>Double rail rigid ladder requires no brace</li> <li>Adjustable padded shooting rail & Armrests</li> <li>Full body harness (meets or exceeds industry standards recognized by TMA)</li> <li>Product meets or exceeds industry standards recognized by TMA</li> </ul> <p> </p> <ul> <li>Material: Steel</li> <li>Capacity: 300 lbs</li> <li>Weight: 92 lbs</li> <li>Platform: 20” W x 32” D</li> <li>Seat Size: 20” W x 17″ D</li> <li>Seat Height: 17”</li> </ul>	[empty string]	N	369.99	369.99	21FT	96720-DEFAULT-s.jpg	[empty string]	1000	L-110-SL	290836	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/l110-single-ladder-21-feet-290836	1
11	OBSESSION	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Accessories	OBSESSION\|NULL\|NULL	0	89.99	0	89.99	[empty string]	89.99	[empty string]	FIELD PRO TURKEY SEAT OBSESSION CAMO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	50-to-100	0.00	[empty string]	Field Pro Turkey Seat Obsession Camo	[empty string]	[empty string]	N	89.99	89.99	[empty string]	[empty string]	[empty string]	1000	TU-01-00	332478	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	millennium-treestand/field-pro-turkey-seat-obsession-camo-332478	1
12	OBSESSION	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Accessories	OBSESSION\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	RUN AND GUN TURKEY SEAT OBSESSION CAMO	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	11	50-to-100	0.00	[empty string]	Run And Gun Turkey Seat Obsession Camo	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	TU-02-00	332479	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	millennium-treestand/run-and-gun-turkey-seat-obsession-camo-332479	1
13	POD	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Stands	POD\|NULL\|NULL	1	799.99	0	799.99	89990-DEFAULT-l.jpg	799.99	89990-DEFAULT-m.jpg	BUCK HUT QUAD POD SHOOTING HOUSE	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]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	12	500-or-more	0.00	[empty string]	Q200 BUCK HUT SHOOTING HOUSE	<ul> <li>Blind is constructed of heavy duty water-resistant soft shell</li> <li>Black windows and black interior for ultimate concealment</li> <li>Roomy interior with up to 7 foot height for standing shots</li> <li>Configured to allow for (1) or (2) 360 Revolution seats to be added</li> <li>Multi-configuration windows for rifle, crossbow or vertical bow hunting</li> <li>Each window has adjustable height shooting rest</li> <li>Tower has two adjustable legs for leveling on uneven ground</li> <li>Heavy duty powder coat steel construction</li> <li>Comes with removable platform pad</li> <li>Includes stabilizing anchoring kit</li> </ul> <p> </p> <ul> <li>Net Weight: 323 lbs</li> <li>Material: Powder coated steel/Fabric</li> <li>Overall Height: 15’ 8”</li> <li>Blind Dimensions: 7’4” W X 4’ D X 7’ H</li> <li>Overall Footprint: 11’9” X 8’</li> <li>Weight Capacity: 500 lbs</li> </ul>	[empty string]	N	799.99	799.99	[empty string]	89990-DEFAULT-s.jpg	[empty string]	1000	Q-200-00	340174	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/q200-buck-hut-shooting-house-340174	1
14	SEATKIT	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Stands	SEATKIT\|NULL\|NULL	1	99.99	0	99.99	92434-DEFAULT-l.jpg	99.99	92434-DEFAULT-m.jpg	360 REVOLUTION SEAT AND MOUNT FOR BUCK HUT	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]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	M369 REVOLUTION SEAT FOR THE BUCK HUT SHOOTING HOUSE	<ul> <li>Offers unparalleled comfort with 360 degree silent rotation</li> <li>Flip up seat for standing shots</li> <li>Offset seat design to maximize platform space with seat up</li> <li>Easy install and removal for offseason storage</li> <li>Box includes: Seat, Seat mount, mounting hardware and instructions</li> </ul> <p> </p> <ul> <li>Net Weight: 13 lbs</li> <li>Box Dims: 37.12” x 22.12” x 4.25”</li> <li>Box weight: 15 lbs</li> </ul>	[empty string]	N	99.99	99.99	[empty string]	92434-DEFAULT-s.jpg	[empty string]	1000	M-369-00	340176	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/m369-revolution-seat-for-the-buck-hut-shooting-house-340176	1
15	[empty string]	MILLENNIUM TREESTAND	MILLENNIUM TREESTAND	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	CLIMBING STICK QUIVER	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]	28	25-to-50	0.00	[empty string]	Climbing Stick Quiver	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	M-260-00	348134	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	millennium-treestand/climbing-stick-quiver-348134	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter