[ROOT]  dt  DimProduct  <  WHERE Photo NEQ NULL  >   SELECT Name, ModelName, Description, Photo   TITLE Products for which we have a photo   

Products for which we have a photo

207 items

DimProductIdNameModelNameDescriptionPhoto
21Freewheel  
307HL Mountain Frame - Silver, 38HL Mountain FrameEach frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
312Road-150 Red, 48Road-150This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.
315Road-450 Red, 58Road-450A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.
318Road-450 Red, 48Road-450A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.
321Road-650 Red, 58Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
324Road-650 Red, 62Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
327Road-650 Red, 44Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
332Road-650 Black, 58Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
333Road-650 Black, 58Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
334Road-650 Black, 60Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
339Road-650 Black, 44Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
340Road-650 Black, 48Road-650Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we're famous for.
345Mountain-100 Silver, 42Mountain-100Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.
346Mountain-100 Silver, 44Mountain-100Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.
351Mountain-100 Black, 48Mountain-100Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.
352Mountain-200 Silver, 38Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
357Mountain-200 Silver, 46Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
358Mountain-200 Black, 38Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
363Mountain-200 Black, 46Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
364Mountain-300 Black, 38Mountain-300For true trail addicts. An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.
226Long-Sleeve Logo Jersey, SLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
474Women's Mountain Shorts, SWomen's Mountain ShortsHeavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.
229Long-Sleeve Logo Jersey, MLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
477Water Bottle - 30 oz.Water BottleAWC logo water bottle - holds 30 oz; leak-proof.
234Long-Sleeve Logo Jersey, LLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
490Short-Sleeve Classic Jersey, LShort-Sleeve Classic JerseyShort sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.
235Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
491Short-Sleeve Classic Jersey, XLShort-Sleeve Classic JerseyShort sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.
236Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
493LL Touring Frame - Yellow, 62LL Touring FrameLightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort.
237Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
501Rear DerailleurRear DerailleurWide-link design.
292HL Mountain Frame - Silver, 48HL Mountain FrameEach frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
515LL Mountain Seat/SaddleLL Mountain Seat/Saddle 2Synthetic leather. Features gel for increased comfort.
293HL Mountain Frame - Silver, 46HL Mountain FrameEach frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
530Touring Tire TubeTouring Tire TubeGeneral purpose tube.
294HL Mountain Frame - Silver, 46HL Mountain FrameEach frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
537HL Mountain TireHL Mountain TireIncredible traction, lightweight carbon reinforced.
295HL Mountain Frame - Silver, 46HL Mountain FrameEach frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
540HL Road TireHL Road TireLightweight carbon reinforced for an unrivaled ride at an un-compromised weight.
300HL Mountain Frame - Black, 48HL Mountain FrameEach frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
546ML Road PedalML Road PedalLightweight aluminum alloy construction.
301HL Mountain Frame - Black, 46HL Mountain FrameEach frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.
547HL Road PedalHL Road PedalTop-of-the-line clipless pedals with adjustable tension.
563Touring-1000 Yellow, 54Touring-1000Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.
564Touring-1000 Yellow, 60Touring-1000Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.