« Previous Plant | Next Plant »
A dense, pyramidal evergreen tree with showy, needled foliage with two white bands on the underside of each needle. Nordmann firs are frequently used in Christmas tree farms for their dense branches that typically remain branched all the way to the ground.
Pyramidal form is perfect for landscape specimen use or grouped together to form a large border planting. Tough and hardy with attractive foliage. Easy to care for.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 100 ms Record Count: 2 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 = 4742 order by udefcategory, name, price | ||||||||||||||||||||||||||
| program | name | udefSKUNameSuffix | sku | udefBannedStates | udefBBL | udefRR | udefLR | udefTimsTopTwenty | udefJaimesHotList | price | category | comments | grade | special | plantSize | size | salePrice | listPrice | udefTier2 | udefTier2Price | udefTier3 | udefTier3Price | plantID | id | ||
| 1 | ABIES NORDMANNIANA | 1014447 | 0 | 0 | 77 | 0 | 0 | 83.90 | TREES: ABIES - fir | 1 | NET | 36-42" | #6 | 0 | 83.90 | (4-6) | 79.71 | (7+) | 72.15 | 4742 | 17965 | |||||
| 2 | ABIES NORDMANNIANA | 1026998 | 0 | 30 | 19 | 0 | 0 | 150.73 | TREES: ABIES - fir | 1 | 42-48" | #10 | 0 | 150.73 | (4-6) | 143.19 | (7+) | 129.63 | 4742 | 21316 | ||||||
| • | Evergreen |
| • | Green |
| • | Low Maintenance |
| • | Non-blooming |
| • | Upright |
| • | Average Water |
| string |