Cryptomeria japonica Yoshino Yoshino Japanese Cedar from Prides Corner Farms

» Pyramidal form
» Lime-green to blue-green foliage
» Evergreen needles
» Faster growing than species
» Less bronzing in winter than speicies
» The species is the national tree of Japan and is often planted in shrines and temples

Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 70.4 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 = 5156 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		CRYPTOMERIA JAPONICA `YOSHINO`		1027025		0	52	0	0	0	108	SHRUBS: CRYPTOMERIA - Japanese cedar		1		4-5'	#5	0	108	(4-6)	102.6	(7+)	92.88	5156	21343
2		CRYPTOMERIA JAPONICA `YOSHINO`		1022443		0	61	0	0	0	367.50	SHRUBS: CRYPTOMERIA - Japanese cedar		1	1+ Only $200.00 Net!!	6-7'	#30	0	367.50					5156	20788