Ahrend

Buy second hand / used Ahrend office furniture.

Showing all 3 results

3
3
1
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) LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_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 (2529)
) 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  wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC  LIMIT 0, 6
WP_Query Object
(
    [query] => Array
        (
            [product_cat] => office-furniture-brands/used-ahrend-office-furniture
        )

    [query_vars] => Array
        (
            [product_cat] => used-ahrend-office-furniture
            [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] => popularity
            [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] => used-ahrend-office-furniture
        )

    [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] => used-ahrend-office-furniture
                                )

                            [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] => used-ahrend-office-furniture
                                )

                            [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] => 2529
            [name] => Ahrend
            [slug] => used-ahrend-office-furniture
            [term_group] => 0
            [term_taxonomy_id] => 2529
            [taxonomy] => product_cat
            [description] => Buy second hand / used Ahrend office furniture.
            [parent] => 2495
            [count] => 3
            [filter] => raw
        )

    [queried_object_id] => 2529
    [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) LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_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 (2529)
) 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  wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC  LIMIT 0, 6
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 7148
                    [post_author] => 4
                    [post_date] => 2018-01-20 09:28:04
                    [post_date_gmt] => 2018-01-20 09:28:04
                    [post_content] => Ahrend Silver Desk High Tambour Cupboard 720x800mm.

Ahrend tambour door cabinets are an extremely high quality storage range. Their quality, meticulous finish and flexible layout possibilities mean that Ahrend tambour door cabinets are among the best on the market.

Thanks to the wide range of available height dimensions, colour possibilities and tops, Ahrend tambour door cabinets can be combined with all the Ahrend furniture ranges.

Features

  • 1 Adjustable shelf
  • Single sliding door to save space
  • Lockable provided with key, ideal for the new GDPR laws
  • Silver finish wood top
  • Adjustable feet with 20mm range
  • Steel welded carcass with a unique ciranol top
Lower Price when bought with additional items. Alternative sizes available in the same range. Feel free to call your local branch if you have questions or would like to order this product(s) [post_title] => Ahrend Silver Desk High Tambour Cupboard 720x800mm [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => ahrend-silver-tambour-cupboard-2 [to_ping] => [pinged] => [post_modified] => 2019-10-02 16:01:16 [post_modified_gmt] => 2019-10-02 15:01:16 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/used-storage/ahrend-silver-desk-high-tambour-cupboard-720x800mm/ [menu_order] => 97 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 7142 [post_author] => 4 [post_date] => 2018-01-20 08:41:03 [post_date_gmt] => 2018-01-20 08:41:03 [post_content] => Ahrend Silver Tambour Cupboard 1320x1000mm

Features

  • 2 Adjustable shelves
  • Sliding doors to save space
  • Lockable provided with key
  • 3rd shelf can be purchased for £12+VAT
[post_title] => Ahrend Silver Tambour Cupboard 1320x1000mm [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => ahrend-silver-tambour-cupboard-1200x1000mm [to_ping] => [pinged] => [post_modified] => 2019-10-02 16:01:25 [post_modified_gmt] => 2019-10-02 15:01:25 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/used-storage/ahrend-silver-tambour-cupboard-1200x1000mm/ [menu_order] => 96 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 6454 [post_author] => 117 [post_date] => 2017-10-03 13:39:48 [post_date_gmt] => 2017-10-03 12:39:48 [post_content] => Ahrend Dark Grey Tambour 1400x1200mm
  • 3 Adjustable shelves
  • Tambour sliding door to save space
  • Lockable provided with key
Lower Price when bought with additional items 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 or would like to order this product(s) [post_title] => Ahrend Dark Grey Tambour 1400x1200mm [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => ahrend-dark-grey-tambour-1400x1200mm [to_ping] => [pinged] => [post_modified] => 2019-10-15 16:19:34 [post_modified_gmt] => 2019-10-15 15:19:34 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6454 [menu_order] => 380 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 3 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 7148 [post_author] => 4 [post_date] => 2018-01-20 09:28:04 [post_date_gmt] => 2018-01-20 09:28:04 [post_content] => Ahrend Silver Desk High Tambour Cupboard 720x800mm. Ahrend tambour door cabinets are an extremely high quality storage range. Their quality, meticulous finish and flexible layout possibilities mean that Ahrend tambour door cabinets are among the best on the market. Thanks to the wide range of available height dimensions, colour possibilities and tops, Ahrend tambour door cabinets can be combined with all the Ahrend furniture ranges.

Features

  • 1 Adjustable shelf
  • Single sliding door to save space
  • Lockable provided with key, ideal for the new GDPR laws
  • Silver finish wood top
  • Adjustable feet with 20mm range
  • Steel welded carcass with a unique ciranol top
Lower Price when bought with additional items. Alternative sizes available in the same range. Feel free to call your local branch if you have questions or would like to order this product(s) [post_title] => Ahrend Silver Desk High Tambour Cupboard 720x800mm [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => ahrend-silver-tambour-cupboard-2 [to_ping] => [pinged] => [post_modified] => 2019-10-02 16:01:16 [post_modified_gmt] => 2019-10-02 15:01:16 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/used-storage/ahrend-silver-desk-high-tambour-cupboard-720x800mm/ [menu_order] => 97 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 3 [max_num_pages] => 1 [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] => 83d5d6f9d9d8c8cb7e6f6be258288062 [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 ) )