PRANA

prAna Men's Stretch Zion Shorts - 10in Inseam

$69.00

Item # M3ST10117

query
RESULTSET
query
  ATTR2 ATTR2_ENTRY_ID ORIGATTR2 QOH SKU_ID
1 . 49293 . 81 544430
CACHED false
EXECUTIONTIME 407
SQL SELECT distinct (b.attr2) as origAttr2, max(CASE WHEN b.attr2_alias IS NULL OR RTRIM(LTRIM(b.attr2_alias)) = '' THEN b.attr2 ELSE b.attr2_alias END) as attr2, max(a.sku_id) as sku_id, max(b.attr2_entry_id) as attr2_entry_id, sum(e.qoh+e.qc) as qoh FROM tb_skus a LEFT JOIN tb_attr2_entries b WITH (NOLOCK) ON (b.attr2_entry_id = a.attr2_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) WHERE (a.style_id IN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = 'M3ST10117' and web_style > '' and web_style is not null ) or a.style_id =?) AND isNull(a.sell_web,'Y') = 'Y' AND e.store_id in(98,8,9,2,5,7,6,3) --AND e.qoh > 1 GROUP BY b.attr2 HAVING sum(e.qoh+e.qc) > 1
SQLPARAMETERS
array
1 109354
prAna Men's Stretch Zion Shorts - 10in Inseam DKKHAKI prAna Men's Stretch Zion Shorts - 10in Inseam CHARCOAL prAna Men's Stretch Zion Shorts - 10in Inseam MUD
28 30 31 32 33 34 35 36 38 40
Add to Cart Find in Store Add to Wish List

product description

The prAna Men's Stretch Zion Shorts - 12in Inseam are an excellent choice for virtually any activity. With its abrasion-resistant Stretch Zion material and ventilated inseam gusset, these shorts work great for anything from a day of hiking and a snack at the summit or a morning paddle before lunchtime tacos. The mesh pockets and quick drying material keep you dry and comfortable, no matter what your day finds.

 

product specs
  • Original Stretch 'Zion' fabric with wicking finish
  • Streamlined adjustable waistband system
  • Ventilated inseam gusset
  • Mesh pocketing
  • Standard fit
  • Abrasion resistant
  • Quick drying
  • Inseam: 10in
  • Fabric: 97% Nylon / 3% Spandex
Overall Rating

5.0/5.0

Review Stats 1 total reviews

5 1

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 - 1 of 1

Ian M.      8 months ago

Review

I’m a big fan of prAna’s pants and shorts, and these shorts do not disappoint. They’re comfortable, very stretchy, fast drying and versatile. I use these shorts out on the town, riding my bike, hiking through the woods and climbing up and over rocks. The 12 inch shorts are the perfect fit for someone who doesn’t want their thigh to show but also doesn’t want their shorts to get caught on their knees. The cargo pocket on the left leg of the shorts is great for someone who needs access while being active. The pocket gives you access from the top and side, which means you can access it while standing, sitting, biking or on the side of a climbing wall. It’s fast drying which helps when you get caught in a little rain or worked up a sweat. If you are looking for shorts you can use everywhere, with a little more storage and feel comfortable doing it, these are the shorts for you. Whole Earth Product Tester - Product Provided


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>Original Stretch &#39;Zion&#39; fabric with wicking finish</li> <li>Streamlined adjustable waistband system</li> <li>Ventilated inseam gusset</li> <li>Mesh pocketing</li> <li>Standard fit</li> <li>Abrasion resistant</li> <li>Quick drying</li> <li>Inseam: 10in</li> <li>Fabric: 97% Nylon / 3% Spandex</li> </ul> [empty string] [empty string] 62557 DKKHAKI,CHARCOAL,MUD, 49271 PRANA PRANA CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Bottoms [empty string] [empty string] [empty string] 204 [empty string] 37461656 [empty string] 69 69 69 Prana, stretch zion, quick dry, standard fit, gusset, ventilated, short 11356-DEFAULT-l.jpg 69 [empty string] 11356-DEFAULT-m.jpg Dry, wet, fast, slow, the prAna Men's Stretch Zion Short 10in are ready for nearly anything you can put them through. [empty string] M/ Stretch Zion Short 10IN N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] [empty string] 71G [empty string] [empty string] SPRING [empty string] [empty string] [empty string] [empty string] PRANA 71 5 [empty string] 11356 11356 50-to-100 5.00 1 [empty string] [empty string] [empty string] prAna Men's Stretch Zion Shorts - 10in Inseam <p>The prAna Men&#39;s Stretch Zion Shorts - 12in Inseam are an excellent choice for virtually any activity. With its abrasion-resistant Stretch Zion material and ventilated inseam gusset, these shorts work great for anything from a day of hiking and a snack at the summit or a morning paddle before lunchtime tacos. The mesh pockets and quick drying material keep you dry and comfortable, no matter what your day finds.</p> <p>&nbsp;</p> [empty string] N 69 69 2178 0 28,30,31,32,33,34,35,36,38,40, [empty string] 11356-DEFAULT-s.jpg 1000 M3ST10117 109354 BOTTOMS EMPTY EMPTY 0 [empty string] [empty string] 11356-DEFAULT-xs.jpg MENS shop/prana-mens-stretch-zion-shorts-109354 0 [empty string] M3ST10117 [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 15
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='109354' order by ID desc