The Friello Team
REALTOR®
Niskayuna, NY
Office: (518) 370-2100

5031 W Lake Road, Mayville, NY 14757

New - 19 Hours Ago
View Full Photo Gallery

Property Description

The iconic Red Brick Farm property is located along Route 394 on the well-trafficked N. Lake corridor between Chautauqua Institution and the Village of Mayville. The compound includes seven buildings situated on approximately 25 acres of land. This turn of the century property was originally a dairy farm which the current owner painstakingly converted into a restaurant, living and retail spaces. The House is set up to operate as a restaurant on the main level with living quarters on the second and third floors. Once inside you'll be impressed by the many original architectural details which were preserved including original hardwood floors, mantles, stairwell and pocket doors. This stately brick home is a prominent feature of the property with its wonderful wraparound porch and handsome brick facade. The Barn has been fully reconstructed inside and is a feast for the eyes with its soaring gambrel ceiling and versatile main floor and loft spaces. The Milking Barn and Produce Stand are both adjacent to the main parking area and would make for wonderful additional retail spaces. The big red Retail One & Two buildings (constructed in 2003) are located behind the main center and can be accessed via paved driveway off of the main road. This service road provides access to additional parking in the rear and out to the immense pole barn. Both Retail One & Two buildings have suffered from water intrusion due to failure of the roofs. Condition issues also exist in the basements of both of these buildings. The level grounds would make for a variety of delightful outdoor uses and they help give a buffer from surrounding properties. The rear of the property features a pond, is partially wooded and leads to the gas well. The private gas well provides supplemental gas in addition to the existing National Fuel service. With so many exciting things happening in our region, now's the perfect time to bring your vision to life here and revitalize this incredible, one-of-a-kind property! Also listed as MLS R1674585.

5031 W Lake Road | MLS# R1680054

This single family home located at 5031 W Lake Road, Mayville, NY 14757 is currently listed for sale with an asking price of $1,495,000. This property was built in 1908 and has 4 bedrooms and 3 full and 2 partial baths with 4500 sq. ft. W Lake Road is located within the Chautauqua Lake school district. Search Mayville real estate on thefrielloteam.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: WalkOutAccess
Cooling: Zoned, CentralAir
Heating: Gas, Zoned, ForcedAir, MultipleHeatingUnits
Home Style: Farmhouse
Lot Size: 24.60 Acres
Roof Type: Architectural, Metal, Shingle
Stories: 3.0
Taxes: $13,758
Year Built: 1908

Amenities

SeparateFormalDiningRoom
GuestAccommodations
BathInPrimaryBedroom
BlacktopDriveway

Feature Descriptions

Appliances: Dishwasher, GasWaterHeater
Exterior: Brick
Flooring: Hardwood, Varies
Lot: Agricultural, IrregularLot
Lot Dimensions: 600X1300
Parcel#: 062889-279-000-0002-040-000
Parking: NoGarage
Parking Notes: NoGarage
Sewer: Connected
Utilities: ElectricityConnected, SewerConnected
Water: Well

Local Schools

School District: Chautauqua Lake

Estimate Your Payment

Estimated Payment

$ 4,909.76 per month $3,327.22 Principal & Interest $1,146.50 Property Tax $436.04 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: ERA Team VP Real Estate
Agency Contact: 716-708-9980

Shown By

Agent Name: The Friello Team
Agent Phone: Primary
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 05/09/2026. The listing information on this page last changed on 05/09/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 Sat 05/09/2026 12:00:38 AM EST) or Global MLS (last updated Fri 05/08/2026 11:52:14 PM EST) or New York State Alliance MLS (last updated Fri 05/08/2026 11:58:47 PM EST) or Hudson Valley Catskill Region MLS (last updated Fri 05/08/2026 11:53:46 PM EST) or OneKey MLS (last updated Fri 05/08/2026 11:53:16 PM 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

Pixel