MAST GENERAL STORE LIGHT HIKER MINI

mast general store

No 9116_GRAY_BURGUNDY

1 Review(s)

$8.99

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	GRAY,RED	91646	[empty string]	[empty string]	0	13	-1	0	GRAY_BURGUNDY	97	Y	[empty string]	778710	[empty string]	159835

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,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=1) 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,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	159835

struct
INTERNALLISTPRICE	8.99
INTERNALMARKDOWN	false
INTERNALPRICE	8.99
REG	8.99
SALE	8.99
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

CHOOSE Size

Size Chart

Size

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

Functional, versatile & made in NC

The Mast Store Outfitters Light Hiker Sock is both functional and versatile. Many people prefer the quarter height in the summer over the crew so their calves can enjoy the scenery, too! Made of soft merino wool, these socks wick moisture away from your foot to keep you cool and dry (or warm and dry if the situation requires). The Light Hiker sock features extra cushioning and a snug, yet comfortable fit across the arch with a flat toe seam that makes it feel virtually seamless. And the very best part is they are made right here in North Carolina!

Knit in USA of imported yarn
Flat toe seam
Wicks moisture
Cushioned
Fabric: 73% merino wool, 25% stretch nylon, 2% Lycra® spandex
Height: Mini
Recommended Care: Machine wash & dry. Launder socks inside-out on medium cycle with cold water. Dry on low heat; remove immediately. Do not bleach.
Guarantee: If you are not completely satisfied with your Mast Store socks, we will replace them or reimburse you for up to one year from date of purchase. Simply send a dated sales receipt along with the laundered socks, an explanation, and a replacement or reimbursement request to Mast Store.

Average 5 out of 5

1 reviews
Jason

September 27, 2019

Unreal Socks!

Yo, these socks are off the hook cozy, durable and good looking! Diggin them! Perfect multi season merino item for hikes or daily wear. Only problem is I don't have enough in my sock drawer!

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

The Mast Store Outfitters Light Hiker Sock is both functional and versatile. Many people prefer the quarter height in the summer over the crew so their calves can enjoy the scenery, too! Made of soft merino wool, these socks wick moisture away from your foot to keep you cool and dry (or warm and dry if the situation requires). The Light Hiker sock features extra cushioning and a snug, yet comfortable fit across the arch with a flat toe seam that makes it feel virtually seamless. And the very best part is they are made right here in North Carolina!
Specs
- Knit in USA of imported yarn
- Flat toe seam
- Wicks moisture
- Cushioned
- Fabric: 73% merino wool, 25% stretch nylon, 2% Lycra® spandex
- Height: Mini
- Recommended Care: Machine wash & dry. Launder socks inside-out on medium cycle with cold water. Dry on low heat; remove immediately. Do not bleach.
- Guarantee: If you are not completely satisfied with your Mast Store socks, we will replace them or reimburse you for up to one year from date of purchase. Simply send a dated sales receipt along with the laundered socks, an explanation, and a replacement or reimbursement request to Mast Store.
Reviews
- Average 5 out of 5
  
  1 reviews
- Jason
  
  September 27, 2019
  
  Unreal Socks!
  
  Yo, these socks are off the hook cozy, durable and good looking! Diggin them! Perfect multi season merino item for hikes or daily wear. Only problem is I don't have enough in my sock drawer!
Live Chat