Welcome to the Q&A Forum

Did you make a change? I'm seeing the canonical tag in the header and not in the content/body (as Boomajoom mentioned). In my experiments, Google won't honor a canonical tag in the body. I do see that the tag is reversed a bit, with the "href" attribute first and "rel" second. Although Google will probably honor this, I think it might be confusing our system, which can be a bit more literal.

Rand has a great post on targeting a single keyword across multiple geo's. I'd say overall, it pays to keep in mind Google's "serve the user, not the engine" philosophy - if you don't want users to see certain pages of your site, then you'll have to try and keep them separate or deep down in your internal link structure (ie at least two clicks/links away from each other), so that it's unlikely that they'll be able to just "click through" to an almost identical page.

I noticed you made the changes that I recommended except for one thing.  You fixed the 404 error on this page http://www.providenceelectricnc.com/localelectrician.html but did not 301 redirect it to the home page which is where your trying to rank for.  I would say unless you trying to rank for "Charlotte electrician" on http://www.providenceelectricnc.com/localelectrician.html it could possibly be fine but you then have a bigger issue. Both your home page http://www.providenceelectricnc.com and http://www.providenceelectricnc.com/localelectrician.html are duplicates.  Bad Idea!  If you redirect the http://www.providenceelectricnc.com/localelectrician.html to home page with a 301 redirect you should be able to garner most of the juice to home page.