Thuja occidentalis Sting™ Sting™ Arborvitae from Prides Corner Farms

Thuja occidentalis Sting™ ('SMNTOO')

Sting™ Arborvitae: Patent PP34,292

» Adds height to any landscape
» Loves the sun
» Winter and fall interest
» Sword-like silhouette

Hardiness Zone:3-8
Height:15-20 ft
Spread:12-18 in
Category:Evergreen
Foliage Color: Green Shades
Breeder:Proven Winners

We love plants with interesting architecture, and this selection of our native Eastern arborvitae (Thuja occidentalis) takes skinny to the max with its sword-like silhouette. Use it to make an exclamation point in garden designs, or fit it into a very narrow bed. Certain to be iconic plant in well-designed landscapes everywhere, from the Shire to Shreveport.

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price