Fantastic rooms heir had in piles (12)

I believe the answer is:

haemorrhoids

'piles' is the definition.
(I know this)

'fantastic rooms heir had' is the wordplay.
'fantastic' indicates anagramming the letters.
'rooms'+'heir'+'had'='roomsheirhad'
'roomsheirhad' is an anagram of 'HAEMORRHOIDS'.

'in' is the link.

I've seen this clue in The Sunday Times.

Want a hint initially instead of a full solution? Install my app