Sign up to get new listings emailed daily! JOIN SIGN IN
Christopher Serra
Licensed Real Estate Salesperson
REALTOR®
(518) 630-3796 Cell
Facebook Icon Instagram Icon 

6188 N Main Street, Sandy Creek, NY 13145

New - 22 Hours Ago
View Full Photo Gallery

Property Description

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 3 rental units, including two spacious apartments on the main 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 parcels surveyed and the acreage represents the new total. Adding even more value, Lamar advertising signs located on the parcel generates $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.

6188 N Main Street | MLS# S1719169

This multi-family property located at 6188 N Main Street, Sandy Creek, NY 13145 is currently listed for sale with an asking price of $370,000. N Main Street is located within the Sandy Creek school district. Search Sandy Creek real estate on chris-serra.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Multi Unit - Multiple
Basement: Full, Sump Pump
Heating: Gas, Baseboard, Hot Water
Lot Size: 36.36 Acres
Roof Type: Asphalt, Metal
Stories: 3.0
Taxes: $4,693
Year Built: 1850

Amenities

Natural Woodwork

Feature Descriptions

Appliances: Gas Water Heater
Exterior: Vinyl Siding, Wood Siding
Flooring: Carpet, Other, See Remarks, Varies, Vinyl
Lot: Irregular Lot
Lot Dimensions: 502X1239
Parcel#: 355203-019-015-0002-004-000-0000
Parking: Gravel, Two or More Spaces
Parking Notes: Gravel, Two or More Spaces
Patio/Porch: Open, Porch
Sewer: Septic Tank
Units: 3
Utilities: Cable Available, High Speed Internet Available, Water Connected
Water: Connected, Public

Local Schools

High School: Sandy Creek High
Middle School: Sandy Creek Middle
Elementary School: Sandy Creek Elementary
School District: Sandy Creek

Estimate Your Payment

Estimated Payment

$ 1,322.46 per month $823.46 Principal & Interest $391.08 Property Tax $107.92 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Berkshire Hathaway HomeServices CNY Realty Watn
Agency Contact: 315-778-1290

Shown By

Agent Name: Christopher Serra
Agent Phone: (518) 630-3796 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 10/07/2026. The listing information on this page last changed on 10/07/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Wed 10/07/2026 12:02:36 AM EST) or Global MLS (last updated Tue 10/06/2026 8:13:18 AM EST) or New York State Alliance MLS (last updated Tue 10/06/2026 11:58:57 PM EST) or Hudson Valley Catskill Region MLS (last updated Wed 10/07/2026 12:01:13 AM EST) or Berkshire MLS (last updated Tue 10/06/2026 8:13:45 PM EST) or OneKey MLS (last updated Wed 10/07/2026 12:00:20 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder