Top » Catalog » SPECIALTY VEHICLES »

  2. EMT Emergency Vehicle

    Our Price:  $0.00

    The classy and cost effective way to handle Emergency services at events.  Available in gas or electric, new or reconditioned.  The EMT Cart includes an 80" Suntop, Fold down windshield, Head and Tail lights, Amber beacon, Fuel gauge or state of charge meter, 12 volt accessory plug, Backboard with body straps and Head Immobilizer.  Solid single unit construction made of heavy duty diamond plate aluminum.  It has a Rear storage box, Cushion seats for driver and EMT, Storage locker under body deck, Full length safety rails that fold down for easy loading and EMT insignia's.  The body tilt's up for ease of maintenance.  Siren not included but is available.  More photos available, e-mail tntsales2@adams.net for more information. 






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