NOT LISTED FOR SALE

3040 Friars Ln Edgewood, KY 41017

Estimated Value: $1,457,000 - $1,636,000

5 Beds
6 Baths
8,300 Sq Ft
$185/Sq Ft Est. Value

Last Sold August 25, 2021

Last sale price $1,162,875 $140 Per Sq Ft

Est. 32% increase in value since last sale

Current estimated payment $9,076/month

120 Days on Market

Highlights

  • Wine Cellar
  • Eat-In Gourmet Kitchen
  • Granite Flooring
  • Hinsdale Elementary School Rated A-
  • View of Trees or Woods
  • 2.42 Acre Lot

About This Home

As of August 2021

Luxury Living Boasting Breathtaking Views of Private 2+ Acres in one of NKY's Most Elite Communities*Custom 8,300 sq ft Ashley Built Featuring Exquisite Finishes w/Stunning Open Plan*Entertainer's Dream Featuring Cherry Bar, Gourmet Kitchen & Impressive Formal Dining Room*Grand Staircase to Owner's Retreat Offering Designer Bath & Amazing Custom Closet*Finished LL has Temp Controlled Wine Cellar, Full Kitchen w/Family Rm & Guest Suites*Beautiful Library*Three See Through Fireplaces*Situated near Expressway, Dining, Shops & St. Elizabeth

Last Agent to Sell the Property

Dianna Caldwell

eXp Realty, LLC Listed on: 03/11/2021

Last Buyer's Agent

Kathy Heimbrock

Sibcy Cline, REALTORS-Florence License #219882

Sibcy Cline, REALTORS-Florence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,918

Year Built

  • Built in 1997

Lot Details

  • 2.42 Acre Lot
  • Cul-De-Sac
  • Front and Back Yard Sprinklers
  • Wooded Lot

HOA Fees

  • $12 Monthly HOA Fees

Parking

  • 5 Car Garage
  • Driveway

Property Views

  • Woods
  • Valley

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 8,300 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Wired For Sound
  • Wired For Data
  • Bookcases
  • Chair Railings
  • Woodwork
  • Crown Molding
  • Tray Ceiling
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Gas Fireplace
  • Insulated Windows
  • Bay Window
  • Picture Window
  • Wood Frame Window
  • Casement Windows
  • French Doors
  • Panel Doors
  • Wine Cellar
  • Family Room with Fireplace
  • 3 Fireplaces
  • Great Room
  • Living Room with Fireplace
  • Sitting Room
  • Formal Dining Room
  • Loft
  • Bonus Room
  • Atrium Room
  • Solarium

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Fireplace in Kitchen

Flooring

  • Wood
  • Carpet
  • Granite
  • Marble
  • Slate Flooring
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Dressing Area
  • Dual Vanity Sinks in Primary Bathroom
  • Primary Bathroom Bathtub Only
  • Primary Bathroom includes a Walk-In Shower

Finished Basement

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

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Enclosed Patio or Porch
  • Exterior Lighting

Schools

  • R.C. Hinsdale Elementary School
  • Turkey Foot Middle School
  • Dixie Heights High School

Utilities

  • Humidifier
  • Central Air
  • Heating System Uses Natural Gas
  • Water Softener
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 029-40-00-016.30

Community Details

Overview

  • Association fees include management
  • Prestwicke Association, Phone Number (859) 801-0776
  • Canterbury Woods Subdivision

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,918

Year Built

Built in 1997

Lot Details

0

HOA Fees

$12 per month

Parking

5

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 2.42
  • Year Built: 1997
  • Lot Size: Irregular
  • Subdivision Name: Canterbury Woods
  • Directions: Dudley Rd to Prestwicke Dr, Left on Canterbury Ln, Left on Friars Ln
  • Architectural Style: Traditional
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: R.C. Hinsdale Elementary
  • Location Tax Legal Info:Middle or Junior School: Turkey Foot Middle School
  • Location Tax Legal Info:High School: Dixie Heights High
  • Location Tax Legal Info:Subdivision2: Canterbury Woods
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 2
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Irregular
  • General Property Description:Approx SqFt2: 8300.0
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 2.42
  • General Property Description:Lot Size Square Feet: 105415.2
  • Structure Type:House: Yes
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Room Type:Loft3: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 029-40-00-016.30
  • General Property Description:Fireplaces Total: 3
  • View:TreesWoods: Yes
  • Room Type:Bonus Room2: Yes
  • Percent Basement Finished: Yes
  • Water Softeners: Yes
  • Other Equipment:Humidifier: Yes
  • Room Type:Great Room4: Yes
  • Room Type:Solarium: Yes
  • Security Features:Security System: Yes
  • View:Valley: Yes
  • Room Type:Atrium2: Yes
  • Room Type:Wine Cellar: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Crown Molding, Ceiling Fan(s), Central Vacuum, French Doors, High Ceilings, Multi Panel Doors, Natural Woodwork, Recess Ceiling(s), Recessed Lighting, Wired for Data, Wired for Sound
  • Basement: Full, Finished, Walk-Out Access
  • Heating: Natural Gas
  • Levels: Two
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Dishwasher, Microwave, Oven, Range, Water Softener
  • Other Equipment: Humidifier
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplaces: 3
  • Fireplace: Yes
  • Window Features: Bay Window(s), Bow Window(s), Casement, Insulated Window(s), Picture Window(s), Wood Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Wired for Data: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Basement:Walk-Out Access7: Yes
  • Interior Features:French Doors: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Natural Woodwork: Yes
  • Interior Features:Crown Molding: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Family Room Features:Fireplace(s)4: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Living Room Features:Carpet Flooring2: Yes
  • Living Room Features:Fireplace(s): Yes
  • Kitchen Features:Ceramic Tile Flooring2: Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Interior Features:Recessed Lighting: Yes
  • Interior Features:Central Vacuum: Yes
  • Interior Features:Wired for Sound: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Marble Flooring2: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Primary Bedroom Features:Wood Flooring7: Yes
  • Interior Features:Recess Ceiling(s): Yes
  • Family Room Features:Wet Bar2: Yes
  • Primary Bath Features:Ceramic Tile Flooring: Yes
  • Appliances Range: Yes
  • Kitchen Features:Granite Flooring2: Yes
  • Kitchen Features:Slate Flooring2: Yes
  • Primary Bath Features:Tub: Yes
  • Family Room Features:Wood Flooring5: Yes
  • Primary Bedroom Features:Fireplace(s)6: Yes
  • Primary Bedroom Features:Sitting Room: Yes
  • Primary Bedroom Features:Dressing Area: Yes
  • Primary Bath Features:Granite Flooring3: Yes
  • Primary Bath Features:Marble Flooring3: Yes
  • Primary Bath Features:Slate Flooring3: Yes
  • Family Room Features:Bookcases2: Yes
  • Family Room Features:French Doors3: Yes
  • Dining Room Features:Chair Rail: Yes
  • Kitchen Features:Planning Desk: Yes
  • Kitchen Features:Fireplace(s)3: Yes

Exterior Features

  • View: Trees/Woods, Valley
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear, Wooded
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Lighting
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Enclosed, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Window Features:Picture Window(s): Yes
  • Lot Features:Wooded: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Window Features:Bay Window(s): Yes
  • Exterior Features:Lighting: Yes
  • Window Features:Wood Frames: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Patio and Porch Features:Enclosed: Yes
  • Window Features:Bow Window(s): Yes
  • Lot Features:Sprinklers In Rear: Yes
  • Window Features:Casement: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway
  • General Property Description:Garage Spaces: 5.0
  • Parking Features:Driveway: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Security: Security System, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available
  • Heating:Natural Gas2: Yes

Condo/Co-op/Association

  • Association Fee: 140.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Prestwicke
  • Association Information:Association Management Phone 1: 859-801-0776
  • Association Information:Total Yearly Fees: 140.0
  • Association Information:Association Fee: 140.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Management: Yes

Fee Information

  • Association Fee Includes: Management

Schools

  • Elementary School: R.C. Hinsdale Elementary
  • Junior High Dist: Kenton Co Public
  • High School: Dixie Heights High
  • Middle Or Junior School: Turkey Foot Middle School

Lot Info

  • Lot Size Sq Ft: 105415.2
  • Zoning Description: {"Residential":true}
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 11, 2021
Closed on
Aug 25, 2021
Sold by
Chandler Adam and Chandler Katie Hastings
Bought by
Bertke Matthew Hatfield and Bertke Megan Marie
Seller's Agent
Dianna Caldwell
eXp Realty, LLC
Buyer's Agent
Kathy Heimbrock
Sibcy Cline, REALTORS-Florence
List Price
$1,350,000
Sold Price
$1,162,875
Premium/Discount to List
-$187,125
-13.86%
Current Estimated Value
$1,538,876

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$376,001
Avg. Annual Appreciation
6.93%
Original Mortgage
$1,046,390
Outstanding Balance
$952,137
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$586,739

Purchase Details

Closed on
Feb 20, 2007
Sold by
Schmitz John P and Schmitz Janet T
Bought by
Schmitz Janet and Janet Schmitz Trust

Purchase Details

Closed on
Sep 5, 1995
Sold by
Ashley Canterbury Ptns
Bought by
Schmitz John P
Source: Public Records

Range of Values:

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

Date Buyer Sale Price Title Company
Bertke Matthew Hatfield $1,162,785 None Available
Schmitz Janet -- None Available
Schmitz Janet -- None Available
Schmitz John P $130,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bertke Matthew Hatfield $1,046,390
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/25/2021 08/25/21 Sold $1,162,875 -9.9% $140 / Sq Ft
07/09/2021 07/09/21 Pending -- -- --
05/18/2021 05/18/21 Price Changed $1,290,000 -3.7% $155 / Sq Ft
05/05/2021 05/05/21 Price Changed $1,340,000 -0.7% $161 / Sq Ft
03/11/2021 03/11/21 For Sale $1,350,000 -- $163 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Tax History Compared to Growth

Source: Public Records

Tax History

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
2024 $11,918 $1,162,700 $200,000 $962,700
2023 $12,394 $1,162,700 $180,000 $982,700
2022 $12,518 $1,162,700 $180,000 $982,700
2021 $15,347 $1,397,000 $180,000 $1,217,000
2020 $14,109 $1,270,000 $180,000 $1,090,000
2019 $14,154 $1,270,000 $180,000 $1,090,000
2018 $14,195 $1,270,000 $180,000 $1,090,000
2017 $10,631 $977,500 $180,000 $797,500
2015 $10,327 $977,500 $242,500 $735,000
2014 $10,151 $977,500 $242,500 $735,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 546662

Northern Kentucky Multiple Listing Service

APN: 029-40-00-016.30