Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 7.2 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 != '231' and
g.genus = 'Juniperus'
limit 1
id
1226

Juniperus sabina 'Arcadia'

Arcadia Juniper

Boasting bright green foliage all year round, this plant is useful in mass plantings and requires little maintenance.

  • Evergreen shrub
  • Semi-spreading habit
  • Rich green, lacy foliage
  • Great for foundation and mass plantings

  • Category: Evergreen
  • Hardiness Zone: 3-7
  • Height: 12-18 in
  • Spread: 3-5 ft
  • Foliage Color: Green
Login for pricing

e

j

p

x

a

*

8

/