Top » Catalog » ACCESSORIES » Audio/Electronics » TRA-STEREO

  2. Tractor Tunes Roof Mount Stereo Console with Dome Light
    [TRA-STEREO]

    Our Price:  $499.95

    The RMT Roof Mount weather resistant stereo console housing is built tough using the latest injection molding technologies to provide a durable design.

    • High intensity domelight.

    • Includes a high quality AM/FM antenna. Built to OEM specifications for great reliability.

    • Marine waterproof retractable cover protects the Pioneer Deck CD Player.

    • WR85B Marine speakers are water, UV, and corrosion resistant and have a one piece molded grill for speaker protection and durability.

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