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
    • 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
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

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

Layout spacer

    Layout spacer

      About Us

      • Who We are
      • Meet the Team

      Resources

      • Latest Blogs
      • Free Vendor List
      • 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
      0
      $1,150,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,451/mo

      $1,150,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 Market24 days

      Est. Monthly Payment

      $5,450.97

      %
      %
      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
      24 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
      • Listed for sale
        Apr 14, 2026 • GLOBAL MLS • 202615019
        $1,150,000
      Mortgage Calculator
      Estimated monthly payment for this property
      $5,450.97
      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
        12 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
        • Lighting

      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
        24 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 →
      • 206 Charles Herrmann Way, Milo, NY 14527ACTIVE$1,039,900OPEN 5/8

        206 Charles Herrmann Way, Milo, NY 14527

        Unit • 2062 Beds2 Baths1,729 SqFt22 Acres

        LISTING BY THE IVERSEN REALTY GROUP

      • 208 Charles Herrmann Way, Milo, NY 14527ACTIVE$1,039,900OPEN 5/8

        208 Charles Herrmann Way, Milo, NY 14527

        Unit • 2082 Beds2 Baths1,729 SqFt22 Acres

        LISTING BY THE IVERSEN REALTY GROUP

      • 4020 Deer Crossing, Pompey, NY 13104ACTIVE$1,050,000

        4020 Deer Crossing, Pompey, NY 13104

        5 Beds4.5 Baths6,707 SqFt2.09 Acres

        LISTING BY KELLER WILLIAMS SYRACUSE

      • 212 Mannix Road, East Greenbush, NY 12061ACTIVE$1,050,000

        212 Mannix Road, East Greenbush, NY 12061

        4 Beds3 Baths3,056 SqFt18.63 Acres

        LISTING BY KW PLATFORM

      • 4990 Kraus Road, Clarence, NY 14031ACTIVE$1,050,000

        4990 Kraus Road, Clarence, NY 14031

        4 Beds3.5 Baths4,034 SqFt1.1 Acres

        LISTING BY HUNT REAL ESTATE CORPORATION

      • 15 Thoroughbred Drive, Saratoga Springs, NY 12866ACTIVE$1,050,000

        15 Thoroughbred Drive, Saratoga Springs, NY 12866

        3 Beds3.5 Baths2,088 SqFt0.14 Acres

        LISTING BY KW PLATFORM

      • 357 County Highway 9, Oneonta, NY 13820ACTIVE$1,050,000

        357 County Highway 9, Oneonta, NY 13820

        5 Beds4.5 Baths5,800 SqFt153.43 Acres

        LISTING BY KELLER WILLIAMS UPSTATE NY PROPERTIES

      • 546-548 Maple Avenue, Wilton, NY 12866ACTIVE$1,050,000

        546-548 Maple Avenue, Wilton, NY 12866

        5 Beds3 Baths2,800 SqFt3.31 Acres

        LISTING BY EXP REALTY

      • 5122 Kandefer's Trail, Clarence, NY 14221ACTIVE$1,058,000

        5122 Kandefer's Trail, Clarence, NY 14221

        3 Beds2.5 Baths2,451 SqFt0.4 Acres

        LISTING BY MARRANO/MARC EQUITY CORP

      • 17 Dark Bay Lane, Queensbury, NY 12845ACTIVE$1,075,000

        17 Dark Bay Lane, Queensbury, NY 12845

        4 Beds2 Baths1,890 SqFt0.42 Acres

        LISTING BY DAVIES-DAVIES & ASSOC REAL EST