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

« Previous Plant  |  Next Plant »

Sciadopitys verticillata

Japanese Umbrella Pine

  • »  Clean and perfect-looking
  • »  Slow-growing when young bus faster as it ages
  • »  Pyramidal
  • »  Thick, deep green, glossy needles
  • »  Nearly pest and insect-free

  • Hardiness Zone:5-8
  • Height:20-30 ft
  • Spread:10-15 ft
  • Category:Conifer
  • Bloom Color: Green Shades
So clean, so perfect looking your customers will think this plants plastic!! Slow-growing when young, speedier as it ages, this pyramidal wonder's deep green, thick glossy needles will show their beauty in any landscape. Nearly pest and insect-free!
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 149 ms
Record Count: 2
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 = 1260
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1SCIADOPITYS VERTICILLATA1000441071400192.37SHRUBS: SCIADOPITYS - Japanese Umbrella Pine130-36"#50192.37(4-6)182.75(7+)165.44126014836
2SCIADOPITYS VERTICILLATA1001289015290034.70TREES: SCIADOPITYS - Japanese umbrella pine115-18"#2034.70(5-9)32.97(10+)29.84126014834

Find a local garden center

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