Sylvan Furniture Sells Furniture & Mattresses in Lewiston, ID
Sylvan Furniture Tagline
Phone Icon

Welcome to

Welcome to Sylvan Furniture


Get updates on our latest styles & savings!

Coupon

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

No Thanks

Magnussen Home

Narrow By

Availability

Category

Features

Collection

Style

949 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='LB0BASS661KMUZ9R1LXVE' 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
Magnussen Home
000000334155

See in Store

Magnussen Home
000000334154

See in Store

Magnussen Home
000000334158

See in Store

Magnussen Home
000000334169

See in Store

Magnussen Home
000000334168

See in Store

Magnussen Home
B1398-65,B1398-01,B1398-10,B1398-22,B1398-36,B1398-40
Magnussen Home
B3561- PINE HILL
Magnussen Home
B4281-13
Magnussen Home
B4398-13
Magnussen Home
B4399-13
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Magnussen Home

Ingwer Magnussen founded our company in 1931, in the town of Kitchener, Ontario. A cabinetmaker by trade and a craftsman and businessman at heart, Ingwer took the bold step of starting his own company when he was unable to find work during the Great Depression. Serving Canadian upholstery manufacturers, he created beautiful, intricately carved show wood for sofa frames, earning a reputation that allowed his young business to grow into a good-sized company. Over the years, Magnussen Home has continued to grow, expanding to become a global enterprise. Yet, we have maintained the core principles of a family-run business - trust, honesty and respect - as the foundation of our success. Richard Magnussen, Ingwer's son, joined the company in 1970 at the age of 20. Focused on growing and expanding the family business, Richard guided Magnussen Furniture to the position of Canada's largest occasional table supplier. Building on this success, he founded Presidential Furniture, a division of Magnussen Furniture, in 1986, to serve the U.S. market. Trading as Magnussen-Presidential Furniture, the company kept a keen eye on detail and nurtured a corporate culture based on understanding its customers, as it became one of the most progressive occasional furniture suppliers in North America. As the 20th Century came to a close, furniture manufacturers around the world began tapping into a huge growth opportunity. Among the first to take advantage of this opportunity, Magnussen-Presidential Furniture started importing from Asia in the late 1980s, a decade before this trend caught on in the broader furniture trade. The relationships, infrastructure and skills we developed during this ten-year period empowered us to provide our customers with beautifully designed, high quality, high value furnishings, delivered in lead times and at service levels that are unrivalled in the industry. In 2002, Magnussen-Presidential Furniture became Magnussen Home. The addition of "Home" reflects who we are and what we offer as a company: fine furniture, designed for today's lifestyles and created by a family of craftsmen from around the world, to enhance the most important rooms in your home.