User Review: SportHill XC Pant

SportHill XC Pant
Above: The current XC Pant, which may differ slightly from the version reviewed.

Reviewed February 28, 2007 by gmp

Rating:
Fabric: 85% polypro 3SP, 15% lycra
Price Paid: 90$

The Sporthill XC ski pant is the best pant I have for cold weather skiing and trekking in the Catskill Mts. of upstate NY. They are extremely wind resistant,warm and flexible and live up to the manufacturers claims. The zip pockets and ankle zips are invaluable. I own 4 pairs. My one mistake with pair #1 many years ago was to put them in the dryer. They will shrink some. LINE DRY ONLY, as Sporthill washing instruction now specify.

Where to Buy

Can't open file: 'retailer_brand.MYI' (errno: 145)

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 = '20622'
								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

Can't open file: 'retailer_brand.MYI' (errno: 145)

SELECT
								*,
								brand.short_name AS brand,
								retailer.retailer_id AS retailer_id
							FROM 
								brand,
								retailer,
								retailer_brand
							WHERE
								brand.brand_id = '505'
								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 SportHill XC Pant. 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 SportHill XC Pant? List your site here.

Similar Pants

Compare
See how the SportHill XC Pant stacks up against the competition: read more pant reviews or more about SportHill.

Contribute
Have you used a SportHill XC Pant or a similar product? Write a gear review.

Discuss
Still have questions? Answers? Opinions? Join the converstation in the Trailspace Forums.

email this page

Can't open file: 'retailer_brand.MYI' (errno: 145)