Top » Catalog » ACCESSORIES » Audio/Electronics » GCA-JW191-00-00

  2. '07-'09 The DRIVE Stereo Console with Speakers
    [GCA-JW191-00-00]

    Our Price:  $269.45

    '07-'09 The DRIVE Stereo Console with Speakers.

    Black roto-molded, foam-insulated, double-wall plastic construction is a perfect complement to existing vehicle body lines.  Easy installation- mounts underneath vehicle roof to built-in mounting points on suntop with stainless steel hardware.  Includes two pre-wired 5" , 40-watt marine grade speakers.  Stereo not included.  Accommodates a wide range of stereos with a single DIN opening of 2-1/8" x 7-1/8".

    We recommend using our marine-grade stereo components.

    Fits '07-'09 The DRIVE cars with ClimaGuard Top, '07-'13 The DRIVE cars with the Yamaha 82" Extended Top.

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