Top » Catalog » Used & Reconditioned Golf Cars »

  2. Reconditioned Yamaha Vortex Green Gas Golf Cart

    Our Price:  $6,499.00

    ONE OF A KIND RECONDITIONED CART!

    Totally reconditioned 2008 Yamaha Drive Gas Golf Car.

    Custom bodies, color matched seats, color matched sun top, rear flip seat with color matched seats, custom dash, custom tires and wheels, carpeting, custom steering wheel, windshield, head and tail lights, horn and stainless steel kick plate to prevent damage to the body while driving.  Make this unique cart your own.  FREE DELIVERY WITHIN 500 MILES!

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