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

England Furniture

Narrow By

Availability

Category

Features

Collection

Style

1,404 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='L1QKY7N0D7GTI4MYTWNPZ' 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
England Furniture
000000207729

See in Store

England Furniture
000000001813

See in Store

England Furniture
000000001812

See in Store

England Furniture
000000150130

See in Store

England Furniture
000000150170

See in Store

England Furniture
000000150160

See in Store

England Furniture
000000150180

See in Store

England Furniture
000000001838

See in Store

England Furniture
000000001831

See in Store

England Furniture
000000001836

See in Store

England Furniture
000000001833

See in Store

England Furniture
111420

See in Store

England Furniture
000000001844

See in Store

England Furniture
000000001849

See in Store

England Furniture
000000001820

See in Store

England Furniture
000000090960

See in Store

England Furniture
000000090970

See in Store

England Furniture
000000090980

See in Store

England Furniture
000000090950

See in Store

England Furniture
000000227731

See in Store

England Furniture
000000200910

See in Store

England Furniture
000000001860,000000227730

See in Store

England Furniture
000000161110

See in Store

England Furniture
000000243181

See in Store

England Furniture
000000256810

See in Store

England Furniture
000000207891

See in Store

England Furniture
000000207892

See in Store

England Furniture
000000227732

See in Store

England Furniture
000000172940
England Furniture
000000001847
England Furniture
2910-69
England Furniture
000000001840
England Furniture
3C04AL
England Furniture
6T00-SECT
England Furniture
2R05
England Furniture
000000001811
England Furniture
7130-06,7130-27,7130-05,7130-43,7130-22
England Furniture
4635L+4636L
England Furniture
2Y05N
England Furniture
2B04ALN
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

England Furniture