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]

In Stock Wheels - November 2017

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

Linea Corse z2s - 19×8.5/9.5 (5×120/+30/+35) Hyper Black

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

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

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

$15 for a set of wheels!! really!

here is a link to our instagram post:

***HUGE CONTEST** We are doing a contest for all the Wheeldude IG followers! We are raffling off a set of Rota wheels. We will have a 5×100 and a 5×114 and 5×108 rs and st fitment for the winner to pick from. Raffle tickets cost $15 and is limited to two tickets per customer. We have a limited number of tickets set to 75! Payment needs to be sent via PayPal to sales@wheeldude.com please put a not with you first and last name along with email and phone number! We have ticket numbers for both you and us! On Sunday 11/13/17 we will be on IG live to pull the winning ticket! Ticket will be in a box and one ticket will be pulled. After the live drawing a picture of the winning ticket will be posted. To enter please send payment as friends and family so no fee is given. Please give us time to send you an email with you ticket and number! If we don’t get the 75 tickets we will extend the raffle for another 2 days. At that point if we don’t sell the 75 needed tickets we will refund all PayPal payments to customers! We have the following wheels .winner can pick from!
Rota Grid 17×9+42 5×100 Gold

Rota KB-R 18×9.5+38 5×108 hyper black

Rota Roku 18×8.5+44 5×100 hyper black

Rota strike 18×9.5+38 5×100 flat black

Rich’s 2010 Subaru WRX on 18×8.5 Rota Grid - Custom Color

Owner: Rich (IG: @Flodwrx)

Car: 2010 Subaru WRX
Wheels: Rota Grid 18×8.5 5×100 - Custom color
Tires: Hankook Ventus V12 Evo 2 245/40/18
Suspensions: ISC Suspension Coilovers

Robin’s 2017 Subaru BRZ on 18×8.5 Rota Grid - White

Owner: Robin
Car: 2017 Subaru BRZ
Wheels: 18×8.5 Rota Grid 5×100 e44 - White
Tires: 245/35/18 Michelin pilot super sport
Suspensions: Stock

I asked Robin how he liked his setup, he said, “Pretty good setup, no rubbing on stock suspension, no more tail happy brz but takes the corners like a champ with these new tires. Review has been left, I appreciate the fast response man.”

Appreciate the response and review Robin! enjoy your wheels. looks awesome!

End of Month Sale - September - $750 shipped

Hi Guys we have been blessed w/ some awesome pricing on a few wheels, we are passing the savings over. Here they are:

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

more pix @ https://dudesphotography.smugmug.com/Wheels/18×85-Rota-Roku-Flat-Black/

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


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


SS10 18×8.5 e44 5X114.3 73 White

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

Strike 18×9.5 e38 5×114.3 73 Hyper Black

Wheels listed above are $750 shipped to you ’til the end of the month.

Please contact us at sales@wheeldude.com or via text at (510) 969-9529.

***Sales expires end of the month.

New wheels soon!

- Wheeldude Team!

Current available 17×8 5×100 wheels

current available 17×8 5×100 wheels:

G-FORCE 1780 48 5X100 56.1 Flat black, gunmetal, gold and hyper black
GRID 1780 44 5X100 73 Flatblack, gunmetal, gold, hyper black.
RECCE 1780 44 5X100 73 Flatblack, gunmetal, gunmetal gray, white
STW 1780 44 5X100 73 Gold w/ polished lip
TITAN 1780 45 5X100 73 Flatblack, hyper black, white
TORQUE 1780 48 5X100 56.1 Flatblack, gunmetal, hyperblack, steelgray, white

above setup is good for BRZ, FRS, legacy, wrx, 2004 STi, XV, foresters and much more basically 5×100 subaru that’s 2002+

Dan’s 2011 WRX on 18×9.5 e38 Titanium Chrome Grids

Owner: Dan
Car: 2011 Subaru WRX
Wheels: 18×9.5 Rota Grid - Titanium Chrome (5×100/e38/73)
Tires: SUMITOMO HTR Z III 265/35R18
Suspensions: Whiteline Rear Sway Bar 24mm Adjustable With control arm Links
Whiteline Front Sway Bar 22mm Adjustable
Kartboy Front Endlinks
Kartboy Rear Endlinks
BC Racing BR Series Coilovers with rear Extenders

for more picture click here

