Wright Furniture & Flooring Shop Furniture Locally in Hannibal, MO | Howard's Furniture » | Waters Furniture »
Wright Furniture & Flooring Tagline
Phone Icon
Wright Furniture Closed Today
Howards Budget Closed Today

Welcome to

Welcome to Wright Furniture & Flooring


Get updates on our latest styles & savings!

We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.

No Thanks

Dalyn

Narrow By

Features

1,181 Items
(SELECT f.u_id, 
									f.id,
									IF(f.display_title = '', f.title, f.display_title) AS title, 
									IF(f.retail_sku = '', f.brand_sku, f.retail_sku) AS public_sku, 
									IF(f.on_display = '1', '1', '0') AS available,						
									f.page,
									f.display_price AS price,
									f.sale_price AS sale_price,
									f.sale_price_start AS sale_price_start,
									f.sale_price_end AS sale_price_end,
									f.msrp_price AS msrpPrice,
									f.ecommerce_enabled_item AS ecommerce_enabled,
									IF(fb.display_title = '', fb.title, fb.display_title) AS b_title,
									IF(sb.display_title='', sb.title, sb.display_title) AS sbtitle,
									fb.title AS origTitle,
									fb.hide_brand_name AS hideAbrand,
									fc.folder AS c_f,
									fsc.folder AS sc_f,								
									'furniture/' AS catalog_folder,
									'furniture' AS rtable,
									f.display_order
								FROM furniture AS f
								JOIN knorrweb_NEWcatalog.furniture AS mf ON ((f.u_id = mf.u_id AND f.on_display='0' AND mf.active='1' AND mf.expired='0') OR (f.u_id = mf.u_id AND f.on_display='1'))
								JOIN furniture_brands AS fb ON f.brand_u_id = fb.u_id
								LEFT JOIN furniture_brands sb ON f.sub_brand_u_id=sb.u_id
								JOIN furniture_categories AS fc ON f.category_u_id = fc.u_id
								JOIN furniture_categories AS fsc ON f.sub_category_u_id = fsc.u_id
								LEFT JOIN item_store_location AS isl ON f.u_id = isl.i_uid
								WHERE f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND fb.u_id='TS7RPS1X12BWL28F21ALF' AND fc.active='1' AND fsc.active='1'
								         
								 AND ((f.u_id NOT IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages)) OR (f.u_id IN (SELECT DISTINCT child_item FROM knorrweb_NEWcatalog.furniture_packages WHERE hide='0'))) 
								GROUP BY u_id)
								ORDER BY available DESC, available DESC, f.display_order = 0, f.display_order ASC, b_title ASC, title ASC
								LIMIT 0, 48
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Dalyn

For more than thirty years, Dalyn Rug Company has been manufacturing an extensive range of rugs that offer a wide variety of textures, colors and styles to meet the design needs of today’s style conscious, sophisticated homeowners. It all began in 1979, when Bill and Judy Adams saw a need for beautiful rugs at an affordable price. To this day, Dalyn is committed to offering expertly-crafted, design-forward rugs that are affordable and of great value. From the very start Dalyn has deliberately worked, not to be the largest, but to be the best rug company in the industry. With this in mind, the foundation of Dalyn is based on the integrity of its employees, our commitment to service, and the expectation of quality. We benchmark our company as a trustworthy, “can-do”, easy-to-work-with partner to our many valued customers. When it comes to working with Dalyn, the beauty goes way beyond the surface. Today, Dalyn offers rugs in four primary categories, machine woven, hand-tufted, printed and custom. All of which exceed our customers high expectations in design and affordability. In addition, through the years, we have perfected the art and process of custom rug manufacturing. In fact, Dalyn is the world’s largest manufacturer of custom rugs. We offer over 450 colors, 150 designs and all available in an astonishing three-week turn time. This is just another way for Dalyn to show its beauty beyond the surface.