5031 W Lake Road, Mayville, NY 14757
Local realty services provided by:Team VP Real Estate
5031 W Lake Road,Mayville, NY 14757
$1,495,000
- 4 Beds
- 5 Baths
- 4,500 sq. ft.
- Single family
- Active
Listed by:
Office: era team vp real estate
MLS#:R1680054
Source:NY_GENRIS
Price summary
- Price:$1,495,000
- Price per sq. ft.:$332.22
About this home
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....
Contact an agent
Home facts
- Year built:1908
- Listing ID #:R1680054
- Added:39 day(s) ago
- Updated:June 16, 2026 at 02:52 PM
Rooms and interior
- Bedrooms:4
- Total bathrooms:5
- Full bathrooms:3
- Half bathrooms:2
- Rooms Total:13
- Flooring:Hardwood, Varies
- Dining Description:Separate Formal Dining Room
- Kitchen Description:Dishwasher
- Basement:Yes
- Basement Description:Walk Out Access
- Living area:4,500 sq. ft.
Heating and cooling
- Cooling:Central Air, Zoned
- Heating:Forced Air, Gas, Zoned
- Central air:Yes
Structure and exterior
- Roof:Metal, Shingle
- Year built:1908
- Building area:4,500 sq. ft.
- Lot area:24.6 Acres
- Lot Features:Agricultural, Irregular Lot
- Architectural Style:Farmhouse
- Construction Materials:Brick
- Foundation Description:Stone
- Levels:3 Stories
Utilities
- Water:Well
- Sewer:Connected, Sewer Connected
Finances and disclosures
- Price:$1,495,000
- Price per sq. ft.:$332.22
- Tax amount:$13,758
Features and amenities
- Appliances:Dishwasher
Parking
- Parking description:No Garage
New listings near 5031 W Lake Road
- New
Listed by ERA$39,900Active0.49 Acres2041 (Lot #14) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690706Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$39,900Active0.72 Acres2017 (Lot 8) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690707Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$39,900Active0.52 Acres2018 (Lot 45) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690709Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$39,900Active0.49 Acres2014 (Lot 44) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690713Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$34,900Active0.49 Acres3013 (Lot 32) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690714Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$34,900Active0.49 Acres3017 (Lot 33) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690724Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$34,900Active0.48 Acres3021 (Lot 34) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690725Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$34,900Active0.5 Acres3025 (Lot 35) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690728Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$34,900Active0.54 Acres3033 (Lot 38) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690730Listed by: ERA TEAM VP REAL ESTATE - New
Listed by ERA$34,900Active0.46 Acres3037 (Lot 39) Mandolin Ridge Way, Mayville, NY 14757
MLS# R1690731Listed by: ERA TEAM VP REAL ESTATE