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

Liberty Furniture

Narrow By

Availability

Category

Features

Collection

Style

1,532 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='BIFGIV5OBH3IQ9AEEOIPO' 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
Liberty Furniture
000000002676

See in Store

Liberty Furniture
000000002666

See in Store

Liberty Furniture
000000002665

See in Store

Liberty Furniture
000000048430

See in Store

Liberty Furniture
000000092710

See in Store

Liberty Furniture
000000092700

See in Store

Liberty Furniture
000000092720

See in Store

Liberty Furniture
000000092730

See in Store

Liberty Furniture
000000092690

See in Store

Liberty Furniture
000000058540

See in Store

Liberty Furniture
000000058530

See in Store

Liberty Furniture
000000003386

See in Store

Liberty Furniture
000000036310

See in Store

Liberty Furniture
000000036260

See in Store

Liberty Furniture
000000036350

See in Store

Liberty Furniture
000000036340

See in Store

Liberty Furniture
000000036250

See in Store

Liberty Furniture
000000036330

See in Store

Liberty Furniture
000000002650

See in Store

Liberty Furniture
000000002649

See in Store

Liberty Furniture
000000263970

See in Store

Liberty Furniture
000000002669

See in Store

Liberty Furniture
000000002667

See in Store

Liberty Furniture
000000002668

See in Store

Liberty Furniture
000000048470

See in Store

Liberty Furniture
000000048450

See in Store

Liberty Furniture
000000048480

See in Store

Liberty Furniture
000000002672

See in Store

Liberty Furniture
000000002673

See in Store

Liberty Furniture
000000002671

See in Store

Liberty Furniture
000000002670

See in Store

Liberty Furniture
000000058570

See in Store

Liberty Furniture
000000058560

See in Store

Liberty Furniture
000000002646

See in Store

Liberty Furniture
000000058620

See in Store

Liberty Furniture
000000002680

See in Store

Liberty Furniture
000000002660

See in Store

Liberty Furniture
000000002661

See in Store

Liberty Furniture
000000002662

See in Store

Liberty Furniture
000000002656

See in Store

Liberty Furniture
000000002654

See in Store

Liberty Furniture
000000002655

See in Store

Liberty Furniture
000000002679

See in Store

Liberty Furniture
000000002677

See in Store

Liberty Furniture
000000002678

See in Store

Liberty Furniture
000000002652

See in Store

Liberty Furniture
000000002653

See in Store

Liberty Furniture
000000263830

See in Store

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

Liberty Furniture