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

Crestview Collection

Narrow By

Availability

Category

Features

Collection

2,597 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='N5WEDKTYPD62N3Q3353MZ' 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
Crestview Collection
000000135280

See in Store

Crestview Collection
000000135220

See in Store

Crestview Collection
000000001655

See in Store

Crestview Collection
000000001656

See in Store

Crestview Collection
000000001657

See in Store

Crestview Collection
000000135160

See in Store

Crestview Collection
000000135170

See in Store

Crestview Collection
000000135190

See in Store

Crestview Collection
000000135200

See in Store

Crestview Collection
000000135740

See in Store

Crestview Collection
000000135750

See in Store

Crestview Collection
000000135230
Crestview Collection
000000135260
Crestview Collection
CVA3456
Crestview Collection
CVCHE652
Crestview Collection
CVA3386
Crestview Collection
CVFZR1248
Crestview Collection
CVAVP093
Crestview Collection
CVA3387
Crestview Collection
CVAVP107
Crestview Collection
CVFZR1227
Crestview Collection
CVFZR1250
Crestview Collection
CVFNR301
Crestview Collection
CVFZR1258
Crestview Collection
CVFZR1257
Crestview Collection
CVAP1747
Crestview Collection
CVTCK1134
Crestview Collection
CVFNR414
Crestview Collection
CVFNR468
Crestview Collection
CVFNR467
Crestview Collection
CVFZR4104
Crestview Collection
CVFNR406
Crestview Collection
CVFZR4047
Crestview Collection
CVFZR1507
Crestview Collection
CVAVP916
Crestview Collection
CVAVP917
Crestview Collection
CVA3895
Crestview Collection
CVA3896
Crestview Collection
CVTMR1688
Crestview Collection
CVTOP2430
Crestview Collection
CVTWA1445
Crestview Collection
CVTWA1452
Crestview Collection
CVTWA1458
Crestview Collection
CVA3834
Crestview Collection
CVDEP902
Crestview Collection
CVVSA1003
Crestview Collection
CVAER946
Crestview Collection
CVTCK1132
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Crestview Collection