It's similar to 'it was there', but you often use 'there it was' when perhaps you were looking for something or reached some conclusion. Example: I couldn't find my money. I looked in all the rooms of my house, then I eventually went to check my car. There it was - in my glove compartment!