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

La-Z-Boy Furniture

Narrow By

Availability

Category

Features

Collection

Style

1,127 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='ZM16AFJNDJHJ8V4I6CEE5' 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
La-Z-Boy Furniture
000000002615
$2,409.99
51% OFF
$1,169.99

See in Store

La-Z-Boy Furniture
000000481883
$3,309.99
52% OFF
$1,599.99

See in Store

La-Z-Boy Furniture
000000070313
$3,969.99
51% OFF
$1,929.99

See in Store

La-Z-Boy Furniture
000000070312
$4,099.99
52% OFF
$1,979.99

See in Store

La-Z-Boy Furniture
000000526131
$2,929.99
52% OFF
$1,419.99

See in Store

La-Z-Boy Furniture
000000377895
$4,029.99
51% OFF
$1,959.99

See in Store

La-Z-Boy Furniture
000000377890
$1,629.99
52% OFF
$789.99

See in Store

La-Z-Boy Furniture
000000002522
$1,459.99
51% OFF
$709.99

See in Store

La-Z-Boy Furniture
000000002590
$4,239.99
51% OFF
$2,059.99

See in Store

La-Z-Boy Furniture
000000002621
$2,459.99
52% OFF
$1,189.99

See in Store

La-Z-Boy Furniture
000000073010
$3,259.99
52% OFF
$1,579.99

See in Store

La-Z-Boy Furniture
000000296521
$3,149.99
51% OFF
$1,529.99

See in Store

La-Z-Boy Furniture
000000377897
$3,629.99
52% OFF
$1,759.99

See in Store

La-Z-Boy Furniture
000000002625
$2,559.99
52% OFF
$1,239.99

See in Store

La-Z-Boy Furniture
000000002563
$1,839.99
52% OFF
$889.99

See in Store

La-Z-Boy Furniture
000000094390,000000141590
$1,279.99
52% OFF
$619.99

See in Store

La-Z-Boy Furniture
000000002539
$1,799.99
51% OFF
$879.99

See in Store

La-Z-Boy Furniture
000000070310
$2,169.99
52% OFF
$1,049.99

See in Store

La-Z-Boy Furniture
000000000071
$5,629.99
52% OFF
$2,729.99

See in Store

La-Z-Boy Furniture
000000000070
$5,629.99
52% OFF
$2,729.99

See in Store

La-Z-Boy Furniture
000000077751
$3,019.99
52% OFF
$1,459.99

See in Store

La-Z-Boy Furniture
000000002534
$1,779.99
52% OFF
$859.99

See in Store

La-Z-Boy Furniture
000000077750
$2,349.99
51% OFF
$1,139.99

See in Store

La-Z-Boy Furniture
000000002560
$1,629.99
52% OFF
$789.99

See in Store

La-Z-Boy Furniture
000000104100
$1,059.99
51% OFF
$519.99

See in Store

La-Z-Boy Furniture
000000389320
$1,339.99
51% OFF
$649.99

See in Store

La-Z-Boy Furniture
000000481882,000000481884
$3,489.99
52% OFF
$1,689.99
La-Z-Boy Furniture
000000000072
$4,999.99
52% OFF
$2,419.99
La-Z-Boy Furniture
000000270642
$3,689.99
51% OFF
$1,789.99
La-Z-Boy Furniture
000000070311
$1,649.99
52% OFF
$799.99
La-Z-Boy Furniture
000000000098
$2,209.99
52% OFF
$1,069.99
La-Z-Boy Furniture
000000220833
$1,119.99
52% OFF
$539.99
La-Z-Boy Furniture
000000220832
$2,169.99
52% OFF
$1,049.99
La-Z-Boy Furniture
000002170311
$2,249.99
52% OFF
$1,089.99
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

La-Z-Boy Furniture

Get Advice from Our Experts
(208) 743-8600

Our experts are here to help!Email Us
Questions?