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]	CAJUN ARCHERY	Cajun Archery	ARCHERY	Archery>Bowfishing>Reels and Reel Accessories	[empty string]	1	26.99	0	26.99	103162-DEFAULT-l.jpg	26.99	103162-DEFAULT-m.jpg	CAJUN SCREW ON DRUM BOWFISHING REEL	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Screw-On Drum Reel	<p>Everything they make is built to make the most of it. When you're out, deep into what's right and natural, they're right there with you. Pick up your Cajun products, head for the water, and know you're about to have the best, most satisfying fun time of your life. Another time-tested Cajun Archery product, the Screw-On Drum Reel mounts into the bow stabilizer bushing with a center bolt and includes 50' of 80-lb tested braided line.</p> <p> </p> <ul> <li> <h3>MAXIMUM DURABILITY                Screw-On Drum Reel is made from an all-metal construction</h3> </li> <li> <h3>PREMIUM MATERIALS                  The Screw-On Drum reel has a 5" diameter and is all-aluminum</h3> </li> <li> <h3>EASY INSTALLATION                     Drum reel mounts into the bow stabilizer bushing with a center bolt</h3> </li> <li> <h3>DURABLE FISHING LINE                Includes 50' of 80 lb. test braided line</h3> </li> <li> <h3>ZERO WORRIES                              Backed by a limited lifetime warranty</h3> </li> </ul>	[empty string]	N	26.99	26.99	[empty string]	103162-DEFAULT-s.jpg	[empty string]	1000	ABF4010	284095	REELS AND REEL ACCESSORIES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cajun-archery/screw-on-drum-reel-284095	1
2	[empty string]	CAJUN ARCHERY	Cajun Archery	ARCHERY	Archery>Bowfishing>Reels and Reel Accessories	[empty string]	1	59.99	0	59.99	103159-DEFAULT-l.jpg	59.99	103159-DEFAULT-m.jpg	CAJUN SPIN DOCTOR BOWFISHING REEL	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Spin Doctor Bowfishing Reel	<p>The all-new and improved Cajun Spin Doctor Reel isone of the most durable and innovative spincast bowfishing reel on the market. The reel is designed to endure the rigors of the sport with dual pickup pins with full metal assembly and a longer hood and larger hole design for better line feeding.</p> <p> </p> <ul> <li> <h3>ULTIMATE PERFORMANCE           Cajun bowfishing spinning reel with pre-spooled 150 lb. fast flight line</h3> </li> <li> <h3>INNOVATIVE DESIGN                      Longer hood design and larger hole for better line feeding</h3> </li> <li> <h3>EXTREME DURABILITY                   Dual pickup pins with full metal assembly</h3> </li> <li> <h3>INCREASED PERFORMANCE          Faster pickup for faster reeling</h3> </li> <li> <h3>TANGLE RESISTENT                         One-sided handle prevents tangling</h3> </li> </ul>	[empty string]	N	59.99	59.99	[empty string]	103159-DEFAULT-s.jpg	[empty string]	1000	AACL1800U	312010	REELS AND REEL ACCESSORIES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cajun-archery/spin-doctor-bowfishing-reel-312010	1
3	[empty string]	CAJUN ARCHERY	Cajun Archery	ARCHERY	Archery>Bowfishing>Bows	[empty string]	1	349.99	0	349.99	102945-DEFAULT-l.jpg	349.99	102945-DEFAULT-m.jpg	SHORERUNNEREXT KIT W/WINCHPRO BOW 45 RH/LH	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2014	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	300-to-350	0.00	[empty string]	Shore Runner Ext Kit With Winch Pro Reel Right Hand	<p>Whether you like to snap and shoot or your bowfishing style is as simple as holding back and letting the fish come to you, the Shore Runner Ext is a sure thing. The constant draw cam provides easy tuning no matter your draw length out to 29 inches doesn't need a bow press for adjustments. Measuring 30 inches long with a peak draw weight of 50 lbs., the Shore Runner Ext comes equipped with all-new Cajun Bowfishing accessories including the Winch Pro bottle reel, Brush Fire arrow rest, Blister Buster finger pads, and a Piranha arrow and point. Start stik’n with this smooth drawing, easy shooting bow!</p> <p> </p> <ul> <li>Constant draw cam does not require bow press for adjustments</li> <li>Deep cam grooves prevent derailed strings</li> <li>30 inches axle-to-axle</li> <li>50lb peak draw weight at 29-inch draw length</li> <li>Kit includes: Brush Fire Arrow Rest, Winch Pro Bottle Reel, Blister Buster Finger Pads, 1 Red Fiberglass Piranha Arrow</li> </ul>	[empty string]	N	349.99	349.99	[empty string]	102945-DEFAULT-s.jpg	[empty string]	1000	A20CB202045R	364660	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cajun-archery/shore-runner-ext-kit-with-winch-pro-reel-right-hand-364660	1
4	[empty string]	CAJUN ARCHERY	Cajun Archery	ARCHERY	Archery>Bowfishing>Reels and Reel Accessories	[empty string]	1	79.99	0	79.99	103165-DEFAULT-l.jpg	79.99	103165-DEFAULT-m.jpg	SPIN MASTER RH/LH	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2014	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Spin Master Bowfishing Reel RH/LH	<p>Built to provide you withÂ greater durabilityÂ and a better performing spincast reel while out on the water. The Spin Master Reel features a compact design with an elongated hood and larger frontÂ line opening. The new design provides smoother ejection and line feeding when reeling in that river monster. The new Cajun Bowfishing Spin Master reel is engineered with solid mounted dual pick up pins to effectively grab slack line, ensuring smoother/faster retrievals of your catch.</p> <ul> <li>Tangle resistant</li> <li>Pre-spooled with 150 lb fast flight line</li> <li>Ergonomic foam handle</li> <li><strong>Color:</strong> black</li> </ul>	[empty string]	N	79.99	79.99	[empty string]	103165-DEFAULT-s.jpg	[empty string]	1000	ABF1100SCR	364661	REELS AND REEL ACCESSORIES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cajun-archery/spin-master-bowfishing-reel-rh-lh-364661	1
5	[empty string]	CAJUN ARCHERY	Cajun Archery	ARCHERY	Archery>Bowfishing>Reels and Reel Accessories	[empty string]	1	26.99	0	26.99	103160-DEFAULT-l.jpg	26.99	103160-DEFAULT-m.jpg	CAJUN REEL SEAT	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Reel Seat	<p>The Cajun Bowfishing Reel Seat feature machine anodized hoods making this their toughest reel seat. The reel seat screws into the bow stabilizer bushing and the threaded end provides for a fishing rod attachment.</p> <p> </p> <ul> <li> <h3>PREMIUM MATERIALS             Machine anodized hoods make this their toughest reel seat</h3> </li> <li> <h3>EASY INSTALL                           Screws into the bow stabilizer bushing</h3> </li> <li> <h3>INNOVATIVE DESIGN                Threaded end provides for a fishing rod attachment</h3> </li> <li> <h3>EXTREME DURABILITY             Constructed of corrosion resistant material</h3> </li> <li> <h3>MAXMIUM PERFORMANCE       Dual locking reel lugs for a secure fit</h3> </li> </ul>	[empty string]	N	26.99	26.99	[empty string]	103160-DEFAULT-s.jpg	[empty string]	1000	ABF100RS	370805	REELS AND REEL ACCESSORIES	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cajun-archery/reel-seat-370805	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter