• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • THE ISLES GROUP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • The wealth report
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON MAY 09 2025 AT 8:26 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

887 Main St

holyoke, MA 01040

$359,000

  • 5 BR
    4 BA, 1 HALF BA
    APPROX. 4,103 SF
  • sold

INTERESTED? LET'S CONNECT

Own a part of Holyoke history with the extraordinary Prew Mansion. Magnificent wood work, stained glass, in-laid floors and many original fixtures create an ambiance of a bygone era. So many beautiful original features in this three Unit property with an in-law apartment on second floor of unit one. This property is a must see to appreciate. Coveted DR zoning allows for three live-in units as well as a business on the first floor (see attached). New owner can imagine and pursue a multitude of possibilities for this unique property. Built in pool adds to the potential for business and residential usage. Interior has maintained most of the original spectacular features, while exterior needs some repair and updating. Being sold as-is. GO AND SHOW APPTS. AVAILABLE THURS. 6/22 - SUN. 6/25 ON SHOWINGTIME.

Details

4,103 Sq Ft

0.35 Private Acres Exterior Space

Investment

$4,789 Annual Tax

Built in 1880

MLS/Listing ID 73127198

3 Stories

3 Units

Amenities & Features

Parking - Paved

Porch

Pool - Inground

Community - Highway Access

Community - House of Worship

Community - Medical Facility

Community - Public School

Bathroom with Tub

Bathroom with Tub and Shower

Ceiling Fans

Dining Room

Living Room

Office/Den

Community - Public Transportation

Community - Park

Brick Mortar

Heating - Oil

Heating - Gas

Community - Shopping

Disposal

Range

Refrigerator

Lot - Corner Lot

Lot - Gentle Sloping

Crown Molding

Pantry

MLSPIN

Source of Data: MLS PROPERTY INFORMATION NETWORK

Interested in 887 Main St?