Listing provided courtesy of ERA Team VP Real EstateMLS# R1680054MLS ProviderContact Information: 716-708-9980
  • 53 days on site
  • 14 views

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.

Source: New York Alliance, MLS#: R1680054

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential
  • Lot
    24.60 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Daniel Terhune
By providing your telephone number and/or email address, you give express permission for Century 21 Turner Brokers to contact you via phone, text message, or email, even if your phone number is listed on a state or national Do Not Call list. Message frequency varies. To opt-out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Message and data rates may apply. Reply HELP for help, STOP to cancel.

Create a profile so you can receive updates on this property as soon as they happen!

  • Median Age
    41
  • Population Density
    73
  • College Educated
    47%
  • Estimated Median Income
    $60,536
  • Estimated Total Home Owners
    1,019
  • Estimated Total Renters
    249
  • Owner / Renter Divide
    80% / 20%
  • Estimated Average Household Size
    2
  • Total Population
    3,371
  • Community data courtesy of LiveBy, Inc.

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Life at 5031 W Lake Road


Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
6/17/2026Source: New York Alliance Price Reduction
$1,350,000 -9.7%
6/17/2026Source: New York Alliance Price Reduction
$1,350,000 -9.7%
5/8/2026Source: New York Alliance Added to Database
May 08, 2026
4/27/2026Source: New York Alliance Added to Database
April 27, 2026