Query
Template: /tires/queries.cfc:204
Execution Time: 1.72 ms
Record Count: 34
Cached: No
Lazy: No
SQL:
SELECT ts.intTireSpecID
,ts.intTireID
,ts.intAccountID
,ts.intBrandID
,ts.intTireImageID
,ts.vchrPartNumber
,ts.vchrName
,b.vchrName as brandName
,ts.vchrQuickDraw
,ts.vchrSize
,ts.vchrSideWall
,ts.decDiameter
,ts.decSectWidth
,ts.decAspectRatio
,ts.decDiameterInch
,ts.decWidthInch
,ts.vchrSpeedRating
,ts.chrType
,ts.chrLoadRange
,ts.intLoadIndex
,ts.decWeight
,ts.decHeight
,ts.vchrTreadDepth
,ts.decOverDiameter
,ts.vchrRimRange
,ts.vchrTreadConstruction
,ts.vchrSideConstruction
,ts.decDynomicBalanceOz
,ts.vchrSideWall
,ts.vchrWarranty
,ts.decWidth
,ts.decLenth
,ts.intMaxLoad
,ts.vchrMaxPSI
,ts.dtCreatedUpdated
FROM tbl_TireSpec ts WITH (NOLOCK)
INNER JOIN tbl_brand b ON ts.intBrandID = b.intID
INNER JOIN tbl_brandConfig bc ON bc.intBrandID = b.intID
WHERE ts.intTireID = 182
AND bc.intConfigID = 404
ORDER BY decDiameter, vchrPartNumber
intTireSpecIDintTireIDintAccountIDintBrandIDintTireImageIDvchrPartNumbervchrNamebrandNamevchrQuickDrawvchrSizevchrSideWalldecDiameterdecSectWidthdecAspectRatiodecDiameterInchdecWidthInchvchrSpeedRatingchrTypechrLoadRangeintLoadIndexdecWeightdecHeightvchrTreadDepthdecOverDiametervchrRimRangevchrTreadConstructionvchrSideConstructiondecDynomicBalanceOzvchrWarrantydecWidthdecLenthintMaxLoadvchrMaxPSIdtCreatedUpdated
1629331182172540RFNT331250R17GRIPPER M/TFuel Tires33X12.50R17LT33X12.50R17LTBlackwall173312.5120QE/10PR032021338.5-10.0-11.03P+2S+2N0 7.5000308565PSI{ts '2024-01-29 14:39:12'}
2629361182172540RFNT34575R17GRIPPER M/TFuel Tires345/75R17345/75R17Blackwall1734575Q13183.7802136.88.5-11.0 0004300{ts '2024-01-29 14:39:13'}
3629332182172540RFNT351250R17GRIPPER M/TFuel Tires35X12.50R17LT35X12.50R17LTBlackwall173512.5125QF/12PR034.602134.88.5-10.0-11.03P+2S+2N0 7.5000364080PSI{ts '2024-01-29 14:39:12'}
4629333182172540RFNT371350R17GRIPPER M/TFuel Tires37X13.50R17LT37X13.50R17LTBlackwall173713.5131QE/10PR038021378.5-10.0-11.03P+2S+2N0 9000430065PSI{ts '2024-01-29 14:39:12'}
5629334182172540RFNT331250R18GRIPPER M/TFuel Tires33X12.50R18LT33X12.50R18LTBlackwall183312.5118QE/10PR031.5021338.5-10.0-11.03P+2S+2N0 7.5000291065PSI{ts '2024-01-29 14:39:12'}
6629335182172540RFNT351250R18GRIPPER M/TFuel Tires35X12.50R18LT35X12.50R18LTBlackwall183512.5123QE/10PR034021358.5-10.0-11.03P+2S+2N0 7.5000341565PSI{ts '2024-01-29 14:39:12'}
7629336182172540RFNT331250R20GRIPPER M/TFuel Tires33X12.50R20LT33X12.50R20LTBlackwall2033125114QE/10PR030.502132.88.5-10.0-11.03P+2S+2N0 7.5000260065PSI{ts '2024-01-29 14:39:12'}
8629350182172540RFNT341250R20GRIPPER M/TFuel Tires34x12.50R20LT34x12.50R20LTBlackwall203412.5123Q034.502133.8 000080PSI{ts '2024-01-29 14:39:13'}
9629358182172540RFNT34555R20GRIPPER M/TFuel Tires345/55R20345/55R20Blackwall2034555Q12676.0602134.88.5-11.0 0003750{ts '2024-01-29 14:39:13'}
10629360182172540RFNT34560R20GRIPPER M/TFuel Tires345/60R20345/60R20Blackwall2034560Q12782.8902136.88.5-11.0 0003860{ts '2024-01-29 14:39:13'}
11629355182172540RFNT351250R20GRIPPER M/TFuel Tires35X12.50R20LT35X12.50R20LTBlackwall203512.5121QE/10PR07302134.88.5 - 11.03P+2S+2N0 7.5000319565PSI{ts '2024-01-29 14:39:13'}
12629354182172540RFNT351250R20XLGRIPPER M/TFuel Tires35X12.50R20LT35X12.50R20LTBlackwall203512.5125QF/12PR073.902134.88.5 - 11.03P+2S+2N0 7.5000364080PSI{ts '2024-01-29 14:39:13'}
13629337182172540RFNT351350R20GRIPPER M/TFuel Tires35X13.50R20LT35X13.50R20LTBlackwall203513.5126QF/12PR034.5021358.5-11.03P+2S+2N0 7.5000375080PSI{ts '2024-01-29 14:39:13'}
14629338182172540RFNT371350R20GRIPPER M/TFuel Tires37x13.50R20LT37x13.50R20LTBlackwall203713.5127QE/10PR038.5021378.5-11.03P+2S+2N0 9000386065PSI{ts '2024-01-29 14:39:13'}
15629339182172540RFNT381550R20GRIPPER M/TFuel Tires38X15.50R20LT38X15.50R20LTBlackwall203815.5125QD/8PR039.602137.711.0-12.0-14.03P+2S+2N0 12000364050PSI{ts '2024-01-29 14:39:13'}
16629364182172540RFNT39560R20GRIPPER M/TFuel Tires395/60R20395/60R20Blackwall2039560Q12587.302137.711.0-14.0 0003640{ts '2024-01-29 14:39:13'}
17629340182172540RFNT331250R22GRIPPER M/TFuel Tires33X12.50R22LT33X12.50R22LTBlackwall223312.5109QE/10PR03002132.88.5-10.0-11.03P+2S+2N0 7.5000227065PSI{ts '2024-01-29 14:39:13'}
18629351182172540RFNT341250R22GRIPPER M/TFuel Tires34x12.50R22LT34x12.50R22LTBlackwall223412.5121Q033.602133.8 0000{ts '2024-01-29 14:39:13'}
19629359182172540RFNT34555R22GRIPPER M/TFuel Tires345/55R22345/55R22Blackwall2234555Q12382.6702136.88.5-11.0 0003420{ts '2024-01-29 14:39:13'}
20629341182172540RFNT351250R22GRIPPER M/TFuel Tires35X12.50R22LT35X12.50R22LTBlackwall223512.5117QE/10PR032.5021358.5-10.0-11.03P+2S+2N0 7.5000283565PSI{ts '2024-01-29 14:39:13'}
21629342182172540RFNT371350R22GRIPPER M/TFuel Tires37X13.50R22LT37X13.50R22LTBlackwall223713.5123QE/10PR037.5021378.5-11.03P+2S+2N0 9000342065PSI{ts '2024-01-29 14:39:13'}
22629343182172540RFNT381550R22GRIPPER M/TFuel Tires38X15.50R22LT38X15.50R22LTBlackwall223815.5124QD/8PR041.50213811.0-12.0-14.03P+2S+2N0 12000352550PSI{ts '2024-01-29 14:39:13'}
23629353182172540RFNT331250R24GRIPPER M/TFuel Tires33x12.50R24LT33x12.50R24LTBlackwall243312.5106Q032.202132.8 0000{ts '2024-01-29 14:39:13'}
24629352182172540RFNT341250R24GRIPPER M/TFuel Tires34x12.50R24LT34x12.50R24LTBlackwall243412.5116Q033.302133.8 0000{ts '2024-01-29 14:39:13'}
25629357182172540RFNT34545R24GRIPPER M/TFuel Tires345/45R24345/45R24Blackwall2434545Q12078.9302136.78.5-11.0 0003085{ts '2024-01-29 14:39:13'}
26629345182172540RFNT351350R24GRIPPER M/TFuel Tires35X13.50R24LT35X13.50R24LTBlackwall243513.5118QE/10PR033.502134.78.5-11.03P+2S+2N0 7.5000291065PSI{ts '2024-01-29 14:39:13'}
27629346182172540RFNT371350R24GRIPPER M/TFuel Tires37X13.50R24LT37X13.50R24LTBlackwall243713.5120QE/10PR035.802136.78.5-11.03P+2S+2N0 9000308565PSI{ts '2024-01-29 14:39:13'}
28629363182172540RFNT39550R24GRIPPER M/TFuel Tires395/50R24395/50R24Blackwall2439550P128108.0302139.711.0-14.0 0003970{ts '2024-01-29 14:39:13'}
29629344182172540RFNT401550R24GRIPPER M/TFuel Tires40X15.50R24LT40X15.50R24LTBlackwall244015.5128PE/10PR04902139.711.0-12.0-14.03P+2S+2N0 12000397065PSI{ts '2024-01-29 14:39:13'}
30629356182172540RFNT34540R26GRIPPER M/TFuel Tires345/40R26345/40R26Blackwall2634540Q11779.8102136.89.5-12.0 0002835{ts '2024-01-29 14:39:13'}
31629347182172540RFNT371350R26GRIPPER M/TFuel Tires37X13.50R26LT37X13.50R26LTBlackwall263713.5117QF/12PR036.2021379.5-11.0-12.03P+2S+2N0 9000238580PSI{ts '2024-01-29 14:39:13'}
32629362182172540RFNT39545R26GRIPPER M/TFuel Tires395/45R26395/45R26Blackwall2639545P127102.7402139.711.0-14.0 0003860{ts '2024-01-29 14:39:13'}
33629348182172540RFNT401550R26GRIPPER M/TFuel Tires40X15.50R26LT40X15.50R26LTBlackwall264015.5127PE/10PR046.602139.711.0-12.0-14.03P+2S+2N0 12000386065PSI{ts '2024-01-29 14:39:13'}
34629349182172540RFNT401650R28GRIPPER M/TFuel Tires40X16.50R28LT40X16.50R28LTBlackwall284016.5126PE/10PR046.602139.713.0-14.0-16.03P+2S+2N0 12000375080PSI{ts '2024-01-29 14:39:13'}
GRIPPER M/T - Fuel Off-Road Wheels

  Fuel Tires     Fuel Tires  

