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

 Hayabusa Finesse Drop Shot Hook Hover to Zoom

hayabusa

Hayabusa Finesse Drop Shot Hook

 Item# EC99681-8

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

$3.39

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] #8 N STK 0 22472 Hayabusa Finesse Drop Shot Hook [empty string] 488628 [empty string] EC99681-8 660256 [empty string] EC99681-8 1
2 [empty string] [empty string] #6 N STK 0 22473 Hayabusa Finesse Drop Shot Hook [empty string] 488629 [empty string] EC99681-6 660257 [empty string] EC99681-8 2
3 [empty string] [empty string] #4 N STK 0 22474 Hayabusa Finesse Drop Shot Hook [empty string] 488630 [empty string] EC99681-4 660258 [empty string] EC99681-8 3
4 [empty string] [empty string] #2 N STK 0 22475 Hayabusa Finesse Drop Shot Hook [empty string] 488631 [empty string] EC99681-2 660259 [empty string] EC99681-8 4
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,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 = 'EC99681-8' AND (upper(f.web_text) = 'HAYABUSA' or upper(f.orig_text) = 'HAYABUSA' or upper(a.brand) = 'HAYABUSA') 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
2

Finesse bass fishing is a staple fishing tactic for bass fishermen around the globe. Bass anglers debate about the necessity of finesse fishing everyday. Truth is, as the sport’s evolution continues, finesse fishing has become a tremendously important part of tournament fishing. Without it, tournament anglers would struggle to catch five fish limits at different parts of the season. Most bass fishermen recognize the important role finesse fishing plays in remaining competitive and relevant. In general, it is common sense to suggest that, regardless of what type of fishing an angler views as beneficial, fishing hook designs matter. The same applies to drop shot bass fishing. The Finesse Hook improves drop shot fishing via simplicity, sharpness, and shape. Clear, deep fisheries often require extreme finesse fishing measures, and the Finesse Hook produces results.

The Finesse Hook has a special purpose. It provides the ultimate traditional finesse fish catching experience. Bass fishermen who fish deep, clear water will find this finesse fishing hook extremely helpful. This drop shot hook features a light wire diameter to utilizes its U-Bend shank shape. Both its light wire diameter and its shape improve hookset penetration on lighter fishing line. Hayabusa Fishing aimed to design a basic, yet highly effective drop shot fishing hook (also usable with other light rig techniques) that proved dependable with small and/or large bass. This fishing hook helps thousands of bass fishermen around the world in catching bass of all sizes. Basically, the Finesse Hook has a singular finesse fishing purpose, but it is dependable in catching different sizes of largemouth bass, smallmouth bass, and spotted bass. Sharp, durable, and light wire … The Finesse Hook answers the challenge of choosing the correct fishing hook for traditional drop shot fishing techniques.

 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


4 Styles Available

Hayabusa Finesse Drop Shot Hook #8 #8 $3.39
Hayabusa Finesse Drop Shot Hook #6 #6 $3.39
Hayabusa Finesse Drop Shot Hook #4 #4 $3.39
Hayabusa Finesse Drop Shot Hook #2 #2 $3.39

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.