Was this a movie era Connie or a TOS era one?
If it was TOS, then it could well be Commodore Matt Deckers USS Constellation, from the episode 'The Doomsday Machine'.
A movie era one, might well be either one of the destroyed USS Enterprise models from Star Trek III (Certainly Admiral Kirks flagship), or perhaps one of the battlefield modles used in Best of Both Worlds (mis-credited)?
Just a few options?
DanG/Darth Gurden
The Voice of Reason and Sith Lord
“Putting the FUNK! back into Dysfunctional!”
Coming soon. The USS Ganymede NCC-80107
"Ad astrae per scientia" (To the stars through knowledge)