I think the same tree is growing outside my parents house. No idea what it is though, will ask later tonight.
I've never seen it fruit or flower or anything either, and has been there at least 20 years.
I don't think it's the Juniperus scopulorum, the leaves definitely have a bluish color and the little leaves think look different to that close up. Could be the 'blue arrow' varietal they mention further down in the entry?