" CHAUTAUQUA RETREAT PROPERTY " GREAT FOR LARGE GATHERINGS " COULD SLEEP 20 PEOPLE COMFORTABLY! THIS NEW BUILT HAS NEVER BEEN OCCUPIED. PROPERTY IS ACROSS FROM CHAUTAUQUA LAKE, MINUTES FROM CHAUTAUQUA INSTITUTION AND HAS IT ALL! OFFERING A STUNNING KITCHEN WITH CUSTOM CABINETRY, LIVE EDGE COUNTERS, GREAT ROOM WITH VAULTED CEILINGS, CUSTOM BUILT STONE FIREPLACE WITH GAS INSERT. OVER SIZED BEDROOMS, YES, THEY ARE TRULY OVER SIZED! COVERED PORCH FOR ENTERTANING, RADIANT HEAT ON MAIN LEVEL FLOORS, HOT WATER BASEBOARD ON 2ND FLOOR, CENTRAL AIR THROUGHOUT THE HOME. 2000 SQUARE FOOT 3 BAY GARAGE WITH RADIANT FLOOR HEAT, GIVING YOU THE ABILITY TO HAVE CAR LIFTS. PLENTY OF GARAGE ATTIC SPACE, HALF BATH IN GARAGE. A PLACE FOR ALL YOUR TOYS AND CARS. WHEN VIEWING THIS HOME, " THINK OUTSIDE THE BOX " SO MUCH POTENTIAL IS OFFERED IN THIS HOME WITH LOTS OF FLEXIBLE SPACE AND POSSIBILITIES! 5 MINUTES TO PUBLIC BOAT LAUNCH, 2 MINUTES TO SNOWMOBILE TRAILS, HEATED GARAGE WHEN YOU COME BACK IN WITH SLEDS. WHAT ELSE CAN YOU ASK FOR!
Active
$469,000
5105 W Lake Rd, Mayville, NY 14757
3beds
3,164sqft
Single Family Residence
Built in 2015
0.5 Acres Lot
$456,600 Zestimate®
$148/sqft
$-- HOA
What's special
Heated garageOversized bedroomsLive edge countersHalf bath in garage
- 14 days
- 913
- 48
Zillow last checked:
Listing updated:
Listed by:
ERA Team VP Real Estate 716-413-0200,
Edward Miller 716-785-1940
Source: NYSAMLSs,MLS#: R1713636
Originating MLS: Chautauqua-Cattaraugus
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 2
- Main level bedrooms: 1
Heating
- Gas, Zoned, Hot Water, Radiant Floor, Radiant
Cooling
- Zoned, Central Air
Appliances
- Included: Dryer, Dishwasher, Free-Standing Range, Oven, Refrigerator, Washer
- Laundry: Main Level
Features
- Breakfast Bar, Dining Area, Den, Separate/Formal Dining Room, Guest Accommodations, Granite Counters, Great Room, Home Office, Country Kitchen, Kitchen Island, Kitchen/Family Room Combo, Living/Dining Room, Main Level Primary, Primary Suite, Programmable Thermostat, Workshop
- Flooring: Hardwood, Luxury Vinyl, Varies
- Basement: Crawl Space
- Number of fireplaces: 1
Interior area
- Total structure area: 3,164
- Total interior livable area: 3,164 sqft
Property
Parking
- Total spaces: 6
- Parking features: Detached, Electricity, Garage, Heated Garage, Storage, Workshop in Garage, Water Available, Garage Door Opener
- Garage spaces: 6
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Porch
- Exterior features: Barbecue, Gravel Driveway, Private Yard, See Remarks
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Lake
- Body of water: Chautauqua Lake
Lot
- Size: 0.5 Acres
- Dimensions: 250 x 189
- Features: Irregular Lot
Details
- Additional structures: Barn(s), Outbuilding
- Parcel number: 0628892790000002032000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Raised Ranch
- Property subtype: Single Family Residence
Materials
- Spray Foam Insulation, Vinyl Siding
- Foundation: Block
- Roof: Architectural,Shingle
Condition
- Resale
- Year built: 2015
Utilities & green energy
- Sewer: Connected
- Water: Well
- Utilities for property: Cable Available, Electricity Connected, High Speed Internet Available, Sewer Connected
Community & HOA
Location
- Region: Mayville
Financial & listing details
- Price per square foot: $148/sqft
- Tax assessed value: $286,000
- Annual tax amount: $5,256
- Date on market: 9/12/2026
- Cumulative days on market: 400 days
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
Estimated market value
$456,600
$434,000 - $479,000
$2,918/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/13/2026 | Listed for sale | $469,000-6%$148/sqft |
Source: | ||
| 9/11/2026 | Listing removed | $499,000$158/sqft |
Source: | ||
| 7/6/2026 | Price change | $499,000-9.1%$158/sqft |
Source: | ||
| 4/7/2026 | Price change | $549,000-7.7%$174/sqft |
Source: | ||
| 9/25/2025 | Price change | $595,000-11.9%$188/sqft |
Source: | ||
| 8/15/2025 | Listed for sale | $675,000-7.4%$213/sqft |
Source: | ||
| 5/16/2025 | Listing removed | $729,000$230/sqft |
Source: | ||
| 10/4/2024 | Listed for sale | $729,000-2.8%$230/sqft |
Source: | ||
| 9/30/2024 | Listing removed | $749,900$237/sqft |
Source: | ||
| 4/2/2024 | Listed for sale | $749,900+2042.6%$237/sqft |
Source: | ||
| 10/3/2011 | Sold | $35,000$11/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $286,000 |
| 2024 | -- | $286,000 +78.2% |
| 2023 | -- | $160,500 |
| 2022 | -- | $160,500 +358.6% |
| 2021 | -- | $35,000 |
| 2020 | -- | $35,000 |
| 2019 | -- | $35,000 |
| 2018 | -- | $35,000 |
| 2017 | $314 | $35,000 |
| 2016 | -- | $35,000 |
| 2015 | -- | $35,000 +75% |
| 2014 | -- | $20,000 |
| 2013 | -- | $20,000 |
| 2012 | -- | $20,000 -20% |
| 2011 | -- | $25,000 |
| 2010 | -- | $25,000 |
| 2009 | -- | $25,000 |
| 2008 | -- | $25,000 |
| 2007 | -- | $25,000 +10.1% |
| 2006 | -- | $22,700 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: 14757
Nearby schools
Schools provided by the listing agent
- Elementary: Chautauqua Lake Elementary
- Middle: Chautauqua Lake Middle
- High: Chautauqua Lake High
- 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.




