Top » Catalog » MULTI PASSENGER VEHICLES » YDRA 4P

  2. 2016 Yamaha Concierge 4 Passenger EFI Gas
    [YDRA 4P]

    Our Price:   $9,999.00 $11,999.00

    Available Options:

    Yamaha Built 357F Gasoline Engine

    Electronic Fuel Injection

    Headlights & Tail LightsFloor Mounted Horn

    Filterless Oil System

    HybriCore™ Chassis

    Automotive-Style Dash

    Largest Most Comfortable Seat in the Industry

    Rear Seat Grab Handle

    Mid-Body Seat Storage

    Low Oil Warning Light

    Low Cost of Ownership

    Tru-Trak II™ Fully Independent Front Suspension

    Best Front & Rear Bumpers in the Industry

    Maintenance-Free Rack-and-Pinion Steering

    One-Piece Fender Well with Integrated Splash Guards

    Removable Floorboard Access Panel

    Virtually Greaseless Chassis

    Flexible, Durable Body Panels

    Easy-To-Clean, Durable One-Piece Floor Mat

    Premium Tread Tires

    Easy-To-Clean Cup Holders

    Largest Rear Access Panel

    Easy-Grip Steering Wheel

    Wheel Covers

    Available Colors:

    Standard Color: Glacier White

    Premium Colors: Emerald, Garnet

    Premium Metallic Colors: Sandstone Metallic, Moonstone Metallic, Onyx Metallic, Jaspar Metallic

    This units IN STOCK and SPECIAL ORDER at both locations.

    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 = '25105' and opa.orders_id = opb.orders_id and opb.products_id != '25105' 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]