|
|
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 = '12' ) group by bikes_motor.id |
|
Displaying 1 - 2 of 2 Scooters | Page : [ 1 ] |
|
|
Flyscooters, Scout, Blue, 2010, 1 Miles |
$ 1899 |
|
2010 Flyscooters Scout!
The Scout is finally here! A throwback to the past, the 110cc Scout is sure to turn heads everywhere you go!
We have Blue & Red in stock, but can order green or yellow.
Features
: Warranty : Roadside Assistance : Rear Seat : Digital Dash |
|
|
|
|
Flyscooters, Scout, Red, 2010, 1 Miles |
$ 1899 |
|
2010 Flyscooters Scout!
The Scout is finally here! A throwback to the past, the 110cc Scout is sure to turn heads everywhere you go!
We have Red & Blue in stock, but can order green or yellow.
Features
: Warranty : Roadside Assistance : Rear Seat : Digital Dash |
|
| |
|
|
Displaying 1 - 2 of 2 Scooters | Page : [ 1 ] |
| |
|
