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

 Dobyns Rods Colt Casting Rod Hover to Zoom

dobyns

Dobyns Rods Colt Casting Rod

 Item# CL 703C

rating 1.0rating 2.0rating  3.0rating 4.0rating 5.0 0 Reviews

$79.99

$71.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
1 [empty string] [empty string] CL 703C N STK 12 23610 Dobyns Rods Colt Casting Rod [empty string] 595944 [empty string] CL 703C 1808594 [empty string] CL 703C 1
2 [empty string] [empty string] CL 704C N STK 25 23609 Dobyns Rods Colt Casting Rod [empty string] 595945 [empty string] CL 704C 1808595 [empty string] CL 703C 2
3 [empty string] [empty string] CL 734C N STK 29 23608 Dobyns Rods Colt Casting Rod [empty string] 595947 [empty string] CL 734C 1808597 [empty string] CL 703C 3
CACHED false
EXECUTIONTIME 63
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,4) ) 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 = 'CL 703C' AND (upper(f.web_text) = 'DOBYNS' or upper(f.orig_text) = 'DOBYNS' or upper(a.brand) = 'DOBYNS') 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
8 DOA
3

The Colt Series was developed for budget-minded anglers that still demand a quality, balanced and sensitive rod.
The Colt Series will be enjoyed by anglers of all ages and abilities and has already proven to be a favorite rod among fishing guides. If you are looking for a rod that won’t break the bank, but is still an awesome every day bass rod, be sure and give the Colt Series a try!


Features:

 

  • High modulus graphite blank
  • Performance balanced
  • Kevlar wrapping
  • Hi-density EVA handle
  • Sea Guides
  • Technique Specific
 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one!  – Write a Review


3 Styles Available

  Item Price Length Feet Line Weight (Lb.) LureWeight (Ounces) Pieces Stock Qty
CL 703C $79.99 $71.99 7 ft 10-17 lb 1/4-3/4 oz 1 10+
CL 704C $79.99 $71.99 7 ft 10-20 lb 1/4-1 oz 1 10+
CL 734C $79.99 $71.99 7 ft 3 in 10-20 lb 1/4-1 oz 1 10+

arrow to add to cart button
Add to Wish List

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.