Query
Template: D:\WebSites\fuelWheels.com\tires\queries.cfc
Execution Time: 1.02 ms
Record Count: 21
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
1391961182172540RFNT331250R17GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires33X12.50R17LTBlackwall173312.5120Q E/10PR070.6002108.5-10.0-11.03P+2S+2N0 7.5000065PSI{ts '2019-06-11 09:03:51'}
2391963182172540RFNT34575R17GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT345/75R17Blackwall1734575131Q E/10PR083.8002108.5-10.0-11.03P+2S+2N0 9000065PSI{ts '2019-06-11 09:03:51'}
3391962182172540RFNT351250R17GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires35X12.50R17LTBlackwall173512.5125Q F/12PR076.3002108.5-10.0-11.03P+2S+2N0 7.5000080PSI{ts '2019-06-11 09:03:51'}
4391964182172540RFNT331250R18GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires33X12.50R18LTBlackwall183312.5118Q E/10PR069.5002108.5-10.0-11.03P+2S+2N0 7.5000065PSI{ts '2019-06-11 09:03:51'}
5391965182172540RFNT351250R18GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires35X12.50R18LTBlackwall183512.5123Q E/10PR07502108.5-10.0-11.03P+2S+2N0 7.5000065PSI{ts '2019-06-11 09:03:51'}
6391966182172540RFNT331250R20GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires33X12.50R20LTBlackwall203312.5114Q E/10PR067.3002108.5-10.0-11.03P+2S+2N0 7.5000065PSI{ts '2019-06-11 09:03:51'}
7391969182172540RFNT34555R20GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT345/55R20Blackwall2034555126Q F/12PR076.1002108.5-11.03P+2S+2N0 7.5000080PSI{ts '2019-06-11 09:03:51'}
8391970182172540RFNT34560R20GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT345/60R20Blackwall2034560127Q E/10PR082.9002108.5-11.03P+2S+2N0 9000065PSI{ts '2019-06-11 09:03:51'}
9391968182172540RFNT351250R20GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires35X12.50R20LTBlackwall203512.5121Q E/10PR07302108.5-10.0-11.03P+2S+2N0 7.5000065PSI{ts '2019-06-11 09:03:51'}
10391967182172540RFNT351250R20XLGRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires35X12.50R20LTBlackwall203512.5125Q F/12PR073.9002108.5-10.0-11.03P+2S+2N0 7.5000080PSI{ts '2019-06-11 09:03:51'}
11391971182172540RFNT39560R20GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT395/60R20Blackwall2039560125Q D/8PR087.30021011.0-12.0-14.03P+2S+2N0 12000050PSI{ts '2019-06-11 09:03:51'}
12391972182172540RFNT331250R22GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires33X12.50R22LTBlackwall223312.5109Q E/10PR066.2002108.5-10.0-11.03P+2S+2N0 7.5000065PSI{ts '2019-06-11 09:03:51'}
13391974182172540RFNT34555R22GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT345/55R22Blackwall2234555123Q E/10PR082.7002108.5-11.03P+2S+2N0 9000065PSI{ts '2019-06-11 09:03:51'}
14391973182172540RFNT351250R22GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires35X12.50R22LTBlackwall223512.5117Q E/10PR071.7002108.5-10.0-11.03P+2S+2N0 7.5000065PSI{ts '2019-06-11 09:03:51'}
15391975182172540RFNT381550R22GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires38X15.50R22LTBlackwall223815.5124Q D/8PR091.50021011.0-12.0-14.03P+2S+2N0 12000050PSI{ts '2019-06-11 09:03:51'}
16391978182172540RFNT34545R24GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT345/45R24Blackwall2434545120Q E/10PR078.9002136.78.5-11.03P+2S+2N0 9013.700065PSI{ts '2019-06-11 09:03:51'}
17391977182172540RFNT351350R24GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires35X13.50R24LTBlackwall243513.5118Q E/10PR073.9002134.78.5-11.03P+2S+2N0 7.5013.600065PSI{ts '2019-06-11 09:03:51'}
18391976182172540RFNT39550R24GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT395/50R24Blackwall2439550128P E/10PR010802139.711.0-12.0-14.03P+2S+2N0 12015.900065PSI{ts '2019-06-11 09:03:51'}
19391979182172540RFNT34540R26GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT345/40R26Blackwall2634540121Q F/12PR079.8002136.89.5-11.0-12.03P+2S+2N0 9013.700080PSI{ts '2019-06-11 09:03:51'}
20391980182172540RFNT39545R26GRIPPER M/T (MUD TERRAIN TIRE)Fuel TiresLT395/45R26Blackwall2639545127P E/10PR0102.8002139.711.0-12.0-14.03P+2S+2N0 12015.800065PSI{ts '2019-06-11 09:03:51'}
21391981182172540RFNT401650R28GRIPPER M/T (MUD TERRAIN TIRE)Fuel Tires40X16.50R28LTBlackwall284016.5126P E/10PR0102.8002139.713.0-14.0-16.03P+2S+2N0 12016.400080PSI{ts '2019-06-11 09:03:51'}
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 70.60 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT34575R17 LT345/75R17 131Q E/10PR 83.80 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 9 0
RFNT351250R17 35X12.50R17LT 125Q F/12PR 76.30 21 0 80PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT331250R18 33X12.50R18LT 118Q E/10PR 69.50 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT351250R18 35X12.50R18LT 123Q E/10PR 75 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT331250R20 33X12.50R20LT 114Q E/10PR 67.30 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT34555R20 LT345/55R20 126Q F/12PR 76.10 21 0 80PSI 0 8.5-11.0 3P+2S+2N 0 7.5 0
RFNT34560R20 LT345/60R20 127Q E/10PR 82.90 21 0 65PSI 0 8.5-11.0 3P+2S+2N 0 9 0
RFNT351250R20 35X12.50R20LT 121Q E/10PR 73 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT351250R20XL 35X12.50R20LT 125Q F/12PR 73.90 21 0 80PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT39560R20 LT395/60R20 125Q D/8PR 87.30 21 0 50PSI 0 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT331250R22 33X12.50R22LT 109Q E/10PR 66.20 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT34555R22 LT345/55R22 123Q E/10PR 82.70 21 0 65PSI 0 8.5-11.0 3P+2S+2N 0 9 0
RFNT351250R22 35X12.50R22LT 117Q E/10PR 71.70 21 0 65PSI 0 8.5-10.0-11.0 3P+2S+2N 0 7.5 0
RFNT381550R22 38X15.50R22LT 124Q D/8PR 91.50 21 0 50PSI 0 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT34545R24 LT345/45R24 120Q E/10PR 78.90 21 0 65PSI 36.7 8.5-11.0 3P+2S+2N 0 9 0
RFNT351350R24 35X13.50R24LT 118Q E/10PR 73.90 21 0 65PSI 34.7 8.5-11.0 3P+2S+2N 0 7.5 0
RFNT39550R24 LT395/50R24 128P E/10PR 108 21 0 65PSI 39.7 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT34540R26 LT345/40R26 121Q F/12PR 79.80 21 0 80PSI 36.8 9.5-11.0-12.0 3P+2S+2N 0 9 0
RFNT39545R26 LT395/45R26 127P E/10PR 102.80 21 0 65PSI 39.7 11.0-12.0-14.0 3P+2S+2N 0 12 0
RFNT401650R28 40X16.50R28LT 126P E/10PR 102.80 21 0 80PSI 39.7 13.0-14.0-16.0 3P+2S+2N 0 12 0

Fitment Lookup

Fitment Lookup