SELECT False AS IsPlantDetail, IIF(POD.PlantID1 IS NULL,False,True) AS Available, IIF(OrderStatus<>2 OR UnitsReceived IS NULL,UnitsOrdered,UnitsReceived) AS UnitsForCalcs, P.ID, P.BotanicalName, P.CommonName, P.DisplayCommonName, P.SeriesName, P.Cultivar, P.Lineage, P.Reviewed, P.ImgsReviewed, P.Type, P.Class, P.NewItem, P.YearIntr, P.URL, P.BenchCardIDSm, P.BenchCardIDLg, P.pHID, P.ECID, P.ExposureCode AS ExpCode, P.BloomSeasonBeginCode, P.BloomSeasonEndCode, P.Rebloomer, P.FlowerColorDesc, P.FlowerColorValue, P.FoliageColorDesc, P.FoliageColorValue, P.FallFoliageColorDesc, P.FallFoliageColorValue, P.MinHeight, P.MaxHeight, P.MinSpacing, P.MaxSpacing, P.MinRowWidth, P.MaxRowWidth, P.MinMaturity, P.MaxMaturity, P.MinHardinessZone, P.MaxHardinessZone, P.DroughtTolerant, P.HeatTolerant, P.ClaySoil, P.MoistSoil, P.PoorSoil, P.SaltTolerant, P.DeerResistant, P.RabbitResistant, P.MildewResistant, P.SlugResistant, P.DiseaseResistant, P.AttractsHummingbirds, P.AttractsButterflies, P.AttractsSongbirds, P.AttractsPollinators, P.Containers, P.VariegatedFoliage, P.IntenseColoredFoliage, P.Fragrant, P.Cuttings, P.Miniature, P.Evergreen, P.WinterInterest, P.CottageGarden, P.MassPlanting, P.Borders, P.RapidlySpreading, P.DryFlower, P.RockGarden, P.Specimen, P.NANative, P.MINative, P.INNative, P.Aquatics, P.Medicinal, P.HousePlant, P.Heirloom, P.JugloneTolerant, P.CultivarComments, P.Form, P.PetalCount, P.FragranceLevel, P.ImgCount, P.FirstYearFlowering, P.PruningCode, P.TagID, P.Discontinued, P.VideoURLTitle, P.VideoURL, P.Recipe, P.PrintBenchcardSm, P.PrintBenchcardLg, P.DefaultRetailLoc,P.DefaultStorageLoc,P.OrderTickler,S.SourceName,S.FinishedOnly,A.Filename AS AudioFilename,FPF.FormDesc AS FinishedFormDesc,GC.GenusName AS GCGenusName,GC.Desc AS Genus_Comment,SpC.Desc AS Species_Comment,SC.Desc AS Series_Comment,GI.Desc AS Growing_Comment,POD.ShipYear1 AS ShipYear,POD.ShipWeek1 AS ShipWeek,POD.SequenceID1 AS SequenceID,POD.SourceID1 AS SourceID,POD.UniqueID1 AS UniqueID,POD.PlantsPerUnitAct1 AS PlantsPerUnitAct,POD.PlantsPerUnitChg1 AS PlantsPerUnitChg,POD.UnitsOrdered1 AS UnitsOrdered,POD.UnitsReceived1 AS UnitsReceived,POD.PlantCost1 AS PlantCost,POD.LicFee1 AS LicFee,POD.ContainerID1 AS ContainerID,POD.PlantsPerContainer1 AS PlantsPerContainer,POD.SplitPlantCount1 AS SplitPlantCount,POD.PriceType1 AS PriceType,POD.PriceClass1 AS PriceClass,POD.PriceItem1 AS PriceItem,POD.PONumber1 AS PONumber,POD.OrderNumber1 AS OrderNumber,POD.InvoiceNumber1 AS InvoiceNumber,POD.PlantFormID1 AS PlantFormID,POD.DateAvailable1 AS DateAvailable,POD.ForNextSeason1 AS ForNextSeason,POD.BareRoot1 AS BareRoot,POD.CurrentQuantity1 AS CurrentQuantity,POD.ShrinkageTotal1 AS ShrinkageTotal,POD.PlacementConfirmed1 AS PlacementConfirmed,POD.OrderPlantSub1 AS OrderPlantSub,PW.PWType,PW.TopSellingOrder,PW.PAllenSmith,PW.ProvenAccent,AAS.ID AS AAS_ID,AAS.Year AS AAS_Year, AAS.URL AS AAS_URL, AGG1.Carryover1 AS Carryover, AGG1.Ordered1 AS Ordered, IIF(AGG2.RetailLocCount=0 AND AGG2.RetailLoc1 IS NULL, IIF(P.DefaultRetailLoc IS NOT NULL, P.DefaultRetailLoc, AGG2.RetailLoc1), AGG2.RetailLoc1) AS RetailLoc,IIF(AGG2.RetailLocCount=0 AND AGG2.RetailLoc1 IS NULL, IIF(P.DefaultRetailLoc IS NOT NULL,1,AGG2.RetailLocCount), AGG2.RetailLocCount) AS RetailLocCount, AGG6.OrderStatus1 AS OrderStatus, AGG6.SoldOut1 AS SoldOut, AGG6.SoldOutDate1 AS SoldOutDate FROM ((((((((((((Plants P INNER JOIN (SELECT PlantID, IIF(MAX(ShipYear<2024 OR (ShipYear=2024 AND ForNextSeason=0)),True,False) AS Carryover1,IIF(MAX(ShipYear)=2025,True,False) AS Ordered1 FROM (SELECT PlantID, ShipYear, ForNextSeason FROM PlantOrderDetail WHERE UnitsOrdered>0 AND ((OrderStatus=1 OR OrderStatus=3) OR ((UnitsReceived IS NULL OR UnitsReceived>0) AND OrderStatus=2)) AND ((ShipYear<2025 AND (SoldOut=0 OR (SoldOut=255 AND SoldOutDate IS NOT NULL AND SoldOutDate>=#04/01/2025#))) OR (ShipYear=2024 AND ForNextSeason=255) OR (ShipYear=2025 AND ForNextSeason=0))) GROUP BY PlantID) AS AGG1 ON AGG1.PlantID=P.ID) LEFT JOIN (SELECT PlantID, MAX(RetailLoc) AS RetailLoc1, IIF(Count(RetailLoc)=1 AND MAX(RetailLoc) IS NULL,1,Count(RetailLoc)) AS RetailLocCount FROM (SELECT DISTINCT PlantID, RetailLoc FROM PlantOrderDetail WHERE UnitsOrdered>0 AND ((OrderStatus=1 OR OrderStatus=3) OR ((UnitsReceived IS NULL OR UnitsReceived>0) AND OrderStatus=2)) AND ((ShipYear<2025 AND (SoldOut=0 OR (SoldOut=255 AND SoldOutDate IS NOT NULL AND SoldOutDate>=#04/01/2025#))) OR (ShipYear=2024 AND ForNextSeason=255) OR (ShipYear=2025 AND ForNextSeason=0))) GROUP BY PlantID) AS AGG2 ON AGG2.PlantID=P.ID) LEFT JOIN (SELECT PlantID, IIF(AVG(SoldOut)=255,255,0) AS SoldOut1, MAX(SoldOutDate) AS SoldOutDate1, MAX(OrderStatus) AS OrderStatus1 FROM (SELECT PlantID, SoldOut, SoldOutDate, OrderStatus FROM PlantOrderDetail POD INNER JOIN Container C ON POD.ContainerID=C.ID WHERE UnitsOrdered>0 AND ((OrderStatus=1 OR OrderStatus=3) OR ((UnitsReceived IS NULL OR UnitsReceived>0) AND OrderStatus=2)) AND ((ShipYear<2025 AND (SoldOut=0 OR (SoldOut=255 AND SoldOutDate IS NOT NULL AND SoldOutDate>=#04/01/2025#))) OR (ShipYear=2024 AND ForNextSeason=255) OR (ShipYear=2025 AND ForNextSeason=0)) AND (C.ContType<>1 OR (C.ID<>62 AND C.ID<>12))) GROUP BY PlantID) AS AGG6 ON AGG6.PlantID=P.ID) INNER JOIN (SELECT First(PlantID) AS PlantID1,First(ShipYear) AS ShipYear1,First(ShipWeek) AS ShipWeek1,First(SequenceID) AS SequenceID1,First(SourceID) AS SourceID1,First(UniqueID) AS UniqueID1,First(PlantsPerUnitAct) AS PlantsPerUnitAct1,First(PlantsPerUnitChg) AS PlantsPerUnitChg1,First(UnitsOrdered) AS UnitsOrdered1,First(UnitsReceived) AS UnitsReceived1,First(PlantCost) AS PlantCost1,First(LicFee) AS LicFee1,First(ContainerID) AS ContainerID1,First(PlantsPerContainer) AS PlantsPerContainer1,First(SplitPlantCount) AS SplitPlantCount1,First(PriceType) AS PriceType1,First(PriceClass) AS PriceClass1,First(PriceItem) AS PriceItem1,First(PONumber) AS PONumber1,First(OrderNumber) AS OrderNumber1,First(InvoiceNumber) AS InvoiceNumber1,First(PlantFormID) AS PlantFormID1,First(DateAvailable) AS DateAvailable1,First(ForNextSeason) AS ForNextSeason1,First(BareRoot) AS BareRoot1,First(CurrentQuantity) AS CurrentQuantity1,First(ShrinkageTotal) AS ShrinkageTotal1,First(PlacementConfirmed) AS PlacementConfirmed1,First(OrderPlantSub) AS OrderPlantSub1 FROM PlantOrderDetail WHERE UnitsOrdered>0 AND ((OrderStatus=1 OR OrderStatus=3) OR ((UnitsReceived IS NULL OR UnitsReceived>0) AND OrderStatus=2)) AND ((ShipYear<2025 AND (SoldOut=0 OR (SoldOut=255 AND SoldOutDate IS NOT NULL AND SoldOutDate>=#04/01/2025#))) OR (ShipYear=2024 AND ForNextSeason=255) OR (ShipYear=2025 AND ForNextSeason=0)) GROUP BY PlantID) AS POD ON P.ID = POD.PlantID1) LEFT JOIN AAS_Winners AS AAS ON P.ID=AAS.ID) LEFT JOIN ProvenWinners AS PW ON P.ID=PW.ID) LEFT JOIN Comments_Genus GC ON P.BotanicalName=GC.GenusName OR MID(P.BotanicalName,1,INSTR(1,P.BotanicalName,' '))=GC.GenusName) LEFT JOIN Comments_Species SpC ON P.BotanicalName=SpC.GenusID + ' ' + SpC.SpeciesID) LEFT JOIN Comments_Series SC ON P.SeriesName=SC.ID) LEFT JOIN Comments_Growing GI ON P.BotanicalName=GI.GenusID + ' ' + GI.SpeciesID) LEFT JOIN PlantSources S ON POD.SourceID1=S.ID) LEFT JOIN FinishedPlantForms FPF ON POD.PlantFormID1=FPF.FormID) LEFT JOIN AudioBotanicalNames A ON P.BotanicalName=A.BotanicalName WHERE ((P.BotanicalName LIKE '%[aà]g[aà]st[aà]ch[eèéêë]%') OR (P.CommonName LIKE '%[aà]g[aà]st[aà]ch[eèéêë]%') OR (P.DisplayCommonName LIKE '%[aà]g[aà]st[aà]ch[eèéêë]%') OR (P.SeriesName LIKE '%[aà]g[aà]st[aà]ch[eèéêë]%') OR (P.Cultivar LIKE '%[aà]g[aà]st[aà]ch[eèéêë]%')) AND P.YearIntr<=2026 ORDER BY P.CommonName ASC,P.BotanicalName ASC,P.Cultivar ASC
| ![]() |
![]() Buy Online | Disclaimer: Although we make every effort to keep this list updated, we cannot guarantee the availability of any of the plants listed. Please call before making a special trip.
Quick Search: Agastache - Displayed by Common Name in Ascending Order5 plants found. Generated on 07/16/2025. Change View Preferences
|
Common Name | Botanical Name | Cultivar | nail Image | Thumb-Description | Greenhouse Location | Flower Color | Foliage Color | Annual/ Perennial | Exposure | Bloom Season | Height | Spread | Hardiness Zone (See Map) | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Spring | Summer | Autumn | ||||||||||||||||||||||||
Early | Middle | Late | Early | Middle | Late | Early | Middle | Late | ||||||||||||||||||
Dwarf Hummingbird Mint | Agastache |
| ![]() | 10C-N | ![]() | ![]() | ![]() | ![]() | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
16"-18" | 14"-16" | 5-9 | ||||||
Hyssop (Anise) |
| ![]() | 10C-N | ![]() | ![]() | ![]() | ![]() | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
28"-32" | 28"-32" | 5-9 | |||||||
| ![]() | 10C-N | ![]() | ![]() | ![]() | ![]() | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
18"-22" | 24"-30" | 6-9 | ||||||||
Agastache rugosa |
| ![]() | 10C-N | ![]() | ![]() | ![]() | ![]() | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
16"-32" | 12"-20" | 5-10 | |||||||
Hyssop (Lavender) | Agastache foeniculum |
| ![]() | 6C-N | ![]() | ![]() | ![]() | ![]() | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
24"-36" | 18"-24" | 3-8 |
VIEW PREFERENCES | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Change the number of plants per page: | ||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||
Display Order | View by Light Exposure | Columns Displayed | ||||||||||||||||||||||||||||||||||||||
|
|
|
Admin Login • Privacy Policy and Disclaimer Website created by us with
Copyright ©2005-2025 Vite Greenhouses, Inc.