Bikes that are rarely ridden don't need a lot of maintenance, as long as they're stored indoors. You mostly just have to pump up the tires.

Solid tires are available, but the reason you rarely see them is that they ride like bricks.