I love having my husband work from home. He has done it exclusively for the past 6.5 years. My kids were 6, 4 and 1 when he started and they don't remember any other way. I added another baby and it was a bit tricky with a newborn and a demanding 3 year old.
Now that my kids are older (youngest is 4), it is much easier. They know that when Daddy is on important calls they need to use very quiet voices. It has been a gift for our kids to have my husband so actively a part of their childhood. He has no commute, rolls out of bed and goes to work, and is able to come out and socialize throughout the day. When he goes into his office and closes his door, the kids know not to disturb him.
I would definitely recommend giving it a try.