Indeed I agonised over housing adviser (4)
I believe the answer is:
aide
'adviser' is the definition.
'indeed i agonised over housing' is the wordplay.
'housing' indicates the answer is hidden within the clue (part of the clue houses the answer).
'over' says the letters should be written in reverse.
'edia' can be found hidden inside 'indeed i agonised'.
'edia' backwards is 'AIDE'.
(Other definitions for aide that I've seen before include "Personal assistant in the military" , "Leader's assistant" , "One to assist" , "Confidential assistant or advisor" , "auxiliary" .)