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

[TEP STOP]

Hitting the potholes ain’t no problem for Paolo and his 18×9.5+30 Linea Corse Lemans

Owner: Paolo of Wheeldude.com, wait he works for us?
Car: 2009 Subaru Impreza
Wheels: 18×9.5 Linea Corse Lemans - Silver w/ Polished Lip (5×100/e30/73) (After 5mm spacers all around, he’s running +25 at all four corners)
Suspension: BC Racing BR Coilovers
Tires: 225/40/18 Bridgestone RE001

If you have been to the Philippines, you know the roads there can’t even be considered decent when compared to roads in the states. Paolo has told us, he dodges potholes on the roads like he would dodge bullets from a gun. It would typically be a 30 minute drive to work in a stock height vehicle for Paolo, but instead he takes an hour as he has to drive very carefully, while still hitting a majority of the pot holes. The pot holes in the PI are so harsh that they could make a female’s heavy chest hurt according to Paolo’s observance.

So we leave you with a question, can Linea Corse and Rota wheels take more pain than a female and her best assets?
We think so ;) But hey, you can go test that out yourself, haha. Please feel free to write to us as we’d like to post some future reviews on our site. (Please send all reviews to vdmtom@wheeldude.com)





Pakman’s Car Found On Popular BMW Enthusiasts’ YouTube Video

While Zoeb was looking for the latest spoofs of Rebecca Black’s “Friday” over the weekend, he stumbled upon random montages of various modified BMWs on YouTube. However, in one of the videos, he noticed our bud, Alex Pak’s E90 330i, was featured in it. Pakman’s car is internet famous. It’s got 36k hits on it since being posted in September of 2009.

Here’s the referenced photo shoot.

Pontiac G8 on 19″ Linea Corse L22 Wheels - Satin Black

Customer: Grant
Car: Pontiac G8
Setup: Linea Corse L22 19×8.5 +30 19×10 +37 - Satin Black

Once lowered, this G8 is stuntin’ hard on L22’s. Oh yea, BMW fitments work just perfectly with these cars.

BMW E46 on 19″ Linea Corse L22 Wheels - Hyper Silver w/ Polished Lip

Customer: Levelle
Car: BMW E46 328Ci
Wheels: Linea Corse L22 19×8.5 +30 19×10 +37 - Hyper Silver w/ Polished Lip

Mildly aggressive fitment for E46’s, which is a piece of cake and nothing a slight fender roll can’t fix. Looks awesome on any E46.

Wheeldude.com Cyber Monday Sale Preview

CLICK HERE TO VIEW CYBER MONDAY WHEELS

Prices effective MONDAY, NOVEMBER 30th, from 12:00AM to 11:59PM Pacific Standard Time

See, we didn’t mess around with Black Friday sales this year. We decided to do something different and offer a CYBER MONDAY SALE. The prices that will be posted when the clock strikes midnight. The prices are only good for just one set of wheels. Once each set is gone, they’re gone at that price. PRICES ONLY VALID THROUGH OUR WEBSITE. You can still call us for questions, but all Cyber Monday sale purchases must be made on this website. First come, first served! In case you’re wondering, no dibs. If dibs don’t work on the forum classifieds, it shouldn’t work at Wheeldude either. :P Now, let’s get to the list of wheels that will be marked down on Monday, shall we? In the meantime, the Wheeldude team wishes you a HAPPY THANKSGIVING and everyone be safe out there!

ROTA WHEELS
DPT 17×9 5X100/114.3 +42 73hb - Matte Steel Grey (AGGRESSIVE Subaru fitment)
DPT 18×8.5 5×100/114.3 +48 73hb - Royal Gold (Subaru fitment)
DPT 18×9.5 5X100/114.3 +22 73hb - White (350Z, G35 coupe, Genesis coupe, Evo X fitment)
DPT 18×9.5 5X100/114.3 +35 73hb - Matte Bronze (Evo fitment)
DPT 18×9.5 5X100/114.3 +44 73hb - Hyper Silver (AGGRESSIVE Subaru fitment)
DPT 18×9 5X100/114.3 +44 73hb - Matte Bronze (AGGRESSIVE Subaru fitment)
GFORCE 18×8.5 5X100 +48 56.1hb - Hyper Black (Subaru fitment)
GFORCE 18×8.5 5X114.3 +48 73hb - Hyper Black (2005 and up Subaru STi fitment)
GFORCE 18×8.5 5×114.3 +48 56.1hb - Gunmetallic (2005 and up Subaru STi fitment)
GRID 18×8.5 5X100 +44 56.1hb - Matte Steel Grey (Subaru fitment)
GRID 18×9.5 5X114.3 +20 73hb - Royal Steel Grey (350Z, G35 coupe, Genesis coupe, Evo X fitment)
SVN 18×9 5X114.3 +20 73hb - Full Royal Sports Bronze (350Z, G35 coupe, Genesis coupe, Evo X fitment)
TORQUE 18×9.5 5X114.3 +20 73.1hb - Full Royal Sports Bronze (350Z, G35 coupe, Genesis coupe, Evo X fitment)

LINEA CORSE WHEELS
L22 19×8.5 5×120 +30 / 19×10 +37 72.6hb Hyper Silver w/ Polished Lip (BMW E90 fitment)
Lemans 19×8.5 5×120 +30 / 19×10 +22 72.6hb Hyper Black (BMW M3 fitment)
Lemans 19×8.5 5×120 +30 / 19×10 +37 72.6hb Hyper Black (BMW E90 fitment)
PFS 5×120 19×8.5 5×120 +30 / 19×10 +37 72.6hb Hyper Silver w/ Polished Lip (BMW E90 fitment)

Davon’s M3 on 19″ Linea Corse Lemans & L22 Wheels - Hyper Silver w/ Polished Lip

Owner: Dan Avon a.k.a. Davon
Car: 2005 BMW E46 M3

Dan’s M3 is modeling a couple sets of wheels in this post. Both in hyper silver w/ a polished lip.

Wheels: Linea Corse Lemans 19×8.5 +30 / 19×10 +22 - Hyper Silver w/ Polished Lip

Wheels: Linea Corse L22 19×8.5 +30 / 19×10 +22 - Hyper Silver w/ Polished Lip

BMW e90/e91/e92/e93 Featured Wheels

If flash above is not working, click here for BMW e90 gallery.


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


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


* BMW E9X Wheel & Tire Package 19″ Linea Corse L22 - Hyper Black


* BMW E9X Wheel & Tire Pkg 19″ Linea Corse L22 - Hyp Sil PLip


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


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)

More wheels for BMW E9X’s after the cut!

Read more…

BMW e90 on Linea Corse L22 - Staggered 19″ setup

Customer: Jon (a.k.a. JonSpec on e90post.com)
Car: BMW 335i sedan
Wheels: Linea Corse L22 19×8.5 +30 (F), 19×10 +37 (R) – Hyper Silver w/ Polished Lip
Additional Stuff: 5mm spacer (front), 15mm spacer (rear) – overall actual offset is +25 (front), +22 (rear)
Tires: Nitto Invo 235/35/19 (front), 275/30/19 (rear)

Wheel Details - L22

Jon’s E90 335i Sedan On 19″ Linea Corse L22 & Lemans Wheels - Hyper Silver w/ Polished Lip

On Tuesday (yesterday) morning, the Dude woke up bright n’ early at the crack of dawn to haul his butt to San Francisco with a friend to take some dope photos of everyone’s favorite Bay Area landmark with some real nice cars. You know, that bridge that got destroyed in the 3rd X-Men movie by Magneto, but I digress. He drove safely in Hes’ I(HES)250 along with Jon in his alpine white 335i sedan. This is part 1 of this photo shoot, so we’re featuring Jon’s car first! He’s rollin’ on a +25 (front) and +22 (rear) offset on both sets of wheels, which is aggressive, but he can do that since he rolled his fenders.

Customer: Jon (a.k.a. JonSpec on e90post.com)
Car: BMW 335i sedan
Wheels: Linea Corse L22 19×8.5 +30 (F), 19×10 +37 (R) & Linea Corse Lemans 19×8.5 +30 (F), 19×10 +37 (R) - both Hyper Silver w/ Polished Lip
Additional Stuff: 5mm spacer (front), 15mm spacer (rear) - overall actual offset is +25 (front), +22 (rear)
Tires: Nitto Invo 235/35/19 (front), 275/30/19 (rear)

L22 Wheels:

Lemans Wheels:

Wheel Details - L22 & Lemans

Ryan’s Audi B6 on 19×8.5″ Linea Corse L22 Wheels - Hyper Black w/ Polished Lip

Owner: Ryan
Car: Audi A4 B6
Wheels: Linea Corse 19×8.5″ +35 - Hyper Black w/ Polished Lip

Ryan sent us some nice shots of his Audi on 19×8.5″ L22’s with a 5×112 bolt pattern. These wheels are available for Audi and Mercedes Benz fitments!

Wheel Details