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]	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Stands	[empty string]	1	329.99	0	329.99	32062-DEFAULT-l.jpg	329.99	32062-DEFAULT-m.jpg	TWO PLEX 2-MAN LADDER LADDER 17FT	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]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	42	300-to-350	0.00	[empty string]	TWOPLEX - 2 MAN	<p>The TwoPlex ladder stand features a flip-up, TearTuff mesh bench seat allowing for 1 or 2 hunters. The 40" wide platform provides plenty of extra room for standing shots. The TwoPlex features a 2-way adjustable shooting rail allowing for you to set a height and depth that works for you.</p> <p> </p> <ul> <li>Flip-up, TearTuff mesh seat for standing shots</li> <li>Bench seat provides space for 1 or 2 hunters</li> <li>40" wide platform for extra room</li> <li>2-way adjustable shooting rail for height and depth</li> <li>Dual tree blades improve platform stability</li> <li>Includes two ratchet straps and criss-cross stability straps</li> <li>Includes adjustable length stabilizer bar</li> </ul> <p> </p> <ul> <li>Height to Shooting Rail: 17' 1"</li> <li>Height to Seat: 16' 1"</li> <li>Seat Dimensions: 37" W x 14" D</li> <li>Seat Height: 18"</li> <li>Height to Platform: 14' 7"</li> <li>Platform Size: 40" W x 26" D</li> <li>Ladder Stance: 17"</li> <li>Ladder Sections: 3 (59" each)</li> <li>Step Distance: 14"</li> <li>Weight: 86 lbs</li> <li>Capacity: 500 lbs</li> <li>Tree Diameter Range: 12" - 20"</li> <li>Full Body Harness: Yes (2)</li> </ul>	[empty string]	N	329.99	329.99	[empty string]	32062-DEFAULT-s.jpg	[empty string]	1000	RE665	143605	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/twoplex-2-man-143605	1
2	[empty string]	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Accessories	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	HANG-ON STAND REPLACEMENT 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]	2015	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	27	20-to-25	0.00	[empty string]	Hang-on Stand Replacement Strap	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	RE760	258977	EMPTY	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/hang-on-stand-replacement-strap-258977	1
3	[empty string]	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Stands	[empty string]	1	799.99	0	799.99	96747-DEFAULT-l.jpg	799.99	96747-DEFAULT-m.jpg	10 FOOT LANDMARK TOWER	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]	2016	[empty string]	BOTH	ACTIVE	PROP 65	[empty string]	[empty string]	6	500-or-more	0.00	[empty string]	LANDMARK 600 TOWER - 10 FEET	<p>The Landmark 10’ 600 Tower can be paired with the Landmark 600 Permanent Blind or used independently for an elevated position to provide optimal viewing. It is built with large steel tubing and cross-bracing for strength and stability. Its large entry platform with handrails allows for easier entry and exit. The treaded ladder rungs provide superior grip to help prevent slipping while climbing in inclement weather. Included with the Landmark 10’ 600 Tower are leg stakes and anchor system.</p> <p> </p> <ul> <li>Large entry platform with handrails allows for easier entry and exit</li> <li>Built with large steel tubing and cross-bracing for strength and stability</li> <li>Ladder rung treads provide superior grip</li> <li>Includes leg stakes and anchor system</li> <li>Fits LM600 & LM601 Landmark Permanent Blinds</li> </ul> <p> </p> <ul> <li>Height to Platform: 10' 4"</li> <li>Platform Size: 72" x 72"</li> <li>Footprint: 9' 9" x 9' 9"</li> <li>Ladder Stance: 17"</li> <li>Step Distance: 12"</li> <li>Weight: 288 lbs</li> <li>Capacity: 800 lbs</li> </ul>	[empty string]	N	799.99	799.99	[empty string]	96747-DEFAULT-s.jpg	[empty string]	1000	LM620	264844	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/landmark-600-tower-10-feet-264844	1
4	STACKINGSTICK	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Stands	STACKINGSTICK\|NULL\|NULL	1	119.99	0	119.99	96745-DEFAULT-l.jpg	119.99	96745-DEFAULT-m.jpg	CONNECT-N-CLIMB STACKING LADDER STICK	N	9 BILL	[empty string]	[empty string]	[empty string]	C	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2016	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	63	100-to-150	0.00	[empty string]	20 FOOT CONNECT-N-CLIMB	<p>The Big Foot 20’ Connect-N-Climb offers security and stability when making the climb to your treestand. This climbing system features a double-step design allowing for two feet at every step. The 20’ Connect-N-Climb steps are covered with Tractionite permanent non-slip coating for superior grip. Each section connects together for easy climbing and increased stability.</p> <p> </p> <ul> <li>Double-step design allows for two feet at every step</li> <li>Tractionite permanent non-slip coating for superior grip</li> <li>Sections connect together for easy climbing</li> </ul> <p> </p> <ul> <li>Height: 20'</li> <li>Step Distance: 15"</li> <li>Step Width: 11"</li> <li>Ladder Sections: 4 (60" each)</li> <li>Tree Diameter Range: 8" - 20"</li> <li>Weight: 22 lbs</li> <li>Capacity: 300 lbs</li> </ul>	[empty string]	N	119.99	119.99	20FT	96745-DEFAULT-s.jpg	[empty string]	1000	RE723	274674	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/20-foot-connect-n-climb-274674	1
5	[empty string]	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Stands	[empty string]	1	159.99	0	159.99	96744-DEFAULT-l.jpg	159.99	96744-DEFAULT-m.jpg	BIGFOOT ROGUE XL 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]	2018	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	35	150-to-200	0.00	[empty string]	ROGUE XL	<p>The Rogue XL features a flip-up, TearTuff mesh seat paired with a 24” wide by 37" deep platform and footrest providing plenty of extra room for standing shots. The unique Big Foot lever action system and noiseless strap attachment creates a secure and silent installation during your hunt.</p> <p> </p> <ul> <li>24” wide x 37” deep platform for extra room</li> <li>Flip-up, TearTuff mesh seat for standing shots</li> <li>Footrest for leg stretching comfort</li> <li>Lever action system secures stand aggressively to the tree</li> <li>Noiseless strap attachment eliminates metal-on-metal contact</li> </ul> <p> </p> <ul> <li>Platform Size: 24' W x 37" D</li> <li>Seat Dimensions: 21" W x 14" D</li> <li>Seat Height: 23"</li> <li>Weight: 24 lbs</li> <li>Capacity: 300 lbs</li> <li>Tree Diameter Range: 8" - 20"</li> <li>Full Body Harness: Yes (1)</li> </ul>	[empty string]	N	159.99	159.99	[empty string]	96744-DEFAULT-s.jpg	[empty string]	1000	RE562	312869	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/rogue-xl-312869	1
6	2MAN	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Stands	2MAN\|NULL\|NULL	1	499.99	0	499.99	96737-DEFAULT-l.jpg	499.99	96737-DEFAULT-m.jpg	LOCKDOWN 21 2-MAN LADDER 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]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	23	450-to-500	0.00	[empty string]	LOCKDOWN - 2 MAN - 21 FEET	<p>The Lockdown 21’ 2-Man, a big, comfortable treestand. Featuring a unique no-split TearTuff bench seat that eliminates the uncomfortable bar in the center giving you a true 1 or 2 man seat option. In addition, this stand features the Ultimate Shooting Rail that can be adjusted for both height and length based on your personal preference and weapon choice. This unique design also allows you to tuck the shooting rail away into a designated slot on the platform, perfect for bowhunting. At 21’ tall the Lockdown 21’ 2-Man ladder stand features added height bowhunters prefer. No longer will you have to trade security for height with our line of Lockdown ladder stands. You can ratchet the platform tight to the tree before ever leaving the ground, with our patent pending Ground-Level Ratcheting technology. This clever system allows the user to pull the platform straps up to the top of the stand while standing on the ground and ratchet them tight to the tree.</p> <p> </p> <ul> <li>The Lockdown Ground-Level Ratcheting Technology allows you to ratchet your stand securely to the tree by pulling the top of the stand into the tree just like a conventional ratchet strap but allows you to do it from the ground</li> <li>21’ height allows you to get up high to eliminate detection without compromising comfort</li> <li>Unique No-Split Teartuff Mesh Seat is comfortable for two or an individual hunter…go ahead and sit right in the middle for more comfort and concealment</li> <li>Oversized TearTuff mesh seat and extra-large platform for all day sits</li> <li>The Ultimate Shooting Rail can be adjusted for both height and length based on your terrain and personal preference. The shooting rail and footrest can be tucked away into the designated slot on the platform</li> <li>Built with octagonal ladder rails, LadderLock connections, and a 3rd ladder rail making this the stiffest and most sturdy ladder stand in the industry</li> <li>Vinyl dipped parts for improved durability and quiet operation</li> </ul> <p> </p> <ul> <li>Height to Shooting Rail: 20' 6"</li> <li>Height to Seat: 19' 5"</li> <li>Seat Dimensions: 41.5" W x 16" D</li> <li>Seat Height: 17"</li> <li>Height to Platform: 18'</li> <li>Platform Size: 42" W x 32.5" D</li> <li>Ladder Stance: 20"</li> <li>Ladder Sections: 5 (44" each)</li> <li>Step Distance: 13.5"</li> <li>Weight: 129 lbs</li> <li>Capacity: 500 lbs</li> <li>Tree Diameter Range: 12" - 30"</li> <li>Full Body Harness: Yes (2)</li> </ul>	[empty string]	N	499.99	499.99	21FT	96737-DEFAULT-s.jpg	[empty string]	1000	LD202	331267	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/lockdown-2-man-21-feet-331267	1
7	WIDE	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Stands	WIDE\|NULL\|NULL	0	449.99	0	449.99	[empty string]	449.99	[empty string]	LOCKDOWN 21 WIDE 1-MAN LADDER 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]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	36	400-to-450	0.00	[empty string]	Lockdown 21 Wide 1-man Ladder Stand	[empty string]	[empty string]	N	449.99	449.99	21FT	[empty string]	[empty string]	1000	LD200	331268	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/lockdown-21-wide-1-man-ladder-stand-331268	1
8	[empty string]	RIVERS EDGE STANDS	RIVERS EDGE STANDS	HUNTING	Hunting>Treestands>Stands	[empty string]	1	199.99	0	199.99	96741-DEFAULT-l.jpg	199.99	96741-DEFAULT-m.jpg	BIGFOOT BRUTE 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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	33	150-to-200	0.00	[empty string]	BRUTE	<p>The Brute features a flip-up, TearTuff mesh seat with armrests paired with an oversized 30” wide x 37" deep platform and footrest providing plenty of extra room for standing shots. The unique Big Foot lever action system and noiseless strap attachment creates a secure and silent installation during your hunt.</p> <p> </p> <ul> <li>30” wide x 37” deep oversized platform for extra room</li> <li>Flip-up, TearTuff mesh seat for standing shots</li> <li>Padded armrests flip-up independently</li> <li>Footrest for leg stretching comfort</li> <li>Lever action system secures stand aggressively to the tree</li> <li>Noiseless strap attachment eliminates metal-on-metal contact</li> </ul> <p> </p> <ul> <li>Platform Size: 30' W x 37" D</li> <li>Seat Dimensions: 21" W x 13" D</li> <li>Seat Height: 23"</li> <li>Weight: 30 lbs</li> <li>Capacity: 300 lbs</li> <li>Tree Diameter Range: 8" - 20"</li> <li>Full Body Harness: Yes (1)</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	96741-DEFAULT-s.jpg	[empty string]	1000	RE560	348041	STANDS	EMPTY	EMPTY	0	0	0	TREESTANDS	[empty string]	rivers-edge-stands/brute-348041	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter