Location, Location, Location

How do you advise someone on home buying who thinks that location, location, location means a home not too far from work (an industrial plant), not too near expensive (a house payment of less than one week's take home pay), and real close to a favorite night club (a dive bar)?