NOT LISTED FOR SALE

107 Herndon Ln Berea, KY 40403

Estimated Value: $818,101

4 Beds
3.5 Baths
4,753 Sq Ft
$172/Sq Ft Est. Value

Sale Details

Date Sold: March 28, 2025

Last sale price $775,000 $163 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $4,456 / mo

107 Days on Market

Highlights

  • New Construction
  • 4 Acre Lot
  • Ranch Style House
  • Farristown Middle School Rated A-
  • Rural View
  • Wood Flooring

About This Home

As of March 2025

Welcome to your dream retreat—a remarkable, new construction 4BR/3.5BA carpet free ranch set on a 4-acre lot. This residence epitomizes refined living, w/every detail meticulously designed. Step through the entrance, where soaring ceilings & rich wood details welcome you into an expansive open floor plan. Warm wood floors lead you to a gourmet kitchen outfitted w/gas range, oversized island & walk-in pantry w/cabinetry. A spacious dining area is perfect for gatherings, while the inviting living rm, centered around a stone-accented gas fireplace, creates a cozy atmosphere. Effortlessly transition from indoors to out w/an incredible covered patio, plumbed for a wet bar & ready for an outdoor fireplace, this space allows you to host w/ease. The split-BR layout ensures a private primary suite, boasting a custom walk-in closet & spa-like BA. Across the home, 3 BR's share a spacious BA. The finished walkout bsmt is a masterpiece of its own, w/vast open spaces. Enjoy a massive bar/kitchenette, 2nd gas fireplace, BA, + 2 versatile bonus rm's. Also enjoy: Oversized garage/aux garage & tankless water heater. Anderson windows ensure energy efficiency, while a 4-acre lot offers room to roam.

Last Agent to Sell the Property

Robin Jones

Keller Williams Legacy Group License #208991 Listed on: 02/11/2025

Keller Williams Legacy Group

Last Buyer's Agent

Jason Smith

Keller Williams Legacy Group License #208335

Keller Williams Legacy Group

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 4 Acre Lot

Parking

  • 2 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Brick Veneer
  • Dimensional Roof
  • Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • Wet Bar
  • Ceiling Fan
  • Ventless Fireplace
  • Gas Log Fireplace
  • Insulated Windows
  • Insulated Doors
  • Entrance Foyer
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Dining Room
  • Bonus Room
  • Utility Room
  • Rural Views
  • Attic Access Panel

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Oven
  • Gas Range
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry on main level
  • Washer and Electric Dryer Hookup

Finished Basement

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

Outdoor Features

  • Patio
  • Porch

Schools

  • Kingston Elementary School
  • Farristown Middle School
  • Madison So High School

Utilities

  • Cooling Available
  • Air Source Heat Pump
  • Natural Gas Connected
  • Tankless Water Heater
  • Gas Water Heater
  • Septic Tank

Community Details

  • Rural Subdivision

Listing and Financial Details

  • Assessor Parcel Number 0072-0018-0002

Home Details

Home Type

Single Family

Year Built

Built in 2024 | New Construction

Lot Details

4 Acres

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub-Type: Single Family Residence
  • Architectural Style: Ranch
  • Structure Type: House
  • Year Built: 2024
  • Above Grade Finished Sq Ft: 2491.0
  • Levels: One
  • New Construction: Yes
  • Structure Type:House: Yes
  • Roof:Dimensional Style: Yes
  • Foundation Details:Concrete Perimeter: Yes
  • Flooring:Tile2: Yes
  • Water Source:Public: Yes
  • Appliances Microwave: Yes
  • Laundry Features:Washer Hookup: Yes
  • Laundry Features:Electric Dryer Hookup: Yes
  • Laundry Features:Main Level: Yes
  • Architectural Style:Ranch: Yes
  • Appliances Refrigerators: Yes
  • View:Rural: Yes
  • Roof:Shingle: Yes
  • Percent Basement Finished: Yes
  • Lot: Lot Size Acres: 4.0
  • Lot: Lot Size Square Feet: 174240.0
  • Tax Legal: Elementary School: Kingston
  • Tax Legal: Middle Or Junior School: Farristown
  • Tax Legal: High School: Madison So
  • Patio And Porch Features: Patio: Yes
  • Water Heater: Gas: Yes
  • Other Sold Info: New Construction YN: Yes
  • Cooling: Heat Pump: Yes
  • Fireplace Features: Great Room: Yes
  • Levels: One: Yes
  • Property Condition: New Construction: Yes
  • Lot: View YN: Yes
  • Building: Accessibility Features YN: No
  • Lot: Water Body Access YN: No
  • Patio And Porch Features: Porch: Yes
  • Fireplace Features: Basement: Yes
  • Fireplace Features: Ventless: Yes
  • Water Heater: Tankless: Yes
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Gas Range, Microwave, Oven, Refrigerator, Other
  • Interior Amenities: Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Primary Downstairs, Walk-In Closet(s), Wet Bar
  • Flooring: Tile, Vinyl, Wood
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Basement: Finished, Full, Walk-Out Access
  • Basement: Yes
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 2262.0
  • Fireplace Features: Basement, Family Room, Gas Log, Great Room, Ventless
  • Fireplace: Yes
  • LivingArea: 4753.0
  • Lot Size Area: 4.0
  • Window Features: Insulated Windows
  • Full Basement: Yes
  • Fireplace Features:Gas Log: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Entrance Foyer: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features:Breakfast Bar: Yes
  • Appliances:Oven: Yes
  • Basement:Walk-Out Access: Yes
  • Interior Features:Wet Bar: Yes
  • Appliances:Gas Range: Yes
  • Interior: Basement YN: Yes
  • Interior: Fireplace YN: Yes
  • Interior Features: Ceiling Fan(s): Yes
  • Interior Features: Primary Downstairs: Yes
  • Attic Features: Access Only: Yes
  • Fireplace Features: Family Room: Yes
  • Flooring: Vinyl: Yes
  • Interior Features: Eat-in Kitchen: Yes
  • Flooring: Wood: Yes

