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

 Big Hammer Hammer Head Jig 1 Oz Hover to Zoom

big hammer

Big Hammer Hammer Head Jig 1 oz

 Item# SE1081

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

$3.49 to $5.49

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] Plain - 4/0 N STK 0 25449 Big Hammer Hammer Head Jig 1 oz [empty string] 471700 [empty string] SE1040 471712 [empty string] SE1081 1
2 [empty string] [empty string] Plain - 8/0 N STK 0 25447 Big Hammer Hammer Head Jig 1 oz [empty string] 256503 [empty string] SE1080 246004 [empty string] SE1081 2
3 [empty string] [empty string] Red - 8/0 N STK 0 25448 Big Hammer Hammer Head Jig 1 oz [empty string] 256504 [empty string] SE1081 246005 [empty string] SE1081 3
CACHED false
EXECUTIONTIME 33
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 = 'SE1081' AND (upper(f.web_text) = 'BIG HAMMER' or upper(f.orig_text) = 'BIG HAMMER' or upper(a.brand) = 'BIG HAMMER') 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

These premium shad head swimbait heads from Big Hammer offer anglers the best there is for rigging your Big Hammer or other brand swimbait tails. Each colored head is powder coated for an extremely durable finish that will resist chips and scratches far longer than regular painted heads. Premium black nickel hooks and deep prismatic eyes round out the package for the best head on the market. Each weight Hammer Head comes with different choices of hook size to perfectly match the size of Big Hammer swimbait you want to put on. The two aggressive keepers on the top and bottom of the shaft will keep your plastic where you want it, cast after cast. These heads and the Big Hammer Tails work well for almost any fish anywhere, salt or fresh. Bass eat the Big Hammers when they are slowly cranked along the bottom or over deep ledges. Have fun with the Big Hammers, there are enough head/tail color combinations that you can come up with something never seen before.

 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

Big Hammer Hammer Head Jig 1 oz Plain - 4/0 Plain - 4/0 $3.49
Big Hammer Hammer Head Jig 1 oz Plain - 8/0 Plain - 8/0 $5.49
Big Hammer Hammer Head Jig 1 oz Red - 8/0 Red - 8/0 $5.49

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.