NOT LISTED FOR SALE

Estimated Value: $528,000 - $623,000

5 Beds
4 Baths
-- Sq Ft
0.77 Acres

Last Sold November 10, 2022

Last sale price $550,000

Est. 7% increase in value since last sale

Current estimated payment $3,780/month

5 Days on Market

Highlights

  • In Ground Pool
  • Golf Course View
  • Open Floorplan
  • Stephens Elementary School Rated A-
  • 0.77 Acre Lot
  • Fireplace in Primary Bedroom

About This Home

As of November 2022

Golf Course View & Inground Pool! You'll love this incredible 5 bedroom home boasting of an open floor plan-ample natural light-ceramic tile & hardwood floors-12 ft copper top island-granite countertops with tiled backsplash-3 working fireplaces-crown molding & wainscoting throughout-multiple custom built-ins-finished lower level with bar, fireplace & walkout-enormous owners suite with fireplace, dual vanity, soaking tub & private balcony-oversized 3 car garage-multiple paver stone patios-enormous inground pool-oversized corner lot-custom built firepit & sitting area-playground-mature landscaping & so much more. This home is truly an entertainment paradise! Low unincorporated Boone County Taxes.

Last Listed By

The Treas Team

Huff Realty - Florence Listed on: 09/22/2022

Huff Realty - Florence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,979

Year Built

  • Built in 1967

Lot Details

  • 0.77 Acre Lot

Parking

  • 3 Car Garage
  • Driveway
  • On-Street Parking
  • Off-Street Parking

Home Design

  • Quad-Level Property
  • Brick Exterior Construction
  • Block Foundation
  • Shingle Roof
  • Wood Siding

Interior Spaces

  • Open Floorplan
  • Built-In Features
  • Bookcases
  • Dry Bar
  • Woodwork
  • Crown Molding
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Wood Burning Fireplace
  • Stone Fireplace
  • Brick Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Garden Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Great Room
  • Family Room
  • Living Room with Fireplace
  • 3 Fireplaces
  • Sitting Room
  • Breakfast Room
  • Formal Dining Room
  • Storage
  • Laundry Room
  • Golf Course Views

Kitchen

  • Eat-In Kitchen
  • Electric Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Solid Wood Cabinet

Flooring

  • Wood
  • Carpet
  • Concrete
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Fireplace in Primary Bedroom
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • 4 Full Bathrooms
  • Entry through bedroom
  • Double Vanity

Finished Basement

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

Outdoor Features

  • In Ground Pool
  • Deck
  • Patio
  • Fire Pit
  • Porch

Schools

  • Stephens Elementary School
  • Camp Ernst Middle School
  • Boone County High School

Utilities

  • Central Air
  • Heat Pump System

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 049.00-08-040.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,979

Year Built

Built in 1967

Lot Details

0

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.77
  • Year Built: 1967
  • Lot Size: Of record
  • Directions: 18 To Boone Aire Road to Left onto Musket Road to Right onto Flintridge Road to Left on Singletree.
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • 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: Stephens Elementary
  • Location Tax Legal Info:Middle or Junior School: Camp Ernst Middle School
  • Location Tax Legal Info:High School: Boone County High
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Of record
  • Architecture:Ranch: Yes
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Duke
  • Water Company: Boone County
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.77
  • Structure Type:House: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Location Tax Legal Info:Tax ID: 049.00-08-040.00
  • Appliances Refrigerators: Yes
  • Foundation:Block4: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 3
  • Levels:Quad-Level: Yes
  • Percent Basement Finished: Yes
  • Laundry Room Features:Concrete Flooring4: Yes
  • Room Type:Great Room4: Yes
  • Pool Features:In Ground: Yes
  • Great Room Features:Recessed Lighting2: Yes
  • Entry Features:Wood Flooring: Yes
  • Great Room Features:Carpet Flooring8: Yes
  • Entry Features:Entrance Foyer: Yes
  • View:Golf Course2: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Storage, Pantry, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Built-in Features, Ceiling Fan(s), French Doors, Multi Panel Doors, Natural Woodwork, Recessed Lighting, Dry Bar, Master Downstairs
  • Basement: Full, Finished, Walk-Out Access
  • Heating: Heat Pump, Electric
  • Levels: Quad-Level
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Electric Cooktop, Electric Oven, Dishwasher, Microwave, Refrigerator
  • Full Bathrooms: 4
  • Total Bedrooms: 5
  • Fireplace Features: Stone, Brick, Wood Burning
  • Fireplaces: 3
  • Fireplace: Yes
  • Window Features: Garden Window(s), Insulated Window(s), Vinyl Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: Yes
  • Interior Features:Built-in Features2: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Storage2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Primary Bedroom Features:Ceiling Fan(s)8: 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:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Living Room Features:Walk-Out Access: Yes
  • Interior Features:Natural Woodwork: Yes
  • Interior Features:Primary Downstairs: Yes
  • Basement:Fireplace(s)7: Yes
  • Fireplace Features:Wood Burning: Yes
  • Interior Features:Crown Molding: Yes
  • Living Room Features:Wood Flooring2: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Brick3: Yes
  • Living Room Features:Fireplace(s): Yes
  • Kitchen Features:Ceramic Tile Flooring2: Yes
  • Interior Features:Chandelier2: Yes
  • Dining Room Features:Chandelier: Yes
  • Appliances:Electric Cooktop: Yes
  • Interior Features:Recessed Lighting: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Fireplace Features:Stone4: Yes
  • Family Room Features:Recessed Lighting6: Yes
  • Family Room Features:Wood Flooring5: Yes
  • Primary Bedroom Features:Fireplace(s)6: Yes
  • Primary Bedroom Features:Sitting Room: Yes
  • Primary Bedroom Features:Walk-Out Access6: Yes
  • Living Room Features:Built-in Features7: Yes
  • Living Room Features:Recessed Lighting4: Yes
  • Kitchen Features:Crown Molding2: Yes
  • Family Room Features:Bookcases2: Yes
  • Living Room Features:Bookcases7: Yes
  • Dining Room Features:Recessed Lighting8: Yes
  • Kitchen Features:Planning Desk: Yes
  • Basement:Dry Bar5: Yes

