[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
474Women's Mountain Shorts, SWomen's Mountain ShortsHeavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.
305HL Mountain Frame - Black, 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.
226Long-Sleeve Logo Jersey, SLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
475Women's Mountain Shorts, MWomen's Mountain ShortsHeavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.
227Long-Sleeve Logo Jersey, SLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
306HL Mountain Frame - Black, 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.
228Long-Sleeve Logo Jersey, SLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
476Women's Mountain Shorts, LWomen's Mountain ShortsHeavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.
477Water Bottle - 30 oz.Water BottleAWC logo water bottle - holds 30 oz; leak-proof.
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.
308HL 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.
229Long-Sleeve Logo Jersey, MLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
230Long-Sleeve Logo Jersey, MLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
479Road Bottle CageRoad Bottle CageAluminum cage is lighter than our mountain version; perfect for long distance trips.
480Patch Kit/8 PatchesPatch kitIncludes 8 different size patches, glue and sandpaper.
309HL 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.
488Short-Sleeve Classic Jersey, SShort-Sleeve Classic JerseyShort sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.
231Long-Sleeve Logo Jersey, MLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
489Short-Sleeve Classic Jersey, MShort-Sleeve Classic JerseyShort sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.
310Road-150 Red, 62Road-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.
233Long-Sleeve Logo Jersey, LLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
232Long-Sleeve Logo Jersey, LLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
234Long-Sleeve Logo Jersey, LLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
311Road-150 Red, 44Road-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.
313Road-150 Red, 52Road-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.
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.
314Road-150 Red, 56Road-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.
490Short-Sleeve Classic Jersey, LShort-Sleeve Classic JerseyShort sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.
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.
491Short-Sleeve Classic Jersey, XLShort-Sleeve Classic JerseyShort sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.
501Rear DerailleurRear DerailleurWide-link design.
235Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
237Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
236Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
507LL Touring Frame - Yellow, 50LL Touring FrameLightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort.
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.
289HL Mountain Frame - Silver, 42HL 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.
316Road-450 Red, 60Road-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.
290HL Mountain Frame - Silver, 42HL 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.
506LL Touring Frame - Yellow, 44LL Touring FrameLightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort.
319Road-450 Red, 52Road-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.
288HL Mountain Frame - Silver, 42HL 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.
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.
317Road-450 Red, 44Road-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.
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.
530Touring Tire TubeTouring Tire TubeGeneral purpose tube.
508LL Touring Frame - Yellow, 54LL Touring FrameLightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum 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.
509LL Touring Frame - Yellow, 58LL Touring FrameLightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort.