You will be logged off in  seconds due to inactivity. Click here to continue your ordering session.

« Previous Plant  |  Next Plant »

Gaillardia aristata SpinTop® 'Mariachi Red'

Mariachi Red Blanket Flower

  • »  Bright red spoon type petals
  • »  Thrives in heat and full sun
  • »  Compact mounding form

This exceptional perennial will delight with its cool red flowers that will brighten your garden all summer long. Low maintenance for those hot sunny locations with dense foliage that forms a tight, rounded bush, its flowers bloom from June through September.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 29.1 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select h.program,
s.name,
s.udefSKUNameSuffix,
s.sku,
s.udefBannedStates,
s.udefBBL,
s.udefRR,
s.udefLR,
s.udefTimsTopTwenty,
s.udefJaimesHotList,
s.listPrice as price,
s.udefCategory as category,
s.udefComments as comments,
s.udefGrade as grade,
s.udefSpecial as special,
s.udefPlantSize as plantSize,
s.qtyUnit as size,
s.salePrice,
s.listPrice,
s.udefTier2,
s.udefTier2Price,
s.udefTier3,
s.udefTier3Price,
s.plantID,
s.id
from tb_plant_skus s
inner join tb_lists_hotlist h on (h.sku = s.sku)
where s.isactive = 1 and
s.delete_date is null and
s.isecommerce = 1
and s.plantID = 10626
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1GAILLARDIA SPINTOP™ `MARIACHI RED`10272840055007.88PERENNIALS: GAILLARDIA - blanket flower1-#107.88(6-11)7.49(12+)6.781062621843

Find a local garden center

Within...
...of zip code:
.
string