Adams Gardens Logo White x2

Christmas Trees Now in Stock

Family buying Christmas Trees Together

Christmas Trees Now in Stock

Family buying Christmas Trees Together

Our shipment of live (potted) and cut Christmas trees are in stock and ready for you to take home!

Come visit us for great selection and knowledgeable, friendly service. 

Special Holiday Hours:

9am-6pm Monday – Thursday
9am-8pm Friday & Saturday (Dec. 2-3 & Dec. 9-10 ONLY)
10am-5pm Sunday

Visit Today

Archives

    collapsArch options:
Array
(
    [title] => Archives
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => 
    [inExcludeYear] => exclude
    [inExcludeYears] => 2016, 2014, 2013, 2011, 2010, 2009
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 1
    [showYearCount] => 1
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 0
    [showPostDate] => 1
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [accordion] => 1
    [useCookies] => 1
    [post_type] => post
    [taxoncmy] => category
    [postTitleLength] => 
    [showPostCount] => 1
    [style] => custom
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [taxonomy] => both
    [number] => 2
)
POST QUERY:
 SELECT nhauk8_terms.slug, nhauk8_posts.ID,
    nhauk8_posts.post_name, nhauk8_posts.post_title, nhauk8_posts.post_author,
    nhauk8_posts.post_date, YEAR(nhauk8_posts.post_date) AS 'year',
    MONTH(nhauk8_posts.post_date) AS 'month' ,
    nhauk8_posts.post_type
    FROM nhauk8_posts LEFT JOIN nhauk8_term_relationships ON nhauk8_posts.ID =
    nhauk8_term_relationships.object_id 
		LEFT JOIN nhauk8_term_taxonomy ON nhauk8_term_taxonomy.term_taxonomy_id =
																			nhauk8_term_relationships.term_taxonomy_id
		LEFT JOIN nhauk8_terms ON nhauk8_terms.term_id = 
		                          nhauk8_term_taxonomy.term_id 
  WHERE post_status='publish' AND nhauk8_posts.post_type='post' AND YEAR(nhauk8_posts.post_date) NOT IN ('2016', ' 2014' , ' 2013' , ' 2011' , ' 2010' , ' 2009' )  
  GROUP BY nhauk8_posts.ID 
  ORDER BY nhauk8_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => growing-tips
            [ID] => 1931
            [post_name] => best-times-to-water-plants-in-the-heat
            [post_title] => Best Times to Water Plants in the Heat
            [post_author] => 3
            [post_date] => 2022-08-05 17:01:58
            [year] => 2022
            [month] => 8
            [post_type] => post
        )

    [1] => stdClass Object
        (
            [slug] => growing-tips
            [ID] => 1900
            [post_name] => best-trees-and-shrubs-to-plant-in-the-treasure-valley
            [post_title] => Best Trees and Shrubs to Plant in the Treasure Valley
            [post_author] => 3
            [post_date] => 2022-07-14 15:57:12
            [year] => 2022
            [month] => 7
            [post_type] => post
        )

    [2] => stdClass Object
        (
            [slug] => growing-tips
            [ID] => 1889
            [post_name] => how-to-prepare-your-lawn-trees-and-landscaping-for-dry-weather
            [post_title] => How to prepare your lawn, trees and landscaping for dry weather
            [post_author] => 3
            [post_date] => 2022-05-01 14:49:02
            [year] => 2022
            [month] => 5
            [post_type] => post
        )

    [3] => stdClass Object
        (
            [slug] => fruit-trees
            [ID] => 1813
            [post_name] => what-is-backyard-orchard-culture
            [post_title] => What Is Backyard Orchard Culture?
            [post_author] => 2
            [post_date] => 2022-03-07 16:49:38
            [year] => 2022
            [month] => 3
            [post_type] => post
        )

    [4] => stdClass Object
        (
            [slug] => adams-gardens
            [ID] => 1753
            [post_name] => start-planning-garden-for-spring
            [post_title] => Why Now is the Perfect Time to Start Planning for Spring!
            [post_author] => 3
            [post_date] => 2022-01-29 00:17:08
            [year] => 2022
            [month] => 1
            [post_type] => post
        )

    [5] => stdClass Object
        (
            [slug] => growing-tips
            [ID] => 1682
            [post_name] => when-should-you-trim-your-shrubs-bushes-and-trees
            [post_title] => When Should You Trim Your Shrubs, Bushes, and Trees?
            [post_author] => 3
            [post_date] => 2021-09-08 23:14:57
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [6] => stdClass Object
        (
            [slug] => lawns
            [ID] => 1679
            [post_name] => how-you-can-start-planning-to-reduce-your-water-needs-for-next-year-now
            [post_title] => How You Can Start Planning to Reduce Your Water Needs for Next Year (Now)
            [post_author] => 3
            [post_date] => 2021-09-08 22:57:43
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [7] => stdClass Object
        (
            [slug] => lawns
            [ID] => 1676
            [post_name] => how-to-prepare-your-lawn-and-garden-for-the-fall-and-winter
            [post_title] => How to Prepare Your Lawn and Garden for the Fall and Winter
            [post_author] => 3
            [post_date] => 2021-09-08 22:49:16
            [year] => 2021
            [month] => 9
            [post_type] => post
        )

    [8] => stdClass Object
        (
            [slug] => news
            [ID] => 1442
            [post_name] => what-is-arbor-day
            [post_title] => What is Arbor Day?
            [post_author] => 2
            [post_date] => 2021-04-08 19:34:15
            [year] => 2021
            [month] => 4
            [post_type] => post
        )

    [9] => stdClass Object
        (
            [slug] => growing-tips
            [ID] => 1412
            [post_name] => the-successful-planting-guide-for-trees-and-shrubs
            [post_title] => The Successful Planting Guide for Trees and Shrubs
            [post_author] => 9145
            [post_date] => 2021-04-07 19:40:33
            [year] => 2021
            [month] => 4
            [post_type] => post
        )

    [10] => stdClass Object
        (
            [slug] => idaho
            [ID] => 1441
            [post_name] => spring-planting-guide-calendar-for-boise-area
            [post_title] => Spring Planting Guide & Calendar for Boise Area
            [post_author] => 2
            [post_date] => 2021-02-27 16:22:15
            [year] => 2021
            [month] => 2
            [post_type] => post
        )

    [11] => stdClass Object
        (
            [slug] => fruit-trees
            [ID] => 1440
            [post_name] => which-bees-are-best-for-pollinating-early-blooming-flowers-trees-and-shrubs-the-orchard-mason-bees
            [post_title] => Which Bees are Best for Pollinating Early Blooming Flowers, Trees and Shrubs?  The Orchard Mason Bees
            [post_author] => 2
            [post_date] => 2021-02-27 16:00:01
            [year] => 2021
            [month] => 2
            [post_type] => post
        )

    [12] => stdClass Object
        (
            [slug] => fruit-trees
            [ID] => 510
            [post_name] => things-to-consider-when-thinking-about-a-backyard-orchard
            [post_title] => Things to Consider When Thinking About a Backyard Orchard
            [post_author] => 2
            [post_date] => 2021-02-26 15:31:28
            [year] => 2021
            [month] => 2
            [post_type] => post
        )

    [13] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 1708
            [post_name] => christmas-tree-nampa
            [post_title] => Christmas Trees in Nampa
            [post_author] => 3
            [post_date] => 2019-11-11 18:21:00
            [year] => 2019
            [month] => 11
            [post_type] => post
        )

    [14] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 1702
            [post_name] => plant-flower-bulbs
            [post_title] => Your Fall Bulb and Rhizome Planting Guide
            [post_author] => 3
            [post_date] => 2019-09-21 18:47:00
            [year] => 2019
            [month] => 9
            [post_type] => post
        )

    [15] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 1685
            [post_name] => fall-sale-2021
            [post_title] => Fall Sale 2021
            [post_author] => 3
            [post_date] => 2019-09-16 20:14:16
            [year] => 2019
            [month] => 9
            [post_type] => post
        )

)
  • ▼2022 (5)
  • ►2021 (8)
  • ►2019 (3)

 More Posts

Christmas Trees in Nampa

Christmas Trees in Nampa

Holiday Decor from Adams Gardens Christmas Trees to Cactuses.When you think about a greenhouse, usually the first thing that comes to mind is spring planting. Images of flowers, vegetable gardens,...

read more
Your Fall Bulb and Rhizome Planting Guide

Your Fall Bulb and Rhizome Planting Guide

Your Fall Bulb and Rhizome Planting Guide.    When we think about planting flowers, spring is usually the first thing that comes to mind. But fall is the perfect time to plant several varieties...

read more
Fall Sale 2021

Fall Sale 2021

Our Annual Fall Sale is running from September 18 - October 2, 2021.  We want these plants going home with you this Fall!  Stop in for big savings.  Fall is a great time to plant.  See you soon!

read more