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 = 44 and ie.CategoryValues$23 = 'ITEM' and (pg.DealerProduct <> 1 or pg.DealerProduct is null)
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 = 45 and ie.CategoryValues$23 = 'ITEM' and (pg.DealerProduct <> 1 or pg.DealerProduct is null)
|
The Boca Bearing Company have been an industry leader in RC Helicopter bearing replacement since 1987. Reducing rolling resistance and conserving energy has been our hallmark. We offer a full line of standard & ceramic hybrid bearings specifically designed for today's demanding RC Helicopters. Various ABEC tolerances, radial plays, retainer styles and seal/shield configurations are available. To make things easier for you we have compiled bearing kits and listed them according to the RC Heli manufacturer and model. Just click on Search By RC Heli Brand or use the Brand Search at the top of any page.
The Boca Bearing Company is capable of supplying after market bearings for those RC Helicopter 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.
|