Special Offers

Showing 1–6 of 44 results

6
6
8
SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (1534)
			) 
  AND 
  wp_term_relationships.term_taxonomy_id IN (21)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 6
WP_Query Object
(
    [query] => Array
        (
            [product_cat] => special-offers
        )

    [query_vars] => Array
        (
            [product_cat] => special-offers
            [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] => 
            [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
                (
                )

            [orderby] => menu_order title
            [order] => ASC
            [meta_query] => Array
                (
                )

            [tax_query] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => product_visibility
                            [field] => term_taxonomy_id
                            [terms] => Array
                                (
                                    [0] => 1534
                                )

                            [operator] => NOT IN
                        )

                )

            [wc_query] => product_query
            [posts_per_page] => 6
            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [post_type] => 
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => product_cat
            [term] => special-offers
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [relation] => AND
                    [0] => Array
                        (
                            [taxonomy] => product_visibility
                            [terms] => Array
                                (
                                    [0] => 1534
                                )

                            [field] => term_taxonomy_id
                            [operator] => NOT IN
                            [include_children] => 1
                        )

                    [1] => Array
                        (
                            [taxonomy] => product_cat
                            [terms] => Array
                                (
                                    [0] => special-offers
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

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

            [queried_terms] => Array
                (
                    [product_cat] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => special-offers
                                )

                            [field] => slug
                        )

                )

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

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                )

            [relation] => 
            [meta_table] => 
            [meta_id_column] => 
            [primary_table] => 
            [primary_id_column] => 
            [table_aliases:protected] => Array
                (
                )

            [clauses:protected] => Array
                (
                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [queried_object] => WP_Term Object
        (
            [term_id] => 21
            [name] => Special Offers
            [slug] => special-offers
            [term_group] => 0
            [term_taxonomy_id] => 21
            [taxonomy] => product_cat
            [description] => 
            [parent] => 0
            [count] => 44
            [filter] => raw
            [term_order] => 0
        )

    [queried_object_id] => 21
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (1534)
			) 
  AND 
  wp_term_relationships.term_taxonomy_id IN (21)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 6
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 18218
                    [post_author] => 324
                    [post_date] => 2020-04-02 13:23:34
                    [post_date_gmt] => 2020-04-02 12:23:34
                    [post_content] => 4 Drawer Side Filer - Oak Top

Lockable

Excellent Condition

Filing bars not included
                    [post_title] => 4 Drawer Side Filer - Oak Top
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => 4-drawer-side-filer-oak-top
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2020-04-02 14:14:12
                    [post_modified_gmt] => 2020-04-02 13:14:12
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18218
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 18232
                    [post_author] => 324
                    [post_date] => 2020-04-03 11:18:12
                    [post_date_gmt] => 2020-04-03 10:18:12
                    [post_content] => Allermuir Designer Stool

Excellent Condition

£39 each

