Cuyahoga Falls 330 923 8604
North Canton 330 768 7643

Video Gallery

Jim & Sons Transmission would like to welcome you to our website's collection of informative and entertaining automotive videos. Jim & Sons Transmission hopes that all of our customers in Cuyahoga Falls ~ North Canton and the surrounding Summit County area find these videos useful.

SELECT offers_owner.website_id, offers_owner.offer_id,, websites.website_url, COALESCE(offers_owner.title, offers.title) AS title, COALESCE(offers_owner.description, offers.description) AS description, COALESCE(offers_owner.fine_print, offers.fine_print) AS fine_print, COALESCE(offers_owner.expiration, offers.expiration) AS expiration, COALESCE(offers_owner.teaser, offers.teaser) AS teaser, COALESCE(offers_owner.meta_title, offers.meta_title) AS meta_title, COALESCE(offers_owner.meta_description, offers.meta_description) AS meta_description, offers.image AS default_image, offers_owner.image AS owner_image, COALESCE(offers_owner.price, offers.price) AS price, offers_owner.sort_order FROM offers_owner LEFT JOIN websites on offers_owner.website_id = LEFT JOIN offers on offers_owner.offer_id = WHERE offers_owner.website_id in ((SELECT id FROM websites WHERE website_id = '10'));