HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 352 Columbia Street, Hudson, NY 12534
ACTIVE
$65,000
$1,085,000

352 Columbia StreetHudson, NY, 12534

4 Beds2.5 Baths3,074 SqFt0.07 Acres
Welcome to Madam Mae House, a four-story contemporary townhome in the heart of walkable downtown Hudson, rebuilt from the ground up in 2019, finished with the material quality of a high-end custom build. A double-height living room rises to twenty feet with two-story windows that flood the home with light. The full third floor is a private primary suite with a soaking tub and walk-in shower. The cozy finished basement has an underground parlor feel, nodding to the home's Diamond District past: once home to Mae Gordon, one of Hudson's last notorious madams. A three-tiered backyard with gardens, Catskill views, and private off-street parking rounds out an uncommonly generous downtown address.
1 / 48

Est. Monthly

$5,143/MO

$1,085,000
$65,000

352 Columbia Street, Hudson, NY

4 Beds2.5 Baths3,074 SqFt0.07 Acres

Welcome to Madam Mae House, a four-story contemporary townhome in the heart of walkable downtown Hudson, rebuilt from the ground up in 2019, finished with the material quality of a high-end custom build. A double-height living room rises to twenty feet with two-story windows that flood the home with light. The full third floor is a private primary suite with a soaking tub and walk-in shower. The cozy finished basement has an underground parlor feel, nodding to the home's Diamond District past: once home to Mae Gordon, one of Hudson's last notorious madams. A three-tiered backyard with gardens, Catskill views, and private off-street parking rounds out an uncommonly generous downtown address.

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built2019
Total Rooms10 rooms
Days on Market66 days

Est. Monthly Payment

$5,142.87

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

352 Columbia Street

Hudson, NY 12534 • Columbia
4
Beds
2.5
Baths
3,074
SqFt
0.07
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
20197 years ago
Total Rooms
10 rooms
Days on Market
66 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $23,651
  • School Taxes
    $7,764
  • Town/County Taxes
    $15,887
Property History
  • Price reduced
    May 27, 2026 • GLOBAL MLS • 202615019
    $1,150,000 → $1,085,000
  • Listed for sale
    Apr 14, 2026 • GLOBAL MLS • 202615019
    $1,150,000
Mortgage Calculator
Estimated monthly payment for this property
$5,142.87
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    Global MLS
  • MLS#
    202615019
  • Listing Office
    Houlihan Lawrence
  • Last Updated
    17 days ago

Kitchen & Laundry

  • Kitchen
    • Eat-in Kitchen
    • Kitchen Island

Appliances

  • Appliances
    • Range
    • Refrigerator
    • Washer
    • Dishwasher
    • Dryer
    • Microwave
    • Washer or Dryer

Climate & Systems

  • Heating
    Natural Gas
  • Fireplace
    Gas

Interior Features

  • Flooring
    • Wood
    • Tile
  • Basement
    Finished
  • Interior Features
    • Cathedral Ceiling(s)
    • High Speed Internet
    • Eat-in Kitchen
    • Kitchen Island

Parking

  • Parking Features
    Off Street

Lot & Grounds

  • Lot Size
    0.07 acres
  • Lot Features
    • Landscaped
    • Garden
  • View
    • City
    • Hills
    • Mountain(s)
  • Patio & Porch
    Deck
  • Exterior Features
    Garden

Type

  • Property Type
    Residential
  • Property Subtype
    Single Family Residence
  • Architectural Style
    Contemporary

Structure

  • Construction
    Block
  • Roof
    • Green Roof
    • Rubber
  • Foundation
    • Slab
    • Block

Condition

  • Year Built
    2019
  • Days on Market
    66 days
  • Water
    Public
  • Sewer
    Public Sewer
  • Electric
    200+ Amp Service

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 16228 Deer Run Road, Watertown Town, NY 13601ACTIVE$979,000

    16228 Deer Run Road, Watertown Town, NY 13601

    5 Beds4 Baths5,469 SqFt5.05 Acres

    LISTING BY KELLER WILLIAMS NORTHERN NEW YORK

  • 7095 Townline Road, Western, NY 13440ACTIVE$979,000OPEN 6/28

    7095 Townline Road, Western, NY 13440

    3 Beds3.5 Baths4,627 SqFt19.76 Acres

    LISTING BY HUNT REAL ESTATE ERA ROME

  • 12286 Williston Road, Marilla, NY 14004ACTIVE$979,000

    12286 Williston Road, Marilla, NY 14004

    6 Beds3.5 Baths4,678 SqFt4.79 Acres

    LISTING BY HUNT REAL ESTATE CORPORATION

  • 72 Tigerlily Ln, Lansing, NY 14850ACTIVE$979,000

    72 Tigerlily Ln, Lansing, NY 14850

    5 Beds4.5 Baths3,589 SqFt1.62 Acres

    LISTING BY WARREN REAL ESTATE

  • 74 Christiana Court, Lake George, NY 12845ACTIVE$979,000

    74 Christiana Court, Lake George, NY 12845

    2 Beds1 Bath576 SqFt0.01 Acres

    LISTING BY BERKSHIRE HATHAWAY HOMESERVICES BLAKE, REALTORS

  • 55 Lakeview Drive, Horicon, NY 12808ACTIVE$979,900

    55 Lakeview Drive, Horicon, NY 12808

    3 Beds2 Baths1,585 SqFt0.86 Acres

    LISTING BY CARR REAL ESTATE GROUP, LLC

  • 65 Woodthrush, Orchard Park, NY 14127ACTIVE$979,900

    65 Woodthrush, Orchard Park, NY 14127

    5 Beds4 Baths3,529 SqFt0.73 Acres

    LISTING BY FORBES CAPRETTO HOMES

  • 17 Wyatt's Way, Clifton Park, NY 12065ACTIVE$986,000

    17 Wyatt's Way, Clifton Park, NY 12065

    4 Beds2.5 Baths3,293 SqFt0.4 Acres

    LISTING BY COLDWELL BANKER PRIME PROPERTIES

  • 81 Hidden Oaks Court, Grand Island, NY 14072ACTIVE$989,000

    81 Hidden Oaks Court, Grand Island, NY 14072

    4 Beds4.5 Baths4,827 SqFt3.24 Acres

    LISTING BY CENTURY 21 NORTH EAST

  • 32 Huna Way, Lake George, NY 12845ACTIVE$989,000

    32 Huna Way, Lake George, NY 12845

    Unit • lot 33 Beds2.5 Baths2,208 SqFt0.86 Acres

    LISTING BY CARTIER REAL ESTATE GROUP LLC