[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. |