I purchased the manor, all the furnishings and hired the housekeeper but i still cannot find a scroll thats hints of hidden treasure. Am i wrong about there being a quest here?

It's on the platform above the door in the master bedroom.

I hope this helps. It is a full walk through of that quest: http://www.uesp.net/wiki/Oblivion:The_Rosethorn_Cache