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

[TEP STOP]

Jesse’s 2017 Ford Focus ST on 18×9.5 Rota Grid in Hyper Black

Owner: Jesse
Car: 2017 Ford Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: Good Year Tires 235/30/18
Suspensions: H&R lowering springs 1.5 in the front and 1.8 in the rear

Ron’s 2007 Outback on PWR 18×9.5 +38 5×100

It’s not everyday you see a clean Outback on some aggressive wheels. Ron wanted to spice up his 2007 Outback with a set of aggressive wheels. Tommy was able to work with him through multiple emails to figure out what fitment would be perfect for his car. After measuring and checking multiple times, he made a decision to bite the bullet and order up a set of PWR 18×9.5 +38 5×100 in Hyper Black. Ron, this was a perfect match for your car and a tremendous job with the photo shoot!

Customer: Ron Coleman
Wheels: PWR 18×9.5 +38 5×100 Hyper Black
Tires: 235/40ZR18 FALKEN PT722
Suspension: KW V2 Coilovers, Whiteline Link kit and rear sway bar
Photo Credits: Robert Villena Photography






Lear’s Forester XT on 18×9.5 Gold PWRs

Owner: Lear Miller
Car: 2004 Subaru Forester XT
Wheels: 18×9.5 Rota PWR - Gold(5×100/e38/73)
Tires: 235/40/18
Suspension: Ohlins Coilovers

This is definitely not your regular crossover utility vehicle. Lear’s Forester has a full STI swap making 404whp. Coupled with one of the best coilovers out there and a wide wheel set up, this makes for one hell of a daily driver.

Manny’s Evo X on Hyper Black Rota PWR’s

Owner: Manny
Car: 2013 Mitsubishi Evolution X
Wheels: 18×9.5 Rota PWR - Hyper Black(5×114.3/e22/73)
Tires: 265.35.18 Hankook Ventus V12
Suspension: Coilovers

We shared Manny’s Evo X on our Facebook page and Instagram account last week. As we expected, people loved the car as much as we did. The Hyper Black PWR’s look right at home on the Black Evo and what’s even better is that it fits like a glove on this body style.

Kelly’s 2011 STI on Flat Black Rota PWR’s

Owner: Kelly
Car: 2011 Subaru Impreza WRX STI
Wheels: 18×9.5 Rota PWR - Flat Black(5×114.3/e32/73)
Tires: 265/35/18 Hankook Ventus V12
Suspension: BC Racing Coilovers

Kelly sent us some pictures of his 2011 STI running the new Rota PWR’s. These wheels have the +32 offset but only required a rear fender roll even with the meaty 265/35/18 tire set up. Gotta love that aggressive set up!


Tyler’s STI on Gold Rota PWR’s

Owner: Tyler
Car: 2012 Subaru Impreza WRX STI
Wheels: 18×9.5 Rota PWR - Gold(5×114.3/e32/73)
Tires: 245/40/18
Suspension: Stock

Tyler sent in some photos of his 2012 STI running the new Rota PWR’s in Gold. The PWR’s look great on the car even without a drop. This is Tyler’s second set of wheels from wheeldude.com and he told us “couldn’t be happier with the service and products!”

Reid’s OBS, “The Sube” on 18×9.5 +38 Grids

Owner: Reid NASIOC: reide181
Car: 2010 Subaru Impreza Outback Sport
Wheel: 18×9.5 Rota Grid - Hyper Black (5×100/e38/73)
Tires: Nexen N3000 235/40/18
Suspension: BC Racing BR Series
Additional Mods: Rallitek Sway Bars (21mm/19mm), Rallitek HD endlinks, Cusco Strut tower braces. Other mods include most of the typical Subaru stuff (Hellas, Red Tail Lights, Independent Yellow Fogs) and tasteful mods like shark fin antenna to get rid of the RC car look, WC Lathe Werks Custom Gunmetal Stainless Steel Shift Knob to match the gunmetal interior trim, STi LED Turn Signal Mirrors, LED Switchback front turn signals, a full LED exterior and interior conversion, 5000K HID Low beams, DRLs Disabled, a Full Rockford Fosgate Sound system, and a WRX exhaust for a little throaty sound without making the neighbors hate him.

Reid sure wanted to be different. He took a rugged Outback Sport and turning it into a clean, curve hugger was his goal. he reported back to us saying that the 9.5″ wheel width wrapped in 235s was a tough fit on the non-wide body Impreza. With a proper fender roll, pull and the perfect offset, Reid can say he’s one of less then a handful with these sizes on an N/A Impreza. She turns heads while still remaining under the radar. He loves his DD and couldn’t be happier!

Always puts a smile on our faces when we read at the end of the article he had the following to say about us, “I had a great experience with wheeldude.com! Shipping was extremely fast to PA, and the wheel/tire package came ready to install. Great prices with everything I needed (lugs, locks, hub rings, center caps) all in one place. Thanks guys!”

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

If you are interested in more pics, I have a bunch on my Razzi, http://razzi.me/ElattrachePhotography.

It’s that time of the week….another set of wheels for our FRS! 18×9.5 Rota PWR.

First set of wheels on our FRS that are not the grids.

18×9.5 Rota PWR’s this time!

Pretty nice look, the wheels suit the car will in our opinion!

Wheels: 18×9.5 Rota PWR - Flat Black(5×100/e35/73)

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

Wheels: 18×9.5 Rota PWR - Hyper Silver(5×100/e38/73)

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

John’s Jaw-Dropping 2012 STI - 18×9.5 Hyper Black Rota PWR’s

Owner: John
Car: 2012 Subaru Impreza WRX STI
Wheels: 18×9.5 Rota PWR - Hyper Black(5×114.3/e32/73)
Tire Size: 245/40/18
Suspension: Stance GR+ Series

We came across John’s STI in one of the social networking apps that we frequently browse. As soon as we saw his car, we knew that we just had to see more. It was the perfect time to ask John for more pictures because he was scheduled to do a photoshoot that week. We’re pretty excited for this feature so let’s just cut the chit chat and take a look at John’s jaw-dropping STI.

Here’s what John has to say about his new set up, “Got the the suspension from an awesome company SSautopower. The wheels speak for themselves. Together they make a perfect combination. The setup is totally functional with no rub/poke.”

John would like to thank Ricky Thach for the pictures.

Click here to see the rest of the gallery.

New 18×9.5 Rota PWR on GRB STi !!

Owner: Alan
Car: 2008 Subaru STi
Wheels: 18×9.5 Rota PWR - Hyper Silver(5×114.3/e38/73)
Tires: 255/35/18

Introducing one of the newest wheels to come out of the Rota Factory.. the Rota PWR on Alan’s WRX STi.

This is the 18×9.5 width with 255/35/18 tire. Aggressive face on a very popular size we carry. Sounds like a win win for our customers!
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery