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.5_linea_corse_lemans%' or p.products_model like '%18x9.5_linea_corse_lemans%' or m.manufacturers_name like '%18x9.5_linea_corse_lemans%') )

[TEP STOP]

@boostski EVO9 on 18×9.5 e17 Linea Corse Lemans

Owner: Chris @boostski
Car: Mitsubishi Lancer EVO 9
Wheel: 18×9.5 Linea Corse Lemans - Hyper Silver w/ Polished Lip (5×114.3/e17/73)
Tires: 235/40/18

Josh’s 02 WRX on 18×9.5 ET30 Linea Corse Lemans

Owner: Josh (@Jdroelle001on Instagram)
Car Model: 2002 Subaru WRX
Tyres: 225/40/18 Yokohama S-Drive
Suspension: ST Suspension Coilovers

Whiteline Max-C Motorsport Front Camber Plates
Group N Rear Strut Tops
Eibach Rear Camber Bolts
Whiteline Front and Rear 24mm Adjustable Swaybars
Kartboy Swaybar Endlinks
Whiteline Steering Rack Bushings
TiC Fender Cowl Braces

Engine and Drivetrian:
VF39 w/ Billet Wheel
STI Intercooler
Injector Dynamics ID1000cc injectors
DeatschWerks DW200 Fuel Pump
TurboXS 50/50 Recirc Valve
NGK Plugs
Cobb SF Intake
GTSpec UEL Header
GTSpec Catless Uppipe
Edo Performance downpipe
Espilir JGT500 JDM Catback
STi Short Shift Linkage
Kartboy Short Shifter
Kartboy Shifter Bushings
Kartboy Rear Shifter Bushing
Kartboy Rear Subframe Outrigger Bushings
Kartboy Rear Subframe Lockout Bolts
TiC Rear Diff Mount Bushings

Exterior:
Morimoto Mini H1 Retrofit Headlights
Blue Demon Eyes
JNA Performance Front Lip
JDM STi Hood Scoop
Debadged Trunk
Carbon fiber Exhaust Garnish
Yellow Foglight Films
Color Matched Sideskirts
Rear Bumper Spats
RallyArmor Mudflaps
35% Tint

Interior:
Flocked Dash
OEM Gauge Pod
OEM All Weather Floormats
WC Latheworks teardrop shift knob
JDM Red Hazard Button
Custom Factory Heated Seats
Pioneer AppRadio2
Custom Red LED Gauge Cluster

Chris’ STi on 18×9.5 +30 Linea Corse Lemans

Chris is running the aggressive Linea Corse Lemans in 18×9.5 +30 on his STi.We put on Hyper Silver with polished lip on one side and Gold with polished lip on the other. Which set-up do you like?

Owner: Chris
Car: Subaru STi
Wheels: 18×9.5 Linea Corse Lemans (5×114.3/e30) in Hyper Silver / Gold with a polished lip.
Tires: Nexen N3000 255/35/18
Suspension:BC Coilvoers, rolled rear fenders


Alan’s STi on LC Lemans 18×9.5 +30 5×114.3

Alan rocking something a little different this time around. The STi sports the aggressive Linea Corse Lemans in 18×9.5 +30. These are on sale and available in both 5×100 and 5×114.3 Check out our sale page for more information.

Owner: Alan 08 STi
Wheels: Linea Corse Lemans 18×9.5 +30 5×114.3 Hyper Silver Polished lip/ Gold with polished up.
Tires: Nexen N3000 255/35/18
Suspension: BC Coilovers with rolled fenders.

Incoming Wheels - April

These wheels are coming in this April 2014. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST or you may place the order on our website.

18×9.5 Rota Grid - Chameleon (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e20/73)

18×9.5 Rota Grid - Titanium Chrome (5×114.3/e20/73)

18×9.5 Linea Corse Lemans - Gold w/ Polish Lip (5×114.3/e30/73)

19×8.5/10 Linea Corse Dyna - Polished (5×120/e35F,e43R)

17×7.5/9 Linea Corse Fox - RSR Finish(5×130/e35/e16/73hb)

20×9/10.5 Linea Corse LC818 - Hyper Silver (5×120 +35+45/72.6)

20×9/10.5 Linea Corse LC818 - Satin Black (5×120 +35+45/72.6)