Exterior Features

  • Roof: Dimensional Style, Shingle
  • Construction Materials: Brick Veneer
  • Fencing: None
  • Foundation Details: Concrete Perimeter
  • List Price: 799900.0
  • Patio And Porch Features: Patio, Porch
  • Property Condition: New Construction
  • View: Rural
  • View YN: Yes
  • Waterfront: No
  • Construction Materials:Brick Veneer: Yes
  • Window Features:Insulated Windows: Yes
  • Lot: Waterfront YN: No

Garage/Parking

  • Attached Garage: No
  • Carport: No
  • Garage Spaces: 2.0
  • Garage: Yes
  • Parking Features: Attached Garage, Driveway, Garage Door Opener, Garage Faces Side
  • Parking Features:Driveway: Yes
  • Parking Information: Garage YN: Yes
  • Parking Information: Garage Spaces: 2.0
  • Parking Features: Attached Garage: Yes
  • Parking Information: Carport YN: No
  • Parking Features: Garage Door Opener: Yes
  • Parking Features: Garage Faces Side: Yes

Utilities

  • Sewer: Septic Tank
  • Heating: Heat Pump
  • Cooling: Heat Pump
  • Cooling: Yes
  • Heating: Yes
  • Laundry Features: Electric Dryer Hookup, Main Level, Washer Hookup
  • Utilities: Electricity Connected, Natural Gas Connected, Water Connected
  • Water Source: Public
  • Heating:Heat Pump2: Yes
  • Sewer Septic Tank: Yes
  • Utilities: Cooling YN: Yes
  • Utilities: Heating YN: Yes
  • Utilities: Electricity Connected: Yes
  • Utilities: Natural Gas Connected: Yes
  • Utilities: Water Connected: Yes

Schools

  • Elementary School: Kingston
  • High School: Madison So
  • Middle or Junior School: Farristown

Lot Info

  • Lot Size Acres: 4.0
  • Lot Size Sq Ft: 174240.0
  • Parcel Number: 0072-0018-0002

Ownership 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 Name Owned For Owner Type

Purchase Details

Listed on
Feb 11, 2025
Closed on
Mar 24, 2025
Sold by
Bought by
Seller's Agent
Robin Jones
Keller Williams Legacy Group
Buyer's Agent
Jason Smith
Keller Williams Legacy Group
List Price
$869,000
Sold Price
$775,000
Premium/Discount to List
-$94,000
-10.82%
Views
947
Current Estimated Value
$818,101

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$43,101
Avg. Annual Appreciation
4.39%
Original Mortgage
$775,000
Outstanding Balance
$264,237
Interest Rate
6.85%
Mortgage Type
Construction
Estimated Equity
$553,864

Purchase Details

Closed on
Mar 28, 2023
Sold by
Bought by
Source: Public Records

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

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 Buyer Sale Price Title Company
$775,000 Five Star Title Llc
$775,000 Five Star Title Llc
$80,000 --
$80,000 None Listed On Document
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 Borrower Loan Amount
Open $775,000
Closed $775,000
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
03/28/2025 03/28/25 Sold $775,000 -3.1% $163 / Sq Ft
02/16/2025 02/16/25 Pending -- -- --
01/24/2025 01/24/25 Price Changed $799,900 -5.8% $168 / Sq Ft
01/07/2025 01/07/25 Price Changed $849,500 -2.2% $179 / Sq Ft
11/01/2024 11/01/24 For Sale $869,000 -- $183 / Sq Ft
Source: ImagineMLS (Bluegrass REALTORS®)

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 $754 $80,000 $0 $0
2024 $766 $80,000 $0 $0
2023 $388 $40,000 $0 $0
2022 $49 $5,000 $0 $0
2021 $50 $5,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: ImagineMLS (Bluegrass REALTORS®)

MLS Number: 24023050

ImagineMLS (Bluegrass REALTORS®)

APN: 0072-0016-0002

Your Personal Tour Guide

Ask me questions while you tour the home.