Deets Home Store - Shop Furniture Locally In Norfolk, NE
Deets Home Store Tagline
Phone Icon
Home Store Open Today 10:00 AM - 6:00 PM
Budget Store Open Today 10:00 AM - 6:00 PM

Welcome to

Welcome to Deets Home Store!


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

Beds

Narrow By

Features

Brand

Collection

Style

860 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
International Furniture Direct
International Furniture Direct
International Furniture Direct
International Furniture Direct
International Furniture Direct
Catalog Loader
Loading More Items
Showing All Items For This Category
Back To Top Button

Beds

Your Bed is the center piece of your bedroom furniture, and will distinguish your style from the moment you enter the room. Beds come in all different styles from contemporary, transitional, traditional or casual. Choose from sleigh beds, different styles of headboards, footboards, and platform beds to make your Bedroom your dream room.

Get Advice from Our Experts
(402) 371-7679

Our experts are here to help!
(402) 371-1174

Our experts are here to help!
Email Us