[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 |
---|---|---|---|---|
21 | Freewheel | |||
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. | |
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. | |
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. | |
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. | |
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. | |
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. | |
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. | |
322 | Road-650 Red, 60 | 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. | |
323 | Road-650 Red, 60 | 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. | |
324 | Road-650 Red, 62 | 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. | |
327 | Road-650 Red, 44 | 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. | |
328 | Road-650 Red, 48 | 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. | |
334 | Road-650 Black, 60 | 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. | |
335 | Road-650 Black, 60 | 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. | |
337 | Road-650 Black, 62 | 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. | |
338 | Road-650 Black, 44 | 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. | |
343 | Road-650 Black, 52 | 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. | |
344 | Mountain-100 Silver, 38 | Mountain-100 | Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain. | |
345 | Mountain-100 Silver, 42 | Mountain-100 | Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain. | |
346 | Mountain-100 Silver, 44 | Mountain-100 | Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain. | |
351 | Mountain-100 Black, 48 | Mountain-100 | Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain. | |
352 | Mountain-200 Silver, 38 | Mountain-200 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100. | |
355 | Mountain-200 Silver, 42 | Mountain-200 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100. | |
356 | Mountain-200 Silver, 46 | Mountain-200 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100. | |
359 | Mountain-200 Black, 38 | Mountain-200 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100. | |
360 | Mountain-200 Black, 42 | Mountain-200 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100. | |
361 | Mountain-200 Black, 42 | Mountain-200 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100. | |
362 | Mountain-200 Black, 46 | Mountain-200 | Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100. | |
367 | Mountain-300 Black, 48 | Mountain-300 | For true trail addicts. An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget. | |
368 | Road-250 Red, 44 | Road-250 | Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads. | |
226 | Long-Sleeve Logo Jersey, S | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
227 | Long-Sleeve Logo Jersey, S | 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 | |
233 | 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 | |
235 | Long-Sleeve Logo Jersey, XL | Long-Sleeve Logo Jersey | Unisex long-sleeve AWC logo microfiber cycling jersey | |
294 | 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. | |
295 | 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. | |
296 | HL Mountain Frame - Black, 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. | |
297 | HL Mountain Frame - Black, 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. | |
304 | 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. | |
369 | Road-250 Red, 48 | Road-250 | Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads. |