User Review: Mountain Hardwear Skyview 3

Mountain Hardwear Skyview 3
Above: The current Skyview 3, which may differ slightly from the version reviewed.

Reviewed November 7, 2002 by Jeff Redding

Rating:
Sleeps: 3

I have had my Skyview 3 for several years now and have found it to be an excellent value. I have spent a few nights in some heavy storm conditions, and found it to be very water tight as well as stable in cross winds. Plenty of room for three people, and the vestibule provides roomy storage for packs and supplies. The convertible nature of this tent allows you to use it in hot weather, or roof panel zipped in for colder weather. I popped for the MH pre-cut footprint, and nice easton pegs and they have worked like a charm! This tent is no lightweight, but parts distributed between 2-3 people make it more than liveable. I have been told that you can actually use the fly and footprint without the tent itself for a lightweight shelter option.

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 = '5726'
								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 = '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 Skyview 3. 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 Skyview 3? List your site here.

Similar Tents

Compare
See how the Mountain Hardwear Skyview 3 stacks up against the competition: read more tent reviews or more about Mountain Hardwear.

Contribute
Have you used a Mountain Hardwear Skyview 3 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)