MEN'S TOA

hoka one one

No 1112032_PHN

Be the first to review!

$170.00

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	7052	[empty string]	[empty string]	0	2	0	0	PHANTOM	58	Y	[empty string]	836429	[empty string]	174498

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	174498

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

CHOOSE Size

Size Chart

Size

One

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

Run, hike & reach for the sky!

There are so many sights to be seen and mountain peaks to be conquered, so lace up the Men's Toa from Hoka One One and find your next adventure! Design to handle the elements, these waterproof hiking boots feature a breathable technical upper, cushioned Rangi foam midsole, and grippy Vibram Megagrip outsole. Whether you're speeding uphill or cautiously heading back down, these light-as-air hikers provide just the right amount of support and traction to keep you going.

eVent Waterproof bootie keeps your feet comfortable and dry
Upper: Technical synthetic upper offers durability, breathability, and lightweight
Midsole: Rangi™ midsole foam offers durable cushioning and a responsive feel
Outsole: Vibram® Megagrip hi-traction outsole; Multidirectional lugs for supreme grip on varied terrain
Heel-toe drop: 4mm
Average weight (men's size 9): 14.99 ounces

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

There are so many sights to be seen and mountain peaks to be conquered, so lace up the Men's Toa from Hoka One One and find your next adventure! Design to handle the elements, these waterproof hiking boots feature a breathable technical upper, cushioned Rangi foam midsole, and grippy Vibram Megagrip outsole. Whether you're speeding uphill or cautiously heading back down, these light-as-air hikers provide just the right amount of support and traction to keep you going.
Specs
- eVent Waterproof bootie keeps your feet comfortable and dry
- Upper: Technical synthetic upper offers durability, breathability, and lightweight
- Midsole: Rangi™ midsole foam offers durable cushioning and a responsive feel
- Outsole: Vibram® Megagrip hi-traction outsole; Multidirectional lugs for supreme grip on varied terrain
- Heel-toe drop: 4mm
- Average weight (men's size 9): 14.99 ounces
Reviews

No Reviews Yet!
Live Chat

MEN'S TOA

$170.00

Choose Color

CHOOSE Size

One

Qty

Spill the Beans

You may also like