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

Rocker / Recliners

Narrow By

Availability

Features

Brand

Collection

Style

1,973 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,
									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 AND fc.active='1')
								JOIN furniture_categories AS fsc ON (f.sub_category_u_id = fsc.u_id AND fsc.active='1')
								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 fsc.u_id LIKE 'XINNMM2QQ2L5MTR44SRTC'
								          
								 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, 15
La-Z-Boy Furniture
000000077750

See in Store

Ultra Comfort
000000003229

See in Store

Ultra Comfort
000000003228

See in Store

La-Z-Boy Furniture
000000185670

See in Store

La-Z-Boy Furniture
000000002563

See in Store

La-Z-Boy Furniture
000000185434

See in Store

Stressless
000000001796

See in Store

Ultra Comfort
000000003224

See in Store

Design 2 Recline
000000393090

See in Store

Design 2 Recline
000000355960

See in Store

Design 2 Recline
000000198170

See in Store

Ultra Comfort
000000205430

See in Store

Design 2 Recline
000000003108

See in Store

La-Z-Boy Furniture
000000003396

See in Store

Benchcraft
000000041451

See in Store

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

Rocker / Recliners

Recliners are truly man’s best friend! With so many options on today’s recliners it can be tough to only choose one. Wall hugger recliners, full chaise recliners, rocker recliners in leather, microfiber, and fabric. Lift recliners are also a great gift for older parents. Some recliners even come with massage or heat to help you relax even more. So pick out a recliner or two for your home and find your relaxation.