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]

Greg’s 2011 WRX on 18×10 e30 Rota SVN-R in Titanium Chrome

Owner: Greg
Car: 2011 Subaru WRX
Wheels: 18×10 Rota SVN-R - Titanium Chrome (5×100/114.3/e30/73)
Tires: Federal 596 RR 255 35 18
Suspension: ein coilover with slight camber all around

@boobs_n_boost 2018 Forester XT on 18×8.5 Flat Black Grids

Owner: Instagram @boobs_n_boost
Car: 2018 Forester XT
Wheels: 18×8.5 Rota Grid - Flat Black (5×100/e44/73)
Tires: Dunlop signature HP 245/45R18 96
Suspension: Stock suspension for now
Mods: Invidia N1 exhaust

In Stock Wheels - June 2018

Here are the wheels that we have in stock for the month of June 2018. 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

-5×112 pcd wheels

Impreza WRX, BRZ, FR-S Wheels

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

Grid 17×7.5 e48 5×100 56.1 Sports Bornze

Torque 17×7.5 e48 5×100 56.1 GoldSport BronzeFlat Black

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

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

G-FORCE 17×8 e48 5X100 56.1 Gold

GRID 17×8 e35 5X100 73 Flat BlackHyper BlackWhiteGold, Sports Bronze

GRID 17×8 e44 5X100 73 Flat BlackGunmetalHyper Black

Recce 17×8 e44 5×100 73 Flat BlackGunmetalWhite, Gunmetal Grey

STRIKE 17×8 e40 5×100 73 Flat Black, Hyper Black

STW 17×8 e44 5×100 73 Royal GoldRoyal Hyper Black

TITAN 17×8 e45 5X100 73 Flat BlackWhiteHyper Black

TORQUE 17×8 e48 5×100 56.1 Flat BlackGunmetalHyper BlackSteel GrayWhite

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

DPT 17×9 e42 5X100/114.3 73 Hyper Black

G-FORCE 17×9 e42 5X100 73  GoldHyper Black

GRID 17×9 e30 5X100 73 Hyper Black

GRID 17×9 e35 5X100 73 Flat BlackYamaha BlackHyper BlackSports Bronze, White

GRID 17×9 e42 5X100 73 Flat BlackGoldHyper BlackSports Bronze, White

GRID-V 17×9 e42 5X100 73 Hyper BlackSpeed Bronze

P45R 17×9 e35 5×100 73 Flat Black

SS10 17×9 e42 5X100 73 White

TITAN 17×9 e42 5X100 73 Flat BlackHyper BlackWhite

TORQUE 17×8 e35 5×100 70 Hyper Black

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

GRAVEL 18×8 e48 5X100 56.1 Hyper BlackHyper SilverGold

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

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

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

G-FORCE 18×8.5 e48 5X100 56.1 Flat BlackGoldHyper BlackGunmetal

GRAVEL 18×8.5 e44 5X100 56.1 GunmetalHyper Black, Gold

GRAVEL 18×8.5 e44 5X100 73 Gunmetal, Hyper Black, Gold

GRID 18×8.5 e44 5X100 73 Flat Black, GoldHyper BlackSpeed Bronze

HG5 18×8.5 e44 5X100 73 GoldHyper Black

KB-F 18×8.5 e44 5×100 73 Yamaha BlackHyper Silver

MXR 18×8.5 e44 5X100 73 Royal Hyper Black

ROKU 18×8.5 e44 5X100 73 Flat BlackHyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Gold

RT-5 18×8.5 e44 5X100 73 Hyper BlackHyper Silver

SS10 18×8.5 e44 5X100 73 Hyper Black

Strike 18×8.5 e44 5×100 73 Flat Black, Hyper Black

SVN 18×8.5 e48 5X100 56.1 Sports BronzeSpeed Bronze

TITAN 18×8.5 e44 5X100 73 Flat BlackHyper Black

TORQUE 18×8.5 e40 5X100 73 Sports BronzeHyper Black

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

G-FORCE 18×9 e35 5X100 73 Flat BlackGunmetalGoldHyper Black

SVN 18×9 e40 5×100 73 Flat Black

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

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

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

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

GRID 18×9.5 e38 5X100 73 ChameleonFlat BlackSpeed BronzeWhite, Deep Red

HASHTAG 18×9.5 e38 5×100 73 Gold

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

