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]	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	[empty string]	0	189.99	0	189.99	[empty string]	189.99	[empty string]	W ICEFIELD PAC BOOT BLACK	N	5 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]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	14	150-to-200	0.00	[empty string]	Icefield - Women`s	<p>FEATURES:<br /> -Liner: Removable, max-layer inner boot system<br /> -Double B-Tek insulation<br /> -Double aluminum insole<br /> -Waffle-comb foot-bed<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Waterproof, Diamond-Lite insulated nylon upper<br /> -Side-to-side webbed lacing system<br /> -Waterproof nylon snow collar</p>	[empty string]	N	189.99	189.99	9,11,6,10,8,7	[empty string]	[empty string]	1000	40100172-001	2871	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-icefield-pac-boot-black-2871	1
2	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	M TITAN PAC BOOT	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	Titan - Pln - Men'S	<p>FEATURES:<br /> -Fully moulded waterproof boot<br /> -Aggressive, long wearing, self-cleaning outsole design<br /> -Micro-cellular waffle foot-bed traps air and moisture<br /> -Light weight and flexible TR compound<br /> -Plain toe</p>	[empty string]	N	159.99	159.99	11,12,10,7,8,9,13	[empty string]	[empty string]	1000	23550000-001	85905	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-titan-pac-boot-85905	1
3	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M TUNDRA PAC BOOT	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	28	100-to-150	0.00	[empty string]	Tundra	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Moisture management system<br /> -Comfort<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Locking snow collar<br /> -Reflective piping for visibility with velcro-strap ankle support</p>	[empty string]	N	139.99	139.99	11,12,10,9,13,8,14	[empty string]	[empty string]	1000	43000162-001	102749	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-tundra-pac-boot-102749	1
4	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	74.99	0	74.99	[empty string]	74.99	[empty string]	JR MUSTANG PAC BOOT	N	5 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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	19	50-to-100	0.00	[empty string]	Mustang - Juniors	<p>FEATURES:<br /> -Removable, multi-layer inner boot system liner<br /> -Arctic Rubber base<br /> -Locking snow collar<br /> -Ankle height Velcro strap for fastening<br /> -Rip-stop nylon upper</p>	[empty string]	N	74.99	74.99	4,6,7,3,5	[empty string]	[empty string]	1000	4820-0068	105064	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/jr-mustang-pac-boot-105064	1
5	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	229.99	0	229.99	[empty string]	229.99	[empty string]	M EIGER PAC BOOT	N	5 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]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	18	200-to-250	0.00	[empty string]	Eiger - Men'S	<p>FEATURES:<br /> -Waterproof base<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Double B-Tek insulation<br /> -Double aluminum insole<br /> -Waffle-comb foot-bed<br /> -Double-strap Velcro fastening<br /> -Waterproof nylon snow collar with built-in extendable gaiter<br /> -Waterproof, Diamond-Lite insulated nylon with full-grain leather upper</p>	[empty string]	N	229.99	229.99	11,12,10,14,8,9,13	[empty string]	[empty string]	1000	4000-M001-BK1	117887	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-eiger-pac-boot-117887	1
6	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	JR EIGER PAC BOOT	N	5 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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	35	50-to-100	0.00	[empty string]	Eiger - Junior`s	<p>FEATURES:<br /> -Removable, multi-layer inner boot system<br /> -Waffle-comb foot-bed<br /> -Arctic Rubber base<br /> -Double-strap Velcro fastening<br /> -Waterproof nylon snow collar</p>	[empty string]	N	94.99	94.99	5,3,4,7,8,6	[empty string]	[empty string]	1000	EPIC-J001	117895	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/jr-eiger-pac-boot-117895	1
7	BROWN	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	229.99	0	229.99	[empty string]	229.99	[empty string]	M CONTROLMAX PAC BOOT	N	5 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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	18	200-to-250	0.00	[empty string]	Control Max	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Waffle-comb foot-bed<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole <br /> -Multi D-Ring lace fastening<br /> -Full-grain insulated leather<br /> -Waterproof seam-sealed upper</p>	[empty string]	N	229.99	229.99	12,13,14,9,10,11,8	[empty string]	[empty string]	1000	EPIC-M004-BR5	118191	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-controlmax-pac-boot-118191	1
8	BLK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLK\|NULL\|NULL	0	74.99	0	74.99	[empty string]	74.99	[empty string]	YTH MUSTANG PAC BOOT	N	5 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]	YOUTH	ACTIVE	ONLINE	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	Mustang - Youth	<p>FEATURES:<br /> -Removable, multi-layer inner boot system<br /> -Arctic Rubber base<br /> -Locking snow collar<br /> -Ankle height Velcro strap for fastening<br /> -Rip-stop nylon upper</p>	[empty string]	N	74.99	74.99	13,12,11,1,2	[empty string]	[empty string]	1000	4880-0068	121248	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/yth-mustang-pac-boot-121248	1
9	BLACK/BARK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK/BARK\|NULL\|NULL	0	249.99	0	249.99	[empty string]	249.99	[empty string]	MNS APEX	N	5 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]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	24	200-to-250	0.00	[empty string]	Apex - Men'S	<p>FEATURES:<br /> -Waterproof base<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Double B-Tek insulation<br /> -Double aluminum insole<br /> -Waffle-comb foot-bed<br /> -Base: Arctic Rubber Shell, EVA Midsole, Polar Rubber Outsole<br /> -Speed-lace front fastening system<br /> -Full length tongue for ease-of-entry<br /> -Waterproof leather upper</p>	[empty string]	N	249.99	249.99	13,11,12,14,9,10,15,8	[empty string]	[empty string]	1000	4000-1305-455	159388	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/mns-apex-159388	1
10	HYPERBERRY	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Leisure and Casual	HYPERBERRY\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.99	[empty string]	W CUSH BOOTY	N	5 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]	WOMENS	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Cush Booty - Women`s	<p>FEATURES:<br /> -Soft nylon upper<br /> -Slip resistant, durable nylon bottom<br /> -Elasticized lockable tie<br /> -Mid height<br /> -Drawstring toggle</p>	[empty string]	N	34.99	34.99	YL	[empty string]	[empty string]	1000	6130-0000-BY2	191814	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	baffin-inc/w-cush-booty-191814	1
11	CHARCOAL	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	CHARCOAL\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	M ZONE	N	5 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]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	25	100-to-150	0.00	[empty string]	Zone - Men`s	<p>FEATURES:<br /> -Waterproof membrane<br /> -Liner: Form fitting, fix-lined inner boot system<br /> -Waterproof bootie construction<br /> -Fixed frost plate<br /> -Removable, stabilizing anti-microbial insole<br /> -Base: TPU Plate and Tendon Guard with EVA midsole and Polar Rubber Outsole<br /> -Hiker-height for improved agility<br /> -Front fastening web and speed-lace system<br /> -Waterproof breathable Soft Shell upper</p>	[empty string]	N	139.99	139.99	11,13,12,10,9,14	[empty string]	[empty string]	1000	SOFT-M006-GY2	222586	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-zone-222586	1
12	CAL	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	CAL\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	W SAGE	N	5 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]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Sage - Women`s	<p>FEATURES:<br /> -B-Tek Lite<br /> -Liner: Body-heat mouldable, removable liner<br /> -Base: Superlite Shell, AirGrip Midsole and Outsole with Polar Rubber contact points <br /> -Hiker height for improved agility<br /> -Waterproof PU coated leather and nylon<br /> -Speed-lace front fastening system with toggle</p>	[empty string]	N	159.99	159.99	8,7,6	[empty string]	[empty string]	1000	LITE-W006-CAL	254103	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-sage-254103	1
13	CHARCOAL	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	CHARCOAL\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	W SNOWGOOSE	N	5 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]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	21	100-to-150	0.00	[empty string]	Snogoose - Women`s	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole and Polar Rubber Outsole designed for a women’s foot<br /> -Side-to-side lace fastening with toggle<br /> -Waterproof nylon snow collar<br /> -Waterproof 900 Denier nylon upper</p>	[empty string]	N	139.99	139.99	9,10,11,7,8,6	[empty string]	[empty string]	1000	4510-1330-GY2	254106	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-snowgoose-254106	1
14	TAUPE	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	TAUPE\|NULL\|NULL	0	159.99	0	159.99	[empty string]	159.99	[empty string]	W CHOLE	N	5 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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	Chloe - Women`s	<p>FEATURES:<br /> -Liner: Removable, Baffin multi-layer inner boot system<br /> -Base: Arctic Rubber Shell, EVA Midsole and Polar Rubber Outsole designed for a women’s foot<br /> -D-Ring front lace fastening system<br /> -Faux-fur collar and sidepiece<br /> -Waterproof suede leather upper</p>	[empty string]	N	159.99	159.99	8,9,11,10,6,7	[empty string]	[empty string]	1000	4510-0185-BG4	254107	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-chole-254107	1
15	BROWN	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	M ONTARIO	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	MENS	SELL THRU	ONLINE	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Ontario - Men`s	<p>FEATURES:<br /> -Liner: Fixed Lining<br /> -Thermaplush<br /> -Removable comfort-crafted insole<br /> -Base: Premium rubber, waterproof base<br /> -Waterproof - B-Tek.DRY breathable membrane<br /> -Low slip-on for easy entry<br /> -Front lace fastening<br /> -Waterproof, durable leather</p>	[empty string]	N	94.99	94.99	11,12,13,9	[empty string]	[empty string]	1000	LAKE-MOO3-BR1	288911	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-ontario-288911	1
16	BROWN	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BROWN\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	W ONTARIO	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2018	[empty string]	WOMENS	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Ontario - Women`s	<p>FEATURES:<br /> -All Season<br /> -Liner: Fixed Lining<br /> -Thermaplush<br /> -Removable comfort-crafted insole<br /> -Base: Premium rubber, waterproof base<br /> -Mid height with soft-backed felt collar<br /> -3 D-ring front lacing with pull loop at the back<br /> -Waterproof, durable leather</p>	[empty string]	N	94.99	94.99	6	[empty string]	[empty string]	1000	LAKE-W003-BR1	288913	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-ontario-288913	1
17	FUSHIA	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	FUSHIA\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	JUNIOR MIA	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2017	[empty string]	YOUTH	SIDEWALK	NOT ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Titan - Men`s - Black	FEATURES:<br/> -Fully moulded waterproof boot<br/> -Aggressive, long wearing, self-cleaning outsole design<br/> -Micro-cellular waffle foot-bed traps air and moisture<br/> -Plain toe<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	79.99	79.99	3,5	[empty string]	[empty string]	1000	SNFL-J019	288916	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/junior-mia-288916	1
18	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	167.99	0	167.99	[empty string]	167.99	[empty string]	M SNOWSTORM	N	5 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]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	16	150-to-200	0.00	[empty string]	M Snowstorm	[empty string]	[empty string]	N	167.99	167.99	11,13,12,10,14,9	[empty string]	[empty string]	1000	SOFT-M024-BK1	322718	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/m-snowstorm-322718	1
19	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	YTH ICEBERG PAC BOOT -508	N	5 MAIDA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	SIDEWALK	ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Iceberg - Youth	<p>FEATURES:<br /> -Removable, Baffin multi-layer inner boot system<br /> -Frost plate<br /> -Arctic Rubber Shell, GelFlex Midsole, Polar Rubber Outsole<br /> -Waterproof, double rip-stop nylon and leather<br /> -Velcro front fastening<br /> -Locking snow collar</p>	[empty string]	N	59.99	59.99	11,12,13	[empty string]	[empty string]	1000	JR ICEBURG	327240	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/yth-iceberg-pac-boot-508-327240	1
20	RED	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Leisure and Casual	RED\|NULL\|NULL	0	99.99	0	99.99	[empty string]	99.99	[empty string]	W ESKA TALL BOOT	N	5 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]	WOMENS	SIDEWALK	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	W Eska Tall Boot	[empty string]	[empty string]	N	99.99	99.99	6	[empty string]	[empty string]	1000	MIKUW017	327241	EMPTY	EMPTY	EMPTY	0	0	0	LEISURE AND CASUAL	[empty string]	baffin-inc/w-eska-tall-boot-327241	1
21	BLACK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLACK\|NULL\|NULL	0	94.99	0	94.99	[empty string]	94.99	[empty string]	JUNIOR AVERY	N	5 MAIDA	[empty string]	[empty string]	[empty string]	B	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	YOUTH	ACTIVE	[empty string]	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Junior Avery	[empty string]	[empty string]	N	94.99	94.99	5,6,3,4	[empty string]	[empty string]	1000	SNFL-J020-BK1	335954	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/junior-avery-335954	1
22	BLK/SANGRIA	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLK/SANGRIA\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	W HIKE	N	5 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]	WOMENS	ACTIVE	[empty string]	[empty string]	[empty string]	9	100-to-150	0.00	[empty string]	W Hike	[empty string]	[empty string]	N	149.99	149.99	7,9,10,11,8	[empty string]	[empty string]	1000	SOFT-W001-BBP	335955	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/w-hike-335955	1
23	BLK/LAV,BLK	BAFFIN INC	Baffin Inc	FOOTWEAR	Footwear>Pac Boots	BLK/LAV\|NULL\|NULL,BLK\|NULL\|NULL	0	49.99	0	49.99	[empty string]	49.99	[empty string]	YTH ICE CASTLE -22	N	5 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]	21	25-to-50	0.00	[empty string]	Iceberg - Youth	<p>FEATURES:<br /> -Removable, Baffin multi-layer inner boot system<br /> -Frost plate<br /> -Arctic Rubber Shell, GelFlex Midsole, Polar Rubber Outsole<br /> -Waterproof, double rip-stop nylon and leather<br /> -Velcro front fastening<br /> -Locking snow collar</p>	[empty string]	N	49.99	49.99	11,12,1,2,3,4,8,9,10	[empty string]	[empty string]	1000	WRUB-Y001	342010	EMPTY	EMPTY	EMPTY	0	0	0	PAC BOOTS	[empty string]	baffin-inc/yth-ice-castle-22-342010	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Size

Filter

Filter By

Price

Categories

Brand

Size

Icefield - Women's

Titan - Pln - Men's

Tundra

Mustang - Juniors

Eiger - Men's

Eiger - Junior's

Control Max

Mustang - Youth

Apex - Men's

Cush Booty - Women's

Zone - Men's

Sage - Women's

Snogoose - Women's

Chloe - Women's

Ontario - Men's

Ontario - Women's

Titan - Men's - Black

M Snowstorm

Iceberg - Youth

W Eska Tall Boot

Junior Avery

W Hike

Iceberg - Youth