Deborah B. Pridgen
Licensed Associate Real Estate Broker
Certified Residential Specialist, CBR: Certified Buyers Representative, E-PRO, Equal Housing Opportunity, Seniors Real Estate Specialist, Coldwell Banker President's Circle
Liverpool, NY
Cell: (315) 427-7905 Office: (315) 622-0161 Fax: (315) 652-3979
social icon social icon social icon 

5031 W Lake Road, Mayville, NY 14757

New - 27 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 deb-pridgen.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Walk-Out Access
Cooling: Zoned, Central Air
Heating: Gas, Zoned, Forced Air, Multiple Heating Units
Home Style: Farmhouse
Lot Size: 24.60 Acres
Roof Type: Architectural, Metal, Shingle
Stories: 3.0
Taxes: $13,758
Year Built: 1908

Amenities

Separate/Formal Dining Room
Guest Accommodations
Bath in Primary Bedroom
Blacktop Driveway

Feature Descriptions

Appliances: Dishwasher, Gas Water Heater
Days on Site: 1
Exterior: Brick
Flooring: Hardwood, Varies
Lot: Agricultural, Irregular Lot
Lot Dimensions: 600X1300
Parcel#: 062889-279-000-0002-040-000
Parking: No Garage
Parking Notes: No Garage
Sewer: Connected
Utilities: Electricity Connected, Sewer Connected
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: Deborah B. Pridgen
Agent Phone: (315) 427-7905 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 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:10 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