Don't Miss A thing

Be the first to hear about Wagner's Home Furnishings
News, Sales & Exclusive Offers

Join Our Mailing List Now!

Sign Up »

We will never sell your information. Opt-Out anytime. See store for details.

Wagner's Home Furnishings & Wagner's Mattress 1st - Missoula, MT
|
|
|
Because Home Should be the Nicest Place you Ever Go!
406-728-3214
Store Hours: Mon. - Fri. 9:30 AM - 5:30 PM | Sat. 9:30 AM - 5:00 PM
Living Room
Dining Room
Home Office
Entertainment
Accessories
Bedroom
Mattresses
»
»
Chaises

Chaises

 

Narrow By

Availability

Features

Upholstery

Brand

Style

4 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, 
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,
									'furniture/' AS catalog_folder,
									'furniture' AS rtable,
									f.display_order,
									f.brand_display_priority
								FROM furniture AS f USE INDEX(u_id)
								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
								JOIN furniture_categories AS fc ON (f.category_u_id = fc.u_id AND fc.active='1')
								JOIN furniture_categories AS fsc ON (f.sub_category_u_id = fsc.u_id AND fsc.active='1')
								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 fsc.u_id LIKE 'IADHKOXO177BU9SP0MPL9'
								         
								GROUP BY u_id)
								UNION
								(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,
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,								
									'furniture/' AS catalog_folder,
									'furniture_ashley' AS rtable,
									f.display_order,
									f.brand_display_priority
								FROM furniture_ashley AS f USE INDEX(u_id)
								JOIN furniture_brands AS fb ON f.brand_u_id = fb.u_id
								JOIN furniture_categories AS fc ON (f.category_u_id = fc.u_id AND fc.active='1')
								JOIN furniture_categories AS fsc ON (f.sub_category_u_id = fsc.u_id AND fsc.active='1')
								LEFT JOIN item_store_location AS isl ON f.u_id = isl.i_uid
								WHERE f.images > 0 AND f.active='1' AND f.expired='0' AND fb.active='1' AND fb.expired='0' AND fsc.u_id LIKE 'IADHKOXO177BU9SP0MPL9'
								        
								GROUP BY u_id)
								ORDER BY available DESC, available DESC, brand_display_priority = 0, brand_display_priority ASC, display_order = 0, display_order ASC, b_title ASC, title ASC
								LIMIT 0, 48
Best

See in Store

Leathercraft Furniture
Leathercraft Furniture
Leathercraft Furniture
Showing All Items For This Category
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button
Back To Top Button
Powered By KnorrWeb
Get Advice from Our Experts
(406) 728-3214

Our experts are here to help!Email Us