I had time to kill, so I thought I'd run a new character out to the housing area to see what information you receive. Keep in mind, this is a level 1 alt. I think someone mentioned that there is an early quest that also takes you out to the wards, so this information is not regarding that quest.
Upon first arrival into the ward, you are greeted by:
Being the dutiful player that I am, I opened up the housing "Active Help" to get more information:
Doesn't really say much, and definitely doesn't mention the timers.
But my journey is not done yet! Using the information obtained in the Active Help, I wander down to the Resident Caretaker for more information! Takes some patience to navigate as there are menus galore (in the SE way), and many options to sift through.
1st menu screen:
2nd menu screen:
3rd menu screen:
AHA! There it is! Phew! "What happens if I abandon my estate". Now, with as straightforward (massive eyeroll) as the above steps were to navigate, pardon while I nitpick a tiny bit. Simply asking "What happens if I abandon my estate" doesn't really convey the importance that there is a demolition timer looming over your head as a homeowner. Someone could easy interpret this as "Hey, what happens when I no longer want it" - which would make it seem like it's based on the player's time frame, and not some in-game timer which is extremely buried and a pain to find.
So, with my adventure now done, I am very much still in the camp of "SE needs to add more notifications in-game to make this more visible as they are currently doing a poor job of it". Several good ideas have been shared already in this thread:
1) Send a mogmail message (in-game mail)
2) Add a pop-up that shows upon login
3) Add a pop-up message right after you purchase a house
4) Update the "estate timer" to display this information / show an active timer
These are all relatively minor changes that come at no cost to the player, but would instead be a huge boon. Clear communication is never a bad thing. Especially when it involves the only item in a game that you can lose permanently when not keeping tabs on it.