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

Best

Narrow By

Availability

Category

Features

Collection

Style

459 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='OSW3M924I0THSRNVSODZL' 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
Best
000000340150

See in Store

Best
000000340151

See in Store

Best
000000340153

See in Store

Best
0036-22626+4080-22626
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Best

In 1962, two men turned their chair expertise into a yet unknown empire. In a small rented building the two covered all aspects of the business for quite some time. Over 55 years later, Best Chairs has surpassed all expectations becoming Best Home Furnishings, a name adopted to further describe the entire product line. Family owned and operated, our facilities cover over 1,100,000 square feet in five locations with nearly 1,000 employees and is growing to become one of the largest furniture manufacturers in the world. The company's success story began with a very simple theme: make the best quality product at the most affordable price. While the Best Home Furnishings of today no longer resembles the Best Chairs of yesterday, one thing has remained constant: our commitment to quality and the total satisfaction of our customers. Best's product selection has grown to hundreds of different styles all available in over a thousand diverse cover selections made to order in days, not weeks. Learn about the five pillars of success that make Best Home Furnishings truly, one of the best. WE ARE BEST HOME FURNISHINGS.