[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 |
---|---|---|---|---|
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. | |
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. | |
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. | |
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. | |
320 | 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. | |
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. | |
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. | |
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. | |
325 | 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. | |
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. | |
326 | 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. | |
330 | Road-650 Red, 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. | |
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. | |
333 | Road-650 Black, 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. | |
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. | |
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. | |
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. | |
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. | |
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. | |
341 | Road-650 Black, 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. | |
342 | 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. | |
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. | |
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. | |
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. | |
329 | 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. | |
349 | Mountain-100 Black, 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. | |
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. | |
331 | Road-650 Red, 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. | |
350 | Mountain-100 Black, 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. | |
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. | |
332 | Road-650 Black, 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. | |
357 | 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. | |
339 | 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. | |
358 | 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. | |
340 | Road-650 Black, 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. | |
365 | Mountain-300 Black, 40 | 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. | |
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. | |
347 | Mountain-100 Silver, 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. | |
366 | Mountain-300 Black, 44 | 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. |