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 '%5x114.3%' or p.products_model like '%5x114.3%' or m.manufacturers_name like '%5x114.3%') )

[TEP STOP]

In Stock Wheels - April 2017

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

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

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

G-FORCE 17×8 e48 5X100 56.1 Flat BlackGoldHyper Black, Gunmetal

GRID 17×8 e35 5X100 73 Flat BlackGoldHyper BlackWhite

GRID 17×8 e44 5X100 73 Flat BlackGunmetalGoldHyper Black, White

Recce 17×8 e44 5×100 73 Flat Black, Gunmetal, White

STW 17×8 e44 5×100 73 Royal Gold, Royal Hyper Black

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

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

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

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

G-FORCE 17×9 e42 5X100 73 Flat BlackGoldHyper Black

GRID 17×9 e30 5X100 73 Hyper Black

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

GRID 17×9 e42 5X100 73 Flat Black, Gold, Hyper BlackWhite, Sports Bronze

GRID 17×9 e40 5×100 73 Chameleon

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

RT5 17×9 e42 5×100 73 Flat BlackGoldSpeed BronzeWhite, Hyper Black

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

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

TORQUE 17×9 e30 5X100 73 Sports Bronze

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

FORMULA 18×8 e48 5×100 56.1 Hyper Black

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

TARMAC3 18×8 e48 5X100 56.1 Hyper Black

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

Lemans 18×8.5 e44 5×100 Machined

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 Flat Black, Gunmetal, GoldHyper Black

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

GRAVEL 18×8.5 e48 5X100 56.1 Hyper Black

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

HG5 18×8.5 e44 5X100 73 GoldHyper Black

MXR 18×8.5 e44 5X100 73 Royal Gold, 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

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 73 Flat Black, GoldGunmetalHyper Black

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

SVN 18×9 e40 5×100 73 Flat Black

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

D2-EX 18×9.5 e38 5X100 73 Black w/ Yamaha Black lip

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

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

FLUSH 18×9.5 e38 5X100 73 MachinedRoyal GunmetalRoyal Hyper Black

GKR 18×9.5 e38 5X100 73 Flat BlackWhite

GRID 18×9.5 e38 5X100 73 Flat BlackHyper BlackTitanium Chrome, Speed Bronze, White

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 BlackGold, Royal Hyper Black, Royal White, Machined

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 Flat Black, Hyper Black, Hyper SilverWhite

LEMANS 18×9.5 e30 5×100 Machined

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

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

TITAN 18×9.5 e38 5X100 73 GoldHyper 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, Flat Black,  Hyper BlackHyper SilverTitanium Chrome

TITAN 18×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 Royal Gunmetal, Royal Hyper Black

GRID 17×9 e42 5X114.3 73 Chameleon, Flat BlackSports BronzeGoldHyper Black, Speed Bronze, White

MXR 17×9 e42 5×114.3 73 Hyper Black, Royal Hyper Black

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 e35 5X114.3 73 Flat Black, Hyper Black

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

TORQUE 17×9 e42 5×114.3 73 Sports Bronze

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

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

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

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

G-FORCE 18×8.5 e48 5X114.3 73 GunmetalGoldHyper Black, White

GRID 18×8.5 e44 5X114.3 73 Chameleon, Flat Black, Gold, Hyper BlackSpeed BronzeWhite

KB-F 18×8.5 e44 5×114.3 73 Flat Black, Hyper Black

MXR 18×8.5 e44 5×114.3 73 Royal Silver

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, GoldHyper BlackWhite

SVN 18×9 e30 5×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,  Hyper Black,

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

DPT 18×9.5 e44 5X100/114.3 73 Flat BlackHyper 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 ChameleonFlat BlackGoldHyper BlackSpeed BronzeTitanium ChromeWhite, Hyper Blue

HASHTAG 18×9.5 e38 5X114.3 73  Gold

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

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

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

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

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

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 Mag BlackWhite

Strike 18×9.5 e38 5×114.3 73 Flat Black, Hyper Black, Speed Bronze, Gold

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

TITAN 18×9.5 e35 5X114.3 73 Flat BlackHyper 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, Hyper Black

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

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

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

EVO Wheels Wheels

D2-EX 18×9.5 e20 5×114.3 Royal Hyper Black

GRID 18×9.5 e20 5X114.3 73 Chameleon, Flat Black, Sports Bronze, GoldHyper BlackTitanium ChromeWhite

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

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

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

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

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

BMW Wheels

Grid 17×9 e42 5×120 72.6 Hyper Black

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 White

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

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

HG5 18×9.5 e38 5X108 73 Flat Black

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

RT5 18×8.5  e38 5×108 63.4 Flat Black

