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
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
- 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#: 156711
Originating MLS: Columbia County & Northern Dutchess MLS

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Open house
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