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]	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Accessories	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	KAYAK HANDLES KIT	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	PROP 65	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Contoured Carrying Handles	<p>Old Town`s padded, contoured carry handles take the pain out of carrying a kayak. Their custom contoured design fits any hand allowing a solid non slip grip.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	01.1332.4200	100851	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	old-town/kayak-handles-kit-100851	1
2	[empty string]	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Accessories	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	DRAIN PLUG KIT	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]	SELL THRU	PROP 65	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Drain Plug Kit	<p>The Drain Plug Kit is made for Old Town Dirigo and Vapor kayaks; with hardware and installation instructions included.</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	01.1331.2025	172214	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	old-town/drain-plug-kit-172214	1
3	[empty string]	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Accessories	[empty string]	0	279.99	0	279.99	[empty string]	279.99	[empty string]	STEADY STAND BAR FOR PREDATOR	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	250-to-300	0.00	[empty string]	Predator Steady Stand Bar	The Predator Steady Stand Bar offers additional support when out of the seat.<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	279.99	279.99	[empty string]	[empty string]	[empty string]	1000	01.1332.0021	172215	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	old-town/steady-stand-bar-for-predator-172215	1
4	[empty string]	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Accessories	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	DOUBLE BLOCK MOTOR MOUNT 38IN	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]	SELL THRU	PROP 65	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	Predator Double Block Motor Mount - 38 Inch	<p>The Predator Minn Kota Trolling Motor Mount makes it easy to add power.</p>	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	01.1315.3628	179764	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	old-town/double-block-motor-mount-38in-179764	1
5	[empty string]	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Accessories	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	WEB SEAT BOW/STEARN WIDER	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	PROP 65	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Web Seat - Generic - 34 Inch	<p>The Generic Web Seat can be cut to fit. Made in Maine of white ash and nylon webbing, this seat is a great replacement option for your canoe.</p> <p> </p> <p>NOTE: May require trimming and drilling for proper fit</p>	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	01.1315.2602	243979	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	old-town/web-seat-bow-stearn-wider-243979	1
6	GREEN	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Canoes	GREEN\|NULL\|NULL	0	949.99	0	949.99	[empty string]	949.99	[empty string]	CANOE 14.7FT 82LBS CAP 900LBS	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]	SELL THRU	PROP 65	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Guide 147 - 14 Feet 7 Inches	<p>Old Town`s popular Guide 147 represents a breakthrough in design and construction that provides a durable, stiff and affordable canoe. With its unique cross-section and stabilizing chines, the Guide 147 delivers exceptional stability, as well as rugged durability. And its sharp entry provides a surprisingly efficient paddling canoe. Stable enough for fishing or nature watching, yet versatile enough for family outings - all at an affordable price!</p>	[empty string]	N	949.99	949.99	[empty string]	[empty string]	[empty string]	1000	GUIDE 147	247997	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	old-town/canoe-14-7ft-82lbs-cap-900lbs-247997	1
7	SUNRISE,PHO-DISC	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Kayaks	SUNRISE\|NULL\|NULL,PHO-DISC\|NULL\|NULL	0	1399.99	0	1399.99	[empty string]	1399.99	[empty string]	KAYAK 13.5FT 50LBS CAP 300LBS	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	PROP 65	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	Castine 135 - 13 Feet 5 Inches	<p>The Old Town Castine is a day touring kayak that comes in three different sizes, making it easier to find a model that fits just right. Built for the perfect balance of comfort and performance, all three models feature the all-new Slide-Away Day Hatch, adjustable thigh braces, and with the ACS2 Seat you’ll feel like you’re floating on a cloud all day long.</p>	[empty string]	N	1399.99	1399.99	[empty string]	[empty string]	[empty string]	1000	CASTINE 135	293047	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	old-town/kayak-13-5ft-50lbs-cap-300lbs-293047	1
8	LEMONGRASS,PHOTIC	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Kayaks	LEMONGRASS\|NULL\|NULL,PHOTIC\|NULL\|NULL	0	1449.99	0	1449.99	[empty string]	1449.99	[empty string]	KAYAK 14FT 53LBS CAP 375LBS	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	PROP 65	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	Castine 140 - 14 Feet	<p>The Old Town Castine is a day touring kayak that comes in three different sizes, making it easier to find a model that fits just right. Built for the perfect balance of comfort and performance, all three models feature the all-new Slide-Away Day Hatch, adjustable thigh braces, and with the ACS2 Seat you’ll feel like you’re floating on a cloud all day long.</p>	[empty string]	N	1449.99	1449.99	[empty string]	[empty string]	[empty string]	1000	CASTINE 140	293048	EMPTY	EMPTY	EMPTY	0	0	0	KAYAKS	[empty string]	old-town/kayak-14ft-53lbs-cap-375lbs-293048	1
9	SILVER/AQUA	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SILVER/AQUA\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	PFD WMS SOLITUDE	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]	SELL THRU	PROP 65	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Solitude - Women`s	<p>Women’s-Specific Performance High-Back Life Jacket. Designed with the performance female paddler in mind, the Solitude jacket comes equipped with many features and adjustments that are designed to keep you on the water in comfort longer.</p>	[empty string]	N	129.99	129.99	L/XL,ONE SZ FITS ALL	[empty string]	[empty string]	1000	WMS SOLITUDE	296970	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	old-town/pfd-wms-solitude-296970	1
10	BLK/CHAR	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLK/CHAR\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	PFD MENS SOLITUDE	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]	SELL THRU	PROP 65	[empty string]	[empty string]	7	100-to-150	0.00	[empty string]	Solitude - Men`s	<p>Performance High-Back Life Jacket. Designed with the performance paddler in mind, the Solitude jacket comes equipped with many features and adjustments that are designed to keep you on the water in comfort longer.</p>	[empty string]	N	129.99	129.99	L/XL,S/M,2X/3X	[empty string]	[empty string]	1000	MENS SOLITUDE	296972	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	old-town/pfd-mens-solitude-296972	1
11	GREY	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Flotation Devices (PFDs)	GREY\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	PFD LUHR ANGLER	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]	SELL THRU	PROP 65	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Lure Angler	<p>Performance High-Back Fishing Life Jacket. Designed with the performance kayak angler in mind, the Lure Angler jacket comes equipped with many features and adjustments that are designed to keep you fishing in comfort longer. Featuring a high-back construction, which nests comfortably with tall kayak seats and the AirComfort system to keep you cool on the hottest days.</p>	[empty string]	N	139.99	139.99	2X/3X	[empty string]	[empty string]	1000	LURE ANGLER	318047	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	old-town/pfd-luhr-angler-318047	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

Filter