This American company has managed to turn back the hands of time with their traditional rugs. Quintessential American-style braided designs are found with Colonial Mills Area rugs. Discover traditional colors and patterns in addition to braided products featuring newer colors and designs. Choose from an abundance of designs suitable for any home or cottage. Drawing from history - and time tested rug craftsmanship these rugs are as close to Americana as you can possibly get.
SELECT DISTINCT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`cost`, `e`.`weight`, `e`.`meta_title`, `e`.`meta_keyword`, `e`.`meta_description`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`media_gallery`, `e`.`old_id`, `e`.`tier_price`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`gallery`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`url_path`, `e`.`minimal_price`, `e`.`visibility`, `e`.`custom_design_from`, `e`.`custom_design_to`, `e`.`custom_layout_update`, `e`.`required_options`, `e`.`has_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`created_at`, `e`.`updated_at`, `e`.`enable_googlecheckout`, `e`.`gift_message_available`, `e`.`price_type`, `e`.`sku_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`samples_title`, `e`.`links_title`, `e`.`special`, `e`.`featured`, `e`.`product_month`, `e`.`top_sellers`, `e`.`shape`, `e`.`shape_value`, `e`.`brand`, `e`.`brand_value`, `e`.`collection_name`, `e`.`collection_sku`, `e`.`collection_style`, `e`.`color_display`, `e`.`color_vendor`, `e`.`construction`, `e`.`construction_value`, `e`.`construction_description`, `e`.`country`, `e`.`country_value`, `e`.`description_1`, `e`.`designer`, `e`.`designer_value`, `e`.`discount`, `e`.`in_depth`, `e`.`map_price`, `e`.`material`, `e`.`material_value`, `e`.`material_description`, `e`.`msrp`, `e`.`product_category_number`, `e`.`product_length`, `e`.`product_width`, `e`.`promo_message1`, `e`.`promo_message2`, `e`.`promo_message3`, `e`.`ship_cost`, `e`.`ship_date`, `e`.`ship_height`, `e`.`ship_length`, `e`.`ship_weight`, `e`.`ship_width`, `e`.`size_actual`, `e`.`size_navigation`, `e`.`size_navigation_value`, `e`.`size_shape_msg`, `e`.`sku_pad`, `e`.`special_search`, `e`.`style_main`, `e`.`style_main_value`, `e`.`style_vendor`, `e`.`upc_code`, `e`.`upsell_sku`, `e`.`vendor_number`, `e`.`date_sku_updated`, `e`.`style`, `e`.`landing_pg_url`, `e`.`image_url_feed`, `e`.`product_type`, `e`.`condition`, `e`.`condition_value`, `e`.`max_bid`, `e`.`style_vendor_descr`, `e`.`description_medium`, `e`.`feature_1`, `e`.`feature_2`, `e`.`feature_3`, `e`.`feature_4`, `e`.`feature_5`, `e`.`seo_text1`, `e`.`use_as_default_similar`, `e`.`volume_weight`, `e`.`collection_name_val`, `e`.`style_vendor_descr_val`, `e`.`price_val`, `e`.`color_content`, `e`.`is_recurring`, `e`.`recurring_profile`, `e`.`links_exist`, `e`.`related_targetrule_position_limit`, `e`.`related_targetrule_position_behavior`, `e`.`upsell_targetrule_position_limit`, `e`.`upsell_targetrule_position_behavior`, `e`.`discontinued`, `e`.`round`, `e`.`runner`, `e`.`closeup`, `e`.`rooms`, `e`.`rejected`, `e`.`front_rooms`, `e`.`brand_room`, `e`.`oval`, `e`.`octagon`, `e`.`rooms_blacklisted`, `e`.`square`, `e`.`small_image_x`, `e`.`small_image_y`, `e`.`exclude_by_sku`, `e`.`parent`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`collection_style`, `e`.`collection_name`, `e`.`promo_message1`, `e`.`description_1`, `e`.`promo_message2`, `e`.`brand`, `e`.`brand_value`, `e`.`style`, `e`.`exclude_by_sku`, IF(a.position is not null,a.position, 9999) AS `root_position`, `e`.`collection_style`, `e`.`collection_name`, `e`.`promo_message1`, `e`.`description_1`, `e`.`promo_message2`, `e`.`brand`, `e`.`brand_value`, `e`.`style`, `e`.`exclude_by_sku` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='10'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `catalog_category_product_index` AS `cat_filter` ON cat_filter.product_id=e.entity_id AND cat_filter.store_id='1' AND cat_filter.visibility IN(2, 4)
INNER JOIN `catalog_product_index_eav` AS `brand_idx` ON brand_idx.entity_id = e.entity_id AND brand_idx.attribute_id = '510' AND brand_idx.store_id = '1' AND brand_idx.value in (31)
LEFT JOIN `catalog_category_product` AS `a` ON a.product_id=e.entity_id AND a.category_id=25 WHERE (exclude_by_sku != 1) AND (e.collection_name_val = 'collection-14') AND (e.style_vendor_descr_val = 'cb97') GROUP BY `e`.`entity_id` ORDER BY `root_position` asc, `cat_index_position` asc, `cat_index`.`product_id` asc LIMIT 28
- Colonial Mills
