Unless you have a room that looks like this that gets full sun, none.

Not super helpful but I appreciate the response. I don't have a room with a glass roof, but I live somewhere with more sunny days and stronger sun than LA, and the plant can be outside in full sun half the year. Aloe striatula for instance I know can thrive in part sun indoors. Not exactly a true tree form type, but it's an aloe that trunks.

They're not going to do well indoors. Just not enough sun, I assure you.

He's a guy (above) who would know, he's also a long time & experienced grower; knows what he's talking about.

I don't doubt his expertise, but I'm not talking about growing a 10 foot Aloe barberae in a north facing window in somewhere like North Dakota year round. I'm talking about growing a 1 to 2 foot Aloe that has a trunking habit that can live with 5+ hours of full direct sunlight against 10 foot southern windows from November to March, and then be outside the rest of the year. I've seen Aloe striatula grown indoors year round in cloudy Oregon and it got 3 feet tall and thriving. I'm not trying to discredit your experience, I'm just saying that I've seen examples.

I see now that it's actually the title of my post that is causing the confusion. I shouldn't have put houseplant without specifying. I meant more of over-wintering inside.

I imagine you could overwinter indoors... I would slack way back on the watering, as well as provide cool temperatures. That will force it to go dormant, which will effectively stop all growth, to resume come warmer months. Otherwise, you would need some pretty powerful grow lights.

Aloe striatula is a climbing/creeping aloe that can tolerate some shade as is to be expected due to it's growth habit. It's also one of the hardiest and easy to grow aloe species. You can't look at that species and expect it to translate to tree aloe species. Also, the amount of sun coming in a South facing window in the winter isn't nearly as much as you might think it is. This is especially true if you have overcast winter's. Then there is the issue of most aloes being cool season growers that can be prone to rot if they get too much rain in the summer when you put it out. Tree aloe species tend to be huge. Even the solitary trunk ones have pretty sizable diameters.

Do you have a specific species in mind?

I cannot think of any tree/trunking aloes that would tolerate growing indoors... sorry... I agree with the above glass roof suggestion. Where I live now I have to bring in most of my sensitive aloes for up to 3 months sometimes, and that period of 'sun' by the window is always a huge hit in terms of setting them back, make them etiolate, allowing mealy bug to attack, etc. that it's hardly worth it anymore. I think 1-2 months is about the limit I can keep an aloe indoors and keep it happy without being in a greenhouse situation. Very young, tiny aloes are an exception and fare better... but anything near a foot tall becomes very unhappy by that point... Aloe vera var. chinensis is an exception, though... and commonly kept as a house plant. But I think trying any trunking aloes in that sort of situation is going to be a real challenge.

Nil13, I live at high elevation in Colorado high desert, our winters are full sun and it's easy to get sunburned even in January because the sun is much stronger at elevation, no overcast winters. The only thing is the spring thunderstorms that might make the aloe too wet as they are a frequent occurrence for a month or so. I don't have a specific species in mind, but I am wondering if a hybrid would be able to tolerate being over wintered indooors more than a species, it's been my experience with most plant that hybrids are usually much tougher and more adaptable to subprime culture than species.

I actually got a cutting fall of last year and am growing indoors in Massachusetts. It rooted indoors last winter and I loved it out mid April and we had a late not quite freezing snow storm that melted that night and it was fine. Ill update in 2 years.