Top » Catalog » MULTI PASSENGER VEHICLES » JP01

  2. 2016 Yamaha Adventurer Sport 2+2 EFI Gas
    [JP01]

    Our Price:  $8,999.00

    Available Options:

    Easy grip steering wheel with integrated pencil and scorecard/note holder

    Combination key/headlight switch

    Automotive-style dash with four cup holders, tee & ball holders

    Check engine light

    Multi-reflector 35W Halogen bulb headlights

    Brush guard

    80" extended sun top

    25 km/H (15 MPH) top speed

    ANSI SAE J2258 compliant

    Rear flip down seat

    Splash style positive lubrication system eliminates the need for oil pump and filter

    Tail lights

    Front and rear fender flares

    Yamaha built 357 cc engine with electronic fuel injection

    Floor mounted horn

    Durable cast aluminum accelerator and brake pedal pads

    Removable floorboard access panel

    HybriCore™ chassis (frame/floor combination)

    20x 10.50-8.00 Duro HF244 all terrain tires

    3 inch lift with Tru-Trak II™ fully independent automotive-style strut front suspension

    Heavy Duty Suspension

    Rack and pinion steering

    Standard Body Color: Glacier White

    Optional body colors: Garnet, Moonstone Metallic, Larimar Metallic and Jasper Metallic

    Suntop colors: Stone, Black and White

    Seat color: Stone

    Wheel color: Black

     

     

    Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'tntgolfc_oscom.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '25350' and opa.orders_id = opb.orders_id and opb.products_id != '25350' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]