Vasque Apex
Average Rating: ![]()
Reviewed by 9 Trailspace users
Description
The Apex is a mountaineering boot made by Vasque. It has an average rating of 3.5 stars (out of 5), based on 9 user reviews.
Can't open file: 'retailer_brand.MYI' (errno: 145) SELECT
product.product_id,
brand.brand_id,
brand.short_name AS brand,
brand.url_stub AS brand_url_stub,
product.product_name,
product.producttype_id AS producttype_id,
product.gender,
product.url_stub,
product.description,
product.manufacturer_description,
UNIX_TIMESTAMP(product.date_available) AS date_available,
product.date_available_note,
product.price_msrp,
product.specs,
# GROUP_CONCAT(DISTINCT(IF(product.gender IN('u'),'m,w',IF(product.gender IN('b','g'),'k',product.gender)))) AS genders,
product_totals.overall_average_rating AS average_rating,
product_totals.overall_num_reviews AS num_reviews,
product_totals.num_retailers
FROM
(
product,
brand
)
LEFT JOIN
product_totals
ON
product_totals.product_id = product.product_id
WHERE
product.url_stub = 'apex'
AND brand.brand_id = product.brand_id
AND brand.brand_id = '78'
GROUP BY
product.producttype_id
ORDER BY
product.producttype_id
User Reviews
Men's Apex
Reviewed by wayofthemaster, May 23, 2007
Men's Apex
Reviewed by Lando, Oct 13, 2006
Apex
Reviewed by an anonymous hiker, Apr 30, 2001
Men's Apex
Reviewed by Michael Geibelson, Oct 19, 1999
Men's Apex
Reviewed by Colin Cunningham, Nov 15, 1998
Men's Apex
Reviewed by Michael Hinshaw, Dec 03, 1997
Men's Apex
Reviewed by an anonymous hiker, Oct 08, 1997
Pros - They are tough and provide good support."
Men's Apex
Reviewed by Craig Patterson, Sep 29, 1997
Apex
Reviewed by an anonymous hiker, Feb 17, 1997
The boots are very waterproof, sturdy, and their Vibram soles give great grip on any terrain - but, if you plan to walk epic distances, your feet will feel like hamburger."
Have you owned or used a Vasque Apex? Share your thoughts with other hikers and backpackers.
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 = '9691' 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 ASCCan'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 = '78' 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 Vasque Apex. 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 Vasque Apex? List your site here.



