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

« Previous Plant  |  Next Plant »

Chamaecyparis obtusa 'Templehof'

Templehof Hinoki Cypress

  • »  Slow, steady growth
  • »  Forms a pleasing globe
  • »  Deep green, fan-shaped foliage
  • »  Excellent texture

Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 83.2 ms
Record Count: 0
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 = 331
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
Another textural masterpiece! Slow, steady growth and a pleasing, globose form combined with its deep green, fan-shaped foliage make this selection a perfect choice.

Find a local garden center

Within...
...of zip code:
.
Attributes
• Great Foliage
Foliage Color
• Green
Exposure
• Full Sun
• Partial Shade
Habit
• Round
Growing & Maintenance Tips for Chamaecyparis obtusa 'Templehof'

Like full to part sun.

string