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 '%19x9.5/11_linea_corse_lc818%' or p.products_model like '%19x9.5/11_linea_corse_lc818%' or m.manufacturers_name like '%19x9.5/11_linea_corse_lc818%') )

[TEP STOP]

Incoming Wheels - October

These wheels are coming in this October 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×8.5 Rota Grid - Speed Bronze (5×114.3/e44/73)

18×8.5 Rota Grid - White (5×114.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×9.5 Rota Grid - Chameleon (5×114.3/e20/73)

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

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

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

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

18×9.5 Rota Grid - White (5×114.3/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 - Flat Black (5×114.3/e38/73)

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

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

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+22/72.6)

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×114 +30+38)

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


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 - Zoeb’s M3 on 19×9.5/11 Hyper Silver LC818

Owner: Zoeb
Car: 2008 BMW M3 E92
Wheels: 19×9.5/11 Linea Corse LC818 - Hyper Silver (5×120 +25+25/72.6)
Tires: 255/35/19 (front), 295/30/19 (rear)

Exactly two years ago, 247media.org did a small photoshoot for Zoeb’s E92 M3 running the Hyper Silver LC818’s. These wheels are on top of the list if you ask us the best looking wheels for an M3.

Linea Corse Wheels In Stock for BMW

Here’s what we currently have in stock for your BMW’s as of April 1. The wheels are listed by size, wheel name, color, bolt pattern, offset and hub bore.

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

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

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

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

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

19×8.5/10 Linea Corse LC855 - Hyper Silver (5×120/e30/e37/72.6)

19×8.5/10 Linea Corse LC855 - Satin Black (5×120/e30/e22/72.6)

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

19×9/10.5 Linea Corse LC888 - Polished (5×120 +25+25/73)

19×8.5/10 Linea Corse Lemans - Hyper Silver Pol Lip 5×120 +15+15

Incoming Wheels - February 2013

These wheels are coming in this February 2013. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.651.2956 M-F 10am-5pm PST.

Subaru

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/e42/73)

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

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

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

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

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

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

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

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

18×9.5 Rota Grid - Full Royal Sports Bronze (5×114.3/e38/73)

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

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

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

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

18×10 Rota SVN - Flat Black (5×100/114.3/E30/73)

18×10 Rota SVN - Hyper Silver (5×100/114.3/E30/73)

18×10 Rota SVN - Gold (5×100/114.3/e30/73)

Evo

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

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

18×9.5 Rota Grid - Full Royal Sports Bronze (5×114.3/e20/73)

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

BMW

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

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

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

Nick’s e92 M3 on 19×9.5/11 Linea Corse LC818 in Hyper Silver

Owner: Nick
Car: 2008 BMW M3
Wheels: 19×9.5/11 Linea Corse LC818 - Hyper Silver (5×120 +25+25/72.6)
Tires: 245/35/19 & 275/35/19 Hankook V12 Ventus

These are updated photos of Nick’s e92 M3 on 19×9.5/11 LC818s. He’s running the 245/35/19 & 275/35/19 Hankook V12 Ventus tires along with the H&R Sport Lowering Springs which gives him the right amount of drop. :)

wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery

Incoming Wheels - December

These wheels are coming in this December. We will be updating this page again so don’t forget to check back! We are now accepting pre-orders for these wheels. Give us a call at the shop at 510.651.2956 M-F 10am-5pm PST or click on the photo of the wheel to pre-order.

Subaru

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

Subaru BRZ/Scion FRS/Toyota 86 Staggered Set Up

18×8.5/9.5 Linea Corse Lemans - H. Silver PLip(5×100/e40/40/73)

BMW

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

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

Lexus/Nissan/Hyundai Luxury

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

Jonathan’s E92 M3 on Satin Black 19×9.5/19×11 LC818’s

Owner: Jonathan Orens
Car: 2008 BMW E92 M3
Wheels: 19×9.5/11 Linea Corse LC818 - Satin Black (5×120 +25+25 72.6)
Tires: 245/35/19 Front; 275/35/19 Rear

Our customer all the way from France sent us a couple of pictures of his E92 M3 at a local BMW meet. Jonathan is running the Satin Black 19×9.5/19×11 Linea Corse LC818’s on his M3. If you notice, Jonathan had the lips painted white to make it a little bit different. What do you think?

Throwback Thursday - Zoeb’s 350Z on Hyper Silver LC818’s

Owner: Zoeb
Car: 2004 Nissan 350z
Wheels: 19×9.5/11 Linea Corse LC818 - Hyper Silver (5×114.3 +15+20/73)
Tires: 245.35.19 front and 275.35.19 rear
Suspension: Megan Coilovers

This shoot was done not too long ago but the pictures are just too sick not to share again. On this shoot, Zoeb was running the Hyper Silver LC818’s in the widest set up that we have. Just in case you were wondering, these massive wheels only weigh in at 25.8lbs for the front and 26.4lbs for the rear, just 1lb heavier than the OEM 18″ wheels. Now that is a compromise any performance junkie is willing to take.

The 19×9.5/19×11 Linea Corse LC818 +15/+20 is also available in Satin Black. :)


We would like to thank 247media.org for the awesome pictures.

Big Blue E92 Monster on 19×9.5/11 Linea Corse LC818

Owner: Shafique
Car: 2008 BMW M3 E92
Wheels: 19×9.5/11 Linea Corse LC818 - Satin Black (5×120 +25+25 72.6)
Tires: 255/35/19 & 305/30/19
Suspension: H&R Sport Springs

Blue car with Black wheels go very well together thus creating a nice aggressive look as seen here! We can see why lots of people love the wheels, just look at the rear concave!

wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery