Sign up to get new listings emailed daily! JOIN SIGN IN
Leighton G. Ashley
Licensed RE Associate Broker
REALTOR®, RSPS - Resort & Second Home Property Specialist; SRS - Seller Representative Specialist
Facebook Icon LinkedIn Icon YouTube Icon Pinterest Icon Instagram Icon Blog Icon Realtor.com Icon Zillow Icon 

5031 W Lake Road, Mayville, NY 14757

New - 18 Hours Ago

50 Total Photos [Click to View All]

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 leighton-ashley.timberlandproperties.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: Leighton G. Ashley
Agent Phone: Cell: (917) 796-3351
Agency Title: Timberland Properties

IDX logo

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless. 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:11 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 Timberland 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.

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless.

Privacy Policy / DMCA Notice / ADA Accessibility


Agent License Information: 10301223732

Login to My Homefinder

Pixel