« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 55.4 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 = 10145 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 | ||
Picea abies 'Little Gem' is a dense, dwarf Norway spruce with a compact, cushion-like shape and slow growth, reaching only 1-2 feet tall and wide over time. Its rich, dark green needles create a fine-textured appearance, making it ideal for year-round interest in garden borders, foundation plantings, and rock gardens. This cultivar is well-suited for smaller spaces and can add texture and structure to beds and pathways, often serving as a focal point in landscaping.
Picea abies 'Little Gem' thrives in well-drained, acidic soils and prefers full sun. It grows best in cool climates and should be watered regularly, especially in warmer regions, though it tolerates occasional dry periods once established.
| string |