Skip main navigation
Active
  • Price cut: $145K (6/17)
    $1,350,000

    5031 W Lake Rd, Mayville, NY 14757

    4beds
    4,500sqft
    Loading
    Farm, Single Family Residence
    Built in 1908
    24.6 Acres Lot
    $-- Zestimate®
    $300/sqft
    $-- HOA

    What's special

    Stately brick homeLevel groundsWonderful wraparound porchHandsome brick facadeOriginal hardwood floorsSoaring gambrel ceilingBuffer from surrounding properties
    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.
    68 days
    |
    652
    |
    28
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    ERA Team VP Real Estate 716-413-0200,

    Ruth Nelson 716-708-9980

    Source: NYSAMLSs,MLS#: R1680054MLS LogoOriginating MLS: Chautauqua-Cattaraugus

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 5
      • Full bathrooms: 3
      • 1/2 bathrooms: 2
      • Main level bathrooms: 2
      Heating
      • Gas, Zoned, Forced Air, Multiple Heating Units
      Cooling
      • Zoned, Central Air
      Appliances
      • Included: Dishwasher, Gas Water Heater
      Features
      • Separate/Formal Dining Room, Guest Accommodations, Bath in Primary Bedroom
      • Flooring: Hardwood, Varies
      • Basement: Walk-Out Access
      • Has fireplace: No
      Interior area
      • Total structure area: 4,500
      • Total interior livable area: 4,500 sqft
      Video & virtual tour

      Property

      Parking
      • Parking features: No Garage
      Features
      • Stories: 3
      • Exterior features: Blacktop Driveway
      Lot
      • Size: 24.6 Acres
      • Dimensions: 600 x 1300
      • Features: Agricultural, Irregular Lot
      Details
      • Additional parcels included: 279.00239
      • Parcel number: 0628892790000002040000
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Farmhouse
      • Property subtype: Farm, Single Family Residence
      Materials
      • Brick
      • Foundation: Stone
      • Roof: Architectural,Metal,Shingle
      Condition
      • Resale
      • Year built: 1908

      Utilities & green energy

      • Sewer: Connected
      • Water: Well
      • Utilities for property: Electricity Connected, Sewer Connected

      Community & HOA

      Location
      • Region: Mayville

      Financial & listing details

      • Price per square foot: $300/sqft
      • Tax assessed value: $800,000
      • Annual tax amount: $13,758
      • Date on market: 5/8/2026
      • Listing terms: Conventional

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        6/17/2026Price change$1,350,000-9.7%$300/sqft
        Source: NYSAMLSs #R1680054 Report a problem
        5/8/2026Listed for sale$1,495,000$332/sqft
        Source: NYSAMLSs #R1680054 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $11,300
        2024-- $11,300
        2023-- $11,300
        2022-- $11,300
        2021-- $11,300 +105.5%
        2020-- $5,500
        2019-- $5,500
        2018-- $5,500
        2017$49 $5,500
        2016-- $5,500
        2015-- $5,500
        2014-- $5,500
        2013-- $5,500
        2012-- $5,500
        2011-- $5,500
        2010-- $5,500
        2009-- $5,500
        2008-- $5,500
        2007-- $5,500
        2006-- $5,500
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 14757

        Getting around

        9 / 100
        Car-Dependent
        38 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Chautauqua Lake

        Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes