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

[TEP STOP]

NEW RELEASE - Introducing the Rota RT5

We would like to introduce to you our new five spoke wheel - the Rota RT5. The Rota RT5 will be available in 18×8.5 and 18×9.5. They will be arriving at our facility in October/November 2012.


The Rota RT5 can now be pre-ordered. Just click on your preferred size/offset below or you may give us a call at (510) 651-2956 to pre-order.

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

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

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

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

18×9.5 Rota RT5 - Flat Black (5×114.3/e22/73)

18×9.5 Rota RT5 - Flat Black (5×114.3/e35/73)

18×9.5 Rota RT5 - Flat Black (5×114.3/e44/73)

Throwback Thursday - Palmer’s Lancer on 18×8.5 Flat Black Rota Grids

Owner: Palmer
Car: Mitsubishi Lancer
Wheels: 18×8.5 Rota Grid - Flat Black (5×114.3/e44/73)
Tire Size: 235/40/18

The Dude woke up at 5AM on a chilly morning back in 2010 for a shoot with Palmer’s Lancer. Here’s what his ice cold hands, a can of Rockstar, and a Canon 5D Mk II came up with that day.

Throwback Thursday - The Dude’s STI on 18×8.5 Gold Rota DPTs

Owner: Subydude
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×8.5 Rota DPT - Gold (5×100x114.3/e44/73)
Tires: 235/40/18
Suspension: BC Coilovers

The STI is already sold but the memories will forever remain. Here it is in its prime rocking 18×8.5 Gold DPTs. We surely miss this car!

Josh Riggins’s Scion FRS on 18×8.5/9.5 Grids

Name: Josh Riggins
Car: 2013 Scion FR-S
Wheel: 18×8.5/9.5 Rota Grid - Hyper Black (5×100/e44F/e38R/73)
Tire Size: 225/40R18 front / 245/45R18 rear
Suspension Set up: Stock for now

According to Josh, he is really liking the aggressive look with the staggered wheels. he plans on going to go with lower profile tires on the back wheels when he need to replace the tires but the wheels definitely give his car a different look. And he’s super happy with the choice of wheels he made.

Glad you made the right choice and went with the Grids Josh.

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

Farewell 2006 Subaru STi! 18×8.5 +44 Rota Grid in White

Name: The Dude’s
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×8.5 Rota Grid - White (5×114.3/e44/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Coilovers

This was one of the very last sets of wheels our 06 STi had on, the 18×8.5 Rota Grid in white. With the color white, you just can’t go wrong, it looks great with EVERY single exterior color. We chose to put on some 255/35/18 tires for the daily drive around town. So with that said, why not put some on your car while we have them in stock? This is also one of the many wheels we have limited sets in stock. Please consider buying ASAP to guaranteeing yourself a set.

Click the link above to buy or give us a call at (510) 651-2956 M-F 10am-5pm.

wheeldude.com Gallery

wheeldude.com Gallery

wheeldude.com Gallery

wheeldude.com Gallery

wheeldude.com Gallery

The Dude wanted 18×8.5 +44 Grids in Slate Grey on his STi

Name: The Dude’s
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×8.5 Rota Grid - Slate Grey (5×114.3/e44/73)
18×8.5 Rota Grid - White (5×114.3/e44/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Coilovers

Time for a new color, this time it’s the Slate Grey making an appearance on the STi!

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

Spotlight: Zach Gill’s Mazdaspeed 3 on 18×8.5 G-Forces

For more information on the wheel: 18×8.5 Rota G-Force - Hyper Black (5×114.3/e48/73)

http://www.wheeldude.com/catalog/product_info.php?products_id=6294

Eugene’s ‘11 WRX on 18×8.5 Rota Grid Wheels in Hyper Black

Owner name: Eugene Suhh
Car/Year: 2011 WRX sedan
Wheel: 18×8.5 Rota Grid - Hyper Black (5×100/e44/73)
Tire: 235/40ZR18 Continental ExtremeContact DW
Suspension mods: Stock (for now)

Eugene is happy with the purchase of his new 18×8.5 Rota Grids as he really liked how the wheels fill out the wheel wells much better and give his car a more aggressive look. The larger rim size also shows off his Brembo brake upgrade advantage. From the photos, he has no reason to not enjoy the new wheels he selected for his car!

wheeldude.com Gallery
wheeldude.com Gallery

Something New - Dallas’ 2012 Impreza Sport on 18×8.5 DPT’s

Owner: Dallas
Car: 2012 Subaru Impreza Sport
Wheels: 18×8.5 Rota DPT - Flat Black (5×100x114.3/e44/73)
Tires: 225/40/18
Suspension: Stock

We posted a teaser picture of this car on our Facebook yesterday. The picture got a lot of negative comments which we already expected since that is always the case whenever a new body style comes out. Nonetheless, we think Dallas’ car looks awesome! The black car and flat black wheels really go well with each other.

Dude’s 06 STi on 18×8.5 Rota Grid Wheels in White right now!

Name: TheDude’s
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×8.5 Rota Grid - White (5×114.3/e44/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Coilovers

Enough of the Flat Black! The Dude said it’s time for the White Rota Grids in 18×8.5!! Everything fits correctly, no rubbing!

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