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

Philip Reinisch Company

Narrow By

Availability

Features

Collection

57 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='PC3Q0I0Y0LTWH5IQWCIUU' 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
Philip Reinisch Company
000000003006

See in Store

Philip Reinisch Company
000000003007
Philip Reinisch Company
15982
Philip Reinisch Company
10041
Philip Reinisch Company
25685
Philip Reinisch Company
45951
Philip Reinisch Company
48958
Philip Reinisch Company
62254
Philip Reinisch Company
62257
Philip Reinisch Company
62258
Philip Reinisch Company
62151
Philip Reinisch Company
62182
Philip Reinisch Company
15951
Philip Reinisch Company
15987
Philip Reinisch Company
11482
Philip Reinisch Company
98657
Philip Reinisch Company
98654
Philip Reinisch Company
98658
Philip Reinisch Company
98662
Philip Reinisch Company
47162
Philip Reinisch Company
14351
Philip Reinisch Company
13282
Philip Reinisch Company
90751
Philip Reinisch Company
58282
Philip Reinisch Company
58251
Philip Reinisch Company
98862
Philip Reinisch Company
98857
Philip Reinisch Company
98858
Philip Reinisch Company
98854
Philip Reinisch Company
70062
Philip Reinisch Company
70688
Philip Reinisch Company
54951
Philip Reinisch Company
54982
Philip Reinisch Company
54551
Philip Reinisch Company
54582
Philip Reinisch Company
48957
Philip Reinisch Company
48954
Philip Reinisch Company
81579
Philip Reinisch Company
81279
Philip Reinisch Company
11051
Philip Reinisch Company
33680
Philip Reinisch Company
74151
Philip Reinisch Company
25593
Philip Reinisch Company
75058
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Philip Reinisch Company