California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account

 Rush Creek Double Sided 16 Fishing Rod Rack Hover to Zoom

rush creek

Rush Creek Double Sided 16 Fishing Rod Rack

 Item# 38-3007

rating 2.0rating 2.0rating 2.0rating 2.0rating 2.0 1 Reviews

$109.99

query
RESULTSET
query
  ATTR1ID ATTR2ID CAPACITY NON_INVT OF8 OVERALLQOH PICTURE_ID REALNAME SCALEID SKU_ID SKU_OF7 STYLE STYLE_ID USEPACKAGE WEBSTYLE WEBSTYLE_SORT
CACHED false
EXECUTIONTIME 31
SQL SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '38-3007' AND (upper(f.web_text) = 'RUSH CREEK' or upper(f.orig_text) = 'RUSH CREEK' or upper(a.brand) = 'RUSH CREEK') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
1


Duly named the Infinity Series, these are made from multiple layers of wood to create the most durable rod rack in the market. Dual Rod Clip Technology and marine grade varnish, this rod rack is highly recommended
Features:
Multi-layers of plywood are used to construct this double sided rod rack
Extra wide one-piece heavy duty side panels
Angled handle rests makes it easy to access the rods
Built-in handles
Marine grade varnish is used to seal coat and make water resistant
Hidden fastening system hides all screws for a clean look
Easy to assemble
Assembled rack size is 27’5″ x 12.13″ x 34.75″

 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

Average of 2 customer reviews: rating 2.0rating 2.0rating 2.0rating 2.0rating 2.0      Write a Review



Visalia,CA
January 2020

Poor finish and assembly hardware
2/5 rating 2.0rating 2.0rating 2.0rating 2.0rating 2.0

Age Range: 55-64
Gender: male
How Long Have You Been Using This Product: Less than 1 month

Outside of package was undamaged but when opened there were several scratches on unit. Once I started to assemble it was obvious why finish was damaged. If you even drug your fingernail on wood finish would peel off. Wood was very low quality with filler used to fill in voids. Rack uses poor quality two piece fasteners which have to allow pin half to go thru them to assemble Holes were not drilled in alighment and hardware had burrs impeding pins from going thru. After drilling some holes to align I was able to get assembled but unit does not sit level. I will probably,in the future, refinish and/or paint the rack. I feel 2 stars is very generous


We Also Recommend Next Prev

x

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy  click here.