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]

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

In Stock Wheels - May 2017

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

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

Jordan’s 05 Outback XT on 18×8.5 e48 Rota SVN

Owner: Jordan
Car: 2005 Outback XT
Wheels: 18×8.5 Rota SVN - Sports Bronze(5×100/e48/56.1)
Tires: 235/40 Hankook Ventus V12 Evo2
Suspensions: Bc Br coilovers
Kartboy endlinks
Megan Racing rear toe arms
Whiteline anti-lift kit
Whiteline roll center adjustment kit
Whiteline rear camber adjustment bushings
Whiteline control arm bushings.

Incoming Wheels in May 2017

Incoming Wheels
ETA: 1st week of May
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

19×8.5/9.5 Linea Corse z2s - Hyper Silver (5×120/+30/+35)
19×8.5/9.5 Linea Corse z2s - Hyper Black (5×120/+15/+20)
18×8.5 Rota D154 - White (5×100/e44)

@thestig719 2004 Subaru WRX on 18×9.5 e35 Rota DPT

Owner: @thestig719
Car: 2004 Subaru WRX
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e35/73) custom finish
Tires: 235/40/18
Suspension: BC Coilovers

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.