Top » Catalog » ACCESSORIES » Enclosures/Cabs/Bag Covers » 4 Sided Enclosures » Yamaha » GCA-40012-00-00

  2. Classic Accessories The DRIVE Custom Enclosure-Sand
    [GCA-40012-00-00]

    Our Price:  $287.64

    Custom fit for The DRIVE golf cars. Fits over the roof and secures with rubberized hooks on the bottom. Features a quick zip-off windshield that can be stored in front pocket. Super-clear windows with easy-zip doors (3 zippers per door). Zippered doors and panels adjust quickly and easily to any weather condition. Keeps golf car clean and dry in storage. Installs in miutes with the need for tools. Deluxe carrying case included. Easy access panel to clubs and rear bag well area. Entire rear panel also rolls up and out of the way.

    Sand -colored, water-resistant material.

    3 year limited warranty.

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