Exterior Features

  • View: Golf Course
  • Roof: Shingle
  • Pool Features: In Ground
  • View: Yes
  • Construction Type: Brick, Wood Siding
  • Exterior Features: Fire Pit
  • Foundation Details: Block
  • Patio And Porch Features: Deck, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Exterior Features:Fire Pit: Yes
  • Construction Materials:Wood Siding: Yes
  • Window Features:Garden Window(s): Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage, Off Street, On Street, Oversized
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:On Street: Yes
  • Parking Features:Oversized: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Utility Sink
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Electric2: Yes
  • Heating:Heat Pump2: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Stephens Elementary
  • Junior High Dist: Boone Co Public
  • High School: Boone County High
  • Middle Or Junior School: Camp Ernst Middle School

Lot Info

  • Lot Size Sq Ft: 33541.2
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 22, 2022
Closed on
Nov 10, 2022
Sold by
Berkemeier Brent M and Berkemeier Emily A
Bought by
Gott Joshua S and Gott Terra D
Seller's Agent
The Treas Team
Huff Realty - Florence
Buyer's Agent
Outside Agent
Outside Sales
List Price
$550,000
Sold Price
$550,000
Total Days on Market
5
Views
53
Current Estimated Value
$586,309

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$36,309
Avg. Annual Appreciation
2.54%
Original Mortgage
$440,000
Outstanding Balance
$428,470
Interest Rate
6.92%
Mortgage Type
New Conventional
Estimated Equity
$157,839

Purchase Details

Closed on
Feb 28, 2011
Sold by
Kreutzer Frank F and Kreutzer Jan Kipp
Bought by
Berkemeier Brent M and Berkemeier Emily A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$324,000
Interest Rate
4.71%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 31, 1998
Sold by
Yoe Edward L
Bought by
Kruetzer Frank F Jan K

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$206,400
Interest Rate
7.25%
Mortgage Type
New Conventional

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