Strike 18×9.5 e38 5×108 Flat Black, Hyper Black

TITAN 17×8 e40 5X108 73 Hyper Black

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

Fiesta Wheels

GRID 17×8 e40 4X108 73 Flat Black, Hyper Black

RECCE 17×8 e40 4×108 73 Flat Black, White

RT-5 18×9.5 e44 4X108 Titanium Chrome

Slipstream 16×7 e38 4×108 63.3 Flat Black

Slipstream 16×7 e40 4×108 63.4 Flat Black

TITAN 17×7.5 e40 4X108 73 Hyper Black

TITAN 17×8 e40 4X108 73 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

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

Matthew’s 2007 Subaru STi on 17×9 e42 Rota Grid in Flat Black

Owner: Matthew
Car: 2007 Subaru STi
Wheels: 17×9 Rota Grid - Flat Black (5×114.3/e42/73)
Tires: 245/40/17 Hankook Ventus V12 Evo2
Suspensions: Stock STI shocks/struts on RCE Black springs

Setup fits perfect, no rubbing (yet lol). Car looks way meaner, love this look. Really brings out the gold brembos!

Matt’s 2016 WRX on 19×8.5 Linea Corse LC818 in Hyper Silver

Owner: Matt
Car: 2016 Subaru WRX
Wheels: 19×8.5 Linea Corse LC818 - Hyper Silver (5×114.3/e30/73)
Tires: 245/35/18
Suspensions: D2 Race Coilovers and Cobb front and rear sway bars

“I enjoy ever subaru and car I have. Pushing the limits of what people say is or is not possible is always fun and something I steve to do! Not only for me but for others! This is my 16 WRX on LC 818 hyper silver 19×8.5+30 lowered 2″ all around on d2 race coilovers! The end result is amazing and I’m speechless on how amazing it looks and rides! No fender work and no rubbing enjoy.” - Matt

Rome’s 2016 STi on 18×9.5 Rota Slipstreams

Owner: Rome
Car: 2016 STi
Wheels: 18×9.5 Rota Slipstream - Black (5X114.3/e38/73)
Tires: 265/35/18
Suspensions: BC BR Coilovers

Aaron’s 2016 WRX on 18×9.5 e38 Flat Black Grids

Owner: Aaron
Car: 2016 Subaru WRX
Wheels: 18×9.5 Rota Grid - Flat Black (5×114.3/e38/73)
Tires: 240/45/18
Suspensions: stock

Matt’s 2016 WRX on 18×9.5 e38 Rota Slipstream in Magnesium Black

Owner: Matt
Car: 2016 Subaru WRX
Wheels: 18×9.5 Rota Slipstream - Magnesium Black (5X114.3/e38/73)
Tires: 240/40/18
Suspensions: D2 Race Coilovers and Cobb front and rear sway bars

Full size pic here

Paulo’s 2016 WRX Limited on 18×9.5 Rota Vector PRO in Gold

Owner: Paulo
Car: 2016 WRX Limited
Wheels: 18×9.5 Rota Vector PRO- Gold (5×114.3/e38/73)
Tires: 255/35/18 Bridgestone Potenza
2016 WRX Limited.
Mods:
RCE Yellow Springs
Bayson R bodykits
STI Exhaust & Wing
JDM Grille JDM Rear Fog

Pat’s 2015 WRX on 18×9.5 e38 Rota Grid in Gold

Owner: Pat Schwass
Car: 2015 Subaru WRX
Wheels: 18×9.5 Rota Grid - Gold (5×114.3/e38/73)
Tires: Michelin Pilots AS3 245/40/18
Suspension: ISC N1 coilovers, Rear wheel wells have to be rolled
Mods: Mishimoto J pipe
Invidia N1 catback
Cobb SF intake with air box
Second pill delete
EGR & TGV delete
Perrin shifter bushing
Perrin shifter stop
Cobb accessport tune by Bren tuning
Front lip

Tyler Miles’ 2008 ISF on 19×10 Linea Corse LC818 in Hyper Silver

Owner: Tyler Miles
Car: 2008 Lexus ISF
Wheels: 19×10 Linea Corse LC818 - Hyper Silver (5×114.3 +38 73)
Tires: Front 255/35/19 and Rear 265/35/19
Suspension: BC Racing coilovers

Gabe’s 2015 EvoX GSR on 18×9.5 e20 Deep Red Grids

Owner: Gabe
Car: 2015 EvoX GSR
Wheels: 18×9.5 Rota Grid - Deep Red (5×114.3/e20/73)
Tires: Yokohama Advans 245/40/18
Suspension: Tein Superstreet coilovers

Instagram: @gabrielgrison

click here for more pix!!!