Welcome to the Q&A Forum

Your welcome. If that fully answered your question please mark it as answered.

As Google will not show you everything, even using the site command, I use Yahoo SiteExplorer:

http://siteexplorer.search.yahoo.com/search?p=seomoz.org&bwm=i&bwmo=d&bwmf=s

and wrote a PHP script to take the TSV it exports and create a line for each page. I could probably make that available for use one one of my sites.

I had the same problem on http://www.tokenrock.com because I was doing a lot of URL Rewriting, it's a CMS system I wrote, but the same issue apply. I went from 7000+ errors according to SEOMoz, and I'm down to 700. Here's a few things I did:

Use canonicals on everything you possibly can.

Redirect 301 the items in the SERPS that are identical.

I'm not familiar with Magento to help you work though that side of it.

Having a link like: domainname/leather-chairs-244-16-price-1.html would work much better.

The ones you have listed are because somehow somewhere you (the site) have a link to it.

Unfortunately some of the CMS's are written by developers who don't fully understand SEO and why the ? is a bad thing.

I went through both sites and noticed that you don't have canonicals on any of your pages. Also don't see any XML sitemaps.

If you can only show the businesses that are in that particular area, and remove the ones that are not I would  probably go for that, unless you are doing Local Search as well.

I would be curious to see the example of canonical issue you mentioned.

Are these Joomla sites? I'm just asking because there are no description tags on anything except the home page.

I agree with EGOL. Are the pages being generated? How many search queries will end with the same information?

It looks like your doing URL ReWriting now since the url:

http://www.businessbroker.net/State/California-Businesses_For_Sale_test.aspx

shows the same information. Start adding canonical to all pages so that the above link will not be seen as duplicated content.

Without actually seeing the site I would say that if you have product pages that are identical to canonical them to one main place. If they are listed in the SERPS 301 them if you are removing them. Even having a few different words can still show up as duplicate.The last CMS option might work, but again without seeing the site it is hard to judge.

Since I do a lot of url rewriting I ran into a similar issue and did 301's and canonical to the pages I wanted to show and things are much better.

The few things I would point out, which aren't so much WordPress issues, but are how this WordPress installation is configured, are:

1. No description tag, that is in the 'Settings -> General' page
2. Well over 100 links on the home page, mostly because of the 'Blog Archive', are people actually clicking on those items?
3. No good H1 tag, the one that was created by the theme "Athletic Foodie" has been commented out and the current (second) one is, "How about a 2,000-year-old Salad? Kale!!", a poor descriptor of the page.
4. Dangling links, some of the images are linked to themselves, that is set on the post or page they are created on.
5. The page names 'slugs' don't usually match their titles, ex, Fiber: health benefits for athletes...., would be: 'fiber-health-benefits-athletes', etc.
6. From a user standpoint, way too much text, the full posts could be reduced by using excerpts and linking to a separate page, increasing load time, and most likely page views. Would you scroll all the way to the bottom? What if it was half or a quarter this size?
7. The 2 main items "Recipes" & "Videos" go offsite? And they are follow links! What the!

Cheers.

Aside from checking out the Yoast plugin, make sure your sitemap is up to date. There is a reason the bots are going to those pages, the question is why.