KB-R 18×9.5 e38 5×100 73 Flat BlackGoldHyper BlackWhite

KENSEI 18×9.5 e35 5X100 73 Royal Silver

MXR 18×9.5 e38 5X100 73 Flat BlackHyper BlackRoyal Hyper BlackRoyal Silver, Royal Gold, Royal White, Gold

P1-R 18×95 e38 5×100 73 Hyper Black

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

ROKU 18×9.5 e38 5X100/114.3 73 Flat BlackGoldHyper Black

RT-5 18×9.5 e44 5X100 73 Hyper BlackHyper SilverWhite

Strike 18×9.5 e38 5×100 73 Flat Black, Hyper Black

SS10 18×9.5 e38 5X100 73 Sports BronzeHyper BlackWhite

TITAN 18×9.5 e38 5×100 73 Flat Black

TORQUE 18×9.5 e35 5X100 73 Sports BronzeHyper Black

TORQUE 18×9.5 e40 5X100 73 Hyper Black

VECTOR Pro 18×9.5 e38 5X100 73 GoldHyper Black

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

SVN-R 18×10 e30 5X100/114.3 73 ChameleonFlat Black Hyper BlackTitanium ChromeWhite

TITAN 18×10 e30 5×100 73 Flat Black

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

KB-R 19×9.5 e40 5×100 73 Flat Black

Linea Corse LC818 19×8.5/10 e38 5×100 73 Hyper BlackHyper Silver

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

STi, WRX 2015 up Wheels

DPT 17×9 e42 5X100/114.3 73 Hyper Black

GRID 17×9 e25 5×114.3 73 Chameleon, Flat BlackHyper Black, Sports Bronze, White

GRID 17×9 e42 5X114.3 73 ChameleonFlat BlackGold, Hyper Black, Speed BronzeWhite

MXR 17×9 e42 5×114.3 73 Hyper BlackRoyal Hyper Black

P45R 17×9 e25 5×114.3 73 Sports Bronze

RT5 17×9 e25 5×114.3 73 Flat Black

SS10 17×9 e25 5×114.3 73 White

SS10 17×9 e42 5X114. 3 73 Flat BlackSports BronzeWhite

TITAN 17×9 e35 5X114.3 73 Flat Black, Hyper Black

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

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

P45-F 18×8 e48 5×114.3 73 Hyper Black

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

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

G-FORCE 18×8.5 e48 5X114.3 73 GoldHyper BlackWhiteFlat BlackGunmetal, White

GRID 18×8.5 e44 5X114.3 73 ChameleonFlat BlackHyper BlackSpeed Bronze

KB-F 18×8.5 e44 5×114.3 73 Flat BlackHyper BlackHyper Silver

MXR 18×8.5 e44 5×114.3 73 Royal Hyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Gold

SS10 18×8.5 e44 5X114.3 73 White

STRIKE 18×8.5 e44 5×114.3 73 Flat BlackHyper Black

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

G-FORCE 18×9 e25 5×114.3 Gunmetal

G-FORCE 18×9 e30 5X114.3 73 GunmetalGoldHyper Black

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

TS-6F e40 5×114.3 73 Gunmetal

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

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

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

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

GRID 18×9.5 e30 5×114.3 73 Hyper Black

GRID 18×9.5 e32 5×114.3 73 Deep RedFlat BlackHyper Black

GRID 18×9.5 e33 5×114.3 73 Hyper Black

GRID 18×9.5 e38 5X114.3 73 ChameleonHyper BlackSpeed Bronze, Flat Black, Gold, Sports Bronze, White

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

KB-R 18×9.5 e38 5×114.3 Flat BlackHyper Silver , Hyper Black

KENSEI 18×9.5 e25 5X114.3 73 Royal Hyper BlackRoyal Silver

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

P1R 18×9.5 e30 5×114.3 73 Hyper Black

P-45R 18×9.5 e30 5X114.3 73 Flat BlackSports Bronze

PWR 18×9.5 e38 5×114.3 73 Hyper Black

REEV 18×9.5 e38 5×114.3 73 Gold

ROKU 18×9.5 e38 5X100/114.3 73 Flat BlackGoldHyper Black

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

Slipstream 18×9.5 e38 5×114.3 73 Flat Black

Strike 18×9.5 e38 5×114.3 73  Hyper BlackGold, Flat Black