Year:​ 2011
Make:​ Subaru
Model:​ Impreza
Sub Model:​ WRX Sedan
Color: ​Obsidian Black Pearl
Engine:​ EJ255 2.5L intercooled turbo, DOHC, 16 valve, H4 cylinder
Power:​ 307WHP / 334FT/LBS TQ Uncorrected
Tuner: ​Cleo (IAG Performance)
New items for May before Boxerfest 2017:
● Perrin Turbo Inlet Hose
● GrimmSpeed Cold Air Intake
● Aeromotive Black A1000-6 FPR Fuel Pressure Regulator
● Fragola 0-100 PSI Fuel Pressure Gauge
● IAG V2 Top Feed Fuel Rails
● IAG Braided Fuel Line & Fitting Kit with Flex Fuel Adapters
● IAG Silver CNC Top Feed TGV Deletes
● Blouch 440XT Turbocharger with HPD Turbine and 10cm^2 Housing
● COBB Tuning Flex Fuel Package with Fuel Pressure Sensor
● AEM 320LPH E85 Ethanol Fuel Pump
● Omni Power 4 Bar Map Sensor
● Delete Secondary Air Pump and install IAG block off plates
● IAG Comp to Street AOS Conversion Kit
● Cobb AP V2 to V3 Upgrade

Exterior:
● SPT Carbon Fiber Trunk Trim
● Rally Armor Red/Black Mud Flaps
● Bayson*R CS Replica Front Lip
● Perrin Shorty Antenna
● 30% Window Tint all around
● Stock Halogen Headlamps
● Stock Fog Lights

Interior:
● SMY Clustermaker Gauge Pod
● Solid Modifications 52mm Vent Pod
● Prosport Amber White Needle 52mm Boost Gauge
● Prosport Amber White Needle 52mm Oil Pressure Gauge
● AEM UEGO Digital Wideband 52mm Air/Fuel Ratio Gauge
● Proto Tuning Tool Holder
● Cobb Red 5 Speed Subaru Shift Knob
● STI Short Throw Shifter

Suspension/Wheels:
● Whiteline Rear Sway Bar 24mm Adjustable With control arm Links
● Whiteline Front Sway Bar 22mm Adjustable
● Kartboy Front Endlinks
● Kartboy Rear Endlinks
● BC Racing BR Series Coilovers with rear Extenders
● ROTA Grid 18×9.5” +38 Wheels Titanium Chrome
● SUMITOMO HTR Z III 265/35R18 Tires
● DBA T2 Street Slotted Rotors
● Hawk HPS Ceramic Pads
● Deburred and G2 Painted Calipers Gloss Black

Engine/Power:
● Nameless Performance Muffler Delete Axleback Double Walled Tips
● Stock Midpipe
● Cobb SS 3” Downpipe
● Cobb AccessPort V2 (Will Be trading in to V3)
● Cobb SF Intake and Airbox
● Cobb Turbo Heat Shield
● IAG EWG Kit
● IAG SS Uppipe
● Prosport UEL Headers
● TiAL MVS 38mm External Wastegate
● Grimmspeed Top Mount Intercooler with shroud
● Grimmspeed Electronic Boost Control Solenoid
● IAG Air Oil Separator
● Injector Dynamics 1000CC Injectors
● Walbro 255lph Fuel Pump
● Perrin Turbo Inlet for 2.5” Turbo
● Stock Block
● Stock Turbo - VF52

shout out to the photographers for the pictures which include @timothy.yiu, @logan_photography_, EP’s Photos, @crazyKonceptz, @subarusense and @european.whips.

Also I’d like to thank IAG Performance, GrimmSpeed, and F.A.S.T. of West Chester for help with the build.

Chris’ 2013 FR-S on 18×8.5/9.5 e44 Rota RT5 in Hyper Silver

Owner: Chris Scott Clark
Car: 2013 Scion FR-S
Wheels: 18×8.5/9.5 Rota RT5 - Hyper Silver (5×100/e44F/e44R/73)
Tires: 225/40r18 & 255/35r18
Suspensions: Fortune Auto Coilovers w/ Radial bearings & Whiteline Endlinks

Josh’s 2013 STi on Rota DPT 18×9.5 e44

Owner: Josh
Car: 2013 Subaru STi
Wheels: 18×9.5 Rota DPT - Flat Black (5×100x114.3/e44/73)
Tires: 265/35/18 Sumitomo htr ziii
Suspensions: Stock

Cobb sf intake invidia catted downpipe. Nameless performance catback muffler delete. Pro tuned by Corbin Johnson

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