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

 Spro Bbz1 Rat Hover to Zoom

spro

Spro BBZ1 Rat

 Item# SRT50Z1GGT

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

$29.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] Brown N STK 0 10297 Spro BBZ1 Rat [empty string] 275895 [empty string] SRT50Z1BRN 273410 [empty string] SRT50Z1GGT 0
2 [empty string] [empty string] Grey Ghost N STK 0 10298 Spro BBZ1 Rat [empty string] 275901 [empty string] SRT50Z1GGT 273411 [empty string] SRT50Z1GGT 0
3 [empty string] [empty string] Ninja N STK 0 10299 Spro BBZ1 Rat [empty string] 275902 [empty string] SRT50Z1NNJ 273412 [empty string] SRT50Z1GGT 0
CACHED false
EXECUTIONTIME 63
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 = 'SRT50Z1GGT' AND (upper(f.web_text) = 'SPRO' or upper(f.orig_text) = 'SPRO' or upper(a.brand) = 'SPRO') 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

LIMIT 1 OF EACH COLOR PER CUSTOMER

SPRO's Pro Staff member Bill Siemantel has been working on a BBZ project the last 2 years and on the opening day of ICAST 2014 all that hard work paid off. Spro's newest BBZ addition to the family, the BBZ-1 Rat won Best of ICAST in the hard lure category. The SPRO Rat is designed for those larger predator fish that every angler is looking for. It entices awesome surface strikes by triggering the instinctive reaction that those lager fish are looking for. When the fish are hungry the SPRO RAT is the real meal deal! The SPRO Rat can be worked in several ways - you can bulge it, v-wake it, walk the dog, pop it or you name it! Bil Siemantel designed the placement of the hooks so the hook up ration is incredible.

Depth: Floating 

Size: Measures 10 inches (5 1/4-inch body and 4 3/4-inch custom articulating tail) Weight: 2.5 oz 

Hooks:#1/0 Gamakatsu 2X strong Treble

 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

Spro BBZ1 Rat Brown Brown $29.99
Spro BBZ1 Rat Grey Ghost Grey Ghost $29.99
Spro BBZ1 Rat Ninja Ninja $29.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.