« Previous Plant | Next Plant »
Sweetly scented flowers are extremely fragrant and will fill the air with the sweet-spice scent in early spring. Sugar n' Spice is slow-growing and forms a nice rounded shrub with pleasing red fall color. Easy to grow with great landscape rewards! The fragrant flowers of Sugar n’ Spice® Koreanspice Viburnum attract birds, butterflies, and other pollinators in spring.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 69.5 ms Record Count: 3 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 = 5094 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 | VIBURNUM CARLESII `SUGAR `N SPICE` | 1010386 | 0 | 872 | 0 | 0 | 0 | 33.78 | SHRUBS: VIBURNUM | 1 | 36-42" | #3 | 0 | 33.78 | (5-9) | 32.09 | (10+) | 29.05 | 5094 | 19421 | ||||||
| 2 | VIBURNUM CARLESII `SUGAR `N SPICE` | 1015021 | 0 | 317 | 0 | 0 | 0 | 50.27 | SHRUBS: VIBURNUM | 1 | 42-48" | #5 | 0 | 50.27 | (4-6) | 47.76 | (7+) | 43.23 | 5094 | 18891 | ||||||
| 3 | VIBURNUM CARLESII `SUGAR `N SPICE` | 1015023 | 0 | 285 | 100 | 0 | 0 | 104.72 | SHRUBS: VIBURNUM | 1 | 4-5' | #10 | 0 | 104.72 | (4-6) | 99.48 | (7+) | 90.06 | 5094 | 18890 | ||||||
| string |