PageComponents/Search/BrowseBySearchBy.ascx
PageComponents/Applications/ProductGroupSamples.ascx
select top 3 i.Product as Product,'~/productdetail.aspx?ItemID=' + Convert(varchar,i.ItemID) + '&MODSYSID=&ProductSubGroupID=' + Convert(varchar,psg.ProductSubGroupID) as ProductDetailLink, i.SellPrice$2 as Price from Item i left join ItemExtension ie on ie.ItemID=i.ItemID left join ProductSubGroupItems psgi on psgi.ItemID=i.ItemID left join ProductSubGroup psg on psg.ProductSubGroupID=psgi.ProductSubGroupID left join ProductGroup pg on pg.ProductGroupID=psg.ProductGroupID where pg.ProductGroupID = 34 and ie.CategoryValues$23 = 'ITEM' and (pg.DealerProduct <> 1 or pg.DealerProduct is null)
Fishing Reel Bearing Lube
PageComponents/Applications/ProductGroupSamples.ascx
select top 3 i.Product as Product,'~/productdetail.aspx?ItemID=' + Convert(varchar,i.ItemID) + '&MODSYSID=&ProductSubGroupID=' + Convert(varchar,psg.ProductSubGroupID) as ProductDetailLink, i.SellPrice$2 as Price from Item i left join ItemExtension ie on ie.ItemID=i.ItemID left join ProductSubGroupItems psgi on psgi.ItemID=i.ItemID left join ProductSubGroup psg on psg.ProductSubGroupID=psgi.ProductSubGroupID left join ProductGroup pg on pg.ProductGroupID=psg.ProductGroupID where pg.ProductGroupID = 35 and ie.CategoryValues$23 = 'ITEM' and (pg.DealerProduct <> 1 or pg.DealerProduct is null)
Fishing Reel Bearing Tools
|
PageComponents/Search/SearchBy.ascx
SEARCH BY: Fishing Reel Models | Fishing Reel Bearings Common Sizes
Ceramic Orange Seal Fishing Reel bearing kits are an upgrade replacement to stock fishing reel bearings. These ABEC #7 bearings have ceramic balls with stainless steel races and retainers. Orange Seal bearings have a non-contact rubber seal which allows the bearing to spin freely with out any excess drag. Ceramic will never corrode; it has less rolling resistance and is lighter and than steel. As a result ceramic bearings last longer and cast longer. All Ceramic Orange Seal fishing reel bearings are supplied with light weight oil. Lube can be removed upon request.
PageComponents/Applications/AppSubGrpDrillDown.ascx
Fishing Reel Models
Fishing Reel Bearing Sizes
METRIC : GetSizesList '3','152','25','metric'
INCHES : GetSizesList '3','152','25','inch'
The Boca Bearing Company is capable of supplying after market bearings for those Fishing Reel manufacturers listed below. If you don't see your specific model listed after you click on the manufacturer name, please fill out our Kit Info Reward form. We are willing to give you additional discount or a reward for helping us identify new information or where exactly in your application each bearing is used.
PageComponents/Applications/AppByManDrillDown.ascx
|