Save $25 when you sign up for emails

Enter your email below and receive a coupon for $25 off with no minimum purchase! Plus, you will receive email exclusive coupons, special offers and more from Deets Home Store!

Sign Up »
No Thanks

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

Deets Furniture Store & Mattresses Norfolk, NE - 402-371-7679
|
|
|
Just the Best!
(402) 371-7679
Store Hours: Mon. - Wed., Fri. 10am - 6pm | Thu. 10am - 8pm | Sat. 10am - 5pm | Sun. Closed
Flooring
Living Room
Bedroom
Dining
Home Office
Entertainment
Accessories
Outdoor Furniture
Mattresses
»
»
Beds

Beds

 

Narrow By

Availability

Category

Features

Upholstery

Brand

Collection

Style

465 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' 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 fb.active='1' AND fb.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.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 '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
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button
Back To Top Button
Powered By KnorrWeb