Sierra Designs Reverse Combi

Sierra Designs Reverse Combi

Average Rating: rated 3.50 of 5 stars
Reviewed by 3 Trailspace users

Description

The Reverse Combi is a three-season tent made by Sierra Designs. It has an average rating of 3.5 stars (out of 5), based on 3 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 = 'reverse-combi'
				AND brand.brand_id = product.brand_id
				AND brand.brand_id = '94'
			GROUP BY
				product.producttype_id
			ORDER BY
				product.producttype_id

User Reviews

rated 3 of 5 stars Reverse Combi
Reviewed by Jonathan Bushey, Sep 11, 2006

"I write this review after having spent approximately 80 nights in this tent:

I was very careful when I chose this tent. I considered several other similar tents, including Sierra Designs' Electron and The North Face's Road Runner 22. In the end I chose the Reverse Combi because (a) I was very happy with the other SD tent I own, the Bedouin 4, (b) it seemed more durable than the Electron, (c) it had a huge vestibule for a tent in its class, and (d) it won several 'gear-of-the-year' type awards from magazine testers."

Read the complete review »

rated 3 of 5 stars Reverse Combi
Reviewed by Max, Mar 30, 2006

"I wanted a two-person, two door, two pole, two vestibule tent -- this seemed like the one because it is light, compact, and very quick set up. I've used this for kayaking and hiking trips. Great in dry weather -- we made an awning by staking the fly out with hiking poles, which allowed for air flow while preventing dew on everything."

Read the complete review »

rated 4 of 5 stars Reverse Combi
Reviewed by potasa, Mar 27, 2006

"Awesome one-person tent, two can be a bit tight depending on your size. Overall the tent is great. I took it out to Colorado (flat tops wilderness area) for a week and then to Utah (Moab) for a week. Encountered all elements and temperature ranges with it and it stood the test."

Read the complete review »

Have you owned or used a Sierra Designs Reverse Combi? 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 = '8167'
								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 = '94'
								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 Sierra Designs Reverse Combi. 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 Sierra Designs Reverse Combi? List your site here.

Similar Tents

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