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	PURPLE	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PURPLE\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	NYLON TEEN VEST 28-32`	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Teen Nylon Vest - Purple - 28	<p>FEATURES:<br /> -Soft, flexible foam core for outstanding comfort<br /> -Sturdy nylon exterior for durability<br /> -3 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	[empty string]	[empty string]	[empty string]	1000	2171707	144381	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/nylon-teen-vest-28-32-144381	1
2	BLU/LIME	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLU/LIME\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	CHILD VEST V-BACK 33-55 LBS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Child Vest V-back 33-55 Lbs	[empty string]	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	2201871	144403	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/child-vest-v-back-33-55-lbs-144403	1
3	PINK/AQUA	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PINK/AQUA\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	NEO CHILDS VEST 30-50 LBS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Neo Childs Vest 30-50 Lbs	[empty string]	[empty string]	N	44.99	44.99	[empty string]	[empty string]	[empty string]	1000	2201882	159006	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/neo-childs-vest-30-50-lbs-159006	1
4	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	LIFE VEST TYPE II CHILD KEYHOLE	N	4 JENNIFER	[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]	46	5-to-10	0.00	[empty string]	Life Vest Type Ii Child Keyhole	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	10000-02-A-OR	167808	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/life-vest-type-ii-child-keyhole-167808	1
5	ORANGE	HARMONY	Harmony	WATERSPORTS	Watersports>Flotation Devices (PFDs)	ORANGE\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	HIGHBACK TYPE III PFD TWO TONE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Kickback Ii Life Jacket	<p>The Harmony Kickback Life Jacket - PFD is a high back personal flotation device with a nylon shell that combines performance with unique design. Its high back design and ergonomic cut allow for maximum ventilation and comfort without limiting your range of motion. The Kickback features a design that is perfect for recreational kayaks with high seat backs, yet comfortable enough for touring or canoeing.</p>	[empty string]	N	79.99	79.99	XL/XXL,XS/SM,MD/LG	[empty string]	[empty string]	1000	KICKBACK II	243397	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	harmony/highback-type-iii-pfd-two-tone-243397	1
6	BLACK/YELLOW	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLACK/YELLOW\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	NEO MNS TRADITIONAL VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Traditional Life Jacket - Men`s	<p>The O’Brien Men’s Traditional is a sleek, comfortable, eco-friendly life jacket that will have you loving your time on the water. The BioLite material adds breathability for faster drying and makes it lighter and more environmentally friendly than traditional neoprene, while still providing exceptional comfort. The segmented panels with the front hinge and the wide armholes allow the life jacket to move with you and minimize any hindrance in range of motion.The full front zip closure and two adjustable belts make it easy to dial in that snug fit to keep you safe and secure on the water. The Men’s Traditional also features a PWC lanyard attachment ring making for a fast, convenient way to keep the lanyard safely out of your way.</p>	[empty string]	N	69.99	69.99	M,L,XS,S	[empty string]	[empty string]	1000	2191853/9	243814	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/neo-mns-traditional-vest-243814	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 JENNIFER	[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]	5	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	XS/SM,MED/LG	[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 JENNIFER	[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]	12	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,M,L	[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	BLUE/BLACK	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLUE/BLACK\|NULL\|NULL	0	89.99	0	89.99	[empty string]	89.99	[empty string]	MNS COASTER PFD ROYAL BLUE/ BLACK	N	4 JENNIFER	[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]	Coaster	<p>Along with Stohlquist`s Graded Sizing, the Coaster features a Thin Back Design offering more coverage and ensuring compatibility with any seat back style. The Coaster is perfect 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	L,M	[empty string]	[empty string]	1000	COASTER	260164	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/mns-coaster-pfd-royal-blue-black-260164	1
10	[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 YOUTH KEYHOLE ORANGE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	24	10-to-15	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	12.99	12.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
11	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	LIFE VEST TYPE II ADULT KEYHOLE ORANGE	N	4 JENNIFER	[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]	44	10-to-15	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	14.99	14.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
12	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	60.99	0	60.99	[empty string]	60.99	[empty string]	LIFE VEST TYPE II ADULT ORANGE 4 PK.	N	4 JENNIFER	[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]	13	50-to-100	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	60.99	60.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
13	MULTI	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	MULTI\|NULL\|NULL	0	46.99	0	46.99	[empty string]	46.99	[empty string]	INFANT GNAR NEOLITE KWIK DRY VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Gnar Neolite Kwik-dry Life Vest - Infant	<p>This USCG approved Type II neoprene vest is cut for greater freedom of movement for the active youth.  Kids will love the contemporary styling.</p>	[empty string]	N	46.99	46.99	[empty string]	[empty string]	[empty string]	1000	10074-01-C	276966	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/infant-gnar-neolite-kwik-dry-vest-276966	1
14	MULTI	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	MULTI\|NULL\|NULL	0	46.99	0	46.99	[empty string]	46.99	[empty string]	CHILDS GNAR NEOLITE KWIK DRY VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Gnar Neolite Kwik-dry Life Vest - Child	<p>This USCG approved Type III neoprene vest is cut for greater freedom of movement for the active youth.  Kids will love the contemporary styling.</p>	[empty string]	N	46.99	46.99	[empty string]	[empty string]	[empty string]	1000	10074-02-B	276967	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/childs-gnar-neolite-kwik-dry-vest-276967	1
15	MULTI	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	MULTI\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	YOUTH GNAR NEOLITE KWIK DRY VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Gnar Neolite Kwik-dry Life Vest - Youth	<p>This USCG approved Type III neoprene vest is cut for greater freedom of movement for the active youth.  Kids will love the contemporary styling.</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	10074-03-B	276968	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/youth-gnar-neolite-kwik-dry-vest-276968	1
16	HOTPINK	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	HOTPINK\|NULL\|NULL	0	45.99	0	45.99	[empty string]	45.99	[empty string]	INFANT WICKED KWIK DRY NEOLITE VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Wicked Neolite Kwik-dry Life Vest - Infant	<p>This USCG approved Type II neoprene vest is cut for greater freedom of movement for the active youth.  Kids will love the contemporary styling.</p>	[empty string]	N	45.99	45.99	INFANT	[empty string]	[empty string]	1000	10077-01	277028	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/infant-wicked-kwik-dry-neolite-vest-277028	1
17	HOTPINK	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	HOTPINK\|NULL\|NULL	0	44.99	0	44.99	[empty string]	44.99	[empty string]	CHILD WICKED KWIK DRY NEOLITE VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Wicked Neolite Kwik-dry Life Vest - Child	<p>This USCG approved Type III neoprene vest is cut for greater freedom of movement for the active youth.  Kids will love the contemporary styling.</p>	[empty string]	N	44.99	44.99	CHILD	[empty string]	[empty string]	1000	10077-02	277029	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/child-wicked-kwik-dry-neolite-vest-277029	1
18	HOTPINK	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	HOTPINK\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	YOUTH WICKED KWIK DRY NEOLITE VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	PROP 65	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Wicked Neolite Kwik-dry Life Vest - Youth	<p>This USCG approved Type III neoprene vest is cut for greater freedom of movement for the active youth.  Kids will love the contemporary styling.</p>	[empty string]	N	49.99	49.99	YOUTH	[empty string]	[empty string]	1000	10077-03	277030	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/youth-wicked-kwik-dry-neolite-vest-277030	1
19	BLUE/BLACK,PINK/BLACK	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLUE/BLACK\|NULL\|NULL,PINK/BLACK\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	ADULT TREND VEST	N	4 JENNIFER	[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]	167	25-to-50	0.00	[empty string]	Trend Closed Side Life Vest - Adult	<p>FEATURES:<br /> -4 Adjustable Belts<br /> -Closed Sided<br /> -Lightweight EPE Foam<br /> -Adult - over 90 lbs<br /> -USCG Approved type III</p>	[empty string]	N	29.99	29.99	2X/3X,L/XL,S/M,XS,4X/6X	[empty string]	[empty string]	1000	30081	277032	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/adult-trend-vest-277032	1
20	OCEAN/BLUE	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	OCEAN/BLUE\|NULL\|NULL	0	26.99	0	26.99	[empty string]	26.99	[empty string]	INFANT TREASURE VEST	N	4 JENNIFER	[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]	17	25-to-50	0.00	[empty string]	Treasure Life Vest - Infant	<p>FEATURES:<br /> -Closed sided vest with ocean inspired graphic<br /> -Front zipper with waist belt and crotch strap included for extra safety<br /> -Segmented head rest and grab handle<br /> -USCG approved TYPE III<br /> -Fits infant less than 30 lbs</p>	[empty string]	N	26.99	26.99	INFANT	[empty string]	[empty string]	1000	10088-01	277034	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/infant-treasure-vest-277034	1
21	OCEAN/BLUE	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	OCEAN/BLUE\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	CHILD TREASURE VEST	N	4 JENNIFER	[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]	15	20-to-25	0.00	[empty string]	Treasure Life Vest - Child	<p>FEATURES:<br /> -Closed sided vest with ocean inspired graphic<br /> -Front zipper with waist belt and crotch strap included for extra safety<br /> -Segmented head rest and grab handle<br /> -USCG approved TYPE III<br /> -Fits Children 30-50 lbs</p>	[empty string]	N	24.99	24.99	CHILD	[empty string]	[empty string]	1000	30088-02	277035	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/child-treasure-vest-277035	1
22	OCEAN/PINK	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	OCEAN/PINK\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	INFANT REEF VEST	N	4 JENNIFER	[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]	19	20-to-25	0.00	[empty string]	Reef Life Vest - Infant	<p>FEATURES:<br /> -Closed sided vest with ocean inspired graphic<br /> -Front zipper with waist belt and crotch strap included for extra safety<br /> -Segmented head rest and grab handle<br /> -USCG approved TYPE II<br /> -Fits infant less than 30 lbs</p>	[empty string]	N	24.99	24.99	INFANT	[empty string]	[empty string]	1000	10089-01	277036	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/infant-reef-vest-277036	1
23	OCEAN/PINK	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	OCEAN/PINK\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	CHILD REEF VEST	N	4 JENNIFER	[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]	12	20-to-25	0.00	[empty string]	Reef Life Vest - Child	<p>FEATURES:<br /> -Closed sided vest with ocean inspired graphic<br /> -Front zipper with waist belt and crotch strap included for extra safety<br /> -Segmented head rest and grab handle<br /> -USCG approved TYPE III<br /> -Fits Children 30-50 lbs</p>	[empty string]	N	24.99	24.99	CHILD	[empty string]	[empty string]	1000	30089-02	277037	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/child-reef-vest-277037	1
24	[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 JENNIFER	[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	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
25	PACIFICBLUE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PACIFICBLUE\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	MNS OSFA PFD VEST	N	4 JENNIFER	[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]	Osfa	<p>The OSFA (One Size Fits All) is a terrific jacket for those looking for a simple, great fitting jacket for recreational paddling. Highly adjustable, it’s a perfect vest to share with family and friends.</p>	[empty string]	N	69.99	69.99	OSFA	[empty string]	[empty string]	1000	QF134310UN	292716	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/mns-osfa-pfd-vest-292716	1
26	SAILBLUE	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	SAILBLUE\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	WMS MELODY OSFA PFD VEST	N	4 JENNIFER	[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]	6	50-to-100	0.00	[empty string]	Melody	<p>FEATURES:<br /> -Multi-Fit design fits chest ranges 28"-46"<br /> -Women`s specific design with supportive inner cups<br /> -High back flotation rides above the seat back of sit-on-top kayaks<br /> -Front buckle entry<br /> -Highly adjustable 1 1/2” webbing shoulder and side pulls<br /> -Cross-chest cinch harness for zero ride-up<br /> -Convenient webbing strap pockets to eliminate the “danglies”<br /> -Type III PFD with sea level buoyancy of 16 lbs 4 oz<br /> -USCG approved</p>	[empty string]	N	69.99	69.99	OSFA	[empty string]	[empty string]	1000	MELODY	292717	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-melody-osfa-pfd-vest-292717	1
27	KHAKI	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	KHAKI\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	PISEAS FISHING VEST	N	4 JENNIFER	[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	50-to-100	0.00	[empty string]	Piseas	<p>Now offered in Stohlquist`s exclusive Graded Sizing, which offers a better fitting, lower profile vest for anglers of every size. The new, higher mesh-back design fits comfortably above the tallest seat backs found in today’s fishing boats.</p>	[empty string]	N	99.99	99.99	S/M	[empty string]	[empty string]	1000	PISEAS	292718	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/piseas-fishing-vest-292718	1
28	GRAPE	OLD TOWN	OLD TOWN	WATERSPORTS	Watersports>Flotation Devices (PFDs)	GRAPE\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	PFD WMS SOLITUDE	N	4 JENNIFER	[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]	12	150-to-200	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	159.99	159.99	ONE SZ FITS ALL,L/XL,XS	[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
29	TAN	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	TAN\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	YUKON ANGLER PADDLE VEST	N	4 JENNIFER	[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	50-to-100	0.00	[empty string]	Angler Paddle Vest - Adult	<p>FEATURES:<br /> -The ultimate kayak fishing vest<br /> -Low profile foam placement for kayak fishing in comfort<br /> -Breathable lower back mesh keeps you cool<br /> -Comfortable neoprene shoulder pads, 6 fully adjustable straps<br /> -Largemouth cargo pocket, zipper chest pocket<br /> -Push button drop down tray pocket with 2” elastic strap for small tackle box<br /> -Zippered fleece-lined pockets for cold hands<br /> -Zippered chest pocket<br /> -Hanging loop for drying<br /> -High-tenacity 200 denier Rip Stop nylon shell<br /> -Lightweight Poly-E flotation inside<br /> -USCG approved Type III PFD</p>	[empty string]	N	59.99	59.99	OVERSIZE	[empty string]	[empty string]	1000	33006	300597	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/yukon-angler-paddle-vest-300597	1
30	TURQUOISE,SAPPHIRE	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	TURQUOISE\|NULL\|NULL,SAPPHIRE\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	YUKON PADDLE VEST	N	4 JENNIFER	[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]	141	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,4X/6X,2X/3X,L/XL,S/M	[empty string]	[empty string]	1000	33007	300598	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	kwik-tek/yukon-paddle-vest-300598	1
31	FISH,RACECAR,CLOWNFISH,SEAHORSE,SHARK,PRINCESS,UNICORN	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	FISH\|NULL\|NULL,RACECAR\|NULL\|NULL,CLOWNFISH\|NULL\|NULL,SEAHORSE\|NULL\|NULL,SHARK\|NULL\|NULL,PRINCESS\|NULL\|NULL,UNICORN\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	CHILDS WATER OTTER CLASSIC VEST	N	4 JENNIFER	[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]	14	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
32	PURPLE	O BRIEN	O Brien	WATERSPORTS	Watersports>Flotation Devices (PFDs)	PURPLE\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	NEO WMS FOCUS VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	30	50-to-100	0.00	[empty string]	Neo Wms Focus Vest	[empty string]	[empty string]	N	69.99	69.99	L,M,S,XL,XS	[empty string]	[empty string]	1000	2201823/7	328456	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	o-brien/neo-wms-focus-vest-328456	1
33	[empty string]	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	LIFE VEST TYPE II ADULT XL KEYHOLE ORANGE	N	4 JENNIFER	[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]	36	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	14.99	14.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
34	BLK/WHITE	KWIK TEK	Kwik Tek	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLK/WHITE\|NULL\|NULL	0	69.99	0	69.99	[empty string]	69.99	[empty string]	AIRHEAD ADULT NEO LITE ORCA VEST	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	74	50-to-100	0.00	[empty string]	Airhead Adult Neo Lite Orca Vest	[empty string]	[empty string]	N	69.99	69.99	2X,M,L,XS,XL,S,3X	[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
35	STEELGREEN	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	STEELGREEN\|NULL\|NULL	0	109.99	0	109.99	[empty string]	109.99	[empty string]	MNS CANDENCE PFD	N	4 JENNIFER	[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	100-to-150	0.00	[empty string]	Mns Candence Pfd	[empty string]	[empty string]	N	109.99	109.99	S/M,L/XL	[empty string]	[empty string]	1000	CADENCE	342146	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/mns-candence-pfd-342146	1
36	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 JENNIFER	[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]	12	100-to-150	0.00	[empty string]	Wms Glide Pfd	[empty string]	[empty string]	N	109.99	109.99	PLUS,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
37	BLK/GRY	STOHLQUIST	Stohlquist	WATERSPORTS	Watersports>Flotation Devices (PFDs)	BLK/GRY\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	WMS BROOK PFD	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[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]	Wms Brook Pfd	[empty string]	[empty string]	N	39.99	39.99	XS/SM,PLUS	[empty string]	[empty string]	1000	BROOK	342148	EMPTY	EMPTY	EMPTY	0	0	0	FLOTATION DEVICES (PFDS)	[empty string]	stohlquist/wms-brook-pfd-342148	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

Teen Nylon Vest - Purple - 28

Child Vest V- Back 33- 55 Lbs

Neo Childs Vest 30- 50 Lbs

Life Vest Type Ii Child Keyhole

Kickback Ii Life Jacket

Traditional Life Jacket - Men's

Flo

Misty

Coaster

Type Ii Keyhole Life Vest - Youth

Type Ii Keyhole Life Vest - Adult

Type Ii Keyhole Life Vest - Adult - 4 Pack

Gnar Neolite Kwik- Dry Life Vest - Infant

Gnar Neolite Kwik- Dry Life Vest - Child

Gnar Neolite Kwik- Dry Life Vest - Youth

Wicked Neolite Kwik- Dry Life Vest - Infant

Wicked Neolite Kwik- Dry Life Vest - Child

Wicked Neolite Kwik- Dry Life Vest - Youth

Trend Closed Side Life Vest - Adult

Treasure Life Vest - Infant

Treasure Life Vest - Child

Reef Life Vest - Infant

Reef Life Vest - Child

Co2 Rearm Kit 24g Cylinder, Baynet, Bobb