[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  
226Long-Sleeve Logo Jersey, SLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
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.
230Long-Sleeve Logo Jersey, MLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
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
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.
236Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
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.
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.
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.
291HL Mountain Frame - Silver, 44HL 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.
320Road-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.
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.
323Road-650 Red, 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.
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.
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.
298HL Mountain Frame - Black, 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.
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.
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.
330Road-650 Red, 52Road-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.
304HL 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.
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.
335Road-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.
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.
341Road-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.
342Road-650 Black, 52Road-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.
343Road-650 Black, 52Road-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.
352Mountain-200 Silver, 38Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
353Mountain-200 Silver, 38Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
354Mountain-200 Silver, 42Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
355Mountain-200 Silver, 42Mountain-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.
365Mountain-300 Black, 40Mountain-300For true trail addicts. An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.
366Mountain-300 Black, 44Mountain-300For true trail addicts. An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.
367Mountain-300 Black, 48Mountain-300For true trail addicts. An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.
368Road-250 Red, 44Road-250Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.
369Road-250 Red, 48Road-250Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.
370Road-250 Red, 52Road-250Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.
371Road-250 Red, 58Road-250Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.
380Road-250 Black, 58Road-250Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.