|
|
select distinct bikes_motor.id,bikes_motor.title,bikes_motor.price,
bikes_category.name,bikes_motor.des,
bikes_motor.model, bikes_make.name, bikes_motor.status
from bikes_motor,bikes_category, bikes_make where bikes_make.id = bikes_motor.make and bikes_motor.price > 0 and bikes_category.id = bikes_motor.cat and bikes_motor.id != '0' and active = 'y' and ( bikes_motor.cat = '11' ) group by bikes_motor.id |
|
Displaying 1 - 1 of 1 Scooters | Page : [ 1 ] |
|
|
Motorcycle, Chopper, Red, 2008, 2 Miles |
$ 1999 |
|
This is a BRAND NEW mid-sized chopper!
Is is an exact copy of a custom chopper from the TV show Orange County Choppers - 2007 series.
With a 200cc engine and 5 forward gears, this baby is fast! |
|
| |
|
|
Displaying 1 - 1 of 1 Scooters | Page : [ 1 ] |
| |
|
