[ROOT]  dt  DimProduct  <  WHERE Photo NEQ NULL  >   SELECT Name, ModelName, Description, Photo   

207 items

DimProductIdNameModelNameDescriptionPhoto
226Long-Sleeve Logo Jersey, SLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
227Long-Sleeve Logo Jersey, SLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
229Long-Sleeve Logo Jersey, MLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
231Long-Sleeve Logo Jersey, MLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
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.
235Long-Sleeve Logo Jersey, XLLong-Sleeve Logo JerseyUnisex long-sleeve AWC logo microfiber cycling jersey
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.
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.
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.
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.
299HL Mountain Frame - Black, 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.
328Road-650 Red, 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.
303HL 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.
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.
338Road-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.
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.
344Mountain-100 Silver, 38Mountain-100Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.
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.
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.
360Mountain-200 Black, 42Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
361Mountain-200 Black, 42Mountain-200Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.
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.
384Road-550-W Yellow, 40Road-550-WSame technology as all of our Road series bikes, but the frame is sized for a woman. Perfect all-around bike for road or racing.
385Road-550-W Yellow, 42Road-550-WSame technology as all of our Road series bikes, but the frame is sized for a woman. Perfect all-around bike for road or racing.
386Road-550-W Yellow, 42Road-550-WSame technology as all of our Road series bikes, but the frame is sized for a woman. Perfect all-around bike for road or racing.
387Road-550-W Yellow, 44Road-550-WSame technology as all of our Road series bikes, but the frame is sized for a woman. Perfect all-around bike for road or racing.
414ML Road Front WheelML Road Front WheelSturdy alloy features a quick-release hub.
415HL Road Front WheelHL Road Front WheelStrong wheel with double-walled rim.
416Touring Front WheelTouring Front WheelAerodynamic rims for smooth riding.
419LL Mountain Rear WheelLL Mountain Rear WheelReplacement mountain wheel for entry-level rider.
448MinipumpMinipumpDesigned for convenience. Fits in your pocket. Aluminum barrel. 160psi rated.
449Mountain PumpMountain PumpSimple and light-weight. Emergency patches stored in handle.
450Taillights - Battery-PoweredTaillightAffordable light for safe night riding - uses 3 AAA batteries
451Headlights - Dual-BeamHeadlights - Dual-BeamRechargeable dual-beam headlight.
490Short-Sleeve Classic Jersey, LShort-Sleeve Classic JerseyShort sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.
491Short-Sleeve Classic Jersey, XLShort-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.
501Rear DerailleurRear DerailleurWide-link design.
546ML Road PedalML Road PedalLightweight aluminum alloy construction.
547HL Road PedalHL Road PedalTop-of-the-line clipless pedals with adjustable tension.
548Touring PedalTouring PedalA stable pedal for all-day riding.
559ChainChainSuperior shifting performance.