Incoming Wheels - March 2014

These wheels are coming in this March 2014. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST or you may place the order on our website.

ROTA WHEELS

17×9 Rota DPT - Flat Black (5×100/114.3/e42/73)

17×9 Rota DPT - Hyper Black (5×100/114.3/e42/73)

17×9 Rota DPT - Sports Bronze (5×100/114.3/e42/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e22/73)

18×9.5 Rota DPT - Speed Bronze (5×100x114.3/e22/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e35/73)

18×9.5 Rota DPT - Gold (5×100x114.3/e35/73)

18×9.5 Rota DPT - Speed Bronze (5×100x114.3/e35/73)

18×8.5 Rota Grid - Flat Black (5×100/e44/73)

18×8.5 Rota Grid - Hyper Black (5×100/e44/73)

18×8.5 Rota Grid - Speed Bronze (5×100/e44/73)

18×8.5 Rota Grid - White (5×100/e44/73)

18×9.5 Rota Grid - Chameleon (5×100/e38/73)

18×9.5 Rota Grid - Gold (5×100/e38/73)

18×9.5 Rota Grid - Hyper Black (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×100/e38/73)

18×9.5 Rota Grid - Flat Black (5×114.3/e20/73)

18×9.5 Rota Grid - Hyper Black (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e20/73)

18×9.5 Rota Grid - White (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e38/73)

LINEA CORSE WHEELS

18×9.5 Linea Corse Lemans - Hyper Silver with Polished Lip (5×100/e30/73)

RUNDFAHREN WHEELS

19×8.5/10 Rundfahren RM101 - Machined (5×114 +30+38)

19×8.5/10 Rundfahren RM101 - Machined (5×120 +30+37)

Incoming Wheels - February 2014

These wheels are coming in this February 2014. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST or you may place the order on our website.

ROTA WHEELS

17×8 Rota DPT - Flat Black (5×100/114.3/e48/73)

17×8 Rota DPT - Hyper Black (5×100/114.3/e48/73)

17×9 Rota DPT - Hyper Black (5×100/114.3/e35/73)

17×9 Rota DPT - Flat Black (5×100/114.3/e42/73)

17×9 Rota DPT - Hyper Black (5×100/114.3/e42/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e22/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e35/73)

18×9.5 Rota DPT - Gold (5×100x114.3/e44/73)

18×8.5 Rota Grid - Flat Black (5×100/e44/73)

18×8.5 Rota Grid - Hyper Black (5×100/e44/73)

18×8.5 Rota Grid - Speed Bronze (5×100/e44/73)

18×8.5 Rota Grid - White (5×100/e44/73)

18×8.5 Rota Grid - Flat Black (5×114.3/e44/73)

18×8.5 Rota Grid - Hyper Black (5×114.3/e44/73)

18×8.5 Rota Grid - Speed Bronze (5×114.3/e44/73)

18×8.5 Rota Grid - White (5×114.3/e44/73)

18×9.5 Rota Grid - Deep Red (5×100/e38/73)

18×9.5 Rota Grid - Flat Black (5×100/e38/73)

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

18×9.5 Rota Grid - Hyper Black (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×100/e38/73)

18×9.5 Rota Grid - Titanium Chrome (5×100/e38/73)

18×9.5 Rota Grid - White (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e38/73)

18×9.5 Rota Grid - White (5×114.3/e38/73)

18×9.5 Rota Grid - Flat Black (5×114.3/e20/73)

18×9.5 Rota Grid - Hyper Black (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e20/73)

18×9.5 Rota RT5 - Flat Black (5×100/e38/73)

18×9.5 Rota RT5 - Hyper Black (5×100/e38/73)

18×10 Rota RT5 - Flat Black (5×100/e30/73)

18×10 Rota RT5 - Hyper Blue (5×100/e30/73)

18×10 Rota RT5 - Titanium Chrome (5×100/e30/73)

18×10 Rota RT5 - White (5×100/e30/73)

18×10 Rota RT5 - Hyper Black (5×114.3/e30/73)

18×10 Rota RT5 - Titanium Chrome (5×114.3/e30/73)

LINEA CORSE WHEELS

19×8.5/10 Linea Corse Dyna - Polished (5×114.3/e30F,e38R/73)

