|
|
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 = '8' ) group by bikes_motor.id |
|
Displaying 1 - 6 of 6 Scooters | Page : [ 1 ] |
|
|
Red Streak, M-80, Blue, 2009, 1 Miles - SOLD |
$ 1699 |
|
The Red Streak M-80, a sporty, fast, unique looking sport scooter! This scooter turns heads everywhere you go!
Plenty of storage, and a FREE trunk! BIG 13" wheels!
Suggested retail price, $1849 - Our price, $1499!
Features
: Warranty : Trunk : Roadside Assistance : Rear Seat |
|
|
|
|
Red Streak, M-80, Yellow, 2010, 0 Miles - SOLD |
$ 1699 |
|
The Redstreak M-80, a sporty, fast, unique looking sport scooter! This scooter turns heads everywhere you go!
Plenty of storage, and a FREE trunk! BIG 13" wheels!
Suggested retail price, $1849 - Our price, $1699!
Features
: Warranty : Trunk : Roadside Assistance : Rear Seat |
|
|
|
|
Red Streak, Metro Duo, Blue, 2009, 1 Miles |
$ 1549 |
|
From Red Streak Motors, this is a brand new Metro Duo. Sporty and stylish, this scooter has a wonderful blue metallic paint that just sparkles in the sun!
You can ride 2-up and it has plenty of storage as well.
Trunk included FREE!
Features
: Warranty : Trunk : Roadside Assistance : Rear Seat
|
|
|
|
|
Red Streak, Metro Retro, Red / Silver, 2010, 1 Miles |
$ 1499 |
|
Metro Retro 50 - Classic Styling, Peppy and Lightweight, Easy to handle!
32-38 MPH Top Speed, 1 Year Factory Warranty, Free roadside assistance!
Features
: Roadside Assistance : Trunk : Warranty |
|
|
|
|
Red Streak, Xtreme, Black, 2009, 1 Miles |
$ 1599 |
|
You gotta love it. This bare-bones scooter thinks it owns the place! And for good reason: It struts onto the urban scene showing off a thrifty 49cc engine that takes you where you want to go on a sip or two of gas.
Zipping around town couldn't be easier with its automatic transmission. The Xtreme talks big, but it's earned the right! This little scooter's built strong and tough.
2 now in stock
Features
: Warranty : Trunk
|
|
|
|
|
TNG, Venice, Blue, 2008, 1 Miles |
$ 1695 |
|
The famous Venice scooter that American buyers have fallen in love with. With a high performance Minarelli type 2 stroke engine, no 49 cc scooter can beat it. Vintage style and priced significantly lower than Vespa, Honda and Yamaha, but with a better warranty!
Features
: Trunk : Warranty |
|
| |
|
|
Displaying 1 - 6 of 6 Scooters | Page : [ 1 ] |
| |
|
