Flexsteel Furniture

Arrange By

Narrow By

Availability

See In Store

New Arrivals

Store Location

Wagner's Furniture & Design

Features

Collection

Alden

Astra

Bay Bridge

Bellingham

Bexley

Bradstreet

Bryant

Carmen

Carpenter

Clive

Comfort Zone

Cute

Dana

Daphne

Dempsey

Devon

Digby

Equestrian

Farrier

Flemington

Hunter

Huron

Jupiter

Kingman

Kube

Lakewood

Latitudes

Lennox

Main Street

Markham

Martin

Nash

Orion

Parkway

Patterson

Patton

Plaza

Plymouth

Poppy

Port Royal

Serendipity

Spencer

Theodore

Thornton

Triton

Vail

Venture

West

Westside

Whistler

Winston

Woodstock

Zevon

Style

Casual

Classic

Contemporary

Traditional

Transitional

Chaises

Curios

Fireplaces Remove Sort Item

Futons

Living Room Remove Sort Item

Living Room Chairs Remove Sort Item

Loveseats

Occasional Tables Remove Sort Item

Ottomans

Rocker / Recliners Remove Sort Item

Sectionals Remove Sort Item

Sleeper Sofas Remove Sort Item

Sofas

727 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='RVW42WCG2VYA3KQ7O8NLZ' AND fc.active='1' AND fsc.active='1'
								  AND (f.sub_category_u_id='YELP3TBEGFLPAK9ABACSE' OR f.sub_category_u_id='TYMOEP6BV1PN8URMLB2GD' OR f.sub_category_u_id='Q8JLZSPK7OAVLDKJSRR8E' OR f.sub_category_u_id='XINNMM2QQ2L5MTR44SRTC' OR f.sub_category_u_id='ITZAS1YNTLLOICTES53T7' OR f.sub_category_u_id='IADHKOXO177BU9SP0MPL9' OR f.sub_category_u_id='XEF1VU06IJM49MJ1WMCUP' OR f.sub_category_u_id='N91G8BVZ24E4U1R4TIX6G' OR f.sub_category_u_id='C9PJT6LOZL4MMAODG8Q2F' OR f.sub_category_u_id='SV74LQV6W4UT77O5AAPRV' OR f.sub_category_u_id='8NAHEEL8VFQTRCJREGJV5' OR f.sub_category_u_id='7CHL2VH1XV5MGYIG27XPK' OR f.sub_category_u_id='ES4DTYRENHLYX6SDCWEGB')        
								 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