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

[TEP STOP]

A Part of History - Josh’s STI on Gold Rota T2R’s

Owner: Josh
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×9.5 Rota T2R - Gold (5×114.3/e38/73)
Tire Size: 235/40/18 Federal Tires
Suspension: BC Coilovers

The Subaru blue and gold color combination has been around for quite some time now and most of us have memories of watching the Subaru World Rally Team dominating the World Rally Championship. That memory plays a great role for most people when setting up their Subarus today which is the reason why a lot of people run the blue and gold color combination. If you think it is overplayed, wait until you see Josh’s STI.

More pictures here.

Engine/Power
Cobb Accessport tuned by John Visconti
ACL Bearings
Nitrated crank
Manley turbo tuff rods
CP pistons
Cosworth head gaskets
ARP studs
GSC stage 2 cams
Supertech springs and retainers
Gates HD timing belt
11mm STI oil pump
Killer B oil pickup tube
ID2000 injectors
T1 Fuel rails
HTA3586
Perrin tuner rotated kit
TGV deletes
GMS thick gaskets
Aeromotive FPR
8AN SS fuel lines and fittings
Perrin rotated intake
Perrin stealth FMIC
Perrin Blow-thru boost tube
Perrin Recirc BPV
Perrin EL header
Perrin Coolant Catch Can
Ball Racing SS AVCS/turbo oil feed line
Walbro 400lph
Tial 44mm EWG
Grimmspeed 8mm Penolic intake manifold spacers
Invidia catless DP
Cobb 3″ CBE
Hallman MBC
Clutchmasters FX400
Clutchmasters Chromoly flywheel
OMNI 4 bar MAP sensor
Crawford AOS
Deka ETX14 LW battery

Suspension/Handling
BC Coilovers with rear extenders
Whiteline Rear camber bolts
Black Wheeltek lug nuts
Hawk HPS F&R brake pads
Kartboy short throw shifter
Kartboy Front and rear bushings
Group N Pitch mount
Group N Rear diff mount
Group N Engine mounts
Group N tranny mount

Interior/Exterior
STI limited replica front lip
STI limited console
Hella supertones
04 WRX side skirts
Wingless trunk
Killer B radiator shroud
DIY red grill stripe
JDM Hazard button
Sparco Prodrive seats
Cleared/painted headlights
Red LED running lights
White LED interior lights
20% tint all around
35% windshield tint
04/05 taillights
Rally Armour UR flaps
Innovative wideband
STRI Boost, Oil Pressure, EGT 60mm Gauges
ATI clock pod
Bride Shift boot
Bride E-brake boot
Euro Plate

Thanks to Jim Davis A.K.A. Killerblackbird and Dan Purpora of CFD Productions for the mind blowing pictures.

John’s 2006 WRX on Flat Black Rota Boost 2

Owner: John
Car: 2006 Subaru Impreza WRX
Wheels: 18×9.5 Rota Boost 2 - Flat Black (5×100/e35/73)
Tires: 245/35/18
Suspension: BC BR Extreme Low Coilovers

As soon as we saw John’s car on the forums, we knew we had to see more of that aggressive WRX.

The Rota Boost 2’s huge lip sets it apart from all the other Rota wheel styles. For those of you looking for the biggest lip without going too crazy on the wheel width, this one’s for you.

Kyle’s 2010 STI on 18×9.5 White Grids

Owner: Kyle
Car: 2010 Subaru Impreza WRX STI
Wheels: 18×9.5 Rota Grid - White (5×114.3/e38/73)
Tires: 245/40/18 Falken 502’s
Suspension: ISC N1 coilovers, GT Spec rear control arms

Kyle has been in the Army for six years now and is currently stationed in Germany. Must be nice to drive on those German autobahns! Kyle chose to run 18×9.5 Rota Grids with 245/40/18 to have that much needed grip during his high speed runs. He is also running a set of ISC coilovers to keep his car planted on the ground.

