« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 38.7 ms Record Count: 0 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 = 9792 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 | ||
Bosnian Pine is a rugged yet elegant evergreen that delivers year-round beauty and reliability. Its dense, glossy green needles stay fresh and full through every season, while its strong, upright form brings a touch of mountain character to the landscape. Exceptionally hardy and long-lived, this pine thrives where other evergreens struggle, handling cold winters, poor soils, and exposed sites with ease.
| • | Green |
| • | Low Maintenance |
| • | Deer Resistant |
| • | Winter |
| • | Full Sun |
| • | Columnar |
| • | Average Water |
Plant in moist, well-draining loamy soil and full sunlight. Adaptable to various soil types, including sandy and clay soils. Avoid areas with poor drainage or consistently soggy conditions. Thrives best in regions with cool summers.
| string |