TRESTLES 15 SLEEPING BAG - REGULAR

No 23530

Be the first to review!

$109.00

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	COBALT_BLUE/BLUE_NT	74140	[empty string]	[empty string]	0	2	0	0	COBALT_BLUE/BLUE_NT	12	[empty string]	692341	[empty string]	140458

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 (11,5,8,6,9,14,15,7,2,1,3) 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(11,5,8,6,9,14,15,7,2,1,3) 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	140458

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

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

bring on the cold

Whether you've built a snow cave or found cover in a trail shelter, the Trestles 15 Sleeping Bag by Marmot will keep you toasty and warm. This SpiraFil synthetic insulated sleeping bag is the ideal choice for mountaineering, camping and backpacking alike as it keeps warmth when damp and is rated to 15° F. It's constructed from tough polyester that features an improved fabric lining for increased comfort, anatomical 3D foot box for natural foot positioning, and easy to grab cinch cords to block the cold. It easily compresses into its stuff sack and with other handy features, this bag easily moves to the top of the cold weather camping list.

SpiraFil® high loft insulation for maximum warmth and durability
Fold-down second zipper provides added ventilation and easy access
Insulated collar with easy access cord
Wave construction top provides maximum loft and warmth
Anatomically 3D footbox increases the insulation and room for your feet
Compression stuff sack
Stash pocket
Freely draw cords
Hood draw cord
Snagless draft tube
Two-way zipper sliders
Two hang loops
Velcro®-free face muff
Zipper garage
EN tested
Main materials: 70d 100% polyester 2.2 ounces/yard, 70d 100% polyester Embossed 2.2 ounces/yard
Lining material: 70d 100% polyester 2.2 ounces/yard
Insulation material: Spirafil®? LT
Bag temperature: 15°F / -9°C
EN rating: Comfort: 27.3°F / -2.6°C | Lower limit: 16°F / -8.9°C | Extreme: -27.2°F / -17°C
Bag zipper position: left hand zip, right hand zip
Weight: 3 pounds 6.1 ounces (1535g)

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

Whether you've built a snow cave or found cover in a trail shelter, the Trestles 15 Sleeping Bag by Marmot will keep you toasty and warm. This SpiraFil synthetic insulated sleeping bag is the ideal choice for mountaineering, camping and backpacking alike as it keeps warmth when damp and is rated to 15° F. It's constructed from tough polyester that features an improved fabric lining for increased comfort, anatomical 3D foot box for natural foot positioning, and easy to grab cinch cords to block the cold. It easily compresses into its stuff sack and with other handy features, this bag easily moves to the top of the cold weather camping list.
Specs
- SpiraFil® high loft insulation for maximum warmth and durability
- Fold-down second zipper provides added ventilation and easy access
- Insulated collar with easy access cord
- Wave construction top provides maximum loft and warmth
- Anatomically 3D footbox increases the insulation and room for your feet
- Compression stuff sack
- Stash pocket
- Freely draw cords
- Hood draw cord
- Snagless draft tube
- Two-way zipper sliders
- Two hang loops
- Velcro®-free face muff
- Zipper garage
- EN tested
- Main materials: 70d 100% polyester 2.2 ounces/yard, 70d 100% polyester Embossed 2.2 ounces/yard
- Lining material: 70d 100% polyester 2.2 ounces/yard
- Insulation material: Spirafil®? LT
- Bag temperature: 15°F / -9°C
- EN rating: Comfort: 27.3°F / -2.6°C | Lower limit: 16°F / -8.9°C | Extreme: -27.2°F / -17°C
- Bag zipper position: left hand zip, right hand zip
- Weight: 3 pounds 6.1 ounces (1535g)
Reviews

No Reviews Yet!
Live Chat

TRESTLES 15 SLEEPING BAG - REGULAR

$109.00

Choose Color

Qty

Description

Specs

Reviews

Live Chat

Spill the Beans

You may also like