Sign-up & Save

Enter your email below and receive email exclusive coupons, special offers and more from Doerr Furniture Store & Mattresses!

Sign Up »
No Thanks

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

Doerr Furniture Store & Mattress - New Orleans, LA
|
|
|
(504) 947-0606

Doerr Furniture Supports WWNO Radio
Proud Underwriter for WWNO

Doerr Furniture Supports WWNO Radio
American Express 2016 Member Favorite
Store Hours: Mon. - Fri. 10am to 6pm | Sat. 10am - 5pm | Sun. Noon to 5pm
Living Room
Bedroom
Dining Room
Entertainment
Home Office
Accents
Rugs
Mattresses
»
»
Beds

Beds

 

Narrow By

Availability

Category

Features

Brand

Collection

Style

1,033 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.msrp_price AS msrpPrice,
								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
							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' AND mf.group_item='0')
								OR (f.u_id = mf.u_id AND f.on_display='1' AND mf.group_item='0'))
							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 fsc.u_id LIKE 'V5YSPAYVC8X47YV6W3E47'
							       
							GROUP BY 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.msrp_price AS msrpPrice,
								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							
							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 fsc.u_id LIKE 'V5YSPAYVC8X47YV6W3E47'
							      
							GROUP BY id)
							ORDER BY available DESC, available DESC, display_order = 0, display_order ASC, brand_display_priority ASC, b_title ASC, title ASC
							LIMIT 0, 48
Fine Furniture Design
Display Flag
Fine Furniture Design
Display Flag
Fine Furniture Design
Display Flag
Durham Furniture
Display Flag
Durham Furniture
Display Flag
Durham Furniture
Display Flag
Durham Furniture
Display Flag
Daniel's Amish Collection
Display Flag
Daniel's Amish Collection
Display Flag
Vaughan Bassett
Display Flag
Vaughan Bassett
Display Flag
Vaughan Bassett
Display Flag
Vaughan Bassett
Display Flag
Vaughan Bassett
Display Flag
Vaughan Bassett
Display Flag
Vaughan Bassett
Display Flag
Kincaid Furniture
Display Flag
Wesley Allen
Display Flag
Wesley Allen
Display Flag
Wesley Allen
Display Flag
Wesley Allen
Display Flag
Wesley Allen
Display Flag
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Fine Furniture Design
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
Durham Furniture
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
(888) 869-4308

Our experts are here to help!
(504) 943-0110

Our experts are here to help!