i would just show him the numbers. take your current budget... add up how much you pay for food, car payments, gas, insurance, etc, basically all the essentials except for mortgage and utilities. take that total, say its $1500. then take how much your dh takes home each month, say $3000. tell him that after paying for all the bills that have to be paid, you have $1500 left over to pay for the mortgage, utilities, and any other extras (savings, vacation fund, college funds, retirement, entertainment, etc). basically bring him back to reality... that if he wants a $200k house, XYZ is what its going to cost for the mortgage, insurance, and property taxes. then tell him you called the listing agent on a 123 main street that he liked and that the utilities were however much a month. let him see that he would have to give up his daily starbucks or you'd only be able to go out to dinner once a month instead of twice (or no golfing saturday mornings with the guys, or whatever he likes to do).
then come to a compromise. like a PP said, maybe a $150k house. just figure out where you're comfortable. oh, and keep in mind what property taxes are. not sure how much they are in the areas you're looking at, but where i am, they can differ $2,000+ a year for comparably priced houses, which can make a BIG difference in the monthly mortgage payment.