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

Ashley Furniture

BOGO

Narrow By

Availability

Category

Features

Collection

Style

6,083 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='R2OLCACI3S4M1KR2C9S6X' 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
Ashley Furniture
000000134370

See in Store

Ashley Furniture
000000134300

See in Store

Millenium
000000001203

See in Store

Millenium
000000001210

See in Store

Millenium
290510

See in Store

Millenium
000000001217

See in Store

Millenium
000000001204

See in Store

Ashley Furniture
290420

See in Store

Millenium
000000001212

See in Store

Millenium
000000001213

See in Store

Signature Design by Ashley
000000003373

See in Store

Signature Design by Ashley
000000001232

See in Store

Ashley Furniture
000000175660

See in Store

Signature Design by Ashley
000000001363

See in Store

Signature Design by Ashley
000000001365

See in Store

Ashley Furniture
000000175650

See in Store

Signature Design by Ashley
000000001228

See in Store

Signature Design by Ashley
000000001230

See in Store

Ashley Furniture
000000133861

See in Store

Signature Design by Ashley
000000001407

See in Store

Signature Design by Ashley
000000001047

See in Store

Signature Design by Ashley
000000001046

See in Store

Ashley Furniture
000000252324

See in Store

Ashley Furniture
000000133860

See in Store

Ashley Furniture
000000001408

See in Store

Ashley Furniture
000000287940

See in Store

Ashley Furniture
000000287920

See in Store

Ashley Furniture
000000287970

See in Store

Signature Design by Ashley
000000003362

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

Signature Design by Ashley
000000001361

See in Store

Ashley Furniture
000000001402

See in Store

Ashley Furniture
000000001263

See in Store

Ashley Furniture
000000001266

See in Store

Ashley Furniture
253269

See in Store

Ashley Furniture
000000349229

See in Store

Ashley Furniture
000000349228

See in Store

Ashley Furniture
000000349227

See in Store

Signature Design by Ashley
000000001085

See in Store

Signature Design by Ashley
000000001086

See in Store

Signature Design by Ashley
000000001084

See in Store

Signature Design by Ashley
000000001087

See in Store

Ashley Furniture
335230

See in Store

Ashley Furniture
000000349226

See in Store

Ashley Furniture
000000252322

See in Store

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

Ashley Furniture