HELIOS SUSPENSION SYSTEM

No HS002

Be the first to review!

$34.95

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BLACK	95776	[empty string]	[empty string]	0	9	0	0	GREY	61	Y	[empty string]	840848	[empty string]	175278

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) >= 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 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) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	175278

struct
INTERNALLISTPRICE	34.95
INTERNALMARKDOWN	false
INTERNALPRICE	34.95
REG	34.95
SALE	34.95
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

Serious support

When your hammock habit requires some heavy duty support, look no further than the Helios Suspension System by Eagles Nest Outfitters. This system is made of over 11.5 feet of polyester sling and Dyneema® Rope which makes it a lightweight, durable, and sturdy way to secure your hammock. The Helios Suspension System is designed to be setup and torn down easily, allowing time for important things — like relaxing in your hammock and taking in the scenery. When it comes time to tear down, know that you can easily remove the straps and safely stow it in the sil nylon compression stuff sack. For the die hard, serious hammocker, this is the most reliable and robust suspension system on the market.

Safely supports up to 300 pounds
ENO's lightest suspension system
Set up and take down in seconds
ENO's lightest suspension system
Lightweight sil nylon stuff sack
Tree friendly
Material: Polyester Sling and Dyneema® Rope
Dimensions: 8 feet 2 inches x 1 inch (length x width)
Weight: 4.1 ounces
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

When your hammock habit requires some heavy duty support, look no further than the Helios Suspension System by Eagles Nest Outfitters. This system is made of over 11.5 feet of polyester sling and Dyneema® Rope which makes it a lightweight, durable, and sturdy way to secure your hammock. The Helios Suspension System is designed to be setup and torn down easily, allowing time for important things — like relaxing in your hammock and taking in the scenery. When it comes time to tear down, know that you can easily remove the straps and safely stow it in the sil nylon compression stuff sack. For the die hard, serious hammocker, this is the most reliable and robust suspension system on the market.
Specs
- Safely supports up to 300 pounds
- ENO's lightest suspension system
- Set up and take down in seconds
- ENO's lightest suspension system
- Lightweight sil nylon stuff sack
- Tree friendly
- Material: Polyester Sling and Dyneema® Rope
- Dimensions: 8 feet 2 inches x 1 inch (length x width)
- Weight: 4.1 ounces
- Imported
Reviews

No Reviews Yet!
Live Chat