@Liv I would love to stay at Tara before the Civil War, The Badger's house in The Wind of the Willows, and the house where Mary found "The Secret Garden." (While Mary and Dickon worked on the garden, I'd be renovating the house and making it less forbidding.)
All the houses Pa built for his family in the Laura Ingalls Wilder series sounded cozy, even the sod house, because Ma was so good at interiors. The house that "The Borrowers" lived under would make a wonderful stay.
The house in Fitzgerald's story "The Diamond as Big as the Ritz" is impressive, but getting away from it proved problematic and destroyed it, so that's out. Nick Carraway's house next to Gatsby's mansion seemed pretty sweet, though.
Finally, I would love to live in the house on Cheyne Walk where Linda Radlett lived in "The Pursuit of Love."
I first met all of these in the pages of books. And now that I think of it, I've already stayed at all of them!