Is this an idiom? I've never heard it used in used a way.:-?
I can think of sentences where each preposition is used with 'front', but they all require something more after - the front X.
He died at the front door.
He died on the Western Front - as TheParser gave
He died in the front room.
Apologies if this is an idiom I just don't know of.