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]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	46.99	0	46.99	[empty string]	46.99	[empty string]	SCOTTY BAIT/SPIN ROD HOLD/ W FLUSH DECK	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Slidetrax Universal Mounting Plate With Rod Holder	<p>The SlideTrax Universal Mounting Plate with Rod Holder is a two-in-one package, including a Universal Mounting plate and your choice of either a Scotty Baitcaster of Fly Rod Holder. The Mounting Plate is designed to fit Wilderness Systems SlideTrax-equipped boats.</p>	[empty string]	N	46.99	46.99	[empty string]	[empty string]	[empty string]	1000	8023067	135917	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/scotty-bait-spin-rod-hold-w-flush-deck-135917	1
2	BLUE/WHITE,RED/YELLOW	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	BLUE/WHITE\|NULL\|NULL,RED/YELLOW\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	KAYAK PADDLE ALUMINUM TAKE APART SHAFT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Sea Passage - Aluminum	<p>The Sea Passage Paddle works well in everything from placid lakes to rough seas with it`s moderate-sized asymmetrical blades. It is suitable for both high and low angle paddling styles. The Sea Passage is one of Harmony Gear`s most popular touring paddles and for good reason.</p>	[empty string]	N	69.99	69.99	235	[empty string]	[empty string]	1000	SEA PASSAGE ALUMINUM	156121	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/kayak-paddle-aluminum-take-apart-shaft-156121	1
3	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	26.99	0	26.99	[empty string]	26.99	[empty string]	RAM BAIT CAST ROD HOLDER	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Ram Bait Caster Rod Holder	Specifically designed with kayak anglers in mind, the Ram Bait Caster Rod Holder accommodates spinning reels for a wide variety of fishing applications. The unique design enables quick insertion and removal of a rod.<br/> <br/> NOTE: ROD AND REEL NOT INCLUDED<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	26.99	26.99	[empty string]	[empty string]	[empty string]	1000	8023515	156138	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/ram-bait-cast-rod-holder-156138	1
4	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	26.99	0	26.99	[empty string]	26.99	[empty string]	RAM TUBE ROD HOLDER	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Ram Tube Rod Holder	[empty string]	[empty string]	N	26.99	26.99	[empty string]	[empty string]	[empty string]	1000	8023517	156139	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/ram-tube-rod-holder-156139	1
5	TURQ/LIME,RED/YEL,BLUE/WHITE	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	TURQ/LIME\|NULL\|NULL,RED/YEL\|NULL\|NULL,BLUE/WHITE\|NULL\|NULL	0	114.99	0	114.99	[empty string]	114.99	[empty string]	KAYAK PADDLE FIBERGLASS TAKE APART SHAFT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	14	100-to-150	0.00	[empty string]	Sea Passage - Fiberglass	<p>Explore your paddling abilities with the Sea Passage from Harmony. This paddle is suitable for any paddling style and produces smooth, responsive and flutter-free strokes. With the corrosion resistant aluminum alloy and fiberglass reinforced blades you can be sure that the Sea Passage will be durable for many years to come.</p>	[empty string]	N	114.99	114.99	235,215	[empty string]	[empty string]	1000	SEA PASSAGE FIBERGLASS	172198	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/kayak-paddle-fiberglass-take-apart-shaft-172198	1
6	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	KEEPERS FOOT BRACE KIT XL	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Keepers Foot Brace Kit Xl	[empty string]	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	8023791	248437	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/keepers-foot-brace-kit-xl-248437	1
7	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	WILDY FLEX ARM LED LIGHT	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2019	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Wilderness Systems - Flex-arm Led	<p>The Flex-Arm LED Light rede?nes what a light can do in a kayak. Featuring a 2 foot ?exible yet stable plastic arm, the LED light can be precisely aimed anywhere - vertically for visibility, towards the deckas work station lighting, or bent into the water as a ?sh attractant. The 300 lumens light is exceptionally bright with adjustable beams of green and white ?lters, and is easily poweredby battery or USB.</p> <p> </p> <p>-Versatile kayak and fishing light<br /> -SlideTrax compatible<br /> -300 lumen light has green and white filters<br /> -Can be submersed to use as a fish attractant<br /> -Quick connects at both ends</p>	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	8070063	278087	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/wildy-flex-arm-led-light-278087	1
8	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	13.99	0	13.99	[empty string]	13.99	[empty string]	WILDY ROD STAGER	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2019	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Wilderness Systems - Rod Stager	<p>The Wilderness Systems Rod Stager keeps your rods safely stored in the hull of your ATAK or Thresher. The soft foam gently holds your rods securely to prevent rolling. It has a peel-and-stick adhesive bottom so it can be easily applied to anywhere you want. The rod stager can be used in any boat with hull access.</p> <p> </p> <p>-Keeps your rods safely stored in the hull of your ATAK or Thresher<br /> -Install in the rectangular hatch to keep rods from rolling<br /> -Peel and stick adhesive bottom<br /> -Can be used in any kayak with hull access</p>	[empty string]	N	13.99	13.99	[empty string]	[empty string]	[empty string]	1000	8070017	278090	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/wildy-rod-stager-278090	1
9	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	PADDED FOOT BRACE SET	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	[empty string]	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Wilderness Systems - Padded Foot Padals	<p>The Wilderness Systems Padded Foot Pedals are molded pliable rubber foot pedal pads that replace existing foot pedals and enhance paddling comfort, particularly on ruddered kayaks where foot pressure is a constant discomfort. Firm enough to maintain ``feel`` and control of the kayak, but soft enough to pamper the paddler`s feet.</p>	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	8023041	278101	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/padded-foot-brace-set-278101	1
10	BLACK	HARMONY	Harmony	WATERSPORTS	Watersports>Paddles	BLACK\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	PADDLE OUTLAW ADJUSTABLE 230-250	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	ADULT SIGNATURE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Paddle Outlaw Adjustable 230-250	[empty string]	[empty string]	N	99.99	99.99	230/250	[empty string]	[empty string]	1000	8080064	331677	EMPTY	EMPTY	EMPTY	0	0	0	PADDLES	[empty string]	harmony/paddle-outlaw-adjustable-230-250-331677	1
11	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	SIT ON TOP SECURITY CABLE 55 INCH	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Sit On Top Security Cable 55 Inch	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	8027092	351134	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/sit-on-top-security-cable-55-inch-351134	1
12	[empty string]	HARMONY	Harmony	WATERSPORTS	Watersports>Accessories	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	SIT INSIDE SECURITY CABLE 47 INCH	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Sit Inside Security Cable 47 Inch	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	8027093	351135	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	harmony/sit-inside-security-cable-47-inch-351135	1

CACHED

false

EXECUTIONTIME

1

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter