Current Criteria (Reset)
22 products found, 176 variants found. Jump To Items
Shape=Round | |
Finish=Hot Finished |
Jump To: Length
All items with these criteria are: Material=Cast Iron, 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 Finish='Hot Finished' And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Grade=Class 40, Condition=Other
Length
Custom Lengths | 12" | 18" | 24" | 36" | 48" | 60" | 72" |
Items
Product | Shape | Grade | Thickness | Width | Wall |
---|---|---|---|---|---|
5/8" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 5/8" |
3/4" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 3/4" |
1" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 1" |
1-1/4" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 1-1/4" |
1-1/2" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 1-1/2" |
1-3/4" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 1-3/4" |
1-7/8" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 1-7/8" |
2" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 2" |
2-1/4" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 2-1/4" |
2-1/2" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 2-1/2" |
2-3/4" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 2-3/4" |
3" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 3" |
3-1/2" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 3-1/2" |
3-3/4" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 3-3/4" |
4" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 4" |
4-1/2" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 4-1/2" |
5" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 5" |
6" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 6" |
6-1/2" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 6-1/2" |
7" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 7" |
11" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 11" |
12" {A} Rd Gray Cast Iron Class 40 | Round | Class 40 | 12" |