SS10 18×9.5 e38 5X114.3 73 Flat BlackWhite

TORQUE 18×9.5 e20 5X114.3 73 Hyper Black

TORQUE 18×9.5 e28 5X114.3 73 Flat Black

TS-6R 18×9.5 e30 5×114.3 73 Gunmetal

TORQUE 18×9.5 e28 5X114.3 73 Flat Black

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

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

GRID 18×10 e30 5×114.3 73 Yamaha Black

P45-r 18×10 e20 5×114.3 73 Royal GunmetalFlat Black

STRIKE 18×10 e15 5×114.3 73 Hyper Black

SVN-R 18×10 e30 5X100/114.3 73 ChameleonFlat Black Hyper BlackTitanium ChromeWhite

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

GARAGISTE 19×8.5 e44 5X114.3 43 Flat BlackHyper Black

GARAGISTE 19×9 e34 5X114.3 43 Flat BlackHyper Black

KB-R 19×9.5 e40 5×114.3 73 Hyper Black

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

EVO Wheels Wheels

G-FORCE 18×9 e30 5X114.3 73 GunmetalGoldHyper Black

GRID 18×9.5 e20 5X114.3 73 ChameleonSports BronzeGoldHyper BlackTitanium ChromeSpeed BronzeWhite

MXR 18×9.5 e20 5X114.3 73 Royal GoldHyper BlackRoyal Hyper Black

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

P45-R 18×10 e20 5×114.3 73 Flat BlackRoyal Gunmetal

TORQUE 18×9.5 e20 5X114.3 73 Hyper Black

SVN-R 18×10 e30 5X100/114.3 73 ChameleonFlat Black Hyper BlackHyper SilverTitanium ChromeWhite

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

BMW Wheels

MXR 18×9.5 e8 5×120 73 Sports Bronze

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

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

Linea Corse z2s - 19×8.5/9.5 (5×120/+30/+35) Hyper Silver with polished Lip

Linea Corse z2s - 19×8.5/9.5 (5×120/+15/+20) Hyper Black with polished Lip

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

Lexus Wheels

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

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

GARAGISTE 19×9 e42 5X108 73 Hyper Black

G-FORCE 18×9 e35 5X108 73 WhiteFlat Black

GRID 18×8.5 e42 5X108 73 Flat BlackHyper BlackSpeed BronzeWhite

GRID 18×9.5 e38 5X108 73 ChameleonHyper BlackWhiteGoldSpeed Bronze, Flat Black, White

KB-F 18×8.5 e42 5×108 73 Hyper BlackYamaha Black, Hyper Silver, Flat Black

KB-R 18×9.5 e38 5×108 Flat Black

KB-R 19×9.5 e40 5×109 56.1 Hyper Black

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

RT5 18×8.5  e38 5×108 63.4 Flat Black

Strike 18×8.5 e42 5×108 73 Flat BlackSpeed Bronze, Hyper Black

Strike 18×9.5 e38 5×108 Flat BlackHyper Black

TITAN 17×8 e40 5X108 73 Hyper Black

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

Fiesta Wheels

GRID 17×8 e40 4X108 73 Flat BlackHyper BlackWhite, Hyper Blue

RECCE 17×8 e40 4×108 73 Flat Black

RT-5 18×9.5 e44 4X108 Titanium Chrome

Slipstream 16×7 e40 4×108 63.4 Flat Black

Strike 17×8 e40 4×108 73 Flat BlackHyper Black

TITAN 17×7.5 e45 4X108 63.3 Gold

TITAN 17×8 e40 4X108 73 GoldHyper Black

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

Porsche Super Carrera wheels

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

17×9/11 Linea Corse Fox - (5×130/e16/e16/71.6hb) RSR Finish

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

Truck Wheels

Grid Offroad 16×8 e20 6X139.7 hub 110 BronzeFlat Black, GunmetalHyper Black

Grid Concave 18×9 e42 6X139.7 hub 73 Hyper Black

Recce 18×8.5 e5 6×139.7 hub 110 Flat BlackHyper Black

Recce 18×9 e10 6X139.7 hub 110 Flat Black

Trail-R 17×8.5 e-17 6×139.7 hub 110 Speed Bronze

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

5×112 Wheels

17×9 Rota Grid - Hyper Black(5×112/42/57.1)

