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	BLUE	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLUE\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	4 BUCKLE NYLON PRO VEST	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]	4	25-to-50	0.00	[empty string]	Men`s 4 Belt Pro - Large - 40`- 44`	<p>FEATURES:<br /> -Soft, flexible foam core for outstanding comfort<br /> -Sturdy nylon exterior for durability<br /> -4 buckles for security and excellent fit<br /> -Big armholes allow a wide range of motion<br /> -U.S. Coast Guard approved<br />  </p>	[empty string]	N	39.99	39.99	LG	[empty string]	[empty string]	1000	2111806	125820	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/4-buckle-nylon-pro-vest-125820	1
2	BLUE	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLUE\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	4 BUCKLE NYLON PRO VEST	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]	Men`s 4 Belt Pro - 2xl - 48	<p>FEATURES:<br /> -Soft, flexible foam core for outstanding comfort<br /> -Sturdy nylon exterior for durability<br /> -4 buckles for security and excellent fit<br /> -Big armholes allow a wide range of motion<br /> -U.S. Coast Guard approved</p>	[empty string]	N	39.99	39.99	2XL	[empty string]	[empty string]	1000	2111808	125822	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/4-buckle-nylon-pro-vest-125822	1
3	LIME	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	LIME\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.99	[empty string]	NYLON TEEN VEST 28-32IN	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	ONLINE	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Teen Nylon Life Jacket - 28-32 Inch	<p>FEATURES:<br /> -Soft, flexible foam core<br /> -200D polyester exterior<br /> -Three belts for security<br /> -U.S. Coast Guard Approved</p>	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	2171897	125831	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/nylon-teen-vest-28-32in-125831	1
4	[empty string]	MUSTANG SURVIVAL	Mustang Survival	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	32.99	0	32.99	[empty string]	32.99	[empty string]	RE-ARM KIT FOR MD-2016 20GRAM	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	PICK-UP ONLY	[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]	2	25-to-50	0.00	[empty string]	Re-arm Kit - M.i.t. 100 Inflatable Pfd	This re-arming kit contains everything you need to re-arm your Mustang Survival M.I.T. 100 manual and automatic inflatable PFD after it`s been deployed. The automatic inflator bobbin on all automatic PFDs should be replaced on a regular basis.<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	32.99	32.99	[empty string]	[empty string]	[empty string]	1000	MA-2014	171311	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	mustang-survival/re-arm-kit-for-md-2016-20gram-171311	1
5	[empty string]	MUSTANG SURVIVAL	Mustang Survival	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	RE-ARM KIT FOR MD-3075 33 GRAM	N	4 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	PICK-UP ONLY	[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]	Re-arm Kit For Md-3075 33 Gram	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	MA7114	171313	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	mustang-survival/re-arm-kit-for-md-3075-33-gram-171313	1
6	PINK	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PINK\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	NYLON CHILD VEST W/COLLAR 30-50 LBS	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	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Child Nylon Life Jacket With Collar	<p>FEATURES:<br /> -Collar with grab strap for safety<br /> -150D polyester exterior<br /> -Three belts for security<br /> -Leg loop strap with buckle<br /> -U.S. Coast Guard Approved Type II</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	2171732	175047	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/nylon-child-vest-w-collar-30-50-lbs-175047	1
7	PURPLE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PURPLE\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	WMS FLO PURPLE PFD PADDLERS	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]	3	50-to-100	0.00	[empty string]	Flo	<p>The EBB is one of Stohlquist`s most popular women’s specific PFDs, now offered in Graded Sizing for the ultimate fit. The higher mesh back design fits more comfortably above the taller seat backs found in today’s rec/touring kayaks. A revised women’s specific cup design also provides a more appropriate fit for a wider range of sizes; from teens and petites, to plus size paddlers.</p> <p> </p> <p>-Supportive inner cup design<br /> -Graded Sizing provides a more appropriate fit for all body types<br /> -Ergonomic WRAPTURE shaped torso<br /> -Cross-chest cinch harness for zero ride-up<br /> -Mesh shoulders & back for maximum ventilation<br /> -Two large, front bellows pockets <br /> -Adjustable shoulder and side pulls<br /> -Lightweight (PVC Free) PE Foam<br /> -Higher, mesh back design for tall seats<br /> -Open sides for maximum ventilation<br /> -Entry grip tab at zipper base<br /> -Sea level buoyancy of 16 lbs 4 oz<br /> -US Coast Guard Approved</p>	[empty string]	N	99.99	99.99	PLUS,XS/SM	[empty string]	[empty string]	1000	FLO	249573	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-flo-purple-pfd-paddlers-249573	1
8	SUN/GRAY	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SUN/GRAY\|NULL\|NULL	0	89.99	0	89.99	[empty string]	89.99	[empty string]	WMS MISTY PFD SUN/GRAY	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	ONLINE	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Misty	<p>Along with Stohlquist`s Graded Sizing, the Misty features a Thin Back Design offering more coverage and ensuring compatibility with any seat back style. The Misty is great for use with boats that feature a higher seat back, but are right at home in a touring boat with sprayskirt.</p>	[empty string]	N	89.99	89.99	S	[empty string]	[empty string]	1000	MISTY	260163	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-misty-pfd-sun-gray-260163	1
9	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	8.99	0	8.99	[empty string]	8.99	[empty string]	LIFE VEST TYPE II YOUTH KEYHOLE ORANGE	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	ONLINE	[empty string]	[empty string]	7	5-to-10	0.00	[empty string]	Type Ii Keyhole Life Vest - Youth	<p>FEATURES:<br /> -Open Sides Adjustable 1" belt<br /> -Not for waterskiing, tubing or PWCs<br /> -Foam PE Size: Youth<br /> -USCG Approved type II</p>	[empty string]	N	8.99	8.99	[empty string]	[empty string]	[empty string]	1000	10000-03-A-OR	274214	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/life-vest-type-ii-youth-keyhole-orange-274214	1
10	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	8.99	0	9.99	[empty string]	8.99	[empty string]	LIFE VEST TYPE II ADULT KEYHOLE ORANGE	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	ONLINE	[empty string]	[empty string]	30	5-to-10	0.00	[empty string]	Type Ii Keyhole Life Vest - Adult	<p>FEATURES:<br /> -Open Sides Adjustable 1" belt<br /> -Not for waterskiing, tubing or PWCs<br /> -Foam PE Size: Adult<br /> -USCG Approved type II</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	10000-15A-OR-NS	274216	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/life-vest-type-ii-adult-keyhole-orange-274216	1
11	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	LIFE VEST TYPE II ADULT ORANGE 4 PK.	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	ONLINE	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Type Ii Keyhole Life Vest - Adult - 4 Pack	<p>FEATURES:<br /> -Open Sides Adjustable 1" belt<br /> -Not for waterskiing, tubing or PWCs<br /> -Foam PE Size: Adult<br /> -USCG Approved type II</p>	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	10000-25-A-OR	274218	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/life-vest-type-ii-adult-orange-4-pk-274218	1
12	CAMO	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	CAMO\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	YOUTH SPORT VEST CMO	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	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Sportsman Camo Life Vest - Youth	<p>FEATURES:<br /> -Open sides made with durable polyester fabric<br /> -2 Sturdy adjustable belts with side release buckles<br /> -2 large oversized pockets with a d-ring<br /> -USCG approved TYPE III</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	10004-03-A-CM	276960	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/youth-sport-vest-cmo-276960	1
13	BLUE,RED	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLUE\|NULL\|NULL,RED\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	ADULT SWOOSH KWIK DRY NEOLITE FLEX VEST	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]	9	50-to-100	0.00	[empty string]	Swoosh Neolite Kwik-dry Life Vest - Adult	<p>This USCG approved Type III neoprene vest provides a better fit for more comfort and freedom of movement. The NeoLite construction is lightweight, quick drying and long lasting.</p>	[empty string]	N	59.99	59.99	XL,2X,3X	[empty string]	[empty string]	1000	10076	276969	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/adult-swoosh-kwik-dry-neolite-flex-vest-276969	1
14	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	22.99	0	22.99	[empty string]	22.99	[empty string]	CO2 REARM KIT 24G CYLINDER,BAYNET,BOBB	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]	9	20-to-25	0.00	[empty string]	Co2 Rearm Kit 24g Cylinder,baynet,bobb	[empty string]	[empty string]	N	22.99	22.99	[empty string]	[empty string]	[empty string]	1000	14601	277046	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/co2-rearm-kit-24g-cylinder-baynet-bobb-277046	1
15	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	11.99	0	11.99	[empty string]	11.99	[empty string]	CO2 CYLINDER 16G WGREEN PIN	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	NOT ONLINE	[empty string]	[empty string]	4	10-to-15	0.00	[empty string]	Co2 Cylinder 16g Wgreen Pin	[empty string]	[empty string]	N	11.99	11.99	[empty string]	[empty string]	[empty string]	1000	14604	277047	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/co2-cylinder-16g-wgreen-pin-277047	1
16	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	CO2 REARM KIT 24G CYLINDER,BAYNET, BOBB	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]	8	25-to-50	0.00	[empty string]	Co2 Rearm Kit 24g Cylinder,baynet, Bobb	[empty string]	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	14605	277048	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/co2-rearm-kit-24g-cylinder-baynet-bobb-277048	1
17	PINK	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PINK\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	NYLON INFANT TYPE II VEST 0-30 LBS	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]	2	20-to-25	0.00	[empty string]	Nylon Infant Type Ii Vest 0-30 Lbs	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	2171722	277224	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/nylon-infant-type-ii-vest-0-30-lbs-277224	1
18	[empty string]	COLEMAN	Coleman	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	PUDDLE JUMPER GREEN FISH PFD	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]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Puddle Jumper Green Fish Pfd	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	3000004733	283208	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	coleman/puddle-jumper-green-fish-pfd-283208	1
19	[empty string]	COLEMAN	Coleman	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	1	19.99	0	19.99	90197-DEFAULT-l.jpg	19.99	90197-DEFAULT-m.jpg	PUDDLE JUMPER PINK FISH PFD	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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Puddle Jumper Pink Fish Pfd	[empty string]	[empty string]	N	19.99	19.99	[empty string]	90197-DEFAULT-s.jpg	[empty string]	1000	3000004731	283209	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	coleman/puddle-jumper-pink-fish-pfd-283209	1
20	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
21	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
22	SAPPHIRE,TURQUOISE	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SAPPHIRE\|NULL\|NULL,TURQUOISE\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	YUKON PADDLE VEST	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]	18	25-to-50	0.00	[empty string]	Sport Paddle Vest - Adult	<p>FEATURES:<br /> -Lightweight performance paddle vest<br /> -Segmented hinged body for ventilation and ease of motion<br /> -Radical EZ pull side zipper entry<br /> -Fully adjustable straps on shoulders and sides<br /> -Breathable mesh lower back and neoprene shoulder pads for comfort<br /> -SOLAS grade reflective strips in front for visibility<br /> -Four D-rings on back for attaching hydration<br /> -Lightweight sculpted PVC-free HydroZote foam<br /> -Rugged 400 denier nylon oxford</p>	[empty string]	N	49.99	49.99	XS,2X/3X,4X/6X,S/M	[empty string]	[empty string]	1000	13007	300598	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/yukon-paddle-vest-300598	1
23	RACECAR	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	RACECAR\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	CHILDS WATER OTTER CLASSIC VEST	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	ONLINE	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Water Otter Classic	<p>The Water Otter is the perfect playful child-size life jacket to keep your little ones safe while having fun in the water.  Perfect for any aquatic adventure, each product is U.S. Coast Guard and Transport Canada approved – so you can rest your worries and enjoy your time making a splash as a family!</p>	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	10000	311345	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/childs-water-otter-classic-vest-311345	1
24	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
25	BLK/PINK	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLK/PINK\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	NEO JUNIOR VEST 28-32 INCHES	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	50-to-100	0.00	[empty string]	Neo Junior Vest 28-32 Inches	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	2201876	328451	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/neo-junior-vest-28-32-inches-328451	1
26	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	LIFE VEST TYPE II ADULT XL KEYHOLE ORANGE	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	10-to-15	0.00	[empty string]	Type Ii Keyhole Life Vest - Adult	<p>FEATURES:<br /> -Open Sides Adjustable 1quot; belt<br /> -Not for waterskiing, tubing or PWCs<br /> -Foam PE Size: Adult<br /> -USCG Approved type II</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	10000-16-A-OR	328743	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/life-vest-type-ii-adult-xl-keyhole-orange-328743	1
27	[empty string]	SEACHOICE PRODUCTS	Seachoice Products	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	10.99	0	10.99	[empty string]	10.99	[empty string]	TYPE II YOUTH LIFE VEST ORANGE	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	10-to-15	0.00	[empty string]	Type Ii Youth Life Vest Orange	[empty string]	[empty string]	N	10.99	10.99	[empty string]	[empty string]	[empty string]	1000	50-85560	338563	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	seachoice-products/type-ii-youth-life-vest-orange-338563	1
28	BLK/WHITE	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLK/WHITE\|NULL\|NULL	0	64.99	0	64.99	[empty string]	64.99	[empty string]	AIRHEAD ADULT NEO LITE ORCA VEST	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]	5	50-to-100	0.00	[empty string]	Airhead Adult Neo Lite Orca Vest	[empty string]	[empty string]	N	64.99	64.99	XL,XS	[empty string]	[empty string]	1000	10075	340021	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/airhead-adult-neo-lite-orca-vest-340021	1
29	[empty string]	COLEMAN	Coleman	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	1	19.99	0	19.99	89672-DEFAULT-l.jpg	19.99	89672-DEFAULT-m.jpg	PUDDLE JUMPER BLUE BIRD PFD	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]	3	15-to-20	0.00	[empty string]	Puddle Jumper Blue Bird Pfd	[empty string]	[empty string]	N	19.99	19.99	[empty string]	89672-DEFAULT-s.jpg	[empty string]	1000	3000005707	341160	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	coleman/puddle-jumper-blue-bird-pfd-341160	1
30	[empty string]	COLEMAN	Coleman	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	PUDDLE JUMPER DRAGON PFD	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]	5	15-to-20	0.00	[empty string]	Puddle Jumper Dragon Pfd	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	3000006102	341161	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	coleman/puddle-jumper-dragon-pfd-341161	1
31	[empty string]	COLEMAN	Coleman	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	PUDDLE JUMPER LION PFD	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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Puddle Jumper Lion Pfd	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	3000005495	341259	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	coleman/puddle-jumper-lion-pfd-341259	1
32	TURQUOISE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	TURQUOISE\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	WMS GLIDE PFD	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	100-to-150	0.00	[empty string]	Wms Glide Pfd	[empty string]	[empty string]	N	109.99	109.99	XS/SM	[empty string]	[empty string]	1000	GLIDE	342147	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-glide-pfd-342147	1
33	[empty string]	COLEMAN	Coleman	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	18.99	0	18.99	[empty string]	18.99	[empty string]	STEARNS PFD TYPE II UNIVERSAL ORANGE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	48	15-to-20	0.00	[empty string]	Stearns Pfd Type Ii Universal Orange	[empty string]	[empty string]	N	18.99	18.99	[empty string]	[empty string]	[empty string]	1000	2000032281	352143	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	coleman/stearns-pfd-type-ii-universal-orange-352143	1
34	[empty string]	COLEMAN	Coleman	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	18.99	0	18.99	[empty string]	18.99	[empty string]	STEARNS PFD TYPE II UNIVERSAL OVER SIZE ORANGE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	36	15-to-20	0.00	[empty string]	Stearns Pfd Type Ii Universal Over Size Orange	[empty string]	[empty string]	N	18.99	18.99	[empty string]	[empty string]	[empty string]	1000	2000032286	352144	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	coleman/stearns-pfd-type-ii-universal-over-size-orange-352144	1
35	PUR	ABSOLUTE OUTDOORS	ABSOLUTE OUTDOORS	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PUR\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.99	[empty string]	INFANT TYPE II LIFE JACKET	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]	5	25-to-50	0.00	[empty string]	Youth Life Jacket - Type Ii	<p>FEATURES:<br /> -Basic flotation for the boating enthusiast<br /> -Designed specifically to provide minimum buoyancy and turn an unconscious person face up in calm water situations<br /> -Less bulky and more affordable than a Type I offshore life jacket<br /> -U.S. Coast Guard Approved Type II Life Jacket / Personal Flotation Device (PFD)</p>	[empty string]	N	34.99	34.99	INFANT	[empty string]	[empty string]	1000	142109	353337	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	absolute-outdoors/infant-type-ii-life-jacket-353337	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts14 ORDER BY sortposition asc

Watersports

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Brand

Size

Men's 4 Belt Pro - Large - 40 `- 44 `

Men's 4 Belt Pro - 2xl - 48

Teen Nylon Life Jacket - 28- 32 Inch

Re- Arm Kit - M.I.T.100 Inflatable Pfd

Re- Arm Kit For Md- 3075 33 Gram

Child Nylon Life Jacket With Collar

Flo

Misty

Type Ii Keyhole Life Vest - Youth

Type Ii Keyhole Life Vest - Adult

Type Ii Keyhole Life Vest - Adult - 4 Pack

Sportsman Camo Life Vest - Youth

Swoosh Neolite Kwik- Dry Life Vest - Adult

Co2 Rearm Kit 24g Cylinder, Baynet, Bobb

Co2 Cylinder 16g Wgreen Pin

Co2 Rearm Kit 24g Cylinder, Baynet, Bobb

Nylon Infant Type Ii Vest 0- 30 Lbs

Puddle Jumper Green Fish Pfd

Puddle Jumper Pink Fish Pfd

Solitude - Women's

Solitude - Men's

Sport Paddle Vest - Adult

Water Otter Classic

Lure Angler