• Product Image
  • Product Image
  • 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] => FLS0540759
                            [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] => FLS0540759
                            [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] => FLS0540759
                            [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] => FLS0540759
                            [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 = 'FLS0540759' ) 
  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] => 2036f90e9e2f1ff4add0c9ecea9a0bb9
    [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
        )

)

Ramsey Accent Mirror

Surya

$630.00

Chat with a live agent

Bring modern style to your home with the Ramsey Mirror. This 32″ mirror is made of high-quality manufactured wood, and can be hung vertically or horizontally depending on your preference. Perfect for any room in your house, the Ramsey Mirror will add a touch of luxury to any wall. With easy maintenance and cleaning, simply wipe the mirror with a dry cloth to keep it looking its best. Add a contemporary feel to your living space with this stylish mirror today!

39.00 in

30.50 in

40.50 lbs

RMS-5800

Surya

Clear

Wood

Rectangle

4-6 Weeks

Ships via Factory-Direct

: Request A Sample

SKU: FLS0540759 Category:

About This Brand

surya Shop All This Brand's Products

Surya is one of the furniture industry’s most recognized manufacturers of area rugs and home accessories. For over 35 years, the name Surya has been synonymous with high quality, innovation and luxury. Surya designers and weavers masterfully create some of the most versatile products to bring out the best in every room. Encompassing an expert understanding of the latest trends in fashion and interior design, each Surya product is a perfect combination of color, pattern and texture to accommodate the widest range of tastes. With a Surya rug or home decor accessory, you aren’t just selecting a floor covering or a piece of art – you are making a fashion statement that will last you a lifetime.