$1,150,000
$145K PRICE DROP

352 Columbia St Hudson, NY 12534

Estimated payment $6,784/month

Total Views 19,949
4 Beds
2.5 Baths
2,400 Sq Ft
$479 Price per Sq Ft

Highlights

  • Contemporary Architecture
  • Granite Countertops
  • No HOA
  • Great Room
  • Mud Room
  • 1-minute walk to Pocket Park

About This Home

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

Listing Agent

Emily Iason

Four Seasons Sotheby's Int. License #10401345178 Listed on: 04/25/2025

Four Seasons Sotheby's Int.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,877

Year Built

  • Built in 1920

Lot Details

  • 3,049 Sq Ft Lot
  • Back Yard Fenced
  • Garden

Parking

  • Alley Access

Home Design

  • Contemporary Architecture
  • Tri-Level Property
  • Rubber Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • Built-In Features
  • Gas Log Fireplace
  • Double Pane Windows
  • Insulated Windows
  • ENERGY STAR Qualified Doors
  • Mud Room
  • Great Room
  • Living Room with Fireplace
  • Tile Flooring
  • Finished Basement

Kitchen

  • Eat-In Kitchen
  • Kitchen Island
  • Granite Countertops
  • Farmhouse Sink

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Soaking Tub

Home Security

  • Home Security System
  • Smart Home

Utilities

  • ENERGY STAR Qualified Air Conditioning
  • Central Heating and Cooling System
  • Heating System Uses Natural Gas
  • Electric Water Heater
  • High Speed Internet

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 109.44-3-21

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,877

Year Built

Built in 1920

Lot Details

0

Listing Details

  • Year Built: 1920
  • Property Sub-Type: Single Family Residence
  • Lot Size Acres: 0.07
  • Road Surface Type: Paved
  • Co List Office Phone: 518-822-0800
  • MLS Status: Active
  • Architectural Style: Contemporary
  • Unit Levels: Tri-Level
  • Property Attached Yn: No
  • General Property Information Lot Size Acres: 0.07
  • Sewer:Public Sewer: Yes
  • Cooling:Central Air: Yes
  • Security Features:Security System: Yes
  • General Property Information:Bathrooms Half: 1
  • General Property Information Fireplace YN: Yes
  • Water Source:Public: Yes
  • Architectural Style:Contemporary: Yes
  • General Property Information Basement YN: Yes
  • RoofRubber: Yes
  • Fencing Back Yard: Yes
  • Room Types Great Room2: Yes
  • Flooring Tile: Yes
  • Cooling ENERGY STAR Qualified Equipment: Yes
  • Levels Tri-Level: Yes
  • Foundation Details Concrete Perimeter: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Water Heater, Electric Water Heater
  • Interior Amenities: Built-in Features, Eat-in Kitchen, Granite Counters, High Speed Internet, Kitchen Island, Smart Home, Soaking Tub, Walk-In Closet(s)
  • Basement: Finished
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Door Features: ENERGY STAR Qualified Doors
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Tile
  • Appliances:Electric Water Heater: Yes
  • Basement Finished: Yes
  • Interior Features:Eat-in Kitchen: Yes
  • Fireplace Features:Living Room: Yes
  • Interior Features:Kitchen Island: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:Soaking Tub: Yes
  • Interior Features:Built-in Features: Yes
  • Interior Features:Smart Home: Yes
  • Fireplace Features:Gas Log: Yes

Exterior Features

  • Exterior Features: Garden, Private Yard
  • Roof: Rubber
  • Construction Type: Other
  • Foundation Details: Concrete Perimeter
  • Construction Materials:Other8: Yes
  • Window Features:Insulated Windows: Yes
  • Exterior Features:Garden: Yes
  • Exterior Features:Private Yard: Yes
  • Window Features:Double Pane Windows: Yes
  • Door Features:ENERGY STAR Qualified Doors: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Alley Access
  • Parking Features:Alley Access: Yes

Utilities

  • Sewer: Public Sewer
  • Electric: 200+ Amp Service
  • Cooling: Central Air, ENERGY STAR Qualified Equipment
  • Cooling Y N: Yes
  • Heating: Central, Natural Gas
  • HeatingYN: Yes
  • Water Source: Public
  • Water Heater: Yes
  • Heating:Natural Gas: Yes
  • Heating:Central: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • General Property Information:Association YN: No

Schools

  • Junior High Dist: Hudson City Schools

Lot Info

  • Lot Size Sq Ft: 3049.2
  • ResoLotSizeUnits: Acres
  • Parcel Number: 109.44-3-21

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $7,877 $650,000 $42,000 $608,000
2023 $13,701 $650,000 $42,000 $608,000
2022 $12,603 $650,000 $42,000 $608,000
2021 $8,847 $650,000 $42,000 $608,000
2020 $1,814 $95,000 $42,000 $53,000
2019 $900 $95,000 $42,000 $53,000
2018 $900 $71,000 $14,000 $57,000
2017 $2,576 $71,000 $14,000 $57,000
2016 $1,261 $71,000 $14,000 $57,000
2015 -- $71,000 $14,000 $57,000
2014 -- $71,000 $14,000 $57,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/10/2025 07/10/25 Price Changed $1,150,000 -5.7% $479 / Sq Ft
06/27/2025 06/27/25 Price Changed $1,220,000 -2.4% $508 / Sq Ft
05/30/2025 05/30/25 Price Changed $1,250,000 -3.5% $521 / Sq Ft
04/25/2025 04/25/25 For Sale $1,295,000 +1263.2% $540 / Sq Ft
01/18/2019 01/18/19 Sold $95,000 -45.7% $58 / Sq Ft
11/02/2018 11/02/18 Pending -- -- --
03/23/2018 03/23/18 For Sale $175,000 -- $107 / Sq Ft
Source: Hudson Valley Catskills Region Multiple List Service

Purchase History

Date Type Sale Price Title Company
Deed $95,000 --
Deed $95,000 --
Deed $95,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $414,000 New Conventional
Source: Public Records

Source: Hudson Valley Catskills Region Multiple List Service

MLS Number: 156711

Hudson Valley Catskills Region Multiple List Service

APN: 100600-109-044-0003-021-000-0000