« Previous Plant | Next Plant »
The Pin Oak is a symmetrical deciduous oak tree with ascending horizontal branches. Glossy, deeply lobed, dark green leaves turn to shades of russet, bronze or red in the fall, but begin as yellow-green buds in the spring. Also known as the Swamp Spanish Oak, it is one of the most popular commercial oaks, planted as both a street and a landscape tree.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 63 ms Record Count: 4 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 = 8880 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 | AB | QUERCUS PALUSTRIS | 1013636 | 0 | 68 | 0 | 0 | 0 | 41.50 | TREES: QUERCUS - oak | 1 | 24-30" | #3 | 0 | 41.50 | (5-9) | 39.43 | (10+) | 35.69 | 8880 | 17384 | |||||
| 2 | QUERCUS PALUSTRIS | 1001277 | 0 | 7 | 0 | 0 | 0 | 260 | Wholesale Yard B&B | 1 | - | 2/2.5 B+B | 0 | 260 | 8880 | 20610 | ||||||||||
| 3 | QUERCUS PALUSTRIS | 1001279 | 0 | 43 | 3 | 0 | 0 | 375 | Wholesale Yard B&B | 1 | - | 3/3.5 B+B | 0 | 375 | 8880 | 20447 | ||||||||||
| 4 | QUERCUS PALUSTRIS | 1000550 | 0 | 14 | 0 | 0 | 0 | 420 | Wholesale Yard B&B | 1 | - | 3.5/4 B+B | 0 | 420 | 8880 | 21980 | ||||||||||
| • | Full Sun |
| • | Average Water |
Tolerates wet soils but performs best in acid, well-drained soils. Plant in full sun.
| string |