User Review: Scarpa SL M3

Scarpa SL M3
Above: The current SL M3, which may differ slightly from the version reviewed.

Reviewed April 10, 2007 by MoooMooocow

Rating:
Materials: hs12 leather
Use: backpacking, hiking, rough trails light pack
Break-in Period: none really (2-3 hours around house)
Weight: 105
Price Paid: $100

These boots rock. I have the older model and they are so well made that I can't believe I got such a good deal on them. They are very rugged and stiff. I broke them in by wearing them around the house a little, and after a couple of days went on a 3-mile hike with no hot spots or blisters! I have a narrow heal, low volume flat foot. I was pleased that these boots felt really good for my type of foot. Not only do they feel good, they're bomb proof. Oh and last but not least, they are some good looking boots. I am sure they will get all scuffed up but they're hiking boots, who cares!

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 = '7921'
								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 = '72'
								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 Scarpa SL M3. 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 Scarpa SL M3? List your site here.

Similar Footwear

Compare
See how the Scarpa SL M3 stacks up against the competition: read more footwear reviews or more about Scarpa.

Contribute
Have you used a Scarpa SL M3 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)