The answer is a big, fat, juicy, YES. That is the epitome of duplicate content.
You need to write the content completely unique from the other page. You cannot trick Google. The Panda will bite you hard 
Welcome to the Q&A Forum
Browse the forum for helpful insights and fresh discussions about all things SEO.
The answer is a big, fat, juicy, YES. That is the epitome of duplicate content.
You need to write the content completely unique from the other page. You cannot trick Google. The Panda will bite you hard 
Dillon,
Thanks for the additional explanation. I do see the canonical tag in your code and see that it is being placed by Yoast's WordPress SEO plugin.
Honestly, you should not worry about the trailing slash. Google and Bing are intelligent enough to understand that .com and .com/ are the same website. You are receiving credit for your backlinks regardless of whether or not the trailing slash exists on the link.
Having said that, here's how you can remove the trailing slash if you still really want to.....
Login to your WordPress backend as an administrator and look for "Plugins" on the left menu and go to "Editor" within the plugins menu. From there, find the dropdown menu near the top right and go to "WordPress SEO". On the list of files that display on the right side, find "wordpress-seo/frontend/class-frontend.php".
In that file, use CTRL + F to find this line of code: $canonical = home_url( '/' );
Remove the / within the ' '
Click on "Update File". Refresh your homepage and you will see that the trailing slash is gone from the canonical tag. Keep in mind, this is a hack. When you update WordPress SEO, this will most likely be overwritten and you'll have to do it again.
In your scenario, you will want to choose one or the other, and setup a force WWW (or non-WWW) 301 redirect. If your site is on a linux-based platform, that is accomplished with an htaccess file. If you are on a Windows-based server, you will need to use IIS (I think). A simple Google search for "force www redirect windows server" will likely return tons of solutions.
If you're on Wordpress or a similar CMS, it is usually very easy to do from within the backend. If you have no idea what server you're on, or what platform your site is built on, use builtwith.com to find out 
How do you choose between www.example.com or just example.com? You'll want to go with the one that's linked to more often, and then work on sticking with that as often as possible in the future. The majority of the link juice that's pointing towards example.com will be transfered to www.example.com with the 301 redirect, so it's not like those links without WWW will be worthless. They only lose a very tiny amount of their value through the redirect. The good news is, you're fixing a big issue so it isn't going to get worse for you.
Let me know if you have more questions.
Each page with unique 300 words will be fine in google's eyes?
If you have 300 words on each page, as long as it's useful content that people are sticking around to read, then you should be okay. Your end goal should be to provide value to your visitors. If 300 words is plenty of content for the subject of your pages, then you're okay. If you have a blog about quantum physics and you only write 300 words per page... you might not be so okay anymore 
After the text is removed is there any chance to recover from Panda? If your site is penalized by Panda, and you make adjustments to fix the issues you were once penalized for, yes, you can certainly recover. It's possible that duplicate content isn't your only issue, and there may be more to fix. Again, this is assuming you're penalized by Panda. I found a really good post about Panda recovery a couple weeks ago. Lucky for you, I bookmarked it! http://www.ventureharbour.com/panda-recovery-a-guide-to-recovering-googles-panda-update/
What about Page title and page meta description? I wouldn't personally write my titles and meta descriptions like that. It is probably a good idea to vary them up and make them a bit more unique from one another. If I'm being totally honest, I think your example title tags might work for Google. That would be up to you though if you're willing to take that chance. If everything else on your site is fantastic, and your only issue is those types of title tags, I really don't think Google would give you a problem. Either way, the best thing to do (obviously) is make them more unique. I'm not a personal fan of them being too similar, but I have seen it done like that on a site before and the pages ranked just fine (they were pretty low competition keywords though). Edit: This is the only question I'm not that sure about... your examples might be okay, but I don't want to give you bad advice.
This is my second question on MOZ
and your answered both of them. 
Hooray! I hope I'm helping you out
I've made it a goal of mine to make it to the top 50 in Moz Points before the end of 2014.
Imran,
I looked at semrush.com and it looks like you had a spike of traffic in August 2013 and then it quickly died back down. I also looked at your backlink profile and I see that the overwhelming majority of your links are from blog comments. It's okay to have some blog comments but you don't want that to dominate your backlinks. You also want to be sure that you're using your actual name for the anchor text of the link (and you are, so that's good). I also noticed that you have some links from other sites linking to you, like androidcentral.us. Since you also own that website, you're effectively creating your own little link network, which could become an issue, if it's not already.
The quality of the content is also lacking. There are a lot of grammatical issues and that may be because English isn't your first language. Your English isn't terrible, but Google wants high quality and unfortunately the level of English on your site won't be considered high quality.
What you should do is work on getting more high quality backlinks and diversifying your backlink profile. I checked a few of your pages on copyscape and they didn't turn up any duplicates found. Assuming this content is actually 100% unique and not just spun/rewritten from another source, you should also have someone fix up the grammatical issues. If the content is spun/rewritten from another source, start adding new content that is completely unique and original. You also need to remove the "Example Widget" text in your sidebar ASAP. That makes your site look incomplete.
If you haven't already done so, please check Google Webmaster Tools to make sure you didn't receive a manual penalty from Google.
Clean up (remove) those spammy backlinks. This is VERY important.
Optimize your title tags across the entire site. Use this tool to see what your title tags will look like on Google. Your homepage title tag says "Colorado bernese mountain dogs | puppies | breeders Colorado" - I would put something more along the lines of "Bernese of the Rockies: Colorado Bernese Mountain Dog Breeders". My suggestion/example is slightly longer than what Google will display but since it is your homepage, you want to make sure your brand name is front and center. For the interior pages you wouldn't necessarily need to do that. For the puppies page, instead of "Colorado bernese mountain dog puppies | For Sale Colorado" - I would do something like "Adorable Bernese Mountain Dog Puppies For Sale in Colorado". My example barely fits within what Google will display, it says exactly what the page is about, it's clean, AND it has something a little enticing ('adorable').
Fix up your URLs. They are very "keyword stuffy" right now. Your "Education & Tips" page's URL is http://www.berneseoftherockies.com/colorado-bernese-mountain-dogs/ -- It should be something as simple as http://www.berneseoftherockies.com/education or http://www.berneseoftherockies.com/education-and-tips. Editing your URLs will mean 301 redirects are necessary. You're using Wordpress and there's a plugin called "Redirection" that works. I still prefer just editing the htaccess file manually. Some quick Google searches can tell you everything you need to know about 301 redirects.
Your overall site isn't that bad. You're using H1s and H2s. You have a lot of content. You're inserting images and some video. Do those 3 things above and you'll be much better off. Of course there's more you can do, but check out the Learn SEO link I shared in my previous comment. I can't go on forever 
First of all, I assume that by "using the keyword" you just simply mean an instance of it on the page somewhere. If you happen to be referring to the meta keywords tag, that's a whole other topic, but you shouldn't be using that meta tag.
Anyways, there is nothing wrong with using the keyword "gear oil" on multiple pages. Since there are different types of gear oils available, it's simply unavoidable, and Google understands this. Imagine you have a site about food, and on that site you have a lot of pages about pizzas. Pepperoni pizza, sausage pizza, sardine pizza, Hawaiian pizza, etc. In this scenario, it would be as if you're posting the same question as you did, but asking if it's okay that you used the keyword "pizza" on multiple pages. Of course that's okay 
The whiteboard Friday from a couple days ago actually discussed almost exactly what you're asking. You should definitely check it out: http://moz.com/blog/keyword-targeting-density-and-cannibalization-whiteboard-friday
When "noindex" is added to a page, does this ensure Google does not count page as part of their analysis of unique vs duplicate content ratio on a website? Yes, that will tell Google that you understand the pages don't belong in the index. They will not penalize your site for duplicate content if you're explicitly telling Google to noindex them.
Is there a chance that even though Google does not index these pages, Google will still see those pages and think "ah, these are duplicate MLS pages, we are going to let those pages drag down value of entire site and lower ranking of even the unique pages". No, there's no chance these will hurt you if they're set to noindex. That is exactly what the noindex tag is for. You're doing what Google wants you to do.
I like to just use "noindex, follow" on those MLS pages, but would it be safer to add pages to robots.txt as well and that should - in theory - increase likelihood Google will not see such MLS pages as duplicate content on my website? You could add them to your robots.txt but that won't increase your likelihood of Google not penalizing you because there is already no worry about being penalized for pages not being indexed.
On another note: I had these MLS pages indexed and 3-4 weeks ago added "noindex, follow". However, still all indexed and no signs Google is noindexing yet.....
Donna's advice is perfect here. Use the Remove URLs tool. Every time I've used the tool, Google has removed the URLs from the index in less than 12-24 hours. I of course made sure to have a noindex tag in place first. Just make sure you enter everything AFTER the TLD (.com, .net, etc) and nothing before it. Example: You'd want to ask Google to remove /mls/listing122 but not example.com/mls/listing122. The ladder will not work properly because Google automatically adds "example.com" to it (they just don't make this very clear).
It's a good idea to include your main keyword in the meta description because when Google does show your custom meta description, the keyword will be bold if it matches the search query.
However, keep in mind that meta descriptions do not help your rankings at all. Google announced this a while ago. Despite not helping rankings, meta descriptions are still useful because they may help increase click thru rates on the SERPs
Matt Cutts did a good video on meta descriptions back in November 2013: http://www.youtube.com/watch?v=W4gr88oHb-k
Yep! After you remove the URL or directory of URLs, there is a "Reinclude" button you can get to. You just need to switch your "Show:" view so it shows URLs removed. The default is to show URLs PENDING removal. Once they're removed, they will disappear from that view.
I'm not 100% sure Google will understand you if you leave off the slashes. I've always added them and have never had a problem, so you want to to type: /oahu/waianae-makaha-condos/
Typing that would NOT include the neighborhood URL, in your example. It will only remove everything that exists in the /waianae-makaha-condos/ folder (including that main category page itself).
edit >> To remove the neighborhood URL and everything in that folder as well, type /oahu/waianae-makaha/maili-condos/ and select the option for "directory".
edit #2 >> I just want to add that you should be very careful with this. You don't want to use the directory option unless you're 100% sure there's nothing in that directory that you want to stay indexed.
Yep. Just last week I had an entire website deindexed (on purpose, it's a staging website) by entering just / into the box and selecting directory. By the next morning the entire website was gone from the index 
It works for folders/directories too. I've used it many times.
Yep, you got it.
You can think of it exactly like Windows folders, if that helps you stay focused. If you have C:\Website\folder1 and C:\Website\folder12. "noindexing" \folder1\ would leave \folder12\ alone because they're not in the same directory.
Yes. It will remove /page-52 and EVERYTHING that exists in /oahu/honolulu/metro/waikiki-condos/. It will also remove everything that exists in /page-52/ (if anything). It trickles down as far as the folders in that directory will go.
**Go to Google search and type this in: **site:honoluluhi5.com/oahu/honolulu/metro/waikiki-condos/
That will show you everything that's going to be removed from the index.
Good find. I've never seen this part of the help section. Their resonating reason behind all of the examples seems to be "You don’t need to manually remove URLs; they will drop out naturally over time."
I have never had an issue, nor have I ever heard of anyone having an issue, removing URLs with the Removal Tool. I guess if you don't feel safe doing it, you can wait for Google's crawler to catch up, although it could take over a month. If you're comfortable waiting it out, have no reasons to rush it, AND feel like playing it super safe... you can disregard everything I've said 
We all learn something new every day!
Sounds like you should actually be using rel=next and rel=prev.
More info here: http://googlewebmastercentral.blogspot.com/2011/09/pagination-with-relnext-and-relprev.html
Curious... was your site apart of the MyBlogGuest.com network? They were recently taken down hard by Google.
Here's a recent Tweet from Matt Cutts stating that sites posting guest posts can receive manual penalties, not just sites that receive links from guest posts: https://twitter.com/mattcutts/statuses/446438659689316353
Your site does seem like pretty good quality, but the sole purpose of it appears to be for guest blogging opportunities. Someone manually reviewed it and decided it was penalty worthy... To be reconsidered you might need to either A) remove all the links or B) nofollow all the links. I'm not 100% sure if nofollowing is enough. You'll probably also want to start posting a lot more content that isn't guest blogs. You might be already doing that (I didn't look around for too long). Good luck, Aaron.
Hey BloggerGuy!
Your reference to "WP adapting theme" is actually called "responsive design." That is definitely a great way to go in regards to mobile. I could go on forever but this great write up (and accompanying video by Matt Cutts) already does a great job at explaining why responsive design is a good choice.
http://searchenginewatch.com/article/2308069/Googles-Matt-Cutts-Responsive-Design-Wont-Hurt-Your-SEO
Let me know if you have any specific questions after watching that video, and reading through SEW's take on it.
You can't have more than 1 author per page. If you put 10 rel=author tags on 1 page, I would assume that Google is just going to look at the first in the list. OR, Google may just entirely ignore it. They don't have to show a rich snippet, just because the rel=author code is there. It's up to them whether or not the author image shows in the SERP and if you've got 10 on 1 page, there's a chance Google might do something like this (Warning: F-bomb ahead!): http://www.quickmeme.com/img/78/788d7237ecca60d8d235cb352eab832f472264065a048fcd24adc834f0ca82f0.jpg
You could setup 301 redirects from the sold property URLs to another relevant page, like other properties available in the same neighborhood/town/city. Or possibly even to search result page that contains very similar properties in regards to square footage, bedrooms, baths, etc.