I will try to give info about price, furniture item limits, trophy item limits, special item limit(mounts/pets/assistants), if the house has a yard and if it is suitable for crafters. Please excuse any mistakes in the format as i've never done a similar post before.
For that reason i'll exclude the first 3 apartments you can acquire through the quest as they are both small and everyone will be able to get them for free.


Staple Homes-Apartments:

- Furniture Item Limit: 100

- Trophy Limit : 2

- Special Item Limit: 2


1.Barbed Hook Private Room:


- Cost: 11k


- Yard: No


- Crafter Suitable: Too small


2.Flaming Nix Deluxe Garret:


- Cost: 13k


- Yard: No


- Crafter Suitable: Too small


3.Sisters of the Sands Apartment:


- Cost: 12k


- Yard: No


- Crafter Suitable: Too small


Small Homes:

- Furniture Item Limit: 200

- Trophy Item Limit: 10

- Special item Limit: 4


1. Autumn's-Gate:


- Cost: 60k


- Yard: It has a small yard


- Crafter Suitable: I believe you can probably fit some crafting stations to it. For that cost i wouldnt mind turning it into a crafting workshop as the room inside is spacious and it helps that the style of the house has not corners and weird architecture to hinder placement.


2.Black Vine Villa:


- Cost: 54k


- Yard: There is a yard but i personally dont like that the wall around it is making it narrow and thus hard to place many things


- Crafter Suitable: You may fit some stations but it wont be the best choice as the elven arhitecture will hinder placement and will give a narrow feel but hey that is my personal opinion you may love it;).


3.Captain Margaux's Place:


- Cost: 56k


- Yard: No yard


- Crafter Suitable: the room is big enough for some crafting stations but for that money there are better options


4.Cyrodilic Jungle House:


- Cost: 71k


- Yard:It has a nice yard, quite spacious for the cost of the house actually with some good spots to place workshops or other things you might like


- Crafter Suitable: The yard allone is a better option for craters than other homes but the interior is smaller than other houses


5.Hammerdeck End:


- Cost: 65k


- Yard: No Yard


- Crafter Suitable: Small for the price, you can get better with that money but if you like the location you can make it work


6.Humblemud:


- Cost: 40k


- Yard: Small yard on the back


- Crafter Suitable: too small i think but hey you may like it


7.Kragenhome:


- Cost: 69k


- Yard: No Yard


- Crafter Suitable: No for that price, too small


8.Moonmirth House:


- Cost: 50k


- Yard: No Yard


- Crafter Suitable: Yes if you only want to make it a workshop


9.Snugpod:


- Cost: 45k


- Yard: No Yard


- Crafter Suitable: Too small


10.Twin Arches:


- Cost: 73k


- Yard: Yes, it's the one with the camel and the skeleton dummy from the trailer


- Crafter Suitable: One of my favourites actually, not too small not too big, can easily be both for crafting and a home


Classic Homes-Medium Homes:

- Furniture item Limit: 400

- Trophy Item Limit: 20

- Special Item Limit: 6


1.Bouldertree Refuge:


- Cost: 190k


- Yard: quite big yard but the terrain doesn't help in placement of some items it's quite up and down so if you want it for crafting stations it can be wonky


- Crafter Suitable: Yes


2.Cliffshade:


- Cost: 255k


- Yard: No Yard


- Crafter Suitable: Yes but you can make it work with cheaper options than this


3.Domus Phrasticus:


- Cost: 295k


- Yard: Very nice quite big


- Crafter Suitable: Yes


4.Grymharth's Woe:


- Cost: 280k


- Yard: No Yard


- Crafter Suitable: Yes


5.House of the Silent Magnifico:


- Cost: 320k


- Yard: No Yard


- Crafter Suitable: yes


6.Mournoth Keep:


- Cost: 325k


- Yard: one of my favourite yards;)


- Crafter Suitable: Yes


7.Ravenhurst:


- Cost: 260k


- Yard: There is a back yard. Quite cozy


- Crafter Suitable: Yes


8.Sleek Creek House:


- Cost: 335k


- Yard: there is a yard and water, there is also space under the house because it's in khajiiti style


- Crafter Suitable: Yes


9.The Ample Domicile:


- Cost: 195k


- Yard: The house is argonian turd style;) and there is a yard around it, actually nice


- Crafter Suitable: Yes


10.Velothi Reverie:


- Cost: 323k


- Yard: There is a small backyard


- Crafter Suitable: Yes but the house is a bit expensive so only if you really like the house


Large Homes:

- Furniture Item Limit: 600

- Trophy Item Limit: 40

- Special Item Limit: 8


1.Dawnshadow:


- Cost: 1,275,000 gold


- Yard: Yes


- Crafter Suitable: Yes


2.Forsaken Stronghold:


- Cost: 1,285,000 gold


- Yard: Yes


- Crafter Suitable: Yes


3.Gardner House:


- Cost: 1,015,000 gold


- Yard: Yes


- Crafter Suitable: Yes


4.Hunding's Palatial Hall:


- Cost: 1,295,000 gold


- Yard: yes with sea view and your own lighthouse


- Crafter Suitable: yes


5.Mathiisen Manor:


- Cost: 1,025,000 gold


- Yard: yes


- Crafter Suitable: yes


6.Old Mistveil Manor:


- Cost: 1,020,000 gold


- Yard: yes with stable too


- Crafter Suitable: yes


7.Quondam Indorilia:


- Cost: 1,265,000 gold


- Yard: yes


- Crafter Suitable: yes


8.Stay-Moist Mansion:


- Cost: 760k


- Yard: yes with stables


- Crafter Suitable: one of the best options in my opinion if you don't mind living in a turd;)


9.Strident Springs Demesne:


- Cost: 1,280,000 gold


- Yard: yes with a waterfall;)


- Crafter Suitable: yes


10.The Gorinir Estate:


- Cost: 780k


- Yard: yes


- Crafter Suitable: yes


Notable Homes-Manors:


- Furniture Item Limit: 700

- Trophy Item Limit: 80

- Special Item Limit: 10


1.Daggerfall Overlook:


- Cost: 3,780,000 gold


- Yard: yep


- Crafter Suitable: yep if you are that rich


2.Ebonheart Chateau:


- Cost: 3,785,000 gold


- Yard: yes


- Crafter Suitable: yes


3.Serenity Falls Estate:


- Cost: 3,775,000 gold


- Yard: yes


- Crafter Suitable:yes

I hope this info helps;)