Welcome, guest [login | register]

User Review: Mountain Hardwear Link Jacket

Reviewed September 16, 2005 by Devin

Rating:
Fabric: Outer: Microfleece -- Inner: Poly Tricot Knit
Price Paid: $160

Beautiful mid-layer fleece jacket! Depending on your needs...whether over your favorite base or under your favorite shell, you can't beat this jacket in this price range. Functional, comfortable and attractive (I have it in the color Carbon).

Where to Buy

SELECT
								retailer.*,
								retailer_product.*,
								retailer_brand.*,
								retailer.retailer_id AS retailer_id,
								LEAST(
									IF(retailer_product.gender IS NULL,0,100),
									IF(retailer_product.gender = '',0,100),
									IF(retailer_product.gender = 'u',0,100),
									IF(retailer_product.gender = 'm',1,100),
									IF(retailer_product.gender = 'w',2,100),
									IF(retailer_product.gender = 'k',3,100),
									IF(retailer_product.gender = 'b',4,100),
									IF(retailer_product.gender = 'g',5,100)
								) AS gender_sort
							FROM 
								product AS p1,
								product AS p2,
								retailer_product,
								retailer,
								retailer_brand
							WHERE
								p1.product_id = '11895'
								AND p2.brand_id = p1.brand_id
								AND p2.product_name = p1.product_name
								AND retailer_product.product_id = p2.product_id
								AND retailer_product.status = 'active'
								AND retailer_product.product_link_url != ''
								AND retailer.retailer_id = retailer_product.retailer_id
								AND retailer.is_online = 1
								AND retailer.status = 'active'
								AND retailer.show_product_link = 1
								AND retailer_brand.retailer_id = retailer.retailer_id
								AND retailer_brand.retailer_brand_id = retailer_product.retailer_brand_id
							GROUP BY
								retailer.retailer_id,
								retailer_product.retailer_product_id
							ORDER BY
								retailer.avg_epc DESC,
								retailer.commission_rate DESC,
								retailer.cookie_days DESC,
								retailer.retailer_id ASC,
								price ASC,
								gender_sort ASC
							

SELECT
								*,
								brand.short_name AS brand,
								retailer.retailer_id AS retailer_id
							FROM 
								brand,
								retailer,
								retailer_brand
							WHERE
								brand.brand_id = '90'
								AND retailer_brand.brand_id = brand.brand_id
								AND retailer_brand.status = 'active'
								AND retailer.retailer_id = retailer_brand.retailer_id
								AND retailer.is_online = 1
								AND retailer.status = 'active'
								AND retailer.show_brand_link = 1
							GROUP BY
								retailer.retailer_id
							ORDER BY
								# is_house_brand DESC,
								retailer.avg_epc DESC,
								retailer.commission_rate DESC,
								retailer.cookie_days DESC,
								retailer.retailer_id ASC
							

Sorry, we couldn't find any online retailers selling the Mountain Hardwear Link Jacket. You may be able to find it new or used at one of these sites:

Trailspace Classifieds

US | Canada | UK | Aus

GearTrade

Retailers: Do you sell the Mountain Hardwear Link Jacket? List your site here.

Similar Jackets

• Mountain Hardwear Lynx Jacket
• Mountain Hardwear Windstopper Tech Jacket
• Patagonia R4 Jacket
• The North Face Sentinel WindStopper Jacket
• Arc'teryx Delta SV Jacket
• Cloudveil Wister Jacket
• More Fleece Jackets »