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 Accessories

Narrow By

Availability

Category

Features

Brand

Style

10,061 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 '8Y3R93HZZNKLIRKLXRM37'
								          
								 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
000000001441

See in Store

Coaster Furniture
000000071580

See in Store

Signature Design by Ashley
000000053390

See in Store

Ashley Furniture
000000053360

See in Store

Signature Design by Ashley
000000053370

See in Store

Coaster Furniture
000000001596

See in Store

Coaster Furniture
000000001600

See in Store

Ashley Furniture
000000357510

See in Store

Crestview Collection
000000001655

See in Store

International Furniture Direct
000000180710

See in Store

Coaster Furniture
000000055920

See in Store

IMAX
000000002347

See in Store

International Furniture Direct
000000002175
Signature Design by Ashley
D596-00
Ashley Furniture
R401051
Ashley Furniture
R401062
Ashley Furniture
R401061
Ashley Furniture
R402202
Signature Design by Ashley
R401762
Ashley Furniture
R401142
Ashley Furniture
R400692
Ashley Furniture
R403002
Ashley Furniture
R401992
Ashley Furniture
R402342
Ashley Furniture
R402241
Signature Design by Ashley
R400271
Signature Design by Ashley
R400471
Signature Design by Ashley
R400111
Signature Design by Ashley
R400211
Signature Design by Ashley
R400011
Signature Design by Ashley
R400432
Ashley Furniture
R402742
Signature Design by Ashley
R400512
Ashley Furniture
R401952
Ashley Furniture
R401662
Ashley Furniture
R401402
Ashley Furniture
R401522
Ashley Furniture
R402702
Ashley Furniture
R402221
Ashley Furniture
R401431
Ashley Furniture
R400312
Ashley Furniture
R401672
Signature Design by Ashley
R316002
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button