Only if you are still in the 2 year window of being posted to a new base. Otherwise its out of pocket.
Correct. The original post (at least the one on this tangent) implied that the individual was well within that window.
On another note, SISIP Financial Services are more about
long term (i.e. retirement) planning. I'm not sure what they could do for you in a more short term scenario such as this. Be careful about investing any down payment money in the interim. You don't want to put it into an investment that will penalize you if you take it out too soon. Also keep in mind that many long term investment plans will actually lose money in the short term (and return big in the long term).
On the size of the down payment, keep in mind that anything less than 25% will require you to take out mortgage default insurance with CMHC. If the CF is covering your costs, this is a claimable expense (especially if this is your first house). When you are posted and go to buy a replacement house in your new location, you can only claim that part of mortgage default insurance that you would pay if you transfer ALL your equity into the replacement property. I know that thinking of buying your next house when you're still thinking of buying the first one seems a bit far ahead of yourself, but forewarned is forearmed! The rule of thumb on posting is if you want the CF to cover the entire cost of mortgage default insurance is to ensure you transfer all your equity to the new house (ie. don't skim off the top to buy a new car). However, if you put 25% or more down on your house, there is no Mortgage Default Insurance and this problem goes away.
On a final note, do not confuse Mortgage Default Insurance with Mortgage Life Insurance. MDI is required by law if you do not have a down payment of at least 25%. Mortgage life insurance is something the bank will try to sell you (yes, you pay for it and it is NOT claimable from the CF under any circumstances). Essentially, it pays off the mortgage if you die. A far better deal is to take out SISIP Optional Group Term Insurance (OGTI) for at least the value of the mortgage. It's a lot cheaper and a better deal. Then if you die, your heir will have enough money to pay off the mortgage. The bonus is that the longer you live, the less the remaining balance on the mortgage will be, which means the more actual cash in your heir's pocket - you may not want to explain that to your heir though

The life insurance your mortgage lender will try to sell you will only pay off the mortgage with nothing left over.