I've always thought that having duplicate content within a site is a bad thing for SEO. However, after doing some research I found that Google doesn't have a penalty for having duplicate content and the only downside is how links are shown in the search engines.
So my question is, If i have the product page under www.example.com/products/walls/product-page.html and www.example.com/products/floors/product-page.html will this have a negative effect on my rankings?
As the product page is relevant to both walls and floors, it makes sense to have them under separate URLs.