• Product Image
  • Product Image
  • Product Image
  • Product Image
  • Product Image
  • Product Image
  • Product Image
  • Thumbnail
  • Thumbnail
  • Thumbnail
  • Thumbnail
  • Thumbnail
  • Thumbnail
  • Thumbnail
                WP_Query Object
(
    [query] => Array
        (
            [author] => 0
            [post_type] => projects
            [posts_per_page] => 1
            [meta_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [key] => sku_projects
                            [value] => FLS0257450
                            [compare] => =
                        )

                    [1] => Array
                        (
                            [key] => parent_type
                            [value] => favorite
                            [compare] => =
                        )

                )

        )

    [query_vars] => Array
        (
            [author] => 0
            [post_type] => projects
            [posts_per_page] => 1
            [meta_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [key] => sku_projects
                            [value] => FLS0257450
                            [compare] => =
                        )

                    [1] => Array
                        (
                            [key] => parent_type
                            [value] => favorite
                            [compare] => =
                        )

                )

            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [paged] => 0
            [meta_key] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [search_columns] => Array
                (
                )

            [flrt_query_hash] => f1e3dc787ba733fa1cdf1c598273c574
            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [update_menu_item_cache] => 
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [order] => DESC
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                )

            [queried_terms] => Array
                (
                )

            [primary_table] => wp_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [key] => sku_projects
                            [value] => FLS0257450
                            [compare] => =
                        )

                    [1] => Array
                        (
                            [key] => parent_type
                            [value] => favorite
                            [compare] => =
                        )

                    [relation] => AND
                )

            [relation] => AND
            [meta_table] => wp_postmeta
            [meta_id_column] => post_id
            [primary_table] => wp_posts
            [primary_id_column] => ID
            [table_aliases:protected] => Array
                (
                    [0] => wp_postmeta
                    [1] => mt1
                )

            [clauses:protected] => Array
                (
                    [wp_postmeta] => Array
                        (
                            [key] => sku_projects
                            [value] => FLS0257450
                            [compare] => =
                            [compare_key] => =
                            [alias] => wp_postmeta
                            [cast] => CHAR
                        )

                    [mt1] => Array
                        (
                            [key] => parent_type
                            [value] => favorite
                            [compare] => =
                            [compare_key] => =
                            [alias] => mt1
                            [cast] => CHAR
                        )

                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
					 WHERE 1=1  AND ( 
  ( wp_postmeta.meta_key = 'sku_projects' AND wp_postmeta.meta_value = 'FLS0257450' ) 
  AND 
  ( mt1.meta_key = 'parent_type' AND mt1.meta_value = 'favorite' )
) AND ((wp_posts.post_type = 'projects' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.post_date DESC
					 LIMIT 0, 1
    [posts] => Array
        (
        )

    [post_count] => 0
    [current_post] => -1
    [before_loop] => 
    [in_the_loop] => 
    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 0
    [max_num_pages] => 0
    [max_num_comment_pages] => 0
    [is_single] => 
    [is_preview] => 
    [is_page] => 
    [is_archive] => 
    [is_date] => 
    [is_year] => 
    [is_month] => 
    [is_day] => 
    [is_time] => 
    [is_author] => 
    [is_category] => 
    [is_tag] => 
    [is_tax] => 
    [is_search] => 
    [is_feed] => 
    [is_comment_feed] => 
    [is_trackback] => 
    [is_home] => 1
    [is_privacy_policy] => 
    [is_404] => 
    [is_embed] => 
    [is_paged] => 
    [is_admin] => 
    [is_attachment] => 
    [is_singular] => 
    [is_robots] => 
    [is_favicon] => 
    [is_posts_page] => 
    [is_post_type_archive] => 
    [query_vars_hash:WP_Query:private] => a40fd10237a24706795222e7c421d6a4
    [query_vars_changed:WP_Query:private] => 1
    [thumbnails_cached] => 
    [allow_query_attachment_by_filename:protected] => 
    [stopwords:WP_Query:private] => 
    [compat_fields:WP_Query:private] => Array
        (
            [0] => query_vars_hash
            [1] => query_vars_changed
        )

    [compat_methods:WP_Query:private] => Array
        (
            [0] => init_query_flags
            [1] => parse_tax_query
        )

)

Shiloh Dresser

Aspenhome

$787.00

Chat with a live agent

Easy Care – Add premier coverage and free White Glove delivery*.
  • Easy care offers five (5) full years of protection from item’s delivery date.
  • With Easy Care, get accidental protection for stains, damages, and structural failures.
  • Add Easy Care for FREE White Glove delivery on qualified orders*.

Learn More

This transitional style bedroom collection comes in a natural Champagne finish complimented by hardware in a soft aged bronze finish. Enjoy elegant, rounded legs and details reminiscent of beloved mid-century designs with features and so much more.

  • Felt Lined Top Drawers: The beautiful premium felt lining helps protect delicate items and reduces movement of objects while opening and closing the drawer.
  • Cedar Lined Bottom Drawers: Known for its pleasant aroma, cedar absorbs unwanted odors and wards off moths, making it a perfect material to store seasonal linens and clothing!
  • Dovetail Joinery: A construction technique that will ensure long-lasting strength and durability.
  • Full Extension, Steel Ball Bearing Drawer Slides: Premium full extension, steel ball bearing drawer slides provide quiet, smooth and reliable drawer function. The low friction steel slides are designed to withstand daily use.

36.00 in

62.00 in

186.00 lbs

I430-453

Aspenhome

Neutral

Wood

2-4 Weeks

Ships via White Glove Delivery

SKU: FLS0257450 Category: 
Array
(
    [0] => shiloh_504200
)

Shop The Collection

About This Brand

aspenhome Shop All This Brand's Products

Aspenhome offers stylish, affordable furniture for every room—designed to enhance how you work, relax, and live at home. With award-winning designs and thoughtful features like built-in power, lighting, and hidden storage, each piece combines function, comfort, and lasting value to fit today’s modern lifestyle.