The trail road dump is very close to that Barrhaven site.
For the carp dump, 5-6 kilo will include most of kanata lake which is highest price in kanata. The expnasion plann was last year's news and dump was there before kanata even existed, if it will affect house price it should already did. I guess this should answer your question.
"prospect regarding housing appreciation" whose knows. Beause the answer is based on who live there. Highly educated,. high income people live there, the house price goes up and school record will be perfect.The shopping and transportion will follow up. For new building site no body knows untill most house are built and sold. You only can guess if most homes are large single, the place should have good future.