What the most latest year first elected john hostettler incumbent and result lost re-election democratic gain?
District Incumbent Party First elected Results
United States House of Representatives elections, 2006
1805191
text text text real text
2-1805191-15
Indiana
Indiana
Indiana 1 Pete Visclosky Democratic 1984 Re-elected
Indiana 2 Chris Chocola Republican 2002 Lost re-election Democratic gain
Indiana 3 Mark Souder Republican 1994 Re-elected
Indiana 4 Steve Buyer Republican 1992 Re-elected
Indiana 5 Dan Burton Republican 1982 Re-elected
Indiana 6 Mike Pence Republican 2000 Re-elected
Indiana 7 Julia Carson Democratic 1996 Re-elected
Indiana 8 John Hostettler Republican 1994 Lost re-election Democratic gain
Indiana 9 Mike Sodrel Republican 2004 Lost re-election Democratic gain
SELECT MAX First elected FROM table WHERE Results = lost re-election democratic gain AND Incumbent = john hostettler
lost re-election democratic gain john hostettler