Just to follow up on this, I purchased one of these
Terk HDTVa Antennas from Tiger Direct and I'm getting pretty decent results, pulling in 5/6 down here in Canyon Meadows from my living room.
I need to get an adapter to string a longer coaxial cable and try this antenna on the second floor or attic, but given the results in the living room on the ground level I'd expect to get all 6 OTA HD channels with the right positioning.
Update #2
Alright one more update for those who google Over The Air HDTV in Canyon Meadows, mounted the Terk HDTVa in the attic and I'm now pulling in all 6 OTA digital channels in Calgary.