Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 2.06 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select g.id
from tb_plant_genusoverview_substitutions s
inner join tb_plant_genusOverview g on (g.id = s.genus_id)
where g.delete_date is null and g.isactive = 1 and
g.id != '229' and
g.genus = 'Juniperus'
limit 1
id
1226

Juniperus horizontalis 'Plumosa Compacta'

Compact Andorra Juniper

Maintains a low, spreading form of bright green new growth in the spring that turns plum in the fall.

  • Low, spreading habit
  • Gray-green foliage in summer
  • Light purple foliage during winter
  • Ideal for border or in large groups

  • Category: Evergreen
  • Hardiness Zone: 3-8
  • Height: 1-2 ft
  • Spread: 4-8 ft
  • Foliage Color: Green
Login for pricing

e

j

x

m

t

2

a

/

{

: