|
|
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 = '13' ) group by bikes_motor.id |
|
Displaying 1 - 1 of 1 Scooters | Page : [ 1 ] |
|
|
Flyscooters, GS125, Black/Silver, 2010, 1 Miles |
$ 1899 |
|
GS125 explores the boundary between a motorcycle and a scooter. Its handling and styling give you an authentic motorcycle experience, while its semi-automatic transmission provides the convenience of a scooters - no clutch shifting!
Want crazy mpg but don't want to ride a scooter? This is the bike for you!
Features
: Warranty : Roadside Assistance : Rear Seat |
|
| |
|
|
Displaying 1 - 1 of 1 Scooters | Page : [ 1 ] |
| |
|
