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	MARSHBROWN	BEAVERTAIL	Beavertail	HUNTING	Hunting>Accessories	MARSHBROWN\|NULL\|NULL	1	499.99	0	499.99	96580-DEFAULT-l.jpg	499.99	96580-DEFAULT-m.jpg	EXPRESS 15 TRAILER 1500LB CAP	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]	13	450-to-500	0.00	[empty string]	XPRESS 15 TRAILER	<p>Beavertail Trailers feature Dual Molded-In Power Rails for the ultimate in strength and durability. Two Aluminum I-Beam Rails are molded directly into the trailer body during the manufacturing process to serve as the anchor point for the trailer bed. No drilling holes in the polyethylene body and relying on a bolt and washer to secure your load. Rhino frames bolt directly to the Power Rails providing the highest level of strength and performance.</p> <p> </p> <ul> <li>Industry Strongest Roto-Molded Trailer Body</li> <li>Molded-In Power-Rail Frame</li> <li>Reinforced Outer Lip For Remarkable Wall Strength</li> <li>Tilt-N-Swivel Side & Rear Dumping w/ Tipper Latch</li> <li>High Clearance Frame with 3/4" Solid Steel Axle</li> <li>Steel Wheels w/ Integrated Greasable Roller Bearings</li> <li>Standard Pin Style Hitch Attachment</li> <li>Optional 2" Ball Coupler Attachment</li> <li>Tows Smoothly Behind any ATV / UTV</li> </ul> <p> </p> <ul> <li>Weight: 140 lbs</li> <li>Dimensions: 65" L x 36" W x 14" D</li> <li>Load Capacity: 1500 Pounds</li> <li>Cubic Ft. of Space: 15'</li> <li>Tires: 18" x 7" x 8" Floatation Turf Tires</li> <li>Material: 100% Virgin Polyethylene</li> <li>Tow Method: Standard Pin Style Hitch with optional 2” ball coupler</li> <li>Wheel Material: Steel</li> <li>Dump Bed: Yes</li> </ul>	[empty string]	N	499.99	499.99	65X36X14	96580-DEFAULT-s.jpg	[empty string]	1000	401314	348616	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	beavertail/xpress-15-trailer-348616	1
2	MARSHBROWN	BEAVERTAIL	Beavertail	HUNTING	Hunting>Accessories	MARSHBROWN\|NULL\|NULL	1	699.99	0	699.99	96581-DEFAULT-l.jpg	699.99	96581-DEFAULT-m.jpg	SUPER EXPRESS 20 TRAILER 1500LB CAP	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]	14	500-or-more	0.00	[empty string]	SUPER XST TRAILER	<p>The Beavertail XST Trailer can haul up to 20 Cubic Feet and 1500 Pounds! This is the most rugged trailer that we offer at Beavertail. Beavertail Trailers are purpose-built for consistent, heavy-duty use in all seasons and for a multitude of uses including farm and ranch, landscaping, hunting, fishing or any hauling need. Trailers tow smoothly behind any ATV, garden tractor or small utility vehicle.</p> <p> </p> <ul> <li>Industry Strongest Roto-Molded Trailer Body</li> <li>Molded-In Power-Rail Frame</li> <li>Reinforced Outer Lip For Remarkable Wall Strength</li> <li>Tilt-N-Swivel Side & Rear Dumping w/ Tipper Latch</li> <li>High Clearance Axle</li> <li>4-Bolt Hub Assembly w/ Greasable Tapered Roller Bearings</li> <li>Standard 2″ Ball Coupler</li> <li>Tows Smoothly Behind any ATV / UTV</li> </ul> <p> </p> <ul> <li>Weight: 176 lbs</li> <li>Dimensions: 65" L x 46" W x 14" D</li> <li>Load Capacity: 1500 Pounds</li> <li>Cubic Ft. of Space: 20'</li> <li>Tires: 18" x 9.5" x 8" Flotation Turf Tires</li> <li>Material: 100% Virgin Polyethylene</li> <li>Tow Method: Standard 2” ball coupler</li> <li>Wheel Material: Steel</li> <li>Dump Bed: Yes</li> </ul>	[empty string]	N	699.99	699.99	65X46X14	96581-DEFAULT-s.jpg	[empty string]	1000	401317	348618	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	beavertail/super-xst-trailer-348618	1
3	MARSHBROWN	BEAVERTAIL	Beavertail	WATERSPORTS	Watersports>Kayaks	MARSHBROWN\|NULL\|NULL	1	799.99	0	799.99	96589-DEFAULT-l.jpg	799.99	96589-DEFAULT-m.jpg	STEALTH 1200 SNEAK BOAT	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]	5	500-or-more	0.00	[empty string]	STEALTH 1200 SNEAKBOAT / KAYAK	<p>Beavertail’s Stealth 1200 Sneak Boat is designed for 1 person with an optional 2nd seat available. Features an air-filled inner structure and the twin hull catamaran style bottom provides ultimate stability for sitting or standing, throwing decoys or shooting, yet floats in only 4-5 inches of water.  The Stealth 1200 can be propelled with a push pole, paddles or an electric trolling motor.</p> <p> </p> <ul> <li>100% Thick and Rugged Roto-Molded Polyethylene</li> <li>Air-Filled Inner Structure</li> <li>Catamaran Style Bottom For Outstanding Stability</li> <li>Water-Resistant Storage Compartments – Front & Rear</li> <li>Single Interior Gun Rack and Shell Holder</li> <li>Decoy Slots – Both Sides</li> <li>Contoured Seat</li> <li>Non-Skid Floor</li> <li>Side Storage Compartments</li> <li>Tie-Down Slots – Front & Rear</li> <li>Handles – Front & Rear</li> <li>Motor Mount Compatible (SKU: 400222)</li> <li>Blind Compatible (SKU: 401354)</li> </ul> <p> </p> <ul> <li>Weight: 140 lbs</li> <li>Dimensions: 12' L x 44" W x 17" D</li> <li>Cockpit: 8' L x 27" W x 13" D</li> <li>Weight Capacity: 550 lbs (motor, persons, gear)</li> <li>Gun Rack Capacity: 1</li> <li>Seat Included: Molded In</li> <li>Dog Platform: No</li> <li>People Capacity: 1 person with optional 2nd seat</li> <li>Storage Compartments: 2 total (1 front, 1 rear)</li> <li>Max. Motor Size: 2HP</li> <li>Material: 100% Thick & Rugged Roto-Molded Polyethylene</li> </ul>	[empty string]	N	799.99	799.99	144X44X17	96589-DEFAULT-s.jpg	[empty string]	1000	400083	359891	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	beavertail/stealth-1200-sneakboat-kayak-359891	1
4	MARSHBROWN	BEAVERTAIL	Beavertail	WATERSPORTS	Watersports>Kayaks	MARSHBROWN\|NULL\|NULL	1	999.99	0	999.99	96582-DEFAULT-l.jpg	999.99	96582-DEFAULT-m.jpg	STEALTH 2000 SNEAK BOAT	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]	8	500-or-more	0.00	[empty string]	STEALTH 2000 SNEAKBOAT / KAYAK	<p>The Stealth 2000 is a Beavertail Sneak Boat that is designed for 1-2 persons or 1 person + 1 dog. Feature a foam-padded dog platform, foam-filled inner structure and the catamaran style bottom provides ultimate stability for sitting standing, throwing decoys or shooting, yet floats in only 4-5 inches of water.  The Stealth 2000 can be propelled with a push pole, paddles or an electric trolling motor.</p> <p> </p> <ul> <li>100% Thick and Rugged Roto-Molded Polyethylene</li> <li>Foam-Filled Inner Structure</li> <li>Catamaran Style Bottom For Outstanding Stability</li> <li>Foam Padded Dog Platform-Front</li> <li>Water-Resistant Storage Compartment-Rear</li> <li>Double Interior Gun Racks and Shell Holders</li> <li>360 Degree Cushioned Swivel Seat with Folding BackRest</li> <li>Non-Skid Floor</li> <li>Side Storage Compartment</li> <li>Tie-Down Slots – Front and Rear</li> <li>Handles-Front and Rear</li> <li>Motor Mount Compatible (SKU: 400223)</li> <li>Blind Compatible (SKU: 401354 & 401355)</li> </ul> <p> </p> <ul> <li>Weight: 150 lbs</li> <li>Dimensions: 12' L x 44" W x 15" D</li> <li>Cockpit: 8' L x 36" W x 10" D</li> <li>Weight Capacity: 460 lbs (motor, persons, gear)</li> <li>Gun Rack Capacity: 2</li> <li>Seat Included: Padded Swivel Seat</li> <li>Dog Platform: Yes</li> <li>People Capacity: 1-2 people or 1 person + 1 dog</li> <li>Storage Compartments: 1 in rear</li> <li>Max. Motor Size: 2HP</li> <li>Material: 100% Thick & Rugged Roto-Molded Polyethylene</li> </ul>	[empty string]	N	999.99	999.99	144X44X15	96582-DEFAULT-s.jpg	[empty string]	1000	400091	359892	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	beavertail/stealth-2000-sneakboat-kayak-359892	1
5	[empty string]	BEAVERTAIL	Beavertail	WATERSPORTS	Watersports>Accessories	[empty string]	1	69.99	0	69.99	96583-DEFAULT-l.jpg	69.99	96583-DEFAULT-m.jpg	STEALTH 1200 SNEAK BOAT MOTOR MOUNT	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]	3	50-to-100	0.00	[empty string]	STEALTH 1200 MOTOR MOUNT	<p>Allows the use of an electric trolling Motor or small outboard on the Stealth 1200. Boat is rated for a 2HP motor.</p> <p> </p> <ul> <li>Weight: 6 lbs</li> <li>Dimensions: 18" × 12" × 9"</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	96583-DEFAULT-s.jpg	[empty string]	1000	400222	359893	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	beavertail/stealth-1200-motor-mount-359893	1
6	[empty string]	BEAVERTAIL	Beavertail	WATERSPORTS	Watersports>Accessories	[empty string]	1	69.99	0	69.99	96584-DEFAULT-l.jpg	69.99	96584-DEFAULT-m.jpg	STEALTH 2000 SNEAK BOAT MOTOR MOUNT	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]	4	50-to-100	0.00	[empty string]	STEALTH 2000 MOTOR MOUNT	<p>Allows the use of an electric trolling Motor or small outboard on the Stealth 2000. Boat is rated for a 2HP motor.</p> <p> </p> <ul> <li>Weight: 6 lbs</li> <li>Dimensions: 18" × 12" × 9"</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	96584-DEFAULT-s.jpg	[empty string]	1000	400223	359894	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	beavertail/stealth-2000-motor-mount-359894	1
7	MARSHBROWN	BEAVERTAIL	Beavertail	WATERSPORTS	Watersports>Accessories	MARSHBROWN\|NULL\|NULL	1	219.99	0	219.99	96585-DEFAULT-l.jpg	219.99	96585-DEFAULT-m.jpg	STEALTH 1200 SNEAK BOAT SEAT BOX	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]	7	200-to-250	0.00	[empty string]	STEALTH 1200 SEAT	<p>These cushioned seats feature 360 degree swivel action and a folding back rest. Poly base conforms to the grooves on the floor of your Stealth boat and is large enough to accommodate a marine battery or may be used for dry storage. This seat can also be used as a stand alone seat while field hunting.</p> <p> </p> <ul> <li>Weight: 20 lbs</li> <li>Dimensions: 23" × 23" × 21"</li> </ul>	[empty string]	N	219.99	219.99	[empty string]	96585-DEFAULT-s.jpg	[empty string]	1000	400256	359895	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	beavertail/stealth-1200-seat-359895	1
8	MARSHBROWN	BEAVERTAIL	Beavertail	WATERSPORTS	Watersports>Accessories	MARSHBROWN\|NULL\|NULL	1	219.99	0	219.99	96586-DEFAULT-l.jpg	219.99	96586-DEFAULT-m.jpg	STEALTH 2000 SNEAK BOAT SEAT BOX	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]	7	200-to-250	0.00	[empty string]	STEALTH 2000 SEAT	<p>These cushioned seats feature 360 degree swivel action and a folding back rest. Poly base conforms to the grooves on the floor of your Stealth boat and is large enough to accommodate a marine battery or may be used for dry storage. Beavertail's Stealth 2000 Seat features a molded-in cup holder and small storage compartment.</p> <p> </p> <ul> <li>Weight: 25 lbs</li> <li>Dimensions: 36.5" × 21" × 20.5"</li> </ul>	[empty string]	N	219.99	219.99	[empty string]	96586-DEFAULT-s.jpg	[empty string]	1000	400257	359896	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	beavertail/stealth-2000-seat-359896	1
9	KARMAWETLAND	BEAVERTAIL	Beavertail	WATERSPORTS	Watersports>Accessories	KARMAWETLAND\|NULL\|NULL	1	429.99	0	429.99	96587-DEFAULT-l.jpg	429.99	96587-DEFAULT-m.jpg	STEALTH BLIND FOR 1200 2000 SNEAK BOAT	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]	5	400-to-450	0.00	[empty string]	STEALTH FLIP-OVER BLIND	<p>At Beavertail, we know blinds. It all began with “the Original Flip-Over Blind” which has set the benchmark in the industry for rapid deploy, fold over boat blinds. This blind can literally be set up or knocked down in seconds and folds down completely out of the way, which means no hassling with poles or tucking in extra material. Inside the blind you’ll find more than enough head-room for you and a partner to not only sit comfortably, but make the shot when it counts.</p> <p> </p> <ul> <li>Fits Stealth 1200 and Stealth 2000 Sneak Boats</li> <li>Fold-over aluminum frame construction</li> <li>Shooting holes on top and side</li> <li>Rapid no hassle deployment or knock down</li> <li>Roomy interior for you and your gear</li> <li>Dog doors on both ends</li> <li>Built-in vegetation straps</li> </ul> <p> </p> <ul> <li>Weight: 13 lbs</li> <li>Dimensions: 37" × 18" × 6"</li> </ul>	[empty string]	N	429.99	429.99	[empty string]	96587-DEFAULT-s.jpg	[empty string]	1000	401354	359897	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	beavertail/stealth-flip-over-blind-359897	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter