Query
Template: /tires/queries.cfc:204
Execution Time: 7.26 ms
Record Count: 4
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 = 3949
AND bc.intConfigID = 404
ORDER BY decDiameter, vchrPartNumber
intTireSpecIDintTireIDintAccountIDintBrandIDintTireImageIDvchrPartNumbervchrNamebrandNamevchrQuickDrawvchrSizevchrSideWalldecDiameterdecSectWidthdecAspectRatiodecDiameterInchdecWidthInchvchrSpeedRatingchrTypechrLoadRangeintLoadIndexdecWeightdecHeightvchrTreadDepthdecOverDiametervchrRimRangevchrTreadConstructionvchrSideConstructiondecDynomicBalanceOzvchrWarrantydecWidthdecLenthintMaxLoadvchrMaxPSIdtCreatedUpdated
16293703949172540RFTR281000R14GRIPPER T/R/K UTVFuel TiresAT28X10R14TRKAT28X10R14TRKBlackwall142810N032.3018286.5-8.52P+2S+1N2P 000085520PSI{ts '2024-01-29 14:39:13'}
26293713949172540RFTR321000R14GRIPPER T/R/K UTVFuel TiresAT32X10R14TRKAT32X10R14TRKBlackwall143210N041.9018326.5-8.52P+2S+1N2P 0000107020PSI{ts '2024-01-29 14:39:13'}
36293723949172540RFTR321000R15GRIPPER T/R/K UTVFuel TiresAT32X10R15TRKAT32X10R15TRKBlackwall153210N042018326.5-8.52P+2S+1N2P 0000105020PSI{ts '2024-01-29 14:39:13'}
46293733949172540RFTR351000R15GRIPPER T/R/K UTVFuel TiresAT35X10R15TRKAT35X10R15TRKBlackwall153510N047.501834.66.5-8.52P+2S+1N2P 0000160035PSI{ts '2024-01-29 14:39:13'}
GRIPPER T/R/K UTV - Fuel Off-Road Wheels

  Fuel Tires     Fuel Tires  

GRIPPER T/R/K UTV

Fuel Tires GRIPPER T/R/K UTV

32x10-14R
32x10-15R
35x10-15R
DOT APPROVED*

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)
RFTR281000R14 AT28X10R14TRK N n/a 32.3 18 855 20PSI 28 6.5-8.5 2P+2S+1N 2P 0 0
RFTR321000R14 AT32X10R14TRK N n/a 41.9 18 1070 20PSI 32 6.5-8.5 2P+2S+1N 2P 0 0
RFTR321000R15 AT32X10R15TRK N n/a 42 18 1050 20PSI 32 6.5-8.5 2P+2S+1N 2P 0 0
RFTR351000R15 AT35X10R15TRK N n/a 47.5 18 1600 35PSI 34.6 6.5-8.5 2P+2S+1N 2P 0 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