Engine:
AMR CXR500 turbo
AMR catted down-pipe
AMR tuned 387WHP
Perrin Cat-back
Agency Power EL header
Agency Power up pipe
Turbo XS FMIC
Deatchwerks 850cc injectors
AEM cold air intake
Cobb Accessport
Gimmick turbo inlet
Grimmspeed AOS
Grimmspeed EBCS
Grimmspeed turbo heat shield
Paint matched (to Rota’s) intercooler pipes

Suspension:
GT Spec control arms
Tanebe 4 point brace
Whiteline F/24mm R/22mm swaybars
ISC N1 coilovers

Exterior:
18×9.5 Rota Grid - White (5×114.3/e38/73)
Falken Tires
Blacked out tails
Paint matched Grill and fog light covers
R205 Fender badges
Red lugs
Rolled fenders
Carbon fiber fuel door

Interior:
AEM Digital Boost and Wideband Gauges
Autometer Carbon fiber gauge cups
Pioneer AVH-P4300 stereo
Agency Power Short shifter

Here’s what Kyle has to say “Hey guys, I have been in the military (Army) for six years now. I would like to throw a shout out to my wife who doesn’t support, but puts up with my bad habit of modifying my car. She has been great!”

WRB WRX on 18×9.5 Rota Boost 2 Wheels in Flat Black

Owner name: Justin Mathews
Car/Year: 2006 Subaru WRX
Wheel: 18×9.5 Rota Boost 2 - Flat Black (5×100/e35/73)
Tire size: 255/35/18
Suspension mods: BC coilovers with front and rear camber plates as well as polyurethane bushings throughout the entire chassis.

Perfect setup for driving around town or taking it for a nice cruise through the mountain roads! The wheel has the perfect lip size to keep it from blending in with all the other wheels!

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

Murdered out with 18×9.5 +22 Rota DPT in Flat Black

Owner: con10der8 on nasioc
Car: 2003 Subaru Impreza WRX
Wheels: Rota DPT 18×9.5 5×100/5×114.3 +22 73hb Flat Black
Tires: 255/35/18 Bridgestone RE01 RFT
Suspension: Helix DNA Coilovers, rolled & pulled fenders, -2 camber front and -1 on the rear

I simply love his car. I know pictures were posted before, but these are NEW ones. Try not to drool over the car LOL!

Engine:
Sti TMIC, custom intake, Helix DP, HKS carbon-ti, AP v1

Interior:
05 seats F&R, CF wrap door panels, 05 cluster (red LEDs), boost & oil press., Kenwood NAV

Exterior:
DIY projector headlights, HELLA 500 fog lights, supertones, 04-05 wrx hoodscoop, prodrive/s204 lip combo, sti fender flares, CF roof vane, CF wing risers, 04-05 tails, LED bulbs, 06-07 sti rear diffuser, custom diffuser bracket, DIY plate delete

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

Tom’s 2010 Subaru STi SE on 18×9.5 Rota Grid Wheels in White

Owner: Tom
Car: 2010 Subaru STi SE
Wheels: 18×9.5 Rota Grid - White (5×114.3/e38/73) (5mm spacer on the front)
Tires: Hankook V12 255/35/18
Suspension: BC Racing BR Coilovers

It’s not everyday someone trades in a Mercedes Benz C63 AMG for an STi. Tom believes he has more fun with the STi and there is no doubt about it, just take a look at his mods list below.

Here’s what Tom had to say about the wheels & it’s durability.
“I love the wheels. I have had them for a year and to date I haven’t found a better looking wheel for the gr STi. I daily drive the car every day and track it on both road course and drag strip.

The white really sets off the color of the car and I think anyone with a dark car should consider white wheels! They only need cleaning 1-2 times a week so completely manageable.”

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

Mods:
Engine Management: Cosworth EcPro, Greddy Boost Controller, Innovate Digital AFR Gauge

AEM Meth Kit (1 Gallon)

