Skip main navigation
Closed
  • $560,000

    196 County Highway 123, Mayfield, NY 12117

    4beds
    3,340sqft
    Single Family Residence, Residential
    Built in 2004
    59 Acres Lot
    $562,700 Zestimate®
    $168/sqft
    $3,636 Estimated rent

    Home value

    $562,700

    $461,000 - $686,000

    $3,636/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,636/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,636/mo

    Rent Zestimate®

    Refinance and save

    $3,967/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,967/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Beautiful wraparound covered porchInviting entry foyer
    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!!

    Zillow last checked:

    Listing updated:

    Listed by:

    Katrina F Ruberti 518-423-2502,

    Howard Hanna Capital Inc

    Bought with:

    Terri Belmonte, 10401246621

    KW Platform

    Source: Global MLS,MLS#: 202613225MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Bedroom
    • Level: Second
    Bedroom
    • Level: Second
    Bedroom
    • Level: Second
    Bedroom
    • Level: Basement
    Dining room
    • Level: First
    Family room
    • Level: Basement
    Foyer
    • Level: First
    Kitchen
    • Level: First
    Living room
    • Level: First
    Sun room
    • Level: First
    Utility room
    • Level: Basement
    Heating
    • Propane, Radiant Floor, Wood
    Cooling
    • Window Unit(s)
    Appliances
    • Included: Microwave, Oven, Range
    • Laundry: Main Level
    Features
    • High Speed Internet, Ceiling Fan(s), Walk-In Closet(s), Built-in Features
    • Flooring: Vinyl
    • Basement: Finished,Full,Walk-Out Access
    Interior area
    • Total structure area: 3,340
    • Total interior livable area: 3,340 sqft
    • Finished area above ground: 3,340
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 10
    • Parking features: Driveway
    • Has uncovered spaces: Yes
    Features
    • Patio & porch: Rear Porch, Side Porch, Wrap Around, Deck, Front Porch
    • Exterior features: Garden, Outdoor Furnace
    • Has view: Yes
    • View description: Mountain(s), Orchard, Skyline
    • Waterfront features: Permit Required
    • Body of water: Great Sacandaga Lake
    Lot
    • Size: 59 Acres
    Details
    • Parcel number: 173089 73.140.1
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    Materials
    • Vinyl Siding
    • Roof: Shingle
    Condition
    • New construction: No
    • Year built: 2004

    Utilities & green energy

    • Sewer: Septic Tank

    Community & HOA

    Community
    • Security: Smoke Detector(s), Carbon Monoxide Detector(s)
    HOA
    • Has HOA: No
    Location
    • Region: Mayfield

    Financial & listing details

    • Price per square foot: $168/sqft
    • Tax assessed value: $344,653
    • Annual tax amount: $5,951
    • Date on market: 3/12/2026

    Price history

    DateEventPrice
    6/5/2026Sold$560,000-10.4%$168/sqft
    Source: Global MLS #202613225 Report a problem
    3/29/2026Pending sale$625,000$187/sqft
    Source: Global MLS #202613225 Report a problem
    3/12/2026Listed for sale$625,000-3%$187/sqft
    Source: Global MLS #202613225 Report a problem
    3/2/2026Listing removed$644,000$193/sqft
    Source: Global MLS #202525165 Report a problem
    2/4/2026Price change$644,000-0.8%$193/sqft
    Source: Global MLS #202525165 Report a problem
    10/5/2025Price change$649,000-3.9%$194/sqft
    Source: Global MLS #202525165 Report a problem
    9/4/2025Listed for sale$675,000+3.8%$202/sqft
    Source: Global MLS #202525165 Report a problem
    2/1/2025Listing removed$650,000$195/sqft
    Source: Global MLS #202421681 Report a problem
    7/18/2024Listed for sale$650,000+8.3%$195/sqft
    Source: Global MLS #202421681 Report a problem
    4/4/2023Sold$600,000+5.3%$180/sqft
    Source: Global MLS #202224410 Report a problem
    2/28/2023Pending sale$569,900$171/sqft
    Source: Global MLS #202224410 Report a problem
    9/15/2022Price change$569,900-5%$171/sqft
    Source: Global MLS #202224410 Report a problem
    8/9/2022Listed for sale$599,900+207.6%$180/sqft
    Source: Global MLS #202224410 Report a problem
    7/31/1995Sold$195,000$58/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $136,000
    2024-- $136,000
    2023-- $136,000
    2022-- $136,000
    2021-- $136,000
    2020-- $136,000
    2019-- $136,000
    2018-- $136,000
    2017$3,007 $136,000
    2016-- $136,000 +8.9%
    2015-- $124,900
    2014-- $124,900
    2013-- $124,900
    2012-- $124,900
    2011-- $124,900
    2010-- $124,900
    2009-- $124,900
    2008-- $124,900
    2007-- $124,900
    2006-- $124,900
    Find assessor info on the county website

    Neighborhood: 12117

    Nearby schools

    GreatSchools rating