Proudspire Manor is the biggest house you can buy in Skyrim. It is located in Solitude and also the most expensive.