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 '%19x10_linea_veneto%' or p.products_model like '%19x10_linea_veneto%' or m.manufacturers_name like '%19x10_linea_veneto%') )

[TEP STOP]

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)

In Stock Wheels - December 19 to 25

Check out our in stock wheels this week! Availability changes daily so give us a call for updates. The wheels are listed by wheel name, size, offset, bolt pattern, hub bore and color.

Subaru Fitment

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

17×9 Rota DPT - Gold (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×8.5 Rota Grid - Hyper Black (5×100/e44/56.1)

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

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

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

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

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

GRID 18×8.5 5X114.3 e44hub 73-White

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

18×9.5 Rota Grid - Flat Gunmetallic (5×100/e38/56.1)

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

18×9.5 Rota Grid - Matte Bronze (5×100/e38/56.1)

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

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

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

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

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

18×8.5 Rota SVN - Tommy Gold(5×100/e48/56.1)

18×9.5 Rota T2R - Flat Black (5×100/e38/56.1)

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

Evo Fitment

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

17×9 Rota DPT - Titanium Chrome (5×100/114.3/e35/73)

18×10 Rota DPT - Hyper Silver (5×120x114.3/e25/72.6)

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

17×9.5 Rota Grid - Full Royal Sports Bronze(5×114.3/e30/73)

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

18×9.5 Rota Option-R - Flat Black (5×114.3/e20/73hb)

18×10 Rota T2R - Gold (5×114.3/e25/73)

18×9.5 Rota T2R - Hyper Silver (5×114.3/e20/73)

BMW Fitment

19×8.5/10 Linea Corse LC301 - Hyper Silver with Polished Lip (5×120 +30+37)

19×8.5 Linea Corse LC808(square set up) - Hyper Black with Polished Lip 5×120 +40

19×8.5/9.5 Linea Corse LC808 - Hyper Blck with Polished Lip 5×120 +40+40

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

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

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

19×9.5/11 Linea Corse LC818 - Satin Black (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/9.5 Linea Corse Lemans -Hyper Silver with Polished Lip 5×120 +40 +40

19×8.5/10 Linea Corse Lemans - Satin Black(5×120/e30F,e37R)

19×8.5/10 Linea Corse Lemans - Hyper Black(5×120/e30F,e37R)

19×8.5/10 Linea Corse Lemans - Gold(5×120/e30F,e37R)

19×8.5/10 Linea Corse Veneto - Hyper Silver (5×120/+30F+22R)

19×8.5/10 Linea Corse Veneto - Hyper Black (5×120/+30F+22R)

18×8 Rota P45F - Full Royal Sports Bronze(5×120/e38/72.6)

18×8 Rota Quake - Hyper Silver(5X120/e35/72.6)

Lexus/Nissan/Hyundai Luxury

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

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

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

19×8.5/10 Linea Corse Lemans - Hyp Silvr wPol Lip 5×114.3 +38+43

20×9.5 Rota Extreme - Titanium Chrome(5×114.3/e15/73)

18×8.5 Rota P45F - Hyper Silver(5×114.3/e25/67.1)

19×9 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

19×9/10 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

18×8 Rota Quake - Hyper Silver (5X114.3/e35/73

19×8 Rota Quake - Hyper Silver(5X114.3/e48/73)

Audi Fitment

19×8.5/9.5 Linea Corse Lemans -Hyper Silver w/Pol Lip 5×112+35

19×9.5 Linea Corse Lemans - Hyper Silver with Polished Lip 5×112 +35

Cadillac Fitment

19×8.5/10 Linea Corse LC855 - Hyper Black (6×115/e40/e47/70.3)

19×8.5/10 Linea Corse LC855 - Satin Black (6×115/e40/e47/70.3)

Porsche Fitment

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

4×100/4×114.3 Wheels

16×7 Rota Circuit 10 - Full Royal Sports Bronze(4×100/e45/67.1)

17×9.5 Rota Grid - Full Royal Sports Bronze(4×114.3/e12/73)

Just a touch of class with 19×10 Linea Corse Veneto - Hyper Silver

Owner: Zoeb
Car: 2008 BMW M3 e92
Wheels: 19×10 Linea Corse Veneto - Hyper Silver
5×120 +22 F +7 R (After 15mm spacer in the rear)
Tires: 255.35.19 / 275.35.19 Hankook Ventus V12 evo K110
Suspension: H&R Sport Springs

The Linea Corse Veneto looks right at home on the BMW M3 E92 as it gives it the touch of class! Zoeb has a large selection of wheels to run and he made the right choice of picking the Veneto’s for the time being. If you want to run a similar mild setup, call us to order the LC Veneto in 19×10 all around. The front have an offset of +22 and the rear is +7 after the spacers were put on.

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

In Stock Wheels - December 12 to December 18

Check out our in stock wheels this week! Availability changes daily so give us a call for updates. The wheels are listed by wheel name, size, offset, bolt pattern, hub bore and color.

Subaru Fitment

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

17×9 Rota DPT - Gold (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×8.5 Rota Grid - Flat Black (5×100/e44/56.1)

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

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

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

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

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

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

GRID 18×8.5 5X114.3 e44hub 73-White

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

18×9.5 Rota Grid - Flat Gunmetallic (5×100/e38/56.1)

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

18×9.5 Rota Grid - Matte Bronze (5×100/e38/56.1)

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

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

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

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

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

18×8.5 Rota SVN - Tommy Gold(5×100/e48/56.1)

18×9.5 Rota T2R - Flat Black (5×100/e38/56.1)

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

Evo Fitment

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

17×9 Rota DPT - Titanium Chrome (5×100/114.3/e35/73)

18×10 Rota DPT - Hyper Silver (5×120x114.3/e25/72.6)

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

17×9.5 Rota Grid - Full Royal Sports Bronze(5×114.3/e30/73)

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

18×9.5 Rota Option-R - Flat Black (5×114.3/e20/73hb)

18×10 Rota T2R - Gold (5×114.3/e25/73)

18×9.5 Rota T2R - Hyper Silver (5×114.3/e20/73)

BMW Fitment

19×8.5/10 Linea Corse LC301 - Hyper Silver with Polished Lip (5×120 +30+37)

19×8.5 Linea Corse LC808(square set up) - Hyper Black with Polished Lip 5×120 +40

19×8.5/9.5 Linea Corse LC808 - Hyper Blck with Polished Lip 5×120 +40+40

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

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

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

19×9.5/11 Linea Corse LC818 - Satin Black (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/9.5 Linea Corse Lemans -Hyper Silver with Polished Lip 5×120 +40 +40

19×8.5/10 Linea Corse Lemans - Satin Black(5×120/e30F,e37R)

19×8.5/10 Linea Corse Lemans - Hyper Black(5×120/e30F,e37R)

19×8.5/10 Linea Corse Lemans - Gold(5×120/e30F,e37R)

19×8.5/10 Linea Corse Veneto - Hyper Silver (5×120/+30F+22R)

19×8.5/10 Linea Corse Veneto - Hyper Black (5×120/+30F+22R)

18×8 Rota P45F - Full Royal Sports Bronze(5×120/e38/72.6)

18×8 Rota Quake - Hyper Silver(5X120/e35/72.6)

Lexus/Nissan/Hyundai Luxury

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

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

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

19×8.5/10 Linea Corse Lemans - Hyp Silvr wPol Lip 5×114.3 +38+43

20×9.5 Rota Extreme - Titanium Chrome(5×114.3/e15/73)

18×8.5 Rota P45F - Hyper Silver(5×114.3/e25/67.1)

19×9 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

19×9/10 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

18×8 Rota Quake - Hyper Silver (5X114.3/e35/73

19×8 Rota Quake - Hyper Silver(5X114.3/e48/73)

Audi Fitment

19×8.5/9.5 Linea Corse Lemans -Hyper Silver w/Pol Lip 5×112+35

19×9.5 Linea Corse Lemans - Hyper Silver with Polished Lip 5×112 +35

Cadillac Fitment

19×8.5/10 Linea Corse LC855 - Hyper Black (6×115/e40/e47/70.3)

19×8.5/10 Linea Corse LC855 - Satin Black (6×115/e40/e47/70.3)

Porsche Fitment

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

4×100/4×114.3 Wheels

16×7 Rota Circuit 10 - Full Royal Sports Bronze(4×100/e45/67.1)

17×9.5 Rota Grid - Full Royal Sports Bronze(4×114.3/e12/73)

BMW E92 on 19″ Linea Corse Veneto Wheels - Hyper Silver

Customer: James (e90post.com thread here)
Car:  2008 BMW E92 335i
Wheels: Linea Corse Veneto 19×8.5 +30 19×10 +37 - Hyper Silver
Tires: Toyo T1R 235/35/19 (front) 275/30/19 (rear)

Here’s the funny thing, James originally wanted a set of Z2S’s, but unfortunately, those are currently out of production. So he made a quick decision and went with a set of Veneto wheels. He just barely got the last set we had in stock. I think the choice is a fantastic one nonetheless! He’s very happy with the look.

Cadillac CTS-V on 19″ Linea Corse Veneto Wheels - Hyper Silver

Customer: Philip Valdez
Car: 2005 Cadillac CTS-V
Wheels: Linea Corse Veneto 19×8.5 +40, 19×10 +47 - Hyper Silver

Philip sent us some great shots of his Caddy on 19″ Venetos. These wheels are new for this car and fitment.

Alex’s CTS-V on 19″ Linea Corse Veneto Wheels - Hyper Black

Customer: Alex
Car: Cadillac CTS-V
Wheels: Linea Corse Veneto 19×8.5 +40, 19×10 +47 - Hyper Black
Tires: 245/40/19 (front), 275/35/19 (rear)

We have an exclusive folks! A CTS-V rocking the new Linea Corse Veneto fitment. Not like you’d see it anywhere else, just sayin’.

19″ Linea Corse Veneto Wheels for 04-07 Cadillac CTS-V

Linea Corse Veneto wheels now available to order in hyper black and hyper silver! As usual, we offer wheel & tire packages for all the wheels we carry.

Size: 19×8.5 (front), 19×10 (rear)
Offset: +40 (front), +47 (rear)
Bolt Pattern: 6×115
Hub bore: 70.3

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

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

Pakman’s E90 on 19″ Linea Corse Veneto Wheels - Hyper Silver

Customer: Alex Pak (e90post.com thread here)
Car: 2006 BMW 330i
Wheels: Linea Corse Veneto 19×8.5 +30, 19×10 +22 - Hyper Silver

While Pak’s out of the country in Brazil for a while, Zoeb is currently baby sitting his E90 for him. While the sun’s out during his super rainy week, we snapped some photos of it before it started raining again. Bare in mind, Pak’s running a more aggressive E46 M3 fitment instead of the usual E90 setup with a +37 offset in the rear. This looks more flush with the way he set up his car.

Zoeb’s E92 on 19″ Linea Corse Veneto Wheels - Hyper Silver

Owner: Zoeb
Car: 2007 BMW E92 335i
Wheels: Linea Corse Veneto 19×8.5 +30 / 19×10 +37 - Hyper Silver

Another edition of warehouse pics! This time with Zoeb’s E92 on Linea Corse Veneto wheels.