Eagle Creek

Eagle Creek Cargo Hauler Duffel 60L

$109.00

Item # EC0A48XX

This item ships for FREE
query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 60L 23 152313 60L [empty string] 518389 137970
CACHED false
EXECUTIONTIME 375
SQL SELECT distinct (b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh) as qoh, max(a.style_id) as style_id FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries b WITH (NOLOCK) on (b.scale_entry_id = a.scale_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_entries d WITH (NOLOCK) on (d.attr1_entry_id = a.attr1_entry_id) LEFT JOIN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = ? and web_style is not null ) sq ON(a.style_id = sq.style_id) WHERE (sq.style_id is not null OR a.style_id = ?) AND (b.siz_alias is null OR b.siz_alias NOT IN ('NO SHOW','NOSHOW') ) AND isNull(a.sell_web,'Y') = 'Y' AND e.qoh > 1 GROUP BY b.siz ORDER BY max(b.size_order), max(a.scale_entry_id)
SQLPARAMETERS
array
1 EC0A48XX
2 137970
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 JET_BLK_281 [empty string] 130896 [empty string] [empty string] JET_BLK_281 9 152313 518387 [empty string] 137970
2 GOLD.ST_312 [empty string] 130897 [empty string] [empty string] GOLD.ST_312 8 152313 518388 [empty string] 137970
3 CALI.HIERO_313 [empty string] 130898 [empty string] [empty string] CALI.HIERO_313 6 152313 518389 [empty string] 137970
CACHED false
EXECUTIONTIME 0
SQL SELECT distinct (b.attr1) as origAttr1, max(b.attr1_alias) as attr1_alias, 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) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam, max(a.style_id) as style_id, max(a.SCALE_ENTRY_ID) as size FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_size_entries k WITH (NOLOCK) on (k.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE a.style_id =? AND (b.attr1_alias is null OR b.attr1_alias NOT IN ('NO SHOW','NOSHOW') ) AND e.qoh > 1 AND isNull(a.sell_web,'Y') = 'Y' GROUP BY b.attr1 ORDER BY sum(e.qoh) DESC --max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 137970
Eagle Creek Cargo Hauler Duffel 60L JET_BLK_281 Eagle Creek Cargo Hauler Duffel 60L GOLD.ST_312 Eagle Creek Cargo Hauler Duffel 60L CALI.HIERO_313
60L
Add to Cart Find in Store Add to Wish List

product description

The mid-sized Eagle Creek Cargo Hauler Duffel 60L is a go-to duffel with plenty of space for all your gear. Where size and convenience meet, with an internal divider to help keep your internal items separated, but organized. Keep your clean items away from the dirty, or put clothes on one side and shoes on the other. It's lightweight and versatile, with grab handles and three easy ways to carry. Six lash points give you the ability to strap it to your roof for any traveler on the move.

product specs
  • Integrates with Eagle Creek's Pack-It System
  • Extra durable, water repellent fabric
  • Zippered end pockets
  • Foam padded bottom
  • Lockable zippers
  • Reflective material adds safety for night use
  • Folds into its front zipper compartment
  • Dimensions: 26.75in x 10.25in x 13.5in / 68 x 26 x 34cm
  • Capacity: 3845cu in / 63L
  • Weight: 2lb 3oz / 1.02kg
  • Material: TPU 600D Poly, 1000D Helix Poly Twill
Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review
Very Poor Poor Average Very Good Excellent
Name: *
Location:
Review Title:
Review: * (maximum 1000 characters)
1 - 0 of 0

No reviews have been written for this product.
Be the first one!  –


FREE SHIPPING* ON ORDERS OVER $100.00
My Bag (0)
Menu

query
RESULTSET
query
  ADDITIONAL_DESCRIPTION AGERANGE ALTIMAGERECORDCOUNT ATTR1ID ATTR1LIST ATTR2ID BRAND BRANDDISPLAY DEPT DEPTTREE DESCRIPTION FAMLIST GENDER GOOGLEPRODUCTTAXONOMY HEXLIST ID INSTORE_ONLY INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE KEYWORDS LARGEPICTURE LISTPRICE LOWESTPRICE MEDIUMPICTURE METADESC METATAGS NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 ORIGBRAND OVERALLQOH OVERALL_RATING PAGETITLE PICTUREID PICTURE_ID PRICERANGE PRODREVIEWSAVERAGE PRODREVIEWSRECORDCOUNT QUANTITYONHANDSUM QUANTITYSOLDSUM RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SCALEID SHIP_SURCHARGE SIZELIST SIZING_IMAGE_FILE SMALLPICTURE SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TINYPICTURE TYP URL USEPACKAGE VIDEO WEBSTYLE WEB_OF1 WEB_OF10 WEB_OF11 WEB_OF12 WEB_OF13 WEB_OF14 WEB_OF15 WEB_OF16 WEB_OF17 WEB_OF18 WEB_OF19 WEB_OF2 WEB_OF20 WEB_OF3 WEB_OF4 WEB_OF5 WEB_OF6 WEB_OF7 WEB_OF8 WEB_OF9
1 <ul> <li>Integrates with Eagle Creek&#39;s Pack-It System</li> <li>Extra durable, water repellent fabric</li> <li>Zippered end pockets</li> <li>Foam padded bottom</li> <li>Lockable zippers</li> <li>Reflective material adds safety for night use</li> <li>Folds into its front zipper compartment</li> <li>Dimensions: 26.75in x 10.25in x 13.5in / 68 x 26 x 34cm</li> <li>Capacity: 3845cu in / 63L</li> <li>Weight: 2lb 3oz / 1.02kg</li> <li>Material: TPU 600D Poly, 1000D Helix Poly Twill</li> </ul> [empty string] [empty string] 59807 JET_BLK_281,GOLD.ST_312,CALI.HIERO_313, [empty string] EAGLE CREEK Eagle Creek TRAVEL & OUTDOOR GEAR Travel & Outdoor Gear &gt Luggage &gt Duffels [empty string] [empty string] [empty string] 596 [empty string] 26337462 [empty string] 109 109 109 [empty string] 37299-DEFAULT-l.jpg 109 [empty string] 37299-DEFAULT-m.jpg Ideal size for short trips, make the Eagle Creek Cargo Hauler Duffel 60L your go-to weekender bag. [empty string] CARGO HAULER DUFFEL 60L N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] ACTIVE [empty string] 05B [empty string] [empty string] FALL_1 [empty string] [empty string] [empty string] N EAGLE CREEK, INC. 22 0 [empty string] 37299 37299 [empty string] 0.00 0 [empty string] [empty string] [empty string] Eagle Creek Cargo Hauler Duffel 60L <p>The mid-sized Eagle Creek Cargo Hauler Duffel 60L is a go-to duffel with plenty of space for all your gear. Where size and convenience meet, with an internal divider to help keep your internal items separated, but organized. Keep your clean items away from the dirty, or put clothes on one side and shoes on the other. It&#39;s lightweight and versatile, with grab handles and three easy ways to carry. Six lash points give you the ability to strap it to your roof for any traveler on the move.</p> [empty string] N 109 109 60890 0 60L, [empty string] 37299-DEFAULT-s.jpg 1000 EC0A48XX 137970 DUFFELS EMPTY EMPTY 0 2 [empty string] 37299-DEFAULT-xs.jpg LUGGAGE shop/eagle-creek-cargo-hauler-duffe-137970 0 [empty string] EC0A48XX [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 0
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='137970' order by ID desc