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

Flexsteel Furniture

Narrow By

Availability

Category

Features

Collection

Style

721 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='RVW42WCG2VYA3KQ7O8NLZ' 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
Flexsteel Furniture
000000203000

See in Store

Flexsteel Furniture
000000202950

See in Store

Flexsteel Furniture
000000202870

See in Store

Flexsteel Furniture
000000202890

See in Store

Flexsteel Furniture
000000202980

See in Store

Flexsteel Furniture
000000202960

See in Store

Flexsteel Furniture
000000202970

See in Store

Flexsteel Furniture
000000203010

See in Store

Flexsteel Furniture
000000202990

See in Store

Flexsteel Furniture
000000202910

See in Store

Flexsteel Furniture
000000202900

See in Store

Flexsteel Furniture
000000202930

See in Store

Flexsteel Furniture
000000202850
Flexsteel Furniture
6625-069,6625-06B
Flexsteel Furniture
5979-28, 5979-33,
Flexsteel Furniture
6629-02
Flexsteel Furniture
W1526-793
Flexsteel Furniture
5979-20
Flexsteel Furniture
6693-02
Flexsteel Furniture
6693-04
Flexsteel Furniture
1418-62PH
Flexsteel Furniture
1418-54PH
Flexsteel Furniture
1659-64PH
Flexsteel Furniture
1659-62PH
Flexsteel Furniture
1418-64PH
Flexsteel Furniture
1418-60PH
Flexsteel Furniture
6612-07
Flexsteel Furniture
5990-20
Flexsteel Furniture
1179-62PH
Flexsteel Furniture
1179-64PH
Flexsteel Furniture
1179-54PH
Flexsteel Furniture
1594-50PH
Flexsteel Furniture
1226-54PH
Flexsteel Furniture
1251-54PH
Flexsteel Furniture
1568-50PH
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Flexsteel Furniture