352 Columbia, Hudson

$1,250,000

4 Beds
2½ Baths
2,400 Sqft
.07 Acre
0 Garage

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

Essential Information
MLS® #156711
Price$1,250,000
Bedrooms4
Bathrooms2.50
Full Baths2
Half Baths1
Square Footage2,400
Acres0.07
Year Built1920
TypeResidential
Sub-TypeSingle Family Residence
StyleContemporary
StatusActive
Community Information
Address352 Columbia
AreaHudson
CityHudson
CountyColumbia
StateNY
Zip Code12534
Amenities
ParkingAlley Access
Interior
HeatingCentral, Natural Gas
FireplaceYes
# of Fireplaces1
FireplacesGas Log, Living Room
StoriesTri-Level
Interior Features

Built-in Features, Eat-in Kitchen, Granite Counters, High Speed Internet, Kitchen Island, Smart Home, Soaking Tub, Walk-In Closet(s)

Appliances

Water Heater, Electric Water Heater

Cooling

Central Air, ENERGY STAR Qualified Equipment

Exterior
ExteriorOther
Exterior FeaturesGarden, Private Yard
RoofRubber
ConstructionOther
FoundationConcrete Perimeter
School Information
DistrictHudson
Listing Details
AgentEmily Iason
Listing Courtesy of Four Seasons Sotheby's Int.
Property History
Price Reduced from $1,295,000 to $1,250,000
LISTING MAP

Get directions to this property:

Properties for Sale Similar to 352 Columbia, Hudson, NY

Photo of Listing #20251978

1 E Court Street, Hudson

$1,550,000 - 4 Beds, 4 Baths, 2,904 Sf

MLS® # 20251978

Ulster County Board of Realtors Logo
Photo of Listing #20251974

601 Spook Rock Road Road, Hudson

$1,450,000 - 4 Beds, 2 Baths, 2,100 Sf

MLS® # 20251974

Ulster County Board of Realtors Logo
Photo of Listing #20251738

526 State Street, Hudson

$1,145,000 - 4 Beds, 4 Baths, 3,100 Sf

MLS® # 20251738

Ulster County Board of Realtors Logo

Ulster County Board of Realtors Logo The data relating to real estate on this website comes in part from the IDX of the Multiple Listing Service of Ulster County, Inc. Real estate listings held by brokerage firms other than Flemming Realty are marked with IDX logo and the detailed information about them includes the name of the listing broker.

Copyright © 2025 by the Multiple Listing Service of Ulster County, Inc. All Rights Reserved.

All information provided is deemed reliable but is not guaranteed and should be independently verified.

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.