• Product Image
  • 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] => FLS0539797
                            [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] => FLS0539797
                            [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] => FLS0539797
                            [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] => FLS0539797
                            [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 = 'FLS0539797' ) 
  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] => 019caedb2dfd70ad395450125edce660
    [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
        )

)

Pirouette Full Length Mirror

Surya

$1,795.00

Chat with a live agent

This Pirouette Mirror is the perfect way to add a modern touch to your home. Featuring a full-length, oversized 63? size, this mirror can be hung either vertically or horizontally and is crafted from durable brass. Made in India and easy to maintain with a simple wipe clean with a dry cloth. Whether you hang it in an entryway, bedroom or bathroom, this mirror will provide an eye-catching addition to any space. Transform your home today with this stunning Pirouette Mirror!

80.40 in

20.00 in

34.30 lbs

PUE001-2080

Surya

Gold

Brass, Wood

Rectangle

4-6 Weeks

Ships via Factory-Direct

: Request A Sample

SKU: FLS0539797 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.