$625,000
PENDING

196 County Highway 123 Mayfield, NY 12117

Estimated payment $3,813/month

Total Views 3,182
4 Beds
2.5 Baths
3,340 Sq Ft
$187 Price per Sq Ft

Highlights

  • Skyline View
  • 59 Acre Lot
  • Deck
  • Waterfront
  • Open Floorplan
  • Radiant Floor

About This Home

This exceptional property truly has it all; offering the perfect blend of LAKE LIFE, country living and investment potential!! Situated on 59 acres of scenic countryside, this spacious 4 bed, 2.5 bath home is an outdoor enthusiast's dream!! There is a beautiful 10' SANDY beach providing access to endless lake activities including kayaking, boating, swimming, and relaxing by the water. The acreage allows for hiking, snowmobiling, cross country skiing and endless trails for ATVs! The home welcomes you with a beautiful wraparound covered porch, the perfect place to enjoy morning coffee while watching the sunrise over the peaceful landscape. Inside, an inviting entry foyer opens to a spacious, open floor plan designed for comfortable living and entertaining. The large living and dining rooms capture sweeping views of the surrounding fields and countryside, while the well appointed kitchen offers ample workspace and a convenient breakfast bar. A bright sunroom surrounded by windows fills the space with natural light and provides serene views of the property. Upstairs you will find three generously sized bedrooms and full bath. The finished walk-out lower level offers excellent flexibility with a family room featuring French doors leading to a stone patio, a large fourth bedroom and full bath, making it ideal as an in-law suite or private guest quarters. Designed with entertaining in mind, the home features seamless indoor-outdoor living with French doors from the kitchen and dining area leading to a deck, a spacious patio overlooking the grounds, and additional shaded outdoor seating areas. Adding to the property's charm and agricultural appeal is a mature 60-tree apple orchard and approximately 250 blueberry bushes. Investment potential with 10-acre subdivision (pending APA). A rare opportunity to own a private countryside retreat with lake access, abundant acreage, and future development potential....all in one remarkable property!!

Listing Agent

Katrina Ruberti

Howard Hanna Capital Inc License #10301210107 Listed on: 03/12/2026

Howard Hanna Capital Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,951

Year Built

  • Built in 2004

Lot Details

  • 59 Acre Lot
  • Waterfront
  • Garden

Property Views

  • Skyline
  • Orchard Views
  • Mountain

Home Design

  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 3,340 Sq Ft Home
  • Open Floorplan
  • Built-In Features
  • Paddle Fans
  • Entrance Foyer
  • Family Room
  • Living Room
  • Formal Dining Room
  • Sun or Florida Room
  • Utility Room
  • Laundry on main level

Kitchen

  • Oven
  • Range
  • Microwave

Flooring

  • Radiant Floor
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Bathroom on Main Level

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Parking

  • 10 Parking Spaces
  • Driveway

Outdoor Features

  • Permit Required for Waterfront Access
  • Deck
  • Wrap Around Porch

Utilities

  • Window Unit Cooling System
  • Outdoor Furnace
  • Heating System Uses Propane
  • Heating System Uses Wood
  • Septic Tank
  • High Speed Internet

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 40.001 / 1
  • Assessor Parcel Number 173089 73.-1-40.1

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,951

Year Built

Built in 2004

Lot Details

59 Acres

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 2004
  • Directions: Route 30 North to County Hwy 123
  • Above Grade Finished Sq Ft: 3340.0
  • Architectural Style: Colonial
  • Lot Size Acres: 59.0
  • New Construction: No
  • Water Body Name: Great Sacandaga Lake
  • Subdivision Name: Select One
  • Special Features: VirtualTour

Interior Features

  • Flooring: Vinyl
  • Basement: Walk-Out Access, Full, Finished
  • Interior Amenities: Walk-In Closet(s), High Speed Internet, Paddle Fan, Built-in Features
  • Appliances: Range, Microwave, Oven
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Living Area: 3340.0
  • Bedroom Level: Second
  • Dining Room Level: First
  • Foyer Level: First
  • Kitchen Level: First
  • Living Room Level: First
  • Sunroom Level: First
  • Bathroom Levels Full Bathroom 1: 1st
  • Bathroom Levels Full Bathroom 2: Basement
  • Bathroom Levels Half Bathroom 1: 1st
  • Fireplace: No
  • Dining Room Type: Formal Dining Room

Exterior Features

  • Exterior Features: Outdoor Furnace, Garden
  • Roof: Shingle
  • Construction Type: Vinyl Siding
  • Patio And Porch Features: Deck, Front Porch, Rear Porch, Side Porch, Wrap Around
  • View: Mountain(s), Orchard, Skyline
  • Waterfront Features: Permit Required
  • Waterfront: Yes

Garage/Parking

  • Parking Features: Driveway
  • Attached Garage: No
  • Total Parking Spaces: 10.0
  • Property Detail:Parking YN: Yes

Utilities

  • Sewer: Septic Tank
  • Cooling: Window Unit(s)
  • Heating: Propane, Radiant Floor, Wood
  • Laundry Features: Main Level
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)
  • Water Source: Well
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Junior High Dist: Mayfield

Lot Info

  • Parcel #: 173089 73.-1-40.1
  • Lot Size Sq Ft: 2570040.0

Tax Info

  • Tax Annual Amount: 5951.42
  • Tax Block: 1
  • Tax Lot: 40.001

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $3,857 $136,000 $48,500 $87,500
2024 $5,786 $136,000 $48,500 $87,500
2023 $5,467 $136,000 $48,500 $87,500
2022 $5,537 $136,000 $48,500 $87,500
2021 $5,447 $136,000 $48,500 $87,500
2020 $3,009 $136,000 $48,500 $87,500
2019 $3,007 $136,000 $48,500 $87,500
2018 $2,909 $136,000 $48,500 $87,500
2017 $3,200 $136,000 $48,500 $87,500
2016 $3,143 $136,000 $48,500 $87,500
2015 -- $124,900 $48,500 $76,400
2014 -- $124,900 $48,500 $76,400
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/28/2026 03/28/26 Pending -- -- --
03/12/2026 03/12/26 For Sale $625,000 +4.2% $187 / Sq Ft
04/04/2023 04/04/23 Sold $600,000 +5.3% $240 / Sq Ft View Prior Sale
02/28/2023 02/28/23 Pending -- -- --
09/15/2022 09/15/22 Price Changed $569,900 -5.0% $228 / Sq Ft
08/09/2022 08/09/22 For Sale $599,900 -- $240 / Sq Ft
Source: Global MLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed $600,000 None Available
Deed $195,000 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $570,000 Purchase Money Mortgage
Source: Public Records

Source: Global MLS

MLS Number: 202613225

Global MLS

APN: 173089-073-000-0001-040-001-0000

Your Personal Tour Guide

Ask me questions while you tour the home.