BOYS' WATERTIGHT JACKET

No 1580641_OP

Description
Specs
Reviews
Live Chat

Zip them up & keep them dry

He’ll be dry and comfortable in this waterproof-breathable, fully seam-sealed jacket no matter how hard it pours. Zip pockets stow small objects easily. Reflective details keep him visible, even in low light. An adjustable hood keeps him extra dry.

Fabric: Omni-Tech™ coated 100% nylon; 100% Polyester
Omni-Tech™ waterproof/breathable fully seam sealed
Mesh lined
Attached, adjustable hood
Zip-closed pockets
Adjustable sleeve cuffs
Reflective detail
Center Back Length: 21 inches
Uses: Trail
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

He’ll be dry and comfortable in this waterproof-breathable, fully seam-sealed jacket no matter how hard it pours. Zip pockets stow small objects easily. Reflective details keep him visible, even in low light. An adjustable hood keeps him extra dry.
Specs
- Fabric: Omni-Tech™ coated 100% nylon; 100% Polyester
- Omni-Tech™ waterproof/breathable fully seam sealed
- Mesh lined
- Attached, adjustable hood
- Zip-closed pockets
- Adjustable sleeve cuffs
- Reflective detail
- Center Back Length: 21 inches
- Uses: Trail
- Imported
Reviews

No Reviews Yet!
Live Chat

Regular Price: $75.00

Sale Price: $37.50

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	COLLEGIATE_NAVY	120119	[empty string]	[empty string]	0	9	0	0	COLLEGIATE_NAVY	208	Y	[empty string]	972765	[empty string]	207718
2	CITY_GREY	120120	[empty string]	[empty string]	0	11	0	-1	CITY_GREY	186	Y	[empty string]	972771	[empty string]	207718

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,8,6,5,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >= 4 ) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,8,6,5,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 4 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	207718

struct
INTERNALLISTPRICE	75
INTERNALMARKDOWN	false
INTERNALPRICE	75
REG	75
SALE	37.5
TERMSALE	true
TERMSALELISTPRICE	75
TERMSALEPRICE	37.5

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	COLLEGIATE_NAVY	120119	[empty string]	[empty string]	0	9	0	0	COLLEGIATE_NAVY	208	Y	[empty string]	972765	[empty string]	207718
2	CITY_GREY	120120	[empty string]	[empty string]	0	11	0	-1	CITY_GREY	186	Y	[empty string]	972771	[empty string]	207718