Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 2.93 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 != '337' and
g.genus = 'Pinus'
limit 1
id
1335

Pinus mugo var. pumilio

Dwarf Mugo Pine

A compact shrub with a dwarf, globular form and dark green needles.

  • CAN NOT BE SHIPPED TO THE US
  • Evergreen shrub
  • Compact, densely uniform in growth
  • Short, rich green leaves in variable length
  • Use in rock gardens or mass plantings

  • Category: Evergreen
  • Hardiness Zone: 2-8
  • Height: 3-5 ft
  • Spread: 6-10 ft
Login for pricing

e

j

p

x

y

+

m

a

*

%

8

/

{