Welsh manor house abandoned for over 20 years becomes one of