My home course is Newport Golf Club in Crosby, Texas (
http://www.newport-tx.com/course/
). We just had a house built on hole #2, so being able to walk on and play is an added bonus. As for the course itself, it is nothing special, so getting a house on this golf course is not what you may imagine. When it opened in the mid 1970's, it was a private club with regular league play and tournaments. In 2000, it became public with new ownership and has really struggled to maintain the course due to lack of business. Don't get me wrong, they still water it and aerate the greens and whatnot, but they don't mow near enough as they need to. They have been removing dead trees lately to clean it up and they are getting some tournaments back in, so I think they are on the rebound and hopefully will get in better shape soon.
As for the course, my favorite hole is #18. It's probably the most picturesque hole. 420 yard par 4 dogleg right with water along the right side hitting onto an island green surrounded by sand bunkers. It's a nice hole to finish on.
Here is the view from my backyard. I'm right at the 150 yard marker and about 250 yards out from the blue tees. I get about 10 to 15 balls a week hit in the backyard that people either don't find or are too lazy to look for.
http://imgur.com/TfG2hPz