• 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
  • Elliman Global
  • Investors

Resources

  • World of Elliman
  • Elliman Insider
  • Magazines
  • Market Reports
  • Research Reports
  • Elliman Private Listings
  • New Elliman Exclusives
  • Featured Cities
  • Guides to Buying & Selling

Brand Portfolio

  • New Development
  • Commercial
  • Relocation
  • Sports & Entertainment
  • Farm & Ranch
  • Building Broker Specialists
  • Title Services
  • Estate, Trust & Probate
  • Elliman Yachts

  • 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 NYC 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 © 2026 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 JUN 14 2026 AT 2:27 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.

SCAMMERS ARE IMPERSONATING REAL ESTATE AGENTS AND USING ACTIVE LISTINGS TO REQUEST FAKE DEPOSITS. SHOULD YOU HAVE A QUESTION ABOUT THE LEGITIMACY OF A DOUGLAS ELLIMAN AGENT OR LISTING, PLEASE CONTACT THE AGENT DIRECTLY VIA THE “AGENTS” LINK IN THE TOP MENU. DOUGLAS ELLIMAN WILL NEVER ASK FOR ANY PAYMENT TO RESERVE, HOLD, OR VIEW A PROPERTY. THESE CHARGES ARE PROHIBITED UNDER NEW YORK LAW. IF YOU RECEIVE A SUSPICIOUS REQUEST FOR MONEY, DO NOT SEND FUNDS. REPORT IT TO THE NYS DEPARTMENT OF STATE AND NOTIFY DOUGLAS ELLIMAN. YOU CAN READ THE NEW YORK STATE DEPARTMENT OF STATE'S CONSUMER ALERT HERE.

This website has been translated using automated software for convenience. While reasonable efforts have been made to ensure accuracy, machine translation may contain errors and is not a substitute for human translation. Translations are provided “as is,” without any express or implied warranty regarding their accuracy, reliability, or completeness. Some content (including images or videos) may not be translated accurately. The official version of this website is the English version. Any discrepancies in translation are not binding and have no legal effect; the English version controls.

POWERED BY PURLIN.AI

6188 N Main St

sandy creek, NY 13145

$370,000

  • 3 BR
    approx. 3,272 SF

Interested? Let's Connect

Step back in time with this extraordinary 1800s farmhouse brimming with history, character, and endless potential! Located on the outskirts of town, this truly one of a kind property offers a rare opportunity for investors, entrepreneurs, or anyone dreaming of restoring a grand historic home to its original farmhouse charm.

Currently configured as a multi-family rental property, the home features a total of 6 rental units, including two spacious apartments on the main floor, four studio apartments on the second floor, and an additional large unit on the third floor. Original details throughout the home showcase its rich history, including beautiful built-ins, warm wood finishes, and elegant French style doors. A partially finished attic adds even more possibilities for future expansion or additional living space.

While the home does require significant updating and restoration, its beauty and character remain undeniable. Whether you choose to continue operating it as an income-producing property or transform it back into a magnificent single family farmhouse, the opportunities here are truly endless.

Outside, a large barn provides abundant storage space and opens the door to hobby farm potential, workshops, or additional uses. The family is currently in the process of having all four parcels surveyed, with work expected to begin immediately. An additional adjoining 4+ acre parcel is also available (see MLS# S1683548) and is ideally suited to be purchased together with the multi-family property.

Adding even more value, Lamar advertising signs located on both parcels generate approximately $9,000 annually in income. This is a rare chance to own a historic property with multiple income streams, acreage potential, and unmatched character ready for someone with vision to bring it back to glory.

Details

3,272 Sq Ft

30.81 Private Acres Lot Size

investment

$391 Monthly Tax

Built in 1850

MLS/Listing ID S1683552

3 Stories

6 Units

Amenities & Features

Carpet

Vinyl

Construction - Vinyl Siding

Heating - Hot Water

Heating - Gas

Heating - Baseboard

Construction - Wood Siding

Gas Oven

Gas Range

Gas Water Heater

Refrigerator

Public Water

Water

Septic System

Metal

Open

Porch

Parking - Driveway

Parking - No Garage

Parking - Threeormore Spaces

Lot - Irregular Lot

Lot - Wooded

Natural Woodwork

Estimate my mortgage

TOTAL MONTHLY COST

$0

  • PRINCIPAL & INTEREST

    $0

  • PROPERTY TAXES

    $0

  • Common Charges

    $0

HOME PRICE
DOWN PAYMENT
TERM
INTEREST

Interested In 6188 N Main St?