A Brutal Final Hand

Last night I played in the Wallingford home game and things started out very nice. I have a pretty tight table image over there and that has allowed me to get away with some nice bluffs. I try not to push it too much and if I get caught I go back to my usual tight play, but last night it seemed like nobody wanted to tangle with me. I did hit a snag when I tried to get tricky and limped in (didn't raise pre-flop) with pocket aces and when two fours came on the flop I knew I had let a crappy hand in for free and it was going to cost me. I was right and almost left as we were only going to play for another hour. I decided to rebuy and within 30 minutes had more than doubled my stack again when the final hand came up. Of course, at the time I didn't know it would be the final hand.
I was in the small blind and called the bet with 3-4 offsuit. It looked like the big blind checked (I thought he motoioned with his hand) and the dealer thought so, too and even asked him at which time he decided to make a weak raise of $5. I quickly called as I had been able to get this player to dump hands off to me earlier. The flop came Q-2-3 all hearts. Now this is a dangerous board for 3-4 even if I had a heart, which I didn't. I bet anyway to see where I was at and the player called. Now I figure he probably has at least one heart and is looking to make his flush. The 4 of hearts comes on the turn and now I have two pair but I know he made his flush, I bet again thinking if he doesn't have the nut flush (Ace high) he might be worried by my bet. He called again so I know he has a flush, just not sure how strong it is and I have 4 outs to the full house anyway. The river is a black 3 making me a full house, threes full of fours, beating a flush, of course. I decide to bet strong and make him think I am bluffing, and there are actually only two possible cards he could be holding in his hand that can beat me. I bet out $40 and he pushes all in, I had to call and the pot is now about $400. Of course he turns over the only two cards that can beat my hand, the ace and five of hearts for a straight flush and the absolute nuts! I can't call this a bad beat as I shouldn't have played the hand in a raised pot (even a weakly raised pot like this one) and I shouldn't have been chasing a four-outer either. It was just a bad hand, it still sucks, but I did it to myself. Of course 99+% of the time I take that nice pot down so I can't really complain. Needless to say, not one of my better nights as far as final results go, but I actually played well for the session overall (not including this hand or the pocket aces earlier) and in the long run playing well and making the right decisions leads to positive results at year end which is what it is all about.