19×8.5/10 Linea Corse Dyna - Polished (5×120/e30F,e37R)

17×7.5/9 Linea Corse Fox - Satin Black w/Satin Silver Lip (5×130/e35/e16)

17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip (5×130/e35/e16)

19×8.5/10 Linea Corse LC818 - Hyper Silver (5×114 +30+38)

19×8.5/10 Linea Corse LC818 - Hyper Silver (5×120 +30+37/72.6)

19×8.5/10 Linea Corse LC818 - Satin Black (5×120 +30+37)

19×9.5/11 Linea Corse LC818 - Satin Black (5×120 +25+25 72.6)

18×9.5 Linea Corse Lemans - Silver w/ Polished Li (5×100/e30/73)

18×9.5 Linea Corse Lemans - Hyper Silver w/ Pol (5×114.3/e17/73)

19×8.5/9.5 Linea Corse Veneto - Hyper Silver (6×115/+40F+47R)

RUNDFAHREN WHEELS

18×9 Rundfahren RM110 - Machined(5×112/e40/73)

18×9.5 Rundfahren RM110 - Machined(5×100/e38/73)

18×9 Rundfahren RM200 - Machined(5×112/e40/73)

18×9.5 Rundfahren RM200 - Machined(5×112/e35/73)

18×9.5 Rundfahren RM200 - Machined(5×100/e38/73)

Throwback Thursday - Brewer’s Clean WRX on 18×9.5 Lemans

Owner: Brewer
Car: 2004 Subaru Impreza WRX
Wheels: 18×9.5 Linea Corse Lemans - Silver w/ Polished Lip (5×100/e30/73)
Tires: 225/40/18
Suspension: Stance GR+ coilovers(-2 camber all around)

Let’s take a moment to recognize one of the cleanest Subaru GD’s that graced the pages of wheeldude.com ever. The Hyper Silver Linea Corse Lemans look absolutely perfect on this black car, which is one of the reasons why these wheels stayed on Brewer’s car for a long time.

Marvin’s WRX on 18×9.5 +38 Flat Black RT5’s

Owner: Marvin
Car: 2007 Subaru Impreza WRX
Wheels: 18×9.5 Rota RT5 - Flat Black (5×100/e38/73)
Tires: 265/35/18
Suspension: Daiyama Coilovers

We’re loving Marvin’s new meaty set-up. He used to run 18×9.5 +30 Linea Corse Lemans with 225/40/18 tires but now he’s back with a more functional set-up.  The higher offset RT5’s allowed him to run 265/35/18 tires under the WRX fenders with a front roll and a rear pull. Check out the pictures of Marvin’s WRX from his latest trip out to the track!

Photo Credits: Nikko Martinez

Incoming Wheels - July

These wheels are coming in this July 2013. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST.

Subaru Fitment

18×9.5 Rota DPT - Gold (5×100x114.3/e44/73)

18×8.5 Rota Grid - Flat Black (5×114.3/e44/73)

18×8.5 Rota Grid - Hyper Black (5×114.3/e44/73)

18×9.5 Rota Grid - Chameleon (5×100/e38/73)

18×9.5 Rota Grid - Hyper Black (5×100/e38/73)

18×9.5 Rota Grid - Chameleon (5×114.3/e38/73)

18×9.5 Rota Grid - Flat Black (5×114.3/e38/73)

18×9.5 Rota Grid - White (5×114.3/e38/73)

18×8.5 Rota RT5 - Hyper Black (5×100/e44/73)

18×9.5 Rota RT5 - Hyper Black (5×100/e44/73)

18×9.5 Linea Corse Lemans - Silver w/ Polished Li (5×100/e30/73)

18×9.5 Linea Corse Lemans - Gold w/ Polish Lip (5×114.3/e30/73)

18×9.5 Linea Corse Lemans - Hyper Silver w/ Pol (5×114.3/e30/73)

18×10 Rota SVN-R - Titanium Chrome (5×100/114.3/e30/73)

18×9.5 Rota Torque - Titanium Chrome (5×100/e35/73)

FRS/BRZ Staggered Set-Up

18×8.5/9.5 Rota RT5 - Hyper Black (5×100/e44F/e44R/73)

Evo Fitment

18×9.5 Rota Grid - Chameleon (5×114.3/e20/73)