#156789, Sean Roland, Listing Office: Compass Greater NY LLC
352 Columbia St Hudson, NY 12534
Property details
About 352 Columbia St
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
Highlights
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 2
- Appliances: Electric Water Heater
- Basement: Yes
- Flooring Type: Hardwood, Tile, Wood
- Fireplace: Living Room
- Total Bedroom Count: 4
- Architectural Style: Contemporary, Modern
- Cooling: Central Air
- List Price: $1,295,000
- Price/SqFt: $539
- Annual Tax Amount: $9,634
- Tax Year: 2021
- Directions: North side of Columbia St
- Year Built: 1920
- Living Area: 2,400 SqFt
- Lot Size: 0.07 Acres
- MLS Number: 156711
- MLS Name: ColumbiaGreene
- Office Name: Four Seasons Sothebys International Realty - Hudson
- Office Phone: (518) 822-0800
- Office Email: michele.richards@fourseasonssir.com
- Listing Agent: Emily Iason
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Copyright © 2025 Columbia Greene Northern Dutchess Multiple Listing Service. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 5/1/2025, 8:15:56 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹

$1,295,000
352 Columbia St
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
Date | Event | Price |
---|---|---|
Jan 31, 2019 | Home Sold | $95,000 |
Tax history
Year | Assessment | Property Tax |
---|---|---|
2023 | $650,000 | $- |
2022 | $650,000 | $- |
2021 | $650,000 | $9,634 |
2020 | $95,000 | $9,634 |
2019 | $95,000 | $1,844 |
2018 | $71,000 | $900 |
2017 | $71,000 | $- |
History based on county public records data.
Nearby schools
4
Montgomery C Smith Elementary School
Public District PK-5
0.5 mi
•102 Harry Howard Ave
3
Edward J Arthur Elementary School
Public District KG-4
1.6 mi
•51 3rd St
5
Catskill Elementary School
Public District PK-5
5.4 mi
•770 Embought Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $53,641. The most common annual income of people living in Hudson, NY is between $35k-100k. Most families are single, no kids. Typical level of education for residents in this area is high school diploma.
Similar homes for sale
Frequently asked questions
About 352 Columbia St
The listing price of 352 Columbia St property is $1,295,000.
The property 352 Columbia St is a house located in Hudson, New York, 12534.
Active Listing: 352 Columbia St is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 352 Columbia St are: Montgomery C Smith Elementary School (GreatSchools Rating 4/10), Edward J Arthur Elementary School (GreatSchools Rating 3/10), Catskill Elementary School (GreatSchools Rating 5/10), Hudson Junior High School (GreatSchools Rating 4/10), Catskill Middle School (GreatSchools Rating 6/10), Coxsackie-Athens Middle School (GreatSchools Rating 3/10), Hudson High School (GreatSchools Rating 3/10), Catskill Senior High School (GreatSchools Rating 6/10), Coxsackie-Athens High School (GreatSchools Rating 6/10).
According to the records, the last property tax for 2021 is $9,634 (source: MLS/based on county public records data).
The last sale was on January 31, 2019 for $95,000 (source: MLS/tax record).
The property at 352 Columbia St has 4 bedrooms and 2 full and 1 half bathrooms.
The property 352 Columbia St is 2,400 SqFt (source: MLS/tax record).
The year of construction for 352 Columbia St is 1920.
This home is located at 352 Columbia St in Hudson, NY and zip code 12534. This 2,400 square foot home, which was built in 1920, sits on a 0.07 acre lot. Features: 4 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since April 24, 2025 and is currently priced at $1,295,000.
In April 2025, from all listings sold in Hudson, NY there were more than 3 sold above asking price, over 7 sold below and more than 1 were sold right at the asked price. Between March and April 2025, Hudson, NY real estate market has seen increase in the number of listings by 15.8%. In April 2025 median list price was $670,000 and the average listing age was 77 days.