|
|
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 = '9' ) group by bikes_motor.id |
|
Displaying 1 - 2 of 2 Scooters | Page : [ 1 ] |
|
|
Flyscooters, E250, Black, 2010, 1 Miles |
$ 2699 |
|
Captain of the road, this 250cc is perfect for the commuter and long distance rider in you. Take it a few exits to work, or go for a long weekend ride away from the hustle and bustle of the city life.
The E250 provides the performance you need to keep up with traffic on the freeway all while saving you thousands in fuel cost and car maintenance. Free yourself from a cage on four wheels! Get an E250!
Features
: Roadside Assistance : Rear Seat : LED Indicators : Trunk : Warranty : Windshield |
|
|
|
|
Pre Owned, Vespa, Red, 2007, 9100 Miles |
$ 3500 |
|
Vespa GT250IE
9100 Miles
Fully serviced with new belt.
Scratches on right side from being dropped, but it does NOT effect the performance in any way.
Great scooter, very reliable, must see!!
Rear luggage rack and windshield included!
Features
: Windshield : Rear Seat : LED Indicators : Digital Dash |
|
| |
|
|
Displaying 1 - 2 of 2 Scooters | Page : [ 1 ] |
| |
|
