Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Advisor Realty

Property view
Listing view 2
Listing view 3

247 Union Street, 
Hudson, NY 12534

$1,695,000


5

Beds


3

Baths


2,815

Sq Ft


Single Family

Active

Listed by

Ryan Wexler

Corcoran Country Living

518-660-7120

Last updated:

October 18, 2026, 06:45 PM

MLS#

20266141

Source:

NY MLSUC

About This Home

247 Union Street

Welcome to 247 Union Street, a distinguished Queen Anne Victorian built circa 1899, where historic Hudson architecture meets contemporary luxury. Extensively restored while preserving its original character, this five-bedroom, three-bath residence offers 2,815 sq ft of living space with exceptional craftsmanship and carefully selected finishes throughout. Inside, a graceful curved staircase, stained and leaded glass, intricate millwork, high ceilings, decorative ceiling medallions, hardwood floors and two fireplaces create an atmosphere rarely found in today's homes. The designer kitchen features custom cabinetry, marble countertops, premium appliances and Waterworks fixtures; all three full baths feature marble finishes and refined materials. A dedicated home office with custom built-ins, third-floor television/theater room, renovated mudroom with exterior access, upgraded central air and supplemental ductless systems add comfort and functionality. Substantial 2025-2026 exterior and building-envelope restoration included work on gutters, drainage, flashing, structural and sill repairs, siding, cedar shingles, windows, trim and porch elements. The covered rear porch leads to a private courtyard between the house and detached two-car carriage barn/garage. Stone pathways, mature landscaping, bespoke fencing and hedging create a rare sense of privacy, while the garage with EV charging provides valuable off-street parking. Ideally situated near Warren Street, the home offers easy access to restaurants, galleries, boutiques, cafés, Amtrak and the waterfront, with on-street parking also available. 247 Union Street offers historic authenticity, modern comfort and rare convenience in the heart of Hudson. Some homes are simply renovated. 247 Union Street has been thoughtfully transformed.

Home Facts

Single Family

3 Baths

5 Bedrooms

Built in 1899

Price Summary

1,695,000

$602 per Sq. Ft.

MLS #:

20266141

Last Updated:

October 18, 2026, 06:45 PM

Added:

7 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

3

Interior

Living Area:

2,815 Sq. Ft.


Structure

Structure

Architectural Style:

Victorian

Building Area:

2,815 Sq. Ft.

Year Built:

1899


Lot

Lot Size (Sq. Ft):

3,049


Finances & Disclosures

Finances

Price:

$1,695,000

Price per Sq. Ft:

$602 per Sq. Ft.

Source:NY MLSUC
The information being provided by Hudson Valley Catskill Mls is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 Hudson Valley Catskill Mls All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.