[ROOT] dt DimProduct < WHERE Photo NEQ NULL > SELECT Name, ModelName, Description, Photo TITLE Products for which we have a photo
207 items
DimProductId | Name | ModelName | Description | Photo |
---|---|---|---|---|
474 | Women's Mountain Shorts, S | Women's Mountain Shorts | Heavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort. | |
305 | HL Mountain Frame - Black, 38 | HL Mountain Frame | Each 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. | |
226 | Long-Sleeve Logo Jersey, S | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
475 | Women's Mountain Shorts, M | Women's Mountain Shorts | Heavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort. | |
227 | Long-Sleeve Logo Jersey, S | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
306 | HL Mountain Frame - Black, 38 | HL Mountain Frame | Each 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. | |
228 | Long-Sleeve Logo Jersey, S | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
476 | Women's Mountain Shorts, L | Women's Mountain Shorts | Heavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort. | |
477 | Water Bottle - 30 oz. | Water Bottle | AWC logo water bottle - holds 30 oz; leak-proof. | |
307 | HL Mountain Frame - Silver, 38 | HL Mountain Frame | Each 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. | |
308 | HL Mountain Frame - Silver, 38 | HL Mountain Frame | Each 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. | |
229 | Long-Sleeve Logo Jersey, M | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
230 | Long-Sleeve Logo Jersey, M | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
479 | Road Bottle Cage | Road Bottle Cage | Aluminum cage is lighter than our mountain version; perfect for long distance trips. | |
480 | Patch Kit/8 Patches | Patch kit | Includes 8 different size patches, glue and sandpaper. | |
309 | HL Mountain Frame - Silver, 38 | HL Mountain Frame | Each 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. | |
488 | Short-Sleeve Classic Jersey, S | Short-Sleeve Classic Jersey | Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets. | |
231 | Long-Sleeve Logo Jersey, M | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
489 | Short-Sleeve Classic Jersey, M | Short-Sleeve Classic Jersey | Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets. | |
310 | Road-150 Red, 62 | Road-150 | This 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. | |
233 | Long-Sleeve Logo Jersey, L | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
232 | Long-Sleeve Logo Jersey, L | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
234 | Long-Sleeve Logo Jersey, L | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
311 | Road-150 Red, 44 | Road-150 | This 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. | |
313 | Road-150 Red, 52 | Road-150 | This 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. | |
312 | Road-150 Red, 48 | Road-150 | This 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. | |
314 | Road-150 Red, 56 | Road-150 | This 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. | |
490 | Short-Sleeve Classic Jersey, L | Short-Sleeve Classic Jersey | Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets. | |
493 | LL Touring Frame - Yellow, 62 | LL Touring Frame | Lightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort. | |
491 | Short-Sleeve Classic Jersey, XL | Short-Sleeve Classic Jersey | Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets. | |
501 | Rear Derailleur | Rear Derailleur | Wide-link design. | |
235 | Long-Sleeve Logo Jersey, XL | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
237 | Long-Sleeve Logo Jersey, XL | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
236 | Long-Sleeve Logo Jersey, XL | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
507 | LL Touring Frame - Yellow, 50 | LL Touring Frame | Lightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort. | |
315 | Road-450 Red, 58 | Road-450 | A 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. | |
289 | HL Mountain Frame - Silver, 42 | HL Mountain Frame | Each 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. | |
316 | Road-450 Red, 60 | Road-450 | A 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. | |
290 | HL Mountain Frame - Silver, 42 | HL Mountain Frame | Each 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. | |
506 | LL Touring Frame - Yellow, 44 | LL Touring Frame | Lightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort. | |
319 | Road-450 Red, 52 | Road-450 | A 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. | |
288 | HL Mountain Frame - Silver, 42 | HL Mountain Frame | Each 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. | |
292 | HL Mountain Frame - Silver, 48 | HL Mountain Frame | Each 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. | |
317 | Road-450 Red, 44 | Road-450 | A 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. | |
321 | Road-650 Red, 58 | Road-650 | Value-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. | |
318 | Road-450 Red, 48 | Road-450 | A 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. | |
530 | Touring Tire Tube | Touring Tire Tube | General purpose tube. | |
508 | LL Touring Frame - Yellow, 54 | LL Touring Frame | Lightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort. | |
293 | HL Mountain Frame - Silver, 46 | HL Mountain Frame | Each 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. | |
509 | LL Touring Frame - Yellow, 58 | LL Touring Frame | Lightweight butted aluminum frame provides a more upright riding position for a trip around town. Our ground-breaking design provides optimum comfort. |