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 Dining Room

Narrow By

Availability

Category

Features

Brand

Style

2,081 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 'Q5V9VADJGAQ3QT8TNZF59'
								          
								 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
Fusion Designs
000000001916

See in Store

Fusion Designs
000000244510

See in Store

Fusion Designs
000000153810

See in Store

Signature Design by Ashley
000000001232

See in Store

Signature Design by Ashley
000000277070,000000277090

See in Store

Signature Design by Ashley
000000001228

See in Store

Signature Design by Ashley
000000001230

See in Store

Coaster Furniture
000000071560

See in Store

Coaster Furniture
000000071600

See in Store

Intercon
000000002450

See in Store

International Furniture Direct
000000159280

See in Store

Porter Designs
000000335979

See in Store

Winners Only
000000087919

See in Store

Winners Only
000000087920

See in Store

Winners Only
000000087930

See in Store

Fusion Designs
000000001918

See in Store

Coaster Furniture
000000130860

See in Store

Coaster Furniture
000000071490

See in Store

Coaster Furniture
000000071480

See in Store

International Furniture Direct
000000002176

See in Store

International Furniture Direct
000000002177

See in Store

International Furniture Direct
000000002179

See in Store

Ashley Furniture
000000001223

See in Store

Ashley Furniture
000000263250

See in Store

Ashley Furniture
000000295900

See in Store

Signature Design by Ashley
000000001224

See in Store

Signature Design by Ashley
000000001225

See in Store

Intercon
000000277460

See in Store

Winners Only
000000003308

See in Store

Winners Only
000000003307

See in Store

Winners Only
000000277250

See in Store

Winners Only
000000003306

See in Store

International Furniture Direct
000000051490

See in Store

Signature Design by Ashley
000000001235

See in Store

Ashley Furniture
000000277060

See in Store

Ashley
000000001218

See in Store

Ashley
000000001219

See in Store

Crestview Collection
000000135200

See in Store

Coaster Furniture
000000055860

See in Store

Coaster Furniture
000000055910

See in Store

Coaster Furniture
000000055870

See in Store

Coaster Furniture
000000055900

See in Store

Stressless
000000245290

See in Store

International Furniture Direct
000000274520

See in Store

International Furniture Direct
000000321161

See in Store

Stressless
000000245300

See in Store

Signature Design by Ashley
000000034420

See in Store

Crestview Collection
000000001656

See in Store

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