KLM operate a combi between Amsterdam and Houston. I have flown it more than a dozen times during the last 5 years and can say based on experience that the freight is aft of the passengers.
I was in first class (nose section) and a freight pallet got stuck in the aft door, we were delayed for 5 hours before the situation was rectified.
As far as I know all combi's are aft freight loaders. Front first and upper decks are pax areas.
Check out this seat plan on seatguru
SeatGuru Seat Map KLM Boeing 747-400 Combi (74E)
Cheers
KW