GRIPPER M/T

Fuel Tires GRIPPER M/T

33x12.50R17
33x12.50R18
33x12.50R20
33x12.50R22
35x12.50R17
35x12.50R18
35x12.50R20
35x12.50R22
35x13.50R20
35x13.50R24
37x13.50R17
37x13.50R20
37x13.50R22
37x13.50R24
37x13.50R26
38x15.50R20
38x15.50R22
40x15.50R24
40x15.50R26
40x16.50R28

Technical Specifications

Part Number Size Speed Rating Load Range Weight (lb) Tread Depth Max Load Max PSI Overall Diameter Rim Range Tread Construction Side Construction Dynamic Balance (oz) Warranty (miles)
RFNT331250R17 33X12.50R17LT 120Q E/10PR 32 21 3085 65PSI 33 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT34575R17 345/75R17 Q n/a 83.78 21 4300 n/a 36.8 8.5-11.0 n/a 0 n/a
RFNT351250R17 35X12.50R17LT 125Q F/12PR 34.6 21 3640 80PSI 34.8 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT371350R17 37X13.50R17LT 131Q E/10PR 38 21 4300 65PSI 37 8.5-10.0-11.0 3P+2S+2N 0 9 0
RFNT331250R18 33X12.50R18LT 118Q E/10PR 31.5 21 2910 65PSI 33 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT351250R18 35X12.50R18LT 123Q E/10PR 34 21 3415 65PSI 35 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT331250R20 33X12.50R20LT 114Q E/10PR 30.5 21 2600 65PSI 32.8 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT341250R20 34x12.50R20LT 123Q n/a 34.5 21 0 80PSI 33.8 n/a n/a 0 n/a
RFNT34555R20 345/55R20 Q n/a 76.06 21 3750 n/a 34.8 8.5-11.0 n/a 0 n/a
RFNT34560R20 345/60R20 Q n/a 82.89 21 3860 n/a 36.8 8.5-11.0 n/a 0 n/a
RFNT351250R20 35X12.50R20LT 121Q E/10PR 73 21 3195 65PSI 34.8 8.5 - 11.0 3P+2S+2N 0 7.5 0
RFNT351250R20XL 35X12.50R20LT 125Q F/12PR 73.9 21 3640 80PSI 34.8 8.5 - 11.0 3P+2S+2N 0 7.5 0
RFNT351350R20 35X13.50R20LT 126Q F/12PR 34.5 21 3750 80PSI 35 8.5-11.0 3P+2S+2N 0 7.5 0
RFNT371350R20 37x13.50R20LT 127Q E/10PR 38.5 21 3860 65PSI 37 8.5-11.0 3P+2S+2N 0 9 0
RFNT381550R20 38X15.50R20LT 125Q D/8PR 39.6 21 3640 50PSI 37.7 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT39560R20 395/60R20 Q n/a 87.3 21 3640 n/a 37.7 11.0-14.0 n/a 0 n/a
RFNT331250R22 33X12.50R22LT 109Q E/10PR 30 21 2270 65PSI 32.8 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT341250R22 34x12.50R22LT 121Q n/a 33.6 21 0 n/a 33.8 n/a n/a 0 n/a
RFNT34555R22 345/55R22 Q n/a 82.67 21 3420 n/a 36.8 8.5-11.0 n/a 0 n/a
RFNT351250R22 35X12.50R22LT 117Q E/10PR 32.5 21 2835 65PSI 35 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT371350R22 37X13.50R22LT 123Q E/10PR 37.5 21 3420 65PSI 37 8.5-11.0 3P+2S+2N 0 9 0
RFNT381550R22 38X15.50R22LT 124Q D/8PR 41.5 21 3525 50PSI 38 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT331250R24 33x12.50R24LT 106Q n/a 32.2 21 0 n/a 32.8 n/a n/a 0 n/a
RFNT341250R24 34x12.50R24LT 116Q n/a 33.3 21 0 n/a 33.8 n/a n/a 0 n/a
RFNT34545R24 345/45R24 Q n/a 78.93 21 3085 n/a 36.7 8.5-11.0 n/a 0 n/a
RFNT351350R24 35X13.50R24LT 118Q E/10PR 33.5 21 2910 65PSI 34.7 8.5-11.0 3P+2S+2N 0 7.5 0
RFNT371350R24 37X13.50R24LT 120Q E/10PR 35.8 21 3085 65PSI 36.7 8.5-11.0 3P+2S+2N 0 9 0
RFNT39550R24 395/50R24 P n/a 108.03 21 3970 n/a 39.7 11.0-14.0 n/a 0 n/a
RFNT401550R24 40X15.50R24LT 128P E/10PR 49 21 3970 65PSI 39.7 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT34540R26 345/40R26 Q n/a 79.81 21 2835 n/a 36.8 9.5-12.0 n/a 0 n/a
RFNT371350R26 37X13.50R26LT 117Q F/12PR 36.2 21 2385 80PSI 37 9.5-11.0-12.0 3P+2S+2N 0 9 0
RFNT39545R26 395/45R26 P n/a 102.74 21 3860 n/a 39.7 11.0-14.0 n/a 0 n/a
RFNT401550R26 40X15.50R26LT 127P E/10PR 46.6 21 3860 65PSI 39.7 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT401650R28 40X16.50R28LT 126P E/10PR 46.6 21 3750 80PSI 39.7 13.0-14.0-16.0 3P+2S+2N 0 12 0

These products can expose you to chemicals including chromium, nickel and lead which are known by the State of California to cause cancer, or birth defects, or other reproductive harm. For more information please visit: www.P65warnings.ca.gov