California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account
Home / Fishing / Terminal Tackle / Jig Heads / Coolbaits 1/2 oz Down Under Underspin

Coolbaits 1/2 Oz Down Under Underspin Hover to Zoom

coolbaits

Coolbaits 1/2 oz Down Under Underspin

 Item# CBL-DU12-BKS

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

$7.99 to $8.19

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] Black Shad N STK 12 14904 Coolbaits 1/2 oz Down Under Underspin [empty string] 483227 [empty string] CBL-DU12-BKS 483249 [empty string] cbl-du12-bks 1
2 [empty string] [empty string] Blue Shad N STK 0 14905 Coolbaits 1/2 oz Down Under Underspin [empty string] 483228 [empty string] CBL-DU12-BS 483250 [empty string] cbl-du12-bks 2
3 [empty string] [empty string] Chartreuse Shad Gold N STK 6 14906 Coolbaits 1/2 oz Down Under Underspin [empty string] 483229 [empty string] CBL-DU12-G-CS 483251 [empty string] cbl-du12-bks 3
4 [empty string] [empty string] Ol' Faithful N STK -1 14907 Coolbaits 1/2 oz Down Under Underspin [empty string] 483230 [empty string] CBL-DU12-RS 483252 [empty string] cbl-du12-bks 4
5 [empty string] [empty string] Snow White N STK -4 14908 Coolbaits 1/2 oz Down Under Underspin [empty string] 483231 [empty string] CBL-DU12-SW 483253 [empty string] cbl-du12-bks 5
CACHED false
EXECUTIONTIME 92
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 = 'cbl-du12-bks' AND (upper(f.web_text) = 'COOLBAITS' or upper(f.orig_text) = 'COOLBAITS' or upper(a.brand) = 'COOLBAITS') 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
2

As detailed as it is brilliant, the Coolbaits Lure Company “The Down Under” delivers flash and lifelike attraction all-in-one bass-catching package. Designed with textured gill plates and 3-D eyes, the Coolbaits Lure Company “The Down Under” features a ball-bearing swivel molded underneath the chin, which connects a shimmering willow blade.
Behind the head, the Coolbaits Lure Company “The Down Under” is fitted with a baitkeeper barb that locks soft plastics firmly in-place, enhancing performance and extending bait life. Armed with a premium Mustad Ultra Point hook, the Coolbaits Lure Company “The Down Under” delivers a one-of-a-kind underspin construction that will keep your lines tight.

 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


5 Styles Available

Coolbaits 1/2 oz Down Under Underspin Black Shad Black Shad $7.99
Coolbaits 1/2 oz Down Under Underspin Blue Shad Blue Shad $7.99
Coolbaits 1/2 oz Down Under Underspin Chartreuse Shad Gold Chartreuse Shad Gold $8.19
Coolbaits 1/2 oz Down Under Underspin Ol' Faithful Ol' Faithful $7.99
Coolbaits 1/2 oz Down Under Underspin Snow White Snow White $7.99

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.