Top » Catalog » ACCESSORIES » Coolers » GCA-JW194-10-00

  2. Trunk Storage/Cooler
    [GCA-JW194-10-00]

    Our Price:  $234.84

    Designed to fit The DRIVE®, this Storage Cooler/Trunk features an insulated double wall design with 1.5 cubic feet of storage space and installs easily in the bagwell area of the car. It features an removable lid for easy loading and unloading,an additional flip-up access lid for quick retrieval of contents and a bottom mounted drain plug. Mounting hardware included.

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