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 '%18x9_rota_g-force%' or p.products_model like '%18x9_rota_g-force%' or m.manufacturers_name like '%18x9_rota_g-force%') )

[TEP STOP]

In Stock Wheels - April 2018

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

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

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 Sports BronzeHyper 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

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

P45R 17×9 e35 5×100 73 Flat Black

RT5 17×9 e42 5×100 73 White

SS10 17×9 e42 5X100 73 White

TITAN 17×9 e42 5X100 73 Flat BlackHyper BlackWhite

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

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

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 BlackHyper BlackSpeed BronzeWhite

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

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

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 Flat BlackWhiteHyper Black, Sports Bronze

GRID 17×9 e42 5X114.3 73 ChameleonFlat BlackGoldSpeed 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

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 BlackGoldHyper BlackSpeed Bronze

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

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

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

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

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

GARAGISTE 19×9 e34 5X114.3 43 Flat Black, Hyper 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 Flat BlackGoldHyper 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)

Mitch’s WRX on 18×9 e35 Gunmetal G-Force

Owner: Mitch
Car: Subaru Impreza WRX
Wheels: 18×9 Rota G-Force - Gunmetal(5×100/e35/73)
Tires: 255/35R18
Suspension: Tein Street Flex Coils, Rear Fenders Rolled

Ernesto’s EVO on 18×9 e30 Rota G-Force in Hyper Black

Owner: Ernesto
Car: Mitsubishi Lancer EVO
Wheels: 18×9 Rota G-Force - Hyper Black (5×114.3/E30/73)
Tires: 255/35/18

Tom’s Bugeye on 18×9 Rota G-Force in Gold

Owner: Tom
Car: Subaru Bugeye Wagon
Wheels: 18×9 Rota G-Force - (5×100/E35/73) in Powdercoated Candy Gold
Tires: 245/40r18 Nitto Nt05
Suspension: Whiteline front & rear Sway Bars & Strut Braces, Raceland Ultimo Coilovers
Mods:Fully built 2.0l with forged internals, bc272 cams, ARP headstuds and a JDM v7 STI Spec C long runner Intake Manifold, JDM v7 STI Spec C powersteering cooler; JDM v7 STI type RA 6 speed swap, Brembo Gran Turismo Brakes with cross drilled rotors all around; Full JDM v7 STI front end, JDM v7 STI Spec C roof vent, full JDM STI Wagon interior.

“I bought this wagon as a fully stripped shell a year and a half ago. I just went to town building my dream subie!”

Instagram: @stiwgn

Jestin’s 2011 WRX on 18×9 Rota G-Force in Gunmetal

Owner: Jestin
Car: 2011 Subaru WRX
Wheels: 18×9 Rota G-Force - Gunmetal(5×100/e35/73)
Tires: Michelin Pilot Sport 4S 245/40R18
Suspensions: Stock

Jesse’s 1998 Mitsubishi Evolution on 18×9 e25 Rota G-Force

Owner: Jesse Morgan
Car: 1998 Mitsubishi Lancer Evolution
Wheels: Rota G-Force 18×9 +25
Tires: 245/40-18 Dunlop Dizzera ZII
Suspension: BC coilovers
Fender liners removed in front, rear arches shaved 3mm

Rob’s 2017 Subaru Forester XT on 18×9.5 Hyper Black Grids

Rob got the car two days ago and the Grids are already on!!

Owner: Rob Silverman
Car: 2017 Subaru Forester XT Premium
Wheels: 18×9.5 Rota Grid - Hyper Black (5×100/e38/73)
Tires: 255/45/18 Bf Goodrich G-Force Comp-2 a/s
Suspension: currently on stock, Feal Coil wil be on shortly.

Aaron Barnes’ 2014 Focus ST on 18×9 e35 Rota G-Force in Gunmetal

Owner: Aaron Barnes
Car: 2014 Ford Focus ST
Wheels: 18×9 e35 Rota G-Force in Gunmetal
Tires: 245/40/18 Michelin PSS
Suspension: Bilstein B14 coilovers
JBR Tru Torsion 1.25 RSB w/Billet brackets
Steeda adjustable endlinks
SPC rear camber arms

Performance:
Greddy SP catback
Mountune quick shift arm
Boosted design shifter/transmission bushings
NTC shifter cable bushing
Depo racing “THE BEAST” FMIC
CPE EXHALE TIAL Q
CPE hot side charge pipe
Levels performance catless downpipe
Cobb accessport V3
CFM valve cover breather
Damond motorsports stage 1 OCC
Damond Motorsports stage 2 OCC (to be installed)
Cobb CAI
Deadhook Motorsports 93 octane protune.

Appearance:
Maxton Design splitter in Ford Rally black
Maxton Design side splitters Ford Rally black
Innovative fabworx wing risers
professionally painted tails
Boosted design dead pedal
Diode Dynamics Luxeon LED (to be installed)Projector fog lights

Ryan’s 2013 WRX on 18×9 e35 Rota G-Force

Owner: Ryan Brown
Car: 2013 Subaru WRX
Wheel: Rota G-Force 18×9 (5×100/e35/73) in White
Tires: 245/40/18 Potenza RE760 Sport
Additional Mods: Turbo-Back/Short Shift

Ramsey’s 2015 Ford Focus ST on 18×9 Rota G-Force in Gunmetal

Wheels: 18×9 Rota G-force 5×108 e35 - Gunmetal
Tires: (stock) 235/40/18

some parking lot shots… photoshoot to follow :)

Rest of the photoshoot, click here.