Special Offers

Showing 1–6 of 67 results

6
6
12
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] => 
            [static] => 
            [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] => 67
            [filter] => raw
        )

    [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] => 15273
                    [post_author] => 4
                    [post_date] => 2019-09-20 16:20:22
                    [post_date_gmt] => 2019-09-20 15:20:22
                    [post_content] => White Round Table with Silver Trumpet Bass & 3 Green chairs
                    [post_title] => White Round Table with Silver Trumpet Bass & 3 Green chairs
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => white-round-table-with-silver-trumpet-bass-3-green-chairs
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2019-09-20 16:21:22
                    [post_modified_gmt] => 2019-09-20 15:21:22
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=15273
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => 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 chair for taking your back health seriously and our used Aeron 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.

Graphite Herman Miller Aeron Chair From £1030 RRP

Aeron Chair Features

  • Herman Miller Aeron Chair
  • Graphite mesh
  • Size B
  • Adjustable padded arms
  • Fully refurbished
  • Available with lumbar support at £325 +VAT
  • 12 Month Warranty
[post_title] => Herman Miller Aeron Designer Office Chair in Graphite / Mesh. 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] => 2019-09-23 11:49:45 [post_modified_gmt] => 2019-09-23 10:49:45 [post_content_filtered] => [post_parent] => 0 [guid] => http://79.170.44.83/newcityused.com/?post_type=product&p=291 [menu_order] => 2 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 14859 [post_author] => 4 [post_date] => 2019-08-17 14:13:19 [post_date_gmt] => 2019-08-17 13:13:19 [post_content] => This Orangebox Do Task Chair Silver is the perfect stylish addition to any work space. Fully adjustable therefore ideal for maintaining optimum back health.

Features

  • Castors / Glides: Black, 50mm hard tyre, free-wheel castors on task chairs & black, fixed glides on counter-height chairs.
  • Base: 26 inch black nylon with removable collar to aid recycling.
  • Gas lift: Black, powder coated steel barrel on task chairs with black extra-height lift & foot-ring fitted to counter-height chairs.
  • Mechanism: Synchronous & weight balancing action with up to 20 deg of recline.
  • Non locking to encourage movement throughout the day.
[post_title] => Orangebox Do Task Designer Office Chair, Mesh Back. Swivel, Adjustable Height (Silver Mesh / White Rear) [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => orangebox-do-task-chair-silver [to_ping] => [pinged] => [post_modified] => 2019-09-20 15:50:40 [post_modified_gmt] => 2019-09-20 14:50:40 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=14859 [menu_order] => 6 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 9490 [post_author] => 4 [post_date] => 2018-08-09 12:17:39 [post_date_gmt] => 2018-08-09 11:17:39 [post_content] => Orangebox chairs are designed and made in the UK and the adaptable "Do" chair is a fresh new take on chair design, using innovative materials and a clever user-generated design and a weight balancing mechanism. The Orangebox Do chair provides simple, comfortable and intuitive seating, ideal for stylish offices.

Features

  • Castors / Glides: Black, 50mm hard tyre, free-wheel castors on task chairs & black, fixed glides on counter-height chairs.
  • Base: 26 inch black nylon with removable collar to aid recycling.
  • Gas lift: Black, powder coated steel barrel on task chairs with black extra-height lift & foot-ring fitted to counter-height chairs.
  • Mechanism: Synchronous & weight balancing action with up to 20 deg of recline.
  • Non locking to encourage movement throughout the day.
£99 EACH  WHEN YOU BUY 20 OR MORE OF THEM. £125 EACH WHEN YOU BUY UNDER 20 OF THEM. [post_title] => Orangebox Do Task Designer Office Chair, Mesh Back. Swivel, Adjustable Height (Black Mesh / White Rear) [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => orangebox-do-task-chair [to_ping] => [pinged] => [post_modified] => 2019-09-20 15:50:02 [post_modified_gmt] => 2019-09-20 14:50:02 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9490 [menu_order] => 9 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 14826 [post_author] => 4 [post_date] => 2019-08-07 13:21:29 [post_date_gmt] => 2019-08-07 12:21:29 [post_content] => This Ergohuman Plus Mesh Operator Chair is the ideal high end chair to provide comfort, maintain optimum back health and is a stylish addition to any work space

Features: 

  • Advanced aluminium mechanism and frame
  • Seat inclination adjustment
  • Eco-friendly - 98% of the Ergohuman Plus chair is made with recyclable materials.
  • Features Advanced aluminium mechanism
  • Seat Height Control
  • Seat Depth Adjustment
  • Seat Inclination Adjustment (Seat Tilt)
  • Backrest Tilt Tension Control
  • Backrest Tilt Angle Adjustment
  • Backrest Height Adjustment
  • Headrest Height & Angle Adjustment
[post_title] => Ergohuman Flex Mesh High Back Operator Office Chair With Arms, Headrest [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => ergohuman-plus-mesh-operator-chair [to_ping] => [pinged] => [post_modified] => 2019-09-21 13:27:41 [post_modified_gmt] => 2019-09-21 12:27:41 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=14826 [menu_order] => 12 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 6084 [post_author] => 117 [post_date] => 2017-08-30 11:26:32 [post_date_gmt] => 2017-08-30 10:26:32 [post_content] => VERCO Graphite Salt and Pepper Chair VERCO was founded in 1912 and is known for it's quality.
  • Mesh back that wraps around your back
  • Durable arm pads
  • Think foam seat-pad
  • 5 star base
  • Height adjustable
  • Back lock
  • Great Price
VERCO Graphite Salt and Pepper Chair Is the perfect ergonomic chair for keeping your back health in check.
Lower Price when bought in bulk. Lower Price when bought with desk. Other furniture in different styles, colours and sizes available. Matching range of furniture options available. Feel free to call us on 01244 389111 if you have questions about this product. [post_title] => Verco Salt N Pepper Task / Office Chair in Graphite, With Arms, Wheels [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => verco-blue-salt-and-pepper-chair [to_ping] => [pinged] => [post_modified] => 2019-09-21 12:57:57 [post_modified_gmt] => 2019-09-21 11:57:57 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6084 [menu_order] => 13 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 6 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 15273 [post_author] => 4 [post_date] => 2019-09-20 16:20:22 [post_date_gmt] => 2019-09-20 15:20:22 [post_content] => White Round Table with Silver Trumpet Bass & 3 Green chairs [post_title] => White Round Table with Silver Trumpet Bass & 3 Green chairs [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => white-round-table-with-silver-trumpet-bass-3-green-chairs [to_ping] => [pinged] => [post_modified] => 2019-09-20 16:21:22 [post_modified_gmt] => 2019-09-20 15:21:22 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=15273 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 67 [max_num_pages] => 12 [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] => cd1087414dff453a1c32218c86a6cb3e [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 ) )