Engine
Rotated GT35r turbo, Titanium/Ceramic Heat Shield, JE Forged Pistons 8.8:1 Compression, Connecting Rods - BC625+ w/ARP Custom Age 625+ Fasteners, ACL Race Bearings, ARP Head Studs, ARP Main Studs, Engine bored to 100mm, Cosworth Head Gaskets, Oil flow Cosworth Oil Pump, lightweight pulley, Balance to 8500rpm, Blue printed, Heads 3 way valve job, BC Valve Springs, BC 272 ’stage 2′ cams’, Supertech Black Nitrided intake valves +1mm, Supertech Inconel Exhaust valves

Misc:
Cosworth High Volume Intake Manifold, Perrin Equal Length Headers, Perrin rotated Catless Downpipe, Perrin Fuel Rails, Gruppe S Catch Can, Perrin FMIC, Custom Intercooler piping anodized cosworth blue, TialBOV, Walbro 255 pump, DIY TGV deletes with ground down shafts.
two step colder plugs, Custom Aluminium Over Flow Tank, Tsudo N1 Exhaust

Transmission: Gruppe S 14lbs FLywheel, ACT XCSS Clutch

Suspension
BC Racing BR Coilovers, SPT lower brace, SPT upper brace, GTSpec Lower Control Arms

Ave’s 04 STi on 18×9.5 Rota Boost 2 Wheels in Hyper Black

Owner: Ave
Car: 04 Subaru STi
Wheels: 18×9.5 Rota Boost 2 - Hyper Black (5×100/e35/73)
Tires: 235/40/18
Suspension: Coilovers

Out goes the old, on goes the new 18×9.5 +35 Rota Boost 2’s for now! Being 5×100, Ave doesn’t have much choices when it comes to his STi needing wheels. At Wheeldude, we will ALWAYS have something in stock for the 5×100 guys. Ave is a die-hard friend of ours that proudly rocks Rotas all day every day! Thank you for the support Ave!

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

Now the other color! 08 STi on 18×9.5 +35 Rota Boost 2 Wheels in Flat Black

Owner: Alan
Car: 2008 Subaru STi
Wheels: 18×9.5 Rota Boost 2 - Flat Black (5×114.3/e35/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Racing Coilovers

Alan put on the Rota Boost 2’s in Flat Black on the other side, signature Wheeldude move. We featured his Hyper Black’s on Friday now it’s time for a change! Which one do you like more?

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

Alan’s 08 STi on 18×9.5 +35 Rota Boost 2 Wheels in Hyper Black

Owner: Alan
Car: 2008 Subaru STi
Wheels: 18×9.5 Rota Boost 2 - Hyper Black (5×114.3/e35/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Racing Coilovers

This 2008 Subaru STi belongs to our newest Logistics employee, Alan, he chose to run the new 18×9.5 Rota Boost 2 in Hyper Black. This is considered his winter setup as he took off his lip for now and put on the not-so-stretched Nexen N3000 255/35/18 for now. As for suspension, he’s running the very typical BC Racing BR coilovers for the 08 guys.

These wheels are IN STOCK & Ready to ship! Looks great for all cars, deep concave, bling bling finish, what more can you ask for? Click the link above to purchase your set before it’s sold out. :)

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

Austin’s 2011 Subaru STi on 18×9.5+35 Rota Boost 2 Wheels in Hyper Black

Owner: Austin Price
Car: 2011 Subaru STi
Wheels: 18×9.5 Rota Boost 2 - Hyper Black (5×114.3/e35/73)
Tires: BFG KDW 2
Suspension: BC Racing Coilovers, Whiteline Rear Camber kit (upper control arm bushings), Perrin front and rear sways, rolled front and rear fenders.

Austin is the one of the very first people running the NEW Rota Boost 2. We must admit, they look awesome!! He just isn’t about the stance of the car as he has upgraded a few crucial suspension elements when lowering a car such as adding new sway bars, and putting in a rear camber kit! Austin would like to give a shout out to Steven Dunlap for always helping with the car!

These wheels and all the other sizes for the Boost 2’s are IN STOCK and READY TO SHIP.

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