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

Pinus sylvestris-Topiary

Scotch Pine-Topiary

This easy grower with blue-green needles and red, peeling bark needs full sun. Trained into an interesting accent plant.

  • CAN NOT BE SHIPPED TO THE US
  • Evergreen tree
  • Horizontal branching habit
  • Fast-growing, medium-sized conifer
  • Orange/red-brown bark
  • Great tree for naturalizing

  • Category: Evergreen
  • Hardiness Zone: 3-7
  • Height: 30-60 ft
  • Spread: 30-40 ft
Login for pricing

e

j

x

m

a

*

%

8