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

 Deps Slide Swimmer 175 Hover to Zoom

dep`s

Deps Slide Swimmer 175

 Item# SS175/10

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

$99.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] Ghost Herring N STK 0 9369 Deps Slide Swimmer 175 [empty string] 298626 [empty string] SS175/01 276727 [empty string] SS175/10 0
2 [empty string] [empty string] Butch Brown Trout N STK 0 9370 Deps Slide Swimmer 175 [empty string] 298627 [empty string] SS175/04 276728 [empty string] SS175/10 0
3 [empty string] [empty string] Flash Carp N STK 0 9371 Deps Slide Swimmer 175 [empty string] 298628 [empty string] SS175/05 276729 [empty string] SS175/10 0
4 [empty string] [empty string] Ghost Ayu N STK 0 9968 Deps Slide Swimmer 175 [empty string] 280102 [empty string] SS175/02 280102 [empty string] SS175/10 0
5 [empty string] [empty string] Clear Wakasagi N STK 0 9969 Deps Slide Swimmer 175 [empty string] 280103 [empty string] SS175/10 280103 [empty string] SS175/10 0
6 [empty string] [empty string] Blue Back Herring N STK 0 11549 Deps Slide Swimmer 175 [empty string] 414150 [empty string] SS175/17 414150 [empty string] SS175/10 0
7 [empty string] [empty string] Butch Brown Bass N STK 0 11536 Deps Slide Swimmer 175 [empty string] 429664 [empty string] SS175/15 429664 [empty string] SS175/10 0
8 [empty string] [empty string] Butch Brown Golden Carp N STK 0 11962 Deps Slide Swimmer 175 [empty string] 436457 [empty string] SS175/14 436457 [empty string] SS175/10 0
CACHED false
EXECUTIONTIME 78
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 = 'SS175/10' AND (upper(f.web_text) = 'DEP`S' or upper(f.orig_text) = 'DEP`S' or upper(a.brand) = 'DEP`S') 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

Deps Slide Swimmer 175

The Slide Swimmer 175 is a large, hard plastic swimbait designed to mimic large species such as trout, hitch and shad when targeting bass. The 7" Deps Slide Swimmer 175 displays the "glide" style action that has become incredibly popular over the past couple of years. Much of the bait's effectiveness has been attributed to its' completely silent nature. Even the hinges of the jointed-body are precision engineered not to make a sound. The bait's body is now constructed from an ABS plastic injection molding process in contrast to the original foam used for the 250. Outside, the bait will still be covered with a soft silicone skin. The lure, which swims completely on its own free of any diving lip, also boasts an astounding level of detail, including accurate color finishes, 3D eyes and is finished with life-like scale patterns and gills. The 175 size measures 6.88" in length.

 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


8 Styles Available

Deps Slide Swimmer 175 Ghost Herring Ghost Herring $99.99
Deps Slide Swimmer 175 Butch Brown Trout Butch Brown Trout $99.99
Deps Slide Swimmer 175 Flash Carp Flash Carp $99.99
Deps Slide Swimmer 175 Ghost Ayu Ghost Ayu $99.99
Deps Slide Swimmer 175 Clear Wakasagi Clear Wakasagi $99.99
Deps Slide Swimmer 175 Blue Back Herring Blue Back Herring $99.99
Deps Slide Swimmer 175 Butch Brown Bass Butch Brown Bass $99.99
Deps Slide Swimmer 175 Butch Brown Golden Carp Butch Brown Golden Carp $99.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.