• 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] => FLS0307788
                            [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] => FLS0307788
                            [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] => FLS0307788
                            [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] => FLS0307788
                            [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 = 'FLS0307788' ) 
  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] => 102b68cc13ef4e4c981a2bf9142daafa
    [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
        )

)

Roxie Twins, Set of 2

Chelsea House

$549.70

Chat with a live agent

A pair of dogs inspired by the Staffordshire antiques. These lovely animals come as a pair in a variety of colors. Note the attention to detail that reflects the finest of Staffordshire dogs where the front foot is separated from the body. Designed by Shayla Copas.

9.00 in

6.50 in

5.00 lbs

4.25 in

384946

Chelsea House

Pink, White, Metallic Gold

1-2 Weeks

Ships via Factory-Direct

SKU: FLS0307788 Category: 
Array
(
    [0] => shaylacopas_519470
)

Shop The Collection

About This Brand

chelseaHouse Shop All This Brand's Products

Chelsea House blends timeless design with vibrant, joyful colors and high-quality materials to create statement-making furniture and accessories. Since 1974, this family-owned company has been known for its craftsmanship and design leadership, offering a curated selection of furniture, lighting, art, mirrors, and decor. Focused on creating spaces with authentic character and elegance, Chelsea House is a trusted partner for designers and homeowners seeking unique, handcrafted pieces that bring both style and warmth to any room.