Shady Real Estate Agent

A seemingly helpful character whose job is to help people like newlywed couples looking for their first home to find the best possible domicile, but whose personality practically screams "real estate fraud" to the viewer. Whether he's a real Con Man or just a really, really immoral entrepreneur, you can be sure that the characters will be cursed with leaking roofs and drafty windows as soon as they have signed the papers...Or worse.

See also Real Estate Scam. Compare Honest John's Dealership.

Examples of Shady Real Estate Agent include:

Anime and Manga

The character who launches the events of Little House With an Orange Roof qualifies, by selling the same house to two families, who are then forced to live together.
Kurosagi Corpse Delivery Service: Japanese real estate agents are legally required to tell the truth about what happened to the previous tenant (murder, suicide, hauntings etc.) But this only applies to the tenant immediately before the new customer. In one chapter of the manga, a decidedly shady-looking real estate agent employs a man to live in dubious properties just long enough to trigger the loophole.

Film

Ghostbusters: The female real estate agent trying to get the heroes to buy an old firehouse as their headquarters.

Real estate agent: There's office space, sleeping quarters and a full kitchen.
Peter Venkman: It seems a little pricey for a fixer-upper. What do you think, Egon?
Egon Spengler: I think this building should be condemned. There's serious metal fatigue in all the load-bearing members, the wiring is substandard, it's completely inadequate for our power needs, and the neighborhood is like a demilitarized zone.

- Yeah, but you've gotta try this pole!
  - Egon's complaints may be about dropping the price, and there might be nothing wrong with the firehouse itself
The agent who sold the house to Tom Hanks' and Shelley Long's characters in The Money Pit.
- The former tenant was the one who talked them into buying it, and though she fit the archetype perfectly, she wasn't an agent. She and "Carlos" were scam artist who made their money by flipping distressed properties.
One is mentioned, if not seen, in the film Seven. When Detective Somerset goes over the the Mills household for dinner, multiple trains passing nearby make everything in the house shake. At one point Mrs. Mills mentions that when they were looking at the house, they thought it was great, but wondered why the realtor would only let them stay in it for 5 minutes at a time. Now they understand all too well.

Live Action TV

Bob Jelly from Sea Change is not a con man, but definitely opportunistic.
Harold Gribble from Round the Twist.
One episode of Minder had a crooked slum lord who might have been based on Peter Rachman, below (or at least the two used similar methods).
An episode of CSI New York features an estate agent who earns his living by breaking into houses to evaluate them before his competition. Unfortunately for him the house he breaks into is booby trapped, Resident Evil style (minus the undead) and he ends up burnt to death by a trapped phone.
Mr. Haney from Green Acres is usually an Honest John, but he did sell Oliver his old home, which is borderline dilapidated.

Western Animation

Pretty much the point of the French animated short Villa Mon Reve.
Marge worked for one of these briefly on The Simpsons, where Lionel Hutz was her boss.

Lionel: Marge, I had a lot of calls about you! Customers love your "no pressure" approach.
Marge: Well, like we say, "the right house for the right person!"
Lionel: Listen, it's time I let you in on a little secret, Marge. The right house is the house that's for sale. The right person is anyone.
Lionel then coaches Marge on proper sales technique, showing her a catalog of available houses.
Marge: It's awfully small...
Lionel: I'd say it's awfully … cozy!
Marge: That's dilapidated...
Lionel: Rustic!
Marge: That house is on fire!
Lionel: Motivated seller!

Real Life

Peter Rachman is an infamous British real-life example.