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

 Shimano Curado Spinning Rod Hover to Zoom

shimano

Shimano Curado Spinning Rod

 Item# CDS70LA

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

$159.99 to $169.99

Out Of Stock

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] CDS70LA N STK 0 22841 Shimano Curado Spinning Rod [empty string] 600035 [empty string] CDS70LA 1812685 [empty string] CDS70LA 1
2 [empty string] [empty string] CDS70MA N STK 0 22842 Shimano Curado Spinning Rod [empty string] 600036 [empty string] CDS70MA 1812686 [empty string] CDS70LA 2
3 [empty string] [empty string] CDS70MLA N STK 0 22843 Shimano Curado Spinning Rod [empty string] 600037 [empty string] CDS70MLA 1812687 [empty string] CDS70LA 3
4 [empty string] [empty string] CDS72MHA N STK 0 22844 Shimano Curado Spinning Rod [empty string] 600038 [empty string] CDS72MHA 1812688 [empty string] CDS70LA 4
CACHED false
EXECUTIONTIME 47
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 = 'CDS70LA' AND (upper(f.web_text) = 'SHIMANO' or upper(f.orig_text) = 'SHIMANO' or upper(a.brand) = 'SHIMANO') 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

Shimano redesigned the Curado series of spinning rods with power and versatility for the tournament angler. Now featuring Shimano's Hi-Power X technology that utilizes diagonally-wrapped carbon tape forming "X" shapes on the rod blank's outermost layer, the Curado series provides anglers with rods showcasing increased strength and improved casting performance. The Curado series of rods now feature Shimano CI4+ reel seats for increased sensitivity and reduced weight. The combination of Fuji tangle-free K guides with FazLite inserts is the ideal guide train for reducing line tangles and providing anglers the option to fish with monofilament, fluorocarbon or PowerPro braided fishing line. Shimano built the Curado series of spinning rods for tournament anglers with powers and actions to fulfill the spectrum of techniques one may face when a check is on the line.

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


4 Styles Available

  Item Price Length Feet Pieces Power Stock Qty
CDS70LA $159.99 7 ft 1 Light, fast 0
CDS70MA $159.99 7 ft 1 Medium, Fast 0
CDS70MLA $159.99 7 ft 1 Medium Light, Fast 0
CDS72MHA $169.99 7 ft 2 in 1 Medium Heavy, Fast 0

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.