Showroom Now Open. Learn More | Also available by Private Appointment. Call us to learn more. To track a status of an order email us at
Wagner's Furniture & Design | Wagner's Mattress 1st - Missoula, MT
Wagner's Furniture Tagline
Phone Icon

Welcome to

Welcome to Wagner's Furniture

Get updates on our latest styles & savings!

We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.

No Thanks

Wesley Hall

Narrow By





Chaises Remove Sort Item
Curios Remove Sort Item
Fireplaces Remove Sort Item
Futons Remove Sort Item
Living Room Remove Sort Item
Living Room Chairs Remove Sort Item
Loveseats Remove Sort Item
Occasional Tables Remove Sort Item
Ottomans Remove Sort Item
Rocker / Recliners Remove Sort Item
Sectionals Remove Sort Item
Sleeper Sofas Remove Sort Item
Sofas Remove Sort Item
354 Items
(SELECT f.u_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.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,
								FROM furniture AS f
								JOIN AS mf ON ((f.u_id = mf.u_id AND f.on_display='0' AND'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'1' AND f.expired='0' AND'1' AND fb.expired='0' AND fb.u_id='G5JM17DKYA2BZU1CPTB7C' AND'1' AND'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
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Wesley Hall