Wright Furniture & Flooring Shop Furniture Locally in Hannibal, MO | Howard's Furniture » | Waters Furniture »
Wright Furniture & Flooring Tagline
Phone Icon
Wright Furniture Open Today 9:00 AM - 8:00 PM
Howards Budget Open Today 9:00 AM - 5:30 PM

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

Kenroy Home

Narrow By

Features

1 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='XDYNUHZ71BEOXXZNJ6GMT' 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
Showing All Items For This Category
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Kenroy Home

Powered by creativity and a love for transforming houses into beautiful living spaces, Kenroy Home is rewriting the rules, challenging the status quo, and reimagining a new model of home décor solutions. One that brings together the perfect balance of form, function, and inspiration under one company, one roof, one Kenroy Home. Technology has evolved many of the pleasures and complexities of modern life, from the way we absorb music and television to on-demand transportation services, everything is just a bit easier, we believe designing your home and making truly unique living experiencing should be no different. By rethinking the experience from floor to ceiling and everything in between, we’ve designed a truly remarkable home design experience. By giving home owners access to Kenroy Home’s extensive selection of luxurious lighting designs, intricately crafted mirrors, sustainably sourced tables, and environmentally conscious outdoor solar lights, we’re ensuring that every Kenroy Home designed product under your roof upholds the values of cohesive and inspired design, craftsmanship, and quality that we created under our roof. WE MADE THIS FOR YOU All of you. From luxury estates to first time apartment dwellers, our line of creative lighting and home décor solutions are designed to comfortably match you with up-to-date styles and design trends regardless of where you find yourself on life’s journey. Kenroy Home is committed to providing luxurious living experiences at extraordinary values, we believe the high-end of interior design and outdoor living should never be out of reach to hardworking homeowners. Kenroy Home’s team of insanely talented designers and product engineers dream far outside of the prescribed consensus; we believe you’re unique, and so is your home. Our team rebels against the idea of cookie cutter lighting designs or dull and uninspired “builder lighting”. With individualism as a core value and design philosophy, Kenroy Home’s designers create works of art from daring and avant garde chandeliers to glamourous and traditionally inspired bath vanity lighting, we never forget that we design products for individuals…for your home. WE CHANGE THINGS Kenroy Home exists because we believe each room in your house has a soul, has a purpose – and when change happens, we’ll be there each step of the way with premiere lighting designs and beautiful home décor. While change isn’t always easy, to help our customers find the right products for their lifestyle and living situation Kenroy Home provides award winning customer service support along with a library of design and home décor advice from more than 100 interior design experts. Putting it all under one roof, from warm chandeliers over the dining room table to soft and cozy lamps in the living room…Kenroy Home is helping to shine a light on what’s really important.