Jacob Loope
Licensed Real Estate Salesperson
REALTOR®
Liverpool, NY
social icon 

5031 W Lake Road, Mayville, NY 14757

New - 41 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! Various supplements attached with additional property information. Delayed showings to begin at noon on April 30th.

5031 W Lake Road | MLS# R1674585

This commercial property located at 5031 W Lake Road, Mayville, NY 14757 is currently listed for sale with an asking price of $1,495,000. W Lake Road is located within the Chautauqua Lake school district. Search Mayville real estate on jacob-loope.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Commercial - Business
Cooling: Zoned, Central Air
Heating: Gas, Zoned, Forced Air, Multiple Heating Units
Lot Size: 24.60 Acres
Roof Type: Architectural, Metal, Shingle
Stories: 3.0
Taxes: $13,803
Year Built: 1908

Feature Descriptions

Days on Site: 1
Exterior: Brick, Frame, Metal Siding
Flooring: Concrete, Hardwood, Varies
Lot: Irregular Lot
Lot Dimensions: 600X1300
Parcel#: 062889-279-000-0002-040-000
Parking: Driveway, Surfaced
Parking Notes: Driveway, Surfaced
Sewer: Public Sewer, Other, See Remarks
Utilities: Electricity Connected, Sewer Connected
Water: Well

Local Schools

School District: Chautauqua Lake

Demographics

Listed By / Shown By

Listing By

Agency Name: ERA Team VP Real Estate
Agency Contact: 716-708-9980

Shown By

Agent Name: Jacob Loope
Agent Phone: (315) 884-0868 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 04/29/2026. The listing information on this page last changed on 04/29/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 04/29/2026 12:02:34 AM EST) or Global MLS (last updated Tue 04/28/2026 11:52:05 PM EST) or New York State Alliance MLS (last updated Tue 04/28/2026 11:58:42 PM EST) or Hudson Valley Catskill Region MLS (last updated Wed 04/29/2026 12:01:11 AM EST) or OneKey MLS (last updated Wed 04/29/2026 12:00:14 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

Pixel