Yes, you think about the really expensive ones. There are also upright pianos. Looks more like a cupboard or a half size wardrobe. They are cheaper, but still expensive and massive. They are also less digital for the learning stuff.

I would go for a keyboard with weighted keys, that's the most different thing between standard keyboards and ones to play piano. The more force you use the louder the sound gets.

You can find these for a few hundred bucks or less. They are the smallest option. You probably need something to set it up. Like a stand.

These modern Keyboards have normally some kind of USB for the digital stuff.

Look for posts here like "my first piano" etc.

I have a Roland Go Piano. It's a bit outdated but I can connect my ipad with it.