Current Criteria (Reset)
14 products found, 14 variants found. Jump To Items
 | Shape=Round |
| Grade=954 |
| Length=48 |
All items with these criteria are: Material=Bronze, Thickness=Select Convert(Int, Thickness) TheField, Count(DISTINCT Product.ProductID) TheCount FROM Product with (NOLOCK) INNER JOIN ProductVariant with (NOLOCK) On Product.ProductID = ProductVariant.ProductID WHERE Shape='Round' and Grade='954 ' and Length=48 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other, Finish=Other
Items
Bronze
| Product | Shape | Grade | Thickness | Width | Wall |
|---|---|---|---|---|---|
| 1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1/2" |
| 3/4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 3/4" |
| 1" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1" |
| 1-1/4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1-1/4" |
| 1-1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1-1/2" |
| 2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 2" |
| 2-1/4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 2-1/4" |
| 2-1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 2-1/2" |
| 3" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 3" |
| 4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 4" |
| 4-1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 4-1/2" |
| 5" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 5" |
| 6" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 6" |
| 8" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 8" |