18×9.5 Rota DPT - Hyper Black (5×108x112/e38/73)

18×9.5 Rota Grid - Full Royal Silver (5×112/e38/73)

18×8.5 Rota KB-F - Hyper Black (5×112/e40/73)

18×9.5 Rota KB-R - Hyper Black (5×112/e40/73)

18×9.5 Rota KB-R - Yamaha Black (5×112/e40/73)

Daniel’s 2015 GT86 on 17×8 Rota Titan

Owner: Daniel
Car: 2015 Toyota 86
Wheels: 17×8 Rota Titan- (5×100/45/73)
Tires: 225/45/17 Advan AD08R tyres all around
Suspension: BC BR coilovers
Mods: Tuning developments UK catback exhaust

Wheels on Sale

Here are the wheels that are on Sale. 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

Impreza WRX, BRZ, FR-S Wheels

HG5 18×8.5 e44 5X100 73 GoldHyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Gold

ROKU 18×8.5 e44 5X100 73  Hyper Black

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

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

ROKU 18×9.5 e38 5X100 73 Hyper Black

SS10 18×9.5 e38 5X100 73 White

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

STi, WRX 2015 up Wheels

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

ROKU 18×8.5 e44 5X100/114.3 73 Gold

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

SS10 18×8.5 e44 5X114.3 73 White

Strike 18×9.5 e38 5×114.3 73  Hyper BlackGold, Flat Black

Kyle’s 2013 WRX on 18×8.5 Rota G-Force in Gold

Owner: Kyle
Car: 2013 Subaru WRX
Wheels: 18×8.5 Rota G-Force - Gold (5×100/e48/56.1)
Tires: Bridgestone 245/40R18 97W XL RE003
Suspensions: BC Racing Coilovers
Tune: ECUTEK Type 4- Race ROM
CP Forged Pistons
ACL Race Series Engine Bearing Sets
MLS-R Head Gasket
Full engine gasket set
Invidia Q300 Turbo Back Exhaust System
Competition Clutch Subaru push type- 5 piece 240mm clutch + Billet Flywheel kit

Khanh’s 2017 Forester on 17×8 Rota Recce

Owner: Khanh
Car: 2017 Subaru Forester 2.5i
Wheels: 17×8 Rota Recce - Flat Black (5X100/e44/73)
Tires: 225/65/17 BFGoodrich All Terrain T/A KO2
Suspension: LP Aventure 2″ lift kit
MOds: Bumper guard: LP Aventure small bumper guard
Cargo Basket: Thule AeroBlade Cross Bars w/ Canyon Basket

lpaventure.com

Jose’s 2015 Subaru STi Limited on 18×9.5 Rota DPT

Owner: Jose
Car: 2015 Subaru wrx sti limited
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e30/73) Gold
Tires: 245 40 18 Toyo Proxies
Suspension: Teins Flex’s z

Instagram: @hood_15sti



Robert’s 2017 Outback on 17×8 Rota Recce in Flat Black

Owner: Robert
Car: 2017 Subaru Outback
Wheels: 17×8 Rota Recce - Flat Black (5X100/e44/73)
Tires: 245/65R17 BFGoodrich All Terrain T/A KO2
Suspension: Lift kit: 2″ LP Aventure
MOds: kid plate: LP Aventure Bumper Guard: LP Aventure
Accessories: Wilco Offroad Hitchgate solo & LP Aventure Jack Spacer

lpaventure.com

Bradden’s 2010 Forester XT on 18×8.5 +44 Rota G-Force

Owner: Bradden Mc
Car: 2010 Forester XT premium
Wheels: 18×8.5 Rota G-Force - Gunmetallic (5×100/E44/56.1)
Tires: 225/50
Suspension: Cusco Type A coilovers
Mods: Nvidia Catless Downpipe with an xforce Catback, DBA T2 Rotors all round with intima SR Break Pads and braided brake lines, Process west Cold are intake, Mishimoto Radiator, GFB Response BOV, GFB Gforce ii Boost Controller, Whiteline 22m Rear sway bar with whiteline Heavy Duty Endlinks, ​​STI Style Front Lip.

Currently have a Blouch TD05 18G Turbo, Process west Verticooler, DW300C Fuel pump waiting To be installed.

Tuned to 140Kw soon to be 220Kw atw

Instagram: @so_shxt