Skip To Content
    • Home
    • lists
    • Holy Hovel! Decrepit $828K Property in Queens Is the Week’s Most Popular Home

    Holy Hovel! Decrepit $828K Property in Queens Is the Week’s Most Popular Home

    At one time, this was a lovely home. Today, not so much. The decrepit residence with shocking listing photos is this week’s most popular home on®.

    This week, many of you took a moment to click on what might be the saddest house in the country: an abandoned home in Flushing, NY, with uninhabitable interiors, punctuated by a rotting hot tub out back.

    What caused folks to click like crazy was the property’s price tag—$828,888. The house isn’t salvageable, but it is sitting on a 4,912-square-foot lot in Queens.

    The viral listing was first shared by a Twitter account affiliated with New York City’s EMT workers. It reads like a not-so-subtle dig at NYC’s affordability for its first responders.

    Teardown, anyone?

    Away from the ugliness of the viral mess, you also managed to click on several gorgeous waterfront properties.

    “Real Housewives of New York” star Luann de Lesseps is selling her eminently tasteful, mid-mod Hudson River home for $1.15 million.

    The retired NHL star Jamie Langenbrunner listed a massive 20-acre estate on Moose Lake in Minnesota for $1.7 million. And a gargantuan waterfront mansion in Long Island also proved captivating.

    Only one of this week’s most popular homes isn’t fit for human habitation. The rest of these clickworthy properties are sparkling and ready for you to move on in. Scroll on down for a closer look…

    10. 615 E. Newhall Ave, Waukesha, WI

    Price: $649,900

    Why it’s here: Stylish digs just outside Milwaukee! Effortlessly cool and impeccably maintained, this midcentury modern from 1950 sits on 2 lush acres.

    There are water features in the front and back, as well as an in-ground pool. Inside, the over 4,000-square-foot floor plan is open and features walls of windows.

    Waukesha, WI midcentury modern exterior
    Waukesha, WI


    9. 397 Oyster River Rd, Warren, ME

    Price: $220,000

    Why it’s here: Built in 1900, this classic three-bedroom farmhouse is absolutely adorable.

    The home has fresh paint and newly refinished wood floors, a rocking porch, and a mudroom. The over 2-acre property also includes an insulated studio, as well as a detached two-car garage.

    Warren ME farmhouse exterior
    Warren, ME


    8. 215 Germantown Rd, Summerville, SC

    Price: $260,000

    Why it’s here: Dreamy from the curb, this pastel green cottage was built in 1998.

    The four-bedroom home has been recently updated and is move-in ready, complete with a brand-new deck out back for observing the local wildlife. It sits on a half-acre and is just a quick bike ride to downtown.

    Summerville, SC cottage exterior
    Summerville, SC


    7. 16255 Harwood Dr S.W., Frostburg, MD

    Price: $224,800

    Why it’s here: Built in 2013, this traditional three-bedroom brick house on a full acre of land is made for family living.

    A wide front porch welcomes guests to the home and is a perfect spot to kick back and soak it all in. The house boasts hardwood floors, a security system, and a roomy rear patio.

    Frostburg, MD brick house exterior
    Frostburg, MD


    6. 1075 W. Park Ave, Long Beach, NY

    Price: $5,499,000

    Why it’s here: Sitting on Reynolds Channel and close to Atlantic Beach, this waterfront mansion brings Nantucket style to Long Island.

    The huge, five-bedroom home is filled with light and plenty of formal spaces.

    Over-the-top details include a mahogany wood billiard-room, a gorgeous outdoor living area, and a state-of-the art dock system with three boatlifts.

    Long Beach, NY mansion exterior
    Long Beach, NY


    5. 243 Tilden St, Port Ewen, NY

    Price: $1,150,000

    Why it’s here: This circular midcentury modern house on the Hudson River would be a showstopper all on its own.

    However, it’s received an extra boost thanks to the seller, “Real Housewives of New York” star Luann de Lesseps.

    De Lesseps told the New York Post that she was rarely able to visit this gorgeous retreat from hectic city life. The property is on nearly a full acre, is ringed with decks for entertaining, and includes a full 200 feet of waterfront.

    Inside, the three-bedroom home is stylish and designed for entertaining a crowd—or bickering with castmates. You decide!

    Port Ewen NY Hudson River house exterior
    Port Ewen, NY


    4. 94096 Warloe Shore Ln, Moose Lake, MN

    Price: $1,700,000

    Why it’s here: Lakeside luxury! This massive eight-bedroom timber lodge is being sold by the former NHL star and Minnesota native Jamie Langenbrunner.

    Designed for water lovers, it sits on over 20 roomy acres and offers 200 feet of lakefront.

    Rustic but refined, the huge home has a ton of luxe amenities, including a game room, home theater, tennis court, fitness facility, and wine cellar.

    Moose Lake, MN house Jamie Langenbrunner
    Moose Lake, MN


    3. 225 S. Hamilton Dr, Apt 102, Beverly Hills, CA

    Price: $1,600,000

    Why it’s here: This once nondescript, two-bedroom condo was transformed into a blush pink, jewel-encrusted, Chanel-themed fantasia.

    The current tenant—the woman who performed the awe-inspiring makeover—is moving out and is also willing to negotiate some of the furnishings along with the purchase.

    Deep-pocketed buyers with a fascination with neo-Hollywood Regency should head for Beverly Hills!

    Beverly Hills, CA condo pink interior
    Beverly Hills, CA


    2. 1150 N. Henderson Ave, Cape Girardeau, MO

    Price: $449,000

    Why it’s here: Listed on the National Register of Historic Places, this midcentury modern home is known as the Dr. Jean Chapman House. It was designed and built by local architect John Boardman in 1963.

    Today, the four-bedroom marvel remains in impeccable condition. Original touches, like the solid walnut accent walls, rosewood cabinetry, and walls of windows, all remain intact.

    Girardeau, MO mid mod house exterior
    Cape Girardeau, MO


    1. 50-18 196th St, Fresh Meadows, NY

    Price: $828,888

    Why it’s here: A social media superstar? Twitter sent folks scurrying to check out the unbelievable listing photos accompanying this uninhabitable mess.

    And just when you thought your gross-out meter was in the red, a new horrific photo appeared. For us, the topper was the kitchen—which looks as if it’s been reclaimed by nature, with vines creeping up the walls.

    It’s another case of an odd disconnect between premium price and horrific home. We’ve previously seen this phenomenon in the San Francisco Bay Area, but it can crop up in any hot market where land is scarce and developers are plentiful.

    The real question: Does the location of the lot justify this particular property’s hefty price tag? Social media opinion remains divided on the issue.

    Fresh Meadows, NY abandoned house
    Fresh Meadows, NY

    The post Holy Hovel! Decrepit $828K Property in Queens Is the Week’s Most Popular Home appeared first on Real Estate News & Insights |®.

    Comments are closed.

    About our blog

    +1 us on Google Plus!