|
|
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.make = '10' ) 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, Rave, Yellow, 2009, 1 Miles - SOLD |
$ 1999 |
|
This is not your father's scooter! The Rave is a fantastic crossover scooter that looks like a motorcycle and rides like a scooter!
With it's 14" wheels, the rave is one of the most stable scooters on the market!
Features
: Roadside Assistance : Rear Seat : 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
|
|
| |
|
|
Displaying 1 - 6 of 6 Scooters | Page : [ 1 ] |
| |
|
