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

 Zuker Trolling Lures Hover to Zoom

zuker

Zuker Trolling Lures

 Item# ZV3

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

$9.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] Brown & White/Brown & Gold Feather N STK 0 7881 Zuker Trolling Lures [empty string] 13170 [empty string] ZF11 13170 [empty string] ZF11 0
2 [empty string] [empty string] Black & Purple/Purple & Silver Feather N STK 0 7882 Zuker Trolling Lures [empty string] 13171 [empty string] ZF14 13171 [empty string] ZF11 0
3 [empty string] [empty string] Rainbow Lime/Lime Feather N STK 0 7883 Zuker Trolling Lures [empty string] 13172 [empty string] ZF16LS 13172 [empty string] ZF11 0
4 [empty string] [empty string] Rainbow Silver/Pink Feather N STK 0 7884 Zuker Trolling Lures [empty string] 13174 [empty string] ZF17 13174 [empty string] ZF11 0
5 [empty string] [empty string] Mean Joe Green Feather N STK 0 7885 Zuker Trolling Lures [empty string] 13175 [empty string] ZF18 13175 [empty string] ZF11 0
6 [empty string] [empty string] Green & Yellow/Lime Feather N STK 0 7886 Zuker Trolling Lures [empty string] 13176 [empty string] ZF1LS 13176 [empty string] ZF11 0
7 [empty string] [empty string] Red & White/Pink & Silver Feather N STK 0 7887 Zuker Trolling Lures [empty string] 13178 [empty string] ZF4 13178 [empty string] ZF11 0
8 [empty string] [empty string] Blue & White/ Blue & Silver Feather N STK 0 7888 Zuker Trolling Lures [empty string] 13179 [empty string] ZF7 13179 [empty string] ZF11 0
9 [empty string] [empty string] White/Clear & Silver Feather N STK -1 7889 Zuker Trolling Lures [empty string] 13180 [empty string] ZF8 13180 [empty string] ZF11 0
10 [empty string] [empty string] Brown & White/Brown & Gold Grass N STK 0 7890 Zuker Trolling Lures [empty string] 13181 [empty string] ZG11 13181 [empty string] ZF11 0
11 [empty string] [empty string] Orange & Yellow/Lime Zukini Grass N STK 0 7891 Zuker Trolling Lures [empty string] 13182 [empty string] ZG17 13182 [empty string] ZF11 0
12 [empty string] [empty string] Blue & Lime Vinyl N STK 0 7892 Zuker Trolling Lures [empty string] 13200 [empty string] ZV2 13200 [empty string] ZF11 0
13 [empty string] [empty string] Black & Purple/Purple & Silver Vinyl N STK 0 7893 Zuker Trolling Lures [empty string] 13201 [empty string] ZV3 13201 [empty string] ZF11 0
CACHED false
EXECUTIONTIME 46
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 = 'ZF11' AND (upper(f.web_text) = 'ZUKER' or upper(f.orig_text) = 'ZUKER' or upper(a.brand) = 'ZUKER') 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

Zuker trolling lures  have proven to be effective on all different tuna species. Zuker lures varying construction featuring, vinyl, feathers, or grass allow the angler to choose a presentation best suiting the fishing conditions. Year after year, Zuker feathers have been the premier choice for locating and catching tuna.

 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


13 Styles Available

Zuker Trolling Lures Brown & White/Brown & Gold Feather Brown & White/Brown & Gold Feather $9.99
Zuker Trolling Lures Black & Purple/Purple & Silver Feather Black & Purple/Purple & Silver Feather $9.99
Zuker Trolling Lures Rainbow Lime/Lime Feather Rainbow Lime/Lime Feather $9.99
Zuker Trolling Lures Rainbow Silver/Pink Feather Rainbow Silver/Pink Feather $9.99
Zuker Trolling Lures Mean Joe Green Feather Mean Joe Green Feather $9.99
Zuker Trolling Lures Green & Yellow/Lime Feather Green & Yellow/Lime Feather $9.49
Zuker Trolling Lures Red & White/Pink & Silver Feather Red & White/Pink & Silver Feather $9.99
Zuker Trolling Lures Blue & White/ Blue & Silver Feather Blue & White/ Blue & Silver Feather $9.99
Zuker Trolling Lures White/Clear & Silver Feather White/Clear & Silver Feather $9.49
Zuker Trolling Lures Brown & White/Brown & Gold Grass Brown & White/Brown & Gold Grass $9.99
Zuker Trolling Lures Orange & Yellow/Lime Zukini Grass Orange & Yellow/Lime Zukini Grass $9.99
Zuker Trolling Lures Blue & Lime Vinyl Blue & Lime Vinyl $9.49
Zuker Trolling Lures Black & Purple/Purple & Silver Vinyl Black & Purple/Purple & Silver Vinyl $9.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.