MEN'S REVOLVR PANT

No 5124_DRFT

Be the first to review!

^$79⁰⁰

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	TAN,BROWN,GREEN	1124	[empty string]	[empty string]	0	2	0	0	DRIFTWOOD	53	[empty string]	846650	[empty string]	176471

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 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 (3,8,9,1,2,6,11,14,5,7) group by sku_id having sum(qoh+qc) >=2) 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 not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(3,8,9,1,2,6,11,14,5,7) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	176471

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

CHOOSE Size

Size Chart

Size

Choose INSEAM

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

come out shootin'!

Quick as a shot, the Men's Kühl Revolvr Pants were made for men on the go. Featuring quick-dry Überkühl technology, these versatile pants are made of a cotton, nylon, and spandex blend that delivers unmatched comfort, breathability, and freedom of movement. The vintage patina dye and river wash of the fabric gives it a broken-in look. The Revolvr has scuff guards at the cuffs for added durability, front and back pockets as well as a cell phone pocket, and articulated knees and a gusseted crotch provide extra freedom to move. The relaxed full fit design has more room in the seat and thighs. Great for climbing, hiking, traveling, whatever you fancy. Forget about restrictions, aim high, and keep going!

Fabric:UberKUHL: 68% cotton, 29% nylon, 3% spandex
Uberkühl™ provides the comfort of cotton and the quick dry of a technical fabric with unmatched breathability
Vintage patina dye and river wash create a worn-in look
Free Ryde™ waistband peached for increased wicking performance, fast drying time; follows natural contour of the body
Double layer scuff-guard at cuffs and pockets for über durability
Front and back pockets
3-D cell phone and coin pocket
Articulated knees to allow you full range of motion
Born Free™ gusseted crotch's extra fabric gives you freedom to move
Full fit: full-seat and thigh for a more relaxed fit
Machine wash, tumble dry
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

Quick as a shot, the Men's Kühl Revolvr Pants were made for men on the go. Featuring quick-dry Überkühl technology, these versatile pants are made of a cotton, nylon, and spandex blend that delivers unmatched comfort, breathability, and freedom of movement. The vintage patina dye and river wash of the fabric gives it a broken-in look. The Revolvr has scuff guards at the cuffs for added durability, front and back pockets as well as a cell phone pocket, and articulated knees and a gusseted crotch provide extra freedom to move. The relaxed full fit design has more room in the seat and thighs. Great for climbing, hiking, traveling, whatever you fancy. Forget about restrictions, aim high, and keep going!
Specs
- Fabric:UberKUHL: 68% cotton, 29% nylon, 3% spandex
- Uberkühl™ provides the comfort of cotton and the quick dry of a technical fabric with unmatched breathability
- Vintage patina dye and river wash create a worn-in look
- Free Ryde™ waistband peached for increased wicking performance, fast drying time; follows natural contour of the body
- Double layer scuff-guard at cuffs and pockets for über durability
- Front and back pockets
- 3-D cell phone and coin pocket
- Articulated knees to allow you full range of motion
- Born Free™ gusseted crotch's extra fabric gives you freedom to move
- Full fit: full-seat and thigh for a more relaxed fit
- Machine wash, tumble dry
- Imported
Reviews

No Reviews Yet!
QA

Your Name Email Question
Live Chat

MEN'S REVOLVR PANT

Choose Color

CHOOSE Size

Choose INSEAM

Qty

Spill the Beans

You may also like

$99