After that one flashback in "Hotel," the house isn't seen again until the eighth season, "Apocalypse." Unsurprisingly, a place called the Murder House is tied to the end of the world. When Madison and Behold buy the property for the Coven, the realtor reveals that there have been a jaw-dropping 37 deaths on the property. Apparently not all of them made it onto camera.
In that episode, "Return to Murder House," Constance explains that Michael Langdon, the child of a human and a ghost, is, indeed, the Anti-Christ. Satan pushed into the world through the house, possessing Tate's spirit and using him to father an unholy son. Though Constance tried raising what she thought would finally, finally be her perfect child, Michael's monstrous nature wore her down. Also, the aging into a teenager after just seven years was more than a bit unnerving.
The murdered priest was the last straw, so she returned to the Murder House to take her own life. There, she was reunited with her children, Beau, Rose, and Tate for all eternity. This timeline, though, is magically destroyed in the Season 8 finale. The Coven sends their most powerful member, Mallory (Billie Lourd), back in time, killing Michael before he can destroy the world, and leaving a relieved Constance alive.