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

Bedgear, LLC

Narrow By

Availability

Features

197 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='KBDDIFY6XTE5HI41A1O02' 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
Bedgear, LLC
000000002027

See in Store

Bedgear, LLC
000000114820

See in Store

Bedgear, LLC
000000002025

See in Store

Bedgear, LLC
000000002031

See in Store

Bedgear, LLC
000000002047

See in Store

Bedgear, LLC
000000002063

See in Store

Bedgear, LLC
000000002068

See in Store

Bedgear, LLC
000000132830,000000132840

See in Store

Bedgear, LLC
000000002059

See in Store

Bedgear, LLC
000000002060

See in Store

Bedgear, LLC
000000002061

See in Store

Bedgear, LLC
000000132060

See in Store

Bedgear, LLC
000000132230

See in Store

Bedgear, LLC
000000132240

See in Store

Bedgear, LLC
000000132260

See in Store

Bedgear, LLC
000000002062

See in Store

Bedgear, LLC
000000002028

See in Store

Bedgear, LLC
000000002037

See in Store

Bedgear, LLC
000000002055

See in Store

Bedgear, LLC
000000002012

See in Store

Bedgear, LLC
000000154540

See in Store

Bedgear, LLC
000000002014

See in Store

Bedgear, LLC
000000002051

See in Store

Bedgear, LLC
000000002052

See in Store

Bedgear, LLC
000000002045

See in Store

Bedgear, LLC
000000002048

See in Store

Bedgear, LLC
000000002032

See in Store

Bedgear, LLC
000000002036

See in Store

Bedgear, LLC
000000002054

See in Store

Bedgear, LLC
000000002066

See in Store

Bedgear, LLC
000000172140

See in Store

Bedgear, LLC
000000172130

See in Store

Bedgear, LLC
000000172120

See in Store

Bedgear, LLC
000000132740

See in Store

Bedgear, LLC
000000187770

See in Store

Bedgear, LLC
000000171930

See in Store

Bedgear, LLC
000000171920

See in Store

Bedgear, LLC
000000002070

See in Store

Bedgear, LLC
000000002009

See in Store

Bedgear, LLC
000000002010

See in Store

Bedgear, LLC
000000189700

See in Store

Bedgear, LLC
000000187650

See in Store

Bedgear, LLC
000000270240

See in Store

Bedgear, LLC
000000046890

See in Store

Bedgear, LLC
000000002011

See in Store

Bedgear, LLC
000000002017

See in Store

Bedgear, LLC
000000002042

See in Store

Bedgear, LLC
000000002043

See in Store

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

Bedgear, LLC