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

International Furniture Direct

Narrow By

Availability

Category

Features

Collection

Style

522 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='YW78IG5SDGV8D7U6A26Q6' 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
International Furniture Direct
000000002176

See in Store

International Furniture Direct
000000002177

See in Store

International Furniture Direct
000000002179

See in Store

International Furniture Direct
000000002181

See in Store

International Furniture Direct
290550

See in Store

International Furniture Direct
000000002175

See in Store

International Furniture Direct
000000002165

See in Store

International Furniture Direct
000000002170

See in Store

International Furniture Direct
000000002171

See in Store

International Furniture Direct
290700

See in Store

International Furniture Direct
000000002174

See in Store

International Furniture Direct
000000002144

See in Store

International Furniture Direct
000000002139

See in Store

International Furniture Direct
000000002140

See in Store

International Furniture Direct
000000002141

See in Store

International Furniture Direct
000000077320

See in Store

International Furniture Direct
000000077310

See in Store

International Furniture Direct
000000077315

See in Store

International Furniture Direct
000000159280

See in Store

International Furniture Direct
000000002182

See in Store

International Furniture Direct
000000002185

See in Store

International Furniture Direct
IFD965CONS-MD

See in Store

International Furniture Direct
000000180720

See in Store

International Furniture Direct
000000172390

See in Store

International Furniture Direct
000000002142

See in Store

International Furniture Direct
000000158620

See in Store

International Furniture Direct
000000172360

See in Store

International Furniture Direct
290600

See in Store

International Furniture Direct
000000158630

See in Store

International Furniture Direct
000000158610

See in Store

International Furniture Direct
000000172400

See in Store

International Furniture Direct
000000002187

See in Store

International Furniture Direct
000000180710

See in Store

International Furniture Direct
000000274520

See in Store

International Furniture Direct
000000002149

See in Store

International Furniture Direct
000000002166

See in Store

International Furniture Direct
000000002145

See in Store

International Furniture Direct
000000002146

See in Store

International Furniture Direct
000000002189

See in Store

International Furniture Direct
000000002190

See in Store

International Furniture Direct
IFD560STAND-76
International Furniture Direct
000000002184
International Furniture Direct
IFD966ARMOIRE
International Furniture Direct
IFD967CHAIR-MC
International Furniture Direct
000000002167
International Furniture Direct
IFD968TABLE-B
International Furniture Direct
IFD370PLTFRM-Q
International Furniture Direct
IFD370HDBD-Q
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Artisan Home