Juniperus chinensis 'Mountbatten' Mountbatten Juniper from Prides Corner Farms

Juniperus chinensis 'Mountbatten'

Mountbatten Juniper

» Bluish-green-gray foliage
» Needle-like foliage
» Upright, pyramidal form

Hardiness Zone:4-8
Height:12-15 ft
Spread:8-10 ft
Category:Evergreen
Foliage Color: Blue Shades, Green Shades

A versatile, low-maintenance evergreen with a dense, pyramidal habit, making it an excellent choice for hedges, screens, or specimen plantings. Its fine, needle-like foliage displays an attractive gray-green color with subtle bluish tones, providing year-round texture and color.

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 55.4 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 = 9522
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price