Similar Homes in the area

  • 7053 Glade Ln, Florence, KY 41042

    $459,900

    • 4 Beds
    • 3.5 Baths
    • 2,888 Sq Ft
    • 7053 Glade Ln
    • Florence, KY

    Step into this beautifully updated 4-bedroom, 3.5-bathroom home located in the highly sought-after Oakbrook community! With thoughtful upgrades throughout, this home blends modern style with cozy comfort—perfect for everyday living and entertaining.The main floor features stunning new flooring that flows seamlessly through the open-concept living and dining spaces. Check out the updated kitchen,

    Christina Kasle Pivot Realty Group

    Section Image
  • 7497 Harvesthome Dr, Florence, KY 41042

    $539,900

    • 4 Beds
    • 3.5 Baths
    • 5,000 Sq Ft
    • 7497 Harvesthome Dr
    • Florence, KY

    One owner well-loved Zaring built brick home in Hearthstone. This ''Savoy'' floor plan offers dramatic high ceilings & 3 finished levels w/ approximately 5000 sqft of finished living space. Inviting covered front porch & 2-story entry w/ hardwood floors & decorative pillars. Formal room has crown molding & could also be utilized as a study. Formal dining room boats detailed wainscoting/ chair

    Team Sanders Sibcy Cline, REALTORS-Florence

    Section Image
  • 1815 Fair Meadow Dr, Florence, KY 41042

    $439,000

    • 4 Beds
    • 3.5 Baths
    • 4,206 Sq Ft
    • 1815 Fair Meadow Dr
    • Florence, KY

    This home is in a prime location with amenities galore. It is waiting for you to put your loving touch on it. Finished basement, large yard, cat walk, and fireplace in LR. This is a must see.

    KRISTY GOOCH RE/MAX Elite Realty

    Section Image
  • 8232 Woodcreek Dr, Florence, KY 41042

    $539,900

    • 5 Beds
    • 5 Baths
    • 8232 Woodcreek Dr
    • Florence, KY

    Hard to find CUSTOM home with meticulous maintenance & a long list of improvements situated on a lush half acre lot boasting a gorgeous pool! Just LOOK at the room sizes in this brick, true 5 bedroom home with walk-in closets, flexible room arrangements that flow effortlessly, an oversized 3 car garage, finished lower level, central vac and all new or newer systems. Ask for a complete list of the

    Holly Nally Huff Realty - Florence

    Section Image
  • 9013 Philly Ct, Union, KY 41091

    $460,000

    • 4 Beds
    • 3.5 Baths
    • 2,320 Sq Ft
    • 9013 Philly Ct
    • Union, KY

    Claim this beautiful home today! Boasting all the perfect finishes that will make you fall in love and want to call it your own. This spacious property features 4 bedrooms, 3 full bathrooms, and an additional half bath for convenience. The inviting living room with a cozy fireplace opens to a large deck, ideal for outdoor entertaining. The open floor plan provides plenty of space for gatherings,

    Heather Pilcher Real Broker, LLC

    Section Image
  • 8394 Saint Louis Blvd, Union, KY 41091

    $625,000

    • 6 Beds
    • 4.5 Baths
    • 4,326 Sq Ft
    • 8394 Saint Louis Blvd
    • Union, KY

    A truly remarkable, 6 bedrm, 4 full bathrms and 1 half bath located in the French Quarter at Orleans North! Step inside to be greeted by a soaring 2 story entry offering hardwood floors. Spacious living room and formal dining room with an added touch of crown molding and chair rail. Hot water heater May 2025. ROOF 2023. Entertain in the expansive kitchen remodeled in 2020. Beautiful oversized

    Blaire Hancock Simple Fee Realty

    Section Image
  • 10113 Lapalco Ct, Union, KY 41091

    $465,000

    • 4 Beds
    • 4 Baths
    • 2,434 Sq Ft
    • 10113 Lapalco Ct
    • Union, KY

    Drees Ashton Plan in one of Northern Kentucky's Top School Districts!Built in 2015, this 4-bedroom, 2 full bath, 2 half bath home offers the space and features families need while being located in one of the best school districts in Northern Kentucky.Enjoy an open floor plan with a stylish kitchen featuring granite countertops and a large breakfast island. All bedrooms are upstairs alongside a

    Jorden Zamrik Comey & Shepherd REALTORS

    Section Image
  • 8104 Harms Hill Dr, Florence, KY 41042

    $449,900

    • 3 Beds
    • 4 Baths
    • 2,452 Sq Ft
    • 8104 Harms Hill Dr
    • Florence, KY

    Welcome Home to Prestigious Dilcrest Manor! Nestled on a quiet cul-de-sac in the heart of Florence, this stunning all-brick home offers the perfect blend of timeless elegance and modern updates. Set on a beautifully landscaped +/- 0.5 acre lot, you'll enjoy the serenity of country living with the convenience of being just moments from the expressway.Step inside to find gracious room sizes, a

    Kathleen Robbins Keller Williams Realty Services

    Section Image
  • 788 Grace Dr, Florence, KY 41042

    $525,000

    • 4 Beds
    • 3.5 Baths
    • 3,770 Sq Ft
    • 788 Grace Dr
    • Florence, KY

    A custom-built home, nestled on a spacious lot, tucked in the coveted Eagles Landing neighborhood. Inside, enjoy an open-concept layout, a vaulted ceiling in the great room that opens into an eat-in kitchen—perfect for entertaining. The first floor primary suite features a spa-like en-suite bath and walk-in closet.The lower level , has a hidden speakeasy which offers rich character with

    Heather Kopf Kopf Hunter Haas

    Section Image

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
Gott Joshua S $550,000 --
Berkemeier Brent M $405,000 Lawyers Title Of Cincinnati
Kruetzer Frank F Jan K $258,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gott Joshua S $440,000
Previous Owner Berkemeier Brent M $100,000
Previous Owner Berkemeier Brent M $46,000
Previous Owner Berkemeier Brent M $325,000
Previous Owner Berkemeier Brent M $327,000
Previous Owner Berkemeier Brent M $324,000
Previous Owner Kreutzer Frank F $391,755
Previous Owner Kruetzer Frank F Jan K $206,400
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/10/2022 11/10/22 Sold $550,000 0.0% --
09/28/2022 09/28/22 Pending -- -- --
09/22/2022 09/22/22 For Sale $550,000 -- --
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 $5,979 $550,000 $40,000 $510,000
2023 $6,122 $550,000 $40,000 $510,000
2022 $4,527 $405,000 $40,000 $365,000
2021 $4,611 $405,000 $30,000 $375,000
2020 $4,616 $405,000 $30,000 $375,000
2019 $4,651 $405,000 $30,000 $375,000
2018 $4,656 $405,000 $30,000 $375,000
2017 $4,609 $405,000 $30,000 $375,000
2015 $4,577 $405,000 $30,000 $375,000
2013 -- $405,000 $30,000 $375,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 608094

Northern Kentucky Multiple Listing Service

APN: 049.00-08-040.00