Skip main navigation
For sale
  • $1,295,000

    352 Columbia St, Hudson, NY 12534

    4beds
    2,400sqft
    Deeded, Single Family Residence
    Built in 1920
    3,049 Square Feet Lot
    $1,274,700 Zestimate®
    $540/sqft
    $-- HOA

    What's special

    Ventless fireplaceThree-tiered backyardFully renovated basementPrivate parkingPrivate sitting areaPergola-covered dining areaExtra-tall fencing
    Introducing The Madame - a stunning 2019 modern rebuild with a storied past rooted in Hudson's historic Red Light District. Originally constructed in 1920 for the notorious madame Mae Gordon, this iconic residence has been masterfully reimagined by Conklin Architecture and built with precision by Furnari Construction into a luxurious four-story home. Just steps from vibrant Warren Street, every inch reflects a thoughtful blend of history, design, and contemporary comfort.Designed with meticulous attention to detail, the home celebrates modern style and efficiency while paying homage to its colorful past. Soaring 20-foot ceilings and dramatic two-story front windows, with custom drapes, bathe the living space in light. The open-concept main floor features floor-to-ceiling shiplap and a striking ventless fireplace framed by a custom concrete mantle, creating a bold yet welcoming focal point. The kitchen features stainless steel appliances, a deep farmhouse sink, and an oversized island clad in custom-cut, black leathered granite. The open dining area seamlessly connects to the living space, ideal for entertaining or casual everyday gatherings. Just off the kitchen, a mudroom with herringbone brick flooring leads to the backyard and includes a convenient half bath.The second floor offers two bright bedrooms connected by a Jack and Jill ensuite bath, along with an open mezzanine overlooking the living area below. The third floor is dedicated entirely to the primary suite, featuring an expansive bedroom & parlor-style sitting area, cleverly designed walk-in closet, and a spa-inspired bath with a soaking tub, glass-enclosed shower, and water closet. The fully renovated basement, infused with speakeasy charm, offers a playful nod to Hudson's more risque era. Currently used as a cozy family room, this flexible space could be a fourth bedroom.Outside, the three-tiered backyard offers rare privacy with extra-tall fencing, French drains, and multiple zones including a garden level, grassy lawn, and a pergola-covered dining area perfect for summer BBQs. A private sitting area and Catskill Mountain views make the upper tier a quiet retreat. Alley access allows for private parking and presents the opportunity to add a garage or accessory dwelling.5 min walk to Warren, 10 mins to Amtrak2 hrs from NYC
    2 days
    on Zillow
    |
    619
    |
    39
    |

    Zillow last checked: 7 hours ago

    Listing updated: April 24, 2025 at 02:12am

    Listing by:

    Four Seasons Sotheby's Int. 518-822-0800,

    Emily Iason 914-671-4097

    Source: Columbia Greene Northern Dutchess MLS,MLS#: 156711MLS LogoOriginating MLS: Columbia County & Northern Dutchess MLS
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 352 Columbia St.

    Next available tour time:Today at 1pm

    Open house

    • Sat, Apr 26

      12:00 PM - 2:00 PM

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Central
    Cooling
    • Has cooling: Yes
    Appliances
    • Included: Water Heater (Electric)
    Features
    • Flooring: Tile, Brick, Engineered Hardwood, Pavers
    • Windows: Double Glazed, Display Window(s), Insulated Windows
    • Basement: Finished
    • Number of fireplaces: 1
    • Fireplace features: Living Room
    Interior area
    • Total structure area: 2,400
    • Total interior livable area: 2,400 sqft

    Property

    Features
    • Levels: Tri Level
    • Has view: Yes
    • View description: Catskills
    Lot
    • Size: 3,049 Square Feet
    Details
    • Parcel number: 109.44-3-21

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary,Modern
    • Property subtype: Deeded, Single Family Residence
    Materials
    • Sheetrock, Composite
    • Foundation: Poured Concrete
    • Roof: Rubber
    Condition
    • Excellent
    • Year built: 1920

    Utilities & green energy

    • Electric: 200+ Amp Service
    • Sewer: Municipal
    • Water: Municipal

    Community & HOA

    Community
    • Security: Security System
    Location
    • Region: Hudson

    Financial & listing details

    • Price per square foot: $540/sqft
    • Tax assessed value: $650,000
    • Annual tax amount: $16,356
    • Price range: $1.3M - $1.3M
    • Date on market: 4/24/2025
    • Electric utility on property: Yes
    • Road surface type: Paved
    • Loading
    • Loading