White & Slate
                    [post_title] => Allermuir Designer Stool
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => allermuir-designer-stool
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2020-04-03 11:18:12
                    [post_modified_gmt] => 2020-04-03 10:18:12
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18232
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [2] => WP_Post Object
                (
                    [ID] => 18205
                    [post_author] => 324
                    [post_date] => 2020-04-01 15:16:08
                    [post_date_gmt] => 2020-04-01 14:16:08
                    [post_content] => FlexiForm 4 Drawer Filing Cabinet

Average Condition

Some Keys Missing
                    [post_title] => FlexiForm 4 Drawer Filing Cabinet
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => flexiform-4-drawer-filing-cabinet
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2020-04-01 15:16:08
                    [post_modified_gmt] => 2020-04-01 14:16:08
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18205
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [3] => WP_Post Object
                (
                    [ID] => 18225
                    [post_author] => 324
                    [post_date] => 2020-04-03 11:05:23
                    [post_date_gmt] => 2020-04-03 10:05:23
                    [post_content] => Senator Bar Stool

Red leather seat pad

Excellent condition

£40 Each

 
                    [post_title] => Senator Bar Stool
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => senator-bar-stool
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2020-04-03 11:19:08
                    [post_modified_gmt] => 2020-04-03 10:19:08
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18225
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [4] => WP_Post Object
                (
                    [ID] => 18239
                    [post_author] => 324
                    [post_date] => 2020-04-03 16:11:24
                    [post_date_gmt] => 2020-04-03 15:11:24
                    [post_content] => White Poseur Table & Designer Chair Package

Senator Designer Stools

Excellent Condition

Fantastic Price

Won't be around for long !
                    [post_title] => White Poseur Table & Designer Chair Package
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => white-poseur-table-designer-chair-package
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2020-04-03 16:11:40
                    [post_modified_gmt] => 2020-04-03 15:11:40
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18239
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [5] => WP_Post Object
                (
                    [ID] => 291
                    [post_author] => 2
                    [post_date] => 2015-06-17 10:12:16
                    [post_date_gmt] => 2015-06-17 09:12:16
                    [post_content] => Looking for a used Aeron chair? The Herman Miller Aeron Is the perfect ergonomic office chair for taking your back health seriously and our used Aeron mesh chairs are excellent value too.

When designers Bill Stumpf and Don Chadwick set out to create a chair that was health-positive, cross-performing, inclusively-sized and environmentally sensitive, they arrived at a design unlike the world had ever seen.

Aeron demonstrated a pioneering step in ergonomics and material innovation, and provided a comfortable solution without the standard use of foam, fabric or leather. It changed people’s perception of what an office chair could be, and in doing so it soon found a place in popular culture.

Features - Herman Miller Aeron

  • Used, in excellent condition (refurbished)
  • Herman Miller Aeron Mesh Office Chair
  • Graphite mesh
  • Size B
  • Adjustable padded arms
  • Fully refurbished
  • Available with lumbar support at £350 +VAT
  • 12 Month Warranty
  • 4 different versions available:  1. No lumber support or forward tilt.  2. With lumber support / no forward tilt.  3. With forward tilt / no lumber.  4. With forward tilt and lumber support.
Used / Second Hand Herman Miller Aeron Mesh Office Chair, Fully Adjustable, Ergonomic, Size B City Office Furniture offer a wide range of quality office chairs.  This is a superb quality Herman Miller Aeron mesh office chair, which is fully adjustable with arms and a swivel base. Buy quality new and  used / second hand mesh office chairs from City Used Office Furniture.  We have UK showrooms in Chester, Hull and Harlow and can deliver within a 50 mile radius of these locations. Free local delivery and installation is available within a 50 mile radius of our branch showrooms. Some exclusions may apply and be subject to  a minimum order charge of £250. Please contact us for further details [post_title] => Herman Miller Aeron Mesh Office Chair, Fully Adjustable, Ergonomic, Size B [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => herman-miller-aeron-designer-office-chair-graphite-mesh-size-b [to_ping] => [pinged] => [post_modified] => 2020-03-30 10:24:13 [post_modified_gmt] => 2020-03-30 09:24:13 [post_content_filtered] => [post_parent] => 0 [guid] => http://79.170.44.83/newcityused.com/?post_type=product&p=291 [menu_order] => 5 [post_type] => product [post_mime_type] => [comment_count] => 1 [filter] => raw ) ) [post_count] => 6 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 18218 [post_author] => 324 [post_date] => 2020-04-02 13:23:34 [post_date_gmt] => 2020-04-02 12:23:34 [post_content] => 4 Drawer Side Filer - Oak Top Lockable Excellent Condition Filing bars not included [post_title] => 4 Drawer Side Filer - Oak Top [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 4-drawer-side-filer-oak-top [to_ping] => [pinged] => [post_modified] => 2020-04-02 14:14:12 [post_modified_gmt] => 2020-04-02 13:14:12 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18218 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 44 [max_num_pages] => 8 [max_num_comment_pages] => 0 [is_single] => [is_preview] => [is_page] => [is_archive] => 1 [is_date] => [is_year] => [is_month] => [is_day] => [is_time] => [is_author] => [is_category] => [is_tag] => [is_tax] => 1 [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_privacy_policy] => [is_404] => [is_embed] => [is_paged] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_posts_page] => [is_post_type_archive] => [query_vars_hash:WP_Query:private] => 5a61f31a0dbf11c4b5853996f3500e64 [query_vars_changed:WP_Query:private] => 1 [thumbnails_cached] => [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 ) )