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

Shop All Living Room

Narrow By

Availability

Category

Features

Brand

Style

8,955 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,
									f.sub_category_u_id,
									'furniture/' AS catalog_folder,
									'furniture' AS rtable,
									f.display_order,
									f.brand_display_priority
								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
								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 fc.active = 1 AND fc.u_id LIKE 'YELP3TBEGFLPAK9ABACSE'
								          
								 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.brand_display_priority = 0, f.brand_display_priority ASC, f.display_order = 0, f.display_order ASC, b_title ASC, title ASC
								LIMIT 0, 48
Bassett
000000001469

See in Store

Bassett
000000297340

See in Store

Bassett
000000001448

See in Store

Bassett
000000001449

See in Store

Bassett
000000001430

See in Store

Bassett
000000001427

See in Store

Bassett
000000001433

See in Store

Bassett
000000001428,000000001429

See in Store

Bassett
000000001456

See in Store

Bassett
000000001479

See in Store

Bassett
000000297380

See in Store

Bassett
000000297290

See in Store

La-Z-Boy Furniture
000000296520

See in Store

Southern Motion
000000281920

See in Store

Signature Design by Ashley
000000001386

See in Store

Signature Design by Ashley
000000001384

See in Store

England Furniture
000000207729

See in Store

England Furniture
000000001813

See in Store

England Furniture
000000001812

See in Store

La-Z-Boy Furniture
000000002590

See in Store

Ashley Furniture
000000287940

See in Store

Signature Design by Ashley
000000001360

See in Store

Signature Design by Ashley
000000001357

See in Store

Signature Design by Ashley
000000001358

See in Store

Signature Design by Ashley
000000001359

See in Store

Ashley Furniture
000000287920

See in Store

Ashley Furniture
000000287970

See in Store

England Furniture
000000090960

See in Store

England Furniture
000000090970

See in Store

England Furniture
000000090980

See in Store

England Furniture
000000090950

See in Store

Southern Motion
000000003108

See in Store

Signature Design by Ashley
000000027650

See in Store

Signature Design by Ashley
000000027660

See in Store

England Furniture
000000001838

See in Store

England Furniture
000000001831

See in Store

England Furniture
000000001836

See in Store

England Furniture
000000001833

See in Store

Ashley Furniture
000000252325

See in Store

Ashley Furniture
000000252324

See in Store

Jackson
000000136810

See in Store

Jackson
000000136800

See in Store

La-Z-Boy Furniture
000000002578

See in Store

La-Z-Boy Furniture
000000002581

See in Store

La-Z-Boy Furniture
000000002579

See in Store

Southern Motion
000000198150

See in Store

Signature Design by Ashley
000000001047

See in Store

Signature Design by Ashley
000000001046

See in Store

Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button