Products meeting the search criteria

1054 - Unknown column 'p.products_id' in 'on clause'

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%5x100%' or p.products_model like '%5x100%' or m.manufacturers_name like '%5x100%') )

[TEP STOP]

John’s 2011 Subaru WRX on 18×9.5 e44 Rota RT5

Owner: John Mullis
Car: 2011 Subaru WRX
Wheels: 18×9.5 Rota RT5 - Hyper Black (5×100/e44/73)
Tires: 265/35/18 Michelin Pilot Super Sport
Suspensions: Stock suspension, non rolled fenders.
No fitment issues, no scrubbing or scraping UNLESS carrying a heavy load or hefty passenger in the rear and hitting a decent size bump.

Brent’s 2015 Subaru Forester XT on 17×8 Rota Recce Flat Black

Owner: Brent Parsons
Car: 2015 Subaru Forester XT
Wheels: 17×8 Rota Recce - Flat Black (5X100/e44/73)
Tires: 235/65-17 Hankook Dynapro
Suspensions: Primitive Racing Lift Spacer 1.25” and Rear Subframe Realignment Spacers

It definitely feels more “truck-like” this high up and with the knobby tires but it handles the mud so much better. The tires did rub a little, front and back, so i trimmed the fender trim and the mudflaps but other than that it fit great. It also has some cheap Chinese Led fang bumper lights that I wrapped in black vinyl and a Smitty built 3/4” D-ring and Subaru tow hook installed in the front. interior just has SubiSpeed paddle shifter extensions, Valentine 1 Radar detector and of course my dashboard Hulu girl.

Joe’s 2014 Forester XT on 18×8.5 Rota HG5 in Hyper Black

Owner: Joe Koppenhaver
Car: 2014 Subaru Forester XT
Wheels: 18×8.5 Rota HG5 - Hyper Black (5×100/e44/73)
Tires: 235/50/18 Continental Extreme contact DWS 06’s
Suspensions: Swift rsr down springs, 20mm whiteline adjustable rear sway bar
Mods: Muteki chrome red lugs
STi front lip
Morimoto XB LED fog lights
STi axle back exhaust
JDM style DRL bumper inserts
Stop tech slotted rotors with hawk pads

In Stock Wheels - January

Here are the wheels that we have in stock for the month of Januart 2017. If you guys need anything please contact us in our new line at (510) 969-9529 SMS preferred or email us at sales@wheeldude.com

The following listings are available

- Impreza WRX, BRZ, FR-S Wheels

- STi, WRX 2015 up Wheels

- EVO Wheels Wheels

- BMW Wheels

- Lexus Wheels

- Focus Wheels

- Fiesta Wheels

- Porsche Super Carrera Wheels

- Truck Wheels

Impreza WRX, BRZ, FR-S Wheels

G-FORCE 17×7.5 e48 5X100 56.1 Flat Black, Gunmetal, Gold

GRID 17×7.5 e48 5X100 56.1 Sports Bronze

TORQUE 17×7.5 e48 5X100 56.1 Bronze

——————————————————————————-

DPT 17×8 e48 5X100/114.3 73 Sports Bronze, Hyper Black

G-FORCE 17×8 e48 5X100 56.1 Flat Black, Gold, Hyper Black

GRID 17×8 e35 5X100 73 Flat Black, Sports Bronze, Gold, Hyper Black, White

GRID 17×8 e44 5X100 73 Flat Black, Gunmetal, Gold, Hyper Black

TITAN 17×8 e45 5X100 73 Flat Black, Hyper Black, White

——————————————————————————-

DPT 17×9 e42 5X100/114.3 73 Sports Bronze, Gold, Hyper Black

FLUSH 17×9 e42 5X100 73  Royal Gunmetal, Royal Hyper Black, Royal White

G-FORCE 17×9 e42 5X100 73 Flat Black, Gold, Hyper Black

GRID 17×9 e30 5X100 73 Hyper Black

GRID 17×9 e35 5X100 73 Sports Bronze, Yamaha Black, Hyper Black, White

GRID 17×9 e42 5X100 73 Flat Black, Gold, Hyper Black, White

GRID-V 17×9 e42 5X100 73 Sports Bronze, Hyper Black , Speed Bronze

RT5 17×9 e42 5×100 73 Flat Black, Gold, Speed Bronze, White

SS10 17×9 e42 5X100 73 Sports Bronze ,White

TITAN 17×9 e35 5X100 73 Flat Black

TITAN 17×9 e42 5X100 73 Flat Black, Hyper Black, White

TORQUE 17×9 e30 5X100 73 Sports Bronze, Hyper Black

——————————————————————————-

GRAVEL 18×8 e48 5X100 56.1 Hyper Black, Hyper Silver

TARMAC3 18×8 e48 5X100 56.1 Hyper Black

——————————————————————————-

DPT 18×8.5 e44 5×100/114.3 73 Flat Black

G-FORCE 18×8.5 e38 5X100 73 Gold, Hyper Black

G-FORCE 18×8.5 e48 5X100 56.1 Gunmetal, Gold, Hyper Black

GRAVEL 18×8.5 e44 5X100 56.1 Gunmetal, Hyper Black

GRID 18×8.5 e44 5X100 73 Flat Black, Gold, Hyper Black

HG5 18×8.5 e44 5X100 73 Gold, Hyper Black

MXR 18×8.5 e44 5X100 73 Hyper Black, Royal Hyper Black

PWR 18×8.5 e44 5X100 56.1 Gunmetal, Hyper Black

ROKU 18×8.5 e44 5X100 73 Flat Black, Hyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Flat Black, Gold, Hyper Black

RT-5 18×8.5 e44 5X100 73 Hyper Black

Lemans 18×8.5 e44 5×100 Machined

SS10 18×8.5 e44 5X100 73 Hyper Black, White

SVN 18×8.5 e48 5X100 56.1 Sports Bronze, TOMY Gold, Speed Bronze

TITAN 18×8.5 e44 5X100 73 Flat Black, Hyper Black

TORQUE 18×8.5 e40 5X100 73 Sports Bronze, Hyper Black

——————————————————————————-

G-FORCE 18×9 e35 5X100 Flat Black, Gold, Gunmetal, Hyper Black

GRID 18×9 e42 5X100 Flat Black, Hyper Black

——————————————————————————-

D2-EX 18×9.5 e38 5X100 73 BLK W/YMH BLK LIP

DPT 18×9.5 e35 5X100/114.3 73 Flat Black, Gold ,Hyper Black

DPT 18×9.5 e44 5X100/114.3 73 Flat Black, Gold, Hyper Black

FLUSH 18×9.5 e38 5X100 73 Machined, Royal Gunmetal, Royal Hyper Black

GKR 18×9.5 e38 5X100 73 Flat Black, White

GRID 18×9.5 e38 5X100 73 Chameleon, Flat Black, Gold ,Hyper Black, SLATE BLUE, Titanium Chrome

HG5 18×9.5 e38 5X100 73 Gold ,Hyper Black

KENSEI 18×9.5 e35 5X100 73 Flat Black, Royal Hyper Black, Royal Silver

MXR 18×9.5 e38 5X100 73 Flat Black, Gold, Hyper Black, Royal, Hyper Black, Royal White

P-1R 18×9.5 e38 5X100 73 Hyper Black

PWR 18×9.5 e38 5×100 73 Hyper Black

RM110 18×9.5 e38 5X100 73 Machined

ROKU 18×9.5 e38 5X100 73 Flat Black, Hyper Black

ROKU 18×9.5 e38 5X100/114.3 73 Flat Black, Gold, Hyper Black

RT-5 18×9.5 e44 5X100 73 Gold, Hyper Black, Hyper Silver, White

LEMANS 18×9.5 e30 5×100 Machined

SS10 18×9.5 e38 5X100 73 Sports Bronze, Hyper Black, White

T2-R 18×9.5 e38 5X100 73 Gold, Hyper Black

TITAN 18×9.5 e38 5X100 73 Flat Black, Gold, Hyper Black

TORQUE 18×9.5 e35 5X100 73 Sports BronzeHyper BlackWhite

TORQUE 18×9.5 e40 5X100 73 Sports BronzeHyper Black

VECTOR Pro 18×9.5 e38 5X100 73 GoldHyper Black

——————————————————————————-

SVN-R 18×10 e30 5X100/114.3 73 Chameleon, Hyper BlackHyper SilverTitanium Chrome ,White

TITAN18×10 e30 5×100 73 Flat Black, White

——————————————————————————-

STi, WRX 2015 up Wheels

DPT 17×9 e42 5X100/114.3 73 Sports BronzeGoldHyper Black

FLUSH 17×9 e42 5X114.3 73 Gunmetal, Royal Hyper Black

GRID 17×9 e42 5X114.3 73 Chameleon, Flat Black, Sports Bronze, Gold, Hyper Black, Speed Bronze, White

RT5 17×9 e42 5×114.3 73 Hyper Black

SS10 17×9 e42 5X114. 3 73 Flat Black, Sports Bronze, White

TITAN 17×9 e42 5X114.3 73 Flat Black, Sports Bronze, Hyper Black

TORQUE 17×9 e42 5×114.3 73 Sports Bronze

——————————————————————————-

DPT 18×8.5 e44 5×100/114.3 73 Flat Black

G-FORCE 18×8.5 e48 5X114.3 73 Gunmetal, Gold, Hyper Black, White

GRID 18×8.5 e44 5X114.3 73 Flat Black, Gold, Hyper Black, Speed Bronze, White

ROKU 18×8.5 e44 5X100/114.3 73 Flat Black, Gold, Hyper Black

SS10 18×8.5 e44 5X114.3 73 Hyper Black, White

SVN 18×8.5 e48 5X114.3 73 Chameleon, Flat Black

TITAN 18×8.5 e44 5X114.3 73 Flat Black

——————————————————————————-

G-FORCE 18×9 e30 5X114.3 73 Cosmic Blue, Gunmetal, Gold, Hyper Black, White

GRID 18×9 e42 5X114.3 73 Flat Black

SVN 18×9 e30 5×114.3 73 Hyper Black

SVN 18×9 e40 5×100/114.3 73 Hyper Black

——————————————————————————-

D2-EX 18×9.5 e38 5X114.3 73 Royal Silver, Royal Yamaha Black

DPT 18×9.5 e35 5X100/114.3 73 Flat Black,  GoldHyper Black,

DPT 18×9.5 e38 5X114.3/108 73 Hyper Black

DPT 18×9.5 e44 5X100/114.3 73 Flat BlackGoldHyper Black

FLUSH 18×9.5 e30 5X114.3 73 Flat Black, Machined, Royal Gunmetal, Royal Hyper Black

GRID 18×9.5 e38 5X114.3 73 Chameleon, Flat Black, Sports Bronze, Gold, Hyper Black, Speed Bronze, Titanium Chrome, White

HASHTAG 18×9.5 e38 5X114.3 73 Flat BlackHyper BlackGold

HG5 18×9.5 e35 5X114.3 73 GoldHyper Black

KENSEI 18×9.5 e25 5X114.3 73 Flat Black, Royal Hyper Black, Royal Silver

MXR 18×9.5 e38 5X114.3 73 Hyper BlackRoyal Hyper Black

P-1R 18×9.5 e30 5X1143 73 Gold, Hyper Black

P-45R 18×9.5 e30 5X114.3 73 Flat Black, Sports Bronze, Hyper Black

PWR 18×9.5 e32 5X114.3 73 Gold

REEV 18×9.5 e38 5X114.3 73 Gold,  Hyper Black

ROKU 18×9.5 e38 5X100/114.3 73 Flat Black, Gold, Hyper Black

ROKU 18×9.5 e38 5X108/114.3 73 GRAY Gunmetal

Lemans 18×9.5 e30 5X114.3 73 Royal Gold

Slipstream 18×9.5 e38 5X114.3 73 Full Royal Gunmetal, Mag Black, White

SS10 18×9.5 e38 5X114.3 73 Slate Blue, White

T2-R 18×9.5 e38 5X114.3 73 Titanium Chrome

TITAN 18×9.5 e35 5X114.3 73 Flat Black, Hyper Black

TORQUE 18×9.5 e28 5X114.3 73 Flat Black, Sports Bronze, Hyper Black

VECTOR PRO 18×9.5 e38 5X114.3 73 Gold

——————————————————————————-

SVN-R 18×10 e30 5X100/114.3 73 Chameleon, Hyper BlackHyper SilverTitanium Chrome ,White

——————————————————————————-

EVO Wheels Wheels

GRID 18×9.5 e20 5X114.3 73 Chameleon, Deep RedFlat Black, Sports Bronze, GoldHyper Black, Speed Bronze, Titanium ChromeWhite

MXR 18×9.5 e20 5X114.3 73 Hyper Black, Royal Gold, Royal Hyper Black

P-45R 18×9.5 e20 5X114.3 73 Flat BlackSports BronzeHyper Black

TORQUE 18×9.5 e20 5X114.3 73 Sports Bronze

SVN-R 18×10 e30 5X100/114.3 73 Chameleon, Flat BlackHyper BlackHyper SilverTitanium Chrome ,White

——————————————————————————-

BMW Wheels

Linea Corse Dyna - 19×8.5/10 (5×120/e30F,e37R) Polished

Linea Corse LC818 - 19×8.5/10 (5×120/e30F,e37R) Hyper SilverSatin Black,

Linea Corse LC910 - 19×8.5/10 (5×120 +35+43) Hyper Silver

Linea Corse Viten - 19×8.5/10 (5×120/e30F,e37R) Silver with Polished Lip

——————————————————————————-

Lexus Wheels

Linea Corse Dyna - 19×8.5/10 (5×114.3/e30F,e38R/73) Polished

Linea Corse Viten - 19×8.5/10 (5×114.3/e30F,e38R) Silver w/ Polished Lip

Linea Corse LC818 - 19×8.5/10 (5×114.3/e30F,e38R/73) Hyper SilverSatin Black

——————————————————————————-

Focus Wheels

G-FORCE 18×9 e35 5X108 73 WhiteHyper BlackGunmetal

GRID 18×8.5 e42 5X108 73 Flat BlackHyper Black, Speed Bronze, White

GRID 18×9.5 e38 5X108 73 Flat Black, Hyper Black, Speed Bronze

HG5 18×9.5 e38 5X108 73 Flat Black

ROKU 18×9.5 e38 5X108/114.3 73 GRAY GunMetal

TITAN 17×8 e40 5X108 73 Hyper Black

TITAN 17×9 e40 5X108 73 Hyper Black

——————————————————————————-

Fiesta Wheels

GRID 17×8 e40 4X108 Flat Black

GRID 17×9 e42 4X108 Hyper Black

RT-5 18×9.5 e44 4X108 Titanium Chrome

TITAN 17×8 e40 4X108 Hyper Black

——————————————————————————-

Porsche Super Carrera wheels

17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip, RSR FinishSatin Black with Polished Lip

——————————————————————————-

Truck Wheels

Grid Offroad 16×8 e0 6X139.7 hub 110 Royal GunmetalRoyal Hyper Black
Grid Offroad 16×8 e20 6X139.7 hub 110 BronzeFlat Black, GunmetalHyper Black
Grid Offroad 18×8.5 e20 6X139.7 hub 110 Bronze
Grid 18×9 e42 6X139.7 hub 73 Hyper Black

Recce 18×9 e10 6X139.7 hub 110 Flat Black
Recce 18×9 e30 6X114.3 hub 73 Flat Black

TRAIL 16×8 e0 6X139.7 hub 110 Flat Black

Will’s WRX on 18×8.5 Rota Torque in Hyper Black

Owner: Will
Car: Subaru WRX
Wheels: 18×8.5 Rota Torque - Hyper Black (5×100/e40/73)
Tires: 235/40/18
Suspensions: BC Racing coils and Eibach sway bars

17×8 Rota Wheels for 2004-2014 WRX

Clears brembo breaks no fender modifications needed.

17×8 Rota Grid - (5×100/e44/73) Flat Black, Gold, Gunmetal and Hyper Black


17×8 Rota Recce - (5×100/e44/73) Flat Black and White

17×8 Rota Torque - (5×100/e4/56.1) Flat Black


Israel’s 2013 WRX on 18×9.5 e38 Hyper Black GKR

Owner: Israel Rodriguez
Car: 2013 Subaru wrx
Wheels: 18×9.5 Rota GKR - Hyper Black (5×100/e38/73)
Tires: 245/40R18
Suspension: BC racing BR type coilovers with upgraded swift springs, whiteline sway bars front:24mm, rear:22mm
Engine mods:
Perrin big tube uppipe
Nameless performance turbo back exhaust without catalytic converters, mufflers, or resonators
Koyorad radiator with Perrin silicon hoses
Turbosmart recirculating valve
Grimspeed 3-port electronic boost control solenoid
Deatschwerks DW65c 265lph fuel pump, deatschwerks 1000cc injectors,
Nameless performance smog air injection pump delete plates
Cavalli stage 1 triple ceramic ball bearing turbo, turbo XS front mount intercooler
Perrin cold air intake, Perrin turbo inlet hose, Perrin turbo heat blanket
Stage 2 competition clutch and lightweight flywheel, and Cobb tuning V3 accessport

Michael’s FR-S on 17×9 +42 Hyper Black Grids-V

Owner: Michael Allman
Car: Scion FR-S
Wheels:17×9 Rota Grid-V - Hyper Black (5×100/e42/73)
Tires: 245/40/17 Hankook Ventus RS3
Suspension: Fortune auto 500

David’ 86 on 18×8.5 e44 Rota MXR in Royal Hyper Black

Owner: David Soliman
Car: 2014 Toyota 86
Wheels: 18×8.5 Rota MXR - Royal Hyper Black (5×100/e44/73)
Tires: 245/35 R18 Achilles 2233s
Suspension: Cobra Sport Springs
Additional Mods: Kyo Ei lug nuts

Armando’s 04 STi on 18×9.5 e35 Rota DPT

Owner: Armando
Car: 2004 Subaru Impreza STi
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e35/73) custom Red finish
Tires: 235/40/18