NOT LISTED FOR SALE

Estimated Value: $610,245

5 Beds
3.5 Baths
-- Sq Ft
0.6 Acres

Last Sold January 29, 2024

Last sale price $580,000

Est. 5% increase in value since last sale

Current estimated payment $3,776/month

40 Days on Market

Highlights

  • On Golf Course
  • 0.6 Acre Lot
  • Vaulted Ceiling
  • Stephens Elementary School Rated A-
  • Open Floorplan
  • Soaking Tub in Primary Bathroom

About This Home

As of January 2024

Tons of upgrades and tons of space make this beautiful-spacious- custom built 5 bedroom two story! This home is overlooking the Boone Links Golf Course. And features an open floor plan, 2 story entry with balcony, newer hardwood floors, all new stair railings, fresh paint, and and more. The kitchen features granite island bar & counter tops, Bosch stainless steel appliances! This home also features A Theater area and wet bar in the basement, Geo thermal heating, 1st flr, laundry, 3 finished levels, 4 car attached garages, huge office, covered patio & storage galore gross square footage of this magnificent home is nearly 6000 square feet! The garage has a storage room built into it that is plumbed for an additional bathroom and/or laundry . Walks out to the covered patio area and back yard. The covered patio area is wired for sound system and a TV and has ceiling fans.


The Media equipment and seating to stay with the property
The Large custom bookcase in the main family area are to stay
The matching bar stools in the kitchen are to stay
The washer and dryer and all kitchen appliances are to stay

The exercise equipment in the bonus master area may stay

Last Listed By

Rebecca Trout

Huff Realty - Florence License #205343 Listed on: 11/09/2023

Huff Realty - Florence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,315

Year Built

  • Built in 1996

Lot Details

  • 0.6 Acre Lot
  • Lot Dimensions are 175 x 150
  • On Golf Course
  • Cul-De-Sac
  • Level Lot
  • Cleared Lot

Parking

  • 4 Car Attached Garage
  • Side Facing Garage
  • Tandem Parking
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Property Views

  • Golf Course
  • Neighborhood

Home Design

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

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Home Theater Equipment
  • Sound System
  • Built-In Features
  • Woodwork
  • Crown Molding
  • Coffered Ceiling
  • Vaulted Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • 2 Fireplaces
  • Wood Burning Fireplace
  • Vinyl Clad Windows
  • Aluminum Window Frames
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Great Room
  • Family Room
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Home Office
  • Bonus Room
  • Storage
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

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

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Finished Basement Bathroom
  • Stubbed For A Bathroom
  • Basement Storage

Outdoor Features

  • Covered patio or porch
  • Water Fountains
  • Exterior Lighting

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Geothermal Heating and Cooling
  • 220 Volts
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 049.00-08-035.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,315

Year Built

Built in 1996

Lot Details

0

Parking

4

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.6
  • Year Built: 1996
  • Lot Size: 175 x 150
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Directions: Burlington Pike to Boone Aire to Mul to right on Flintrock
  • Architectural Style: Traditional
  • 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
  • Location Tax Legal Info:Subdivision2: Boone Aire Country Club & Estates
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: 175 x 150
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Office5: 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: 0.6
  • General Property Description:Lot Size Square Feet: 26136.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 049.00-08-035.00
  • Appliances Refrigerators: Yes
  • Laundry Features:Electric Dryer Hookup: Yes
  • Laundry Features:Washer Hookup: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 2
  • Appliances Dryer: Yes
  • Washers: Yes
  • Room Type:Bonus Room2: Yes
  • Utilities:Sewer Available: Yes
  • Utilities:Water Available: Yes
  • Other Equipment:Sump Pump: Yes
  • Percent Basement Finished: Yes
  • Other Equipment:Home Theater: Yes
  • Room Type:Great Room4: Yes
  • Entry Features:Hardwood Floors5: Yes
  • Entry Features:Entrance Foyer: Yes
  • Office Features:Hardwood Floors16: Yes
  • Great Room Features:Hardwood Floors8: Yes
  • View:Golf Course2: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Sound System, Soaking Tub, Pantry, Open Floorplan, Granite Counters, Double Vanity, Crown Molding, Coffered Ceiling(s), Chandelier, Built-in Features, 220 Volts, Ceiling Fan(s), French Doors, High Ceilings, Multi Panel Doors, Natural Woodwork, Recessed Lighting, Vaulted Ceiling(s)
  • Basement: Full, Finished, Bath/Stubbed, Storage Space, Walk-Out Access
  • Heating: Natural Gas, Geothermal, Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Electric Range, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer
  • Other Equipment: Home Theater, Sump Pump
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Window Features: Aluminum Clad Window(s), Vinyl Clad Window(s)
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Built-in Features2: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:High Ceilings: 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
  • Interior Features:Wet Bar4: Yes
  • Kitchen Features:Granite Countertops: 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
  • Appliances:Electric Range: Yes
  • Living Room Features:Hardwood Floors13: Yes
  • Dining Room Features:Hardwood Floors4: Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Natural Woodwork: Yes
  • Basement:Fireplace(s)7: Yes
  • Fireplace Features:Wood Burning: Yes
  • Interior Features:Crown Molding: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Primary Bath Features:Soaking Tub2: Yes
  • Kitchen Features:Hardwood Floors10: Yes
  • Primary Bedroom Features:Hardwood Floors18: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Soaking Tub: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Interior Features:Coffered Ceiling(s): Yes
  • Primary Bath Features:Ceramic Tile Flooring: Yes
  • Basement:Built-in Features3: Yes
  • Primary Bedroom Features:Dressing Area: Yes
  • Interior Features:Sound System: Yes

Exterior Features

  • View: Golf Course, Neighborhood
  • Roof: Shingle
  • Lot Features: Cleared, Cul-De-Sac, Level, On Golf Course
  • View: Yes
  • Construction Type: Brick, Vinyl Siding
  • Exterior Features: Fountain, Lighting
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Window Features:Vinyl Clad Window(s): Yes
  • Lot Features:Cul-De-Sac: Yes
  • Lot Features:Level: Yes
  • Lot Features:Cleared: Yes
  • Exterior Features:Lighting: Yes
  • Window Features:Aluminum Clad Window(s): Yes
  • Exterior Features:Fountain: Yes
  • Lot Features:On Golf Course: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage Door Opener, Garage Faces Side, Off Street, Tandem
  • General Property Description:Garage Spaces: 4.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:Garage Faces Side: Yes
  • Parking Features:Tandem: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available, Sewer Available, Water Available
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes
  • Heating:Geothermal: 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: 26136.0
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 9, 2023
Closed on
Jan 23, 2024
Sold by
Ochs Brian and Ochs Cammie S
Bought by
Cardosi Joseph Blair
Seller's Agent
Rebecca Trout
Huff Realty - Florence
Buyer's Agent
Leslie Blair
Towne & Country Realty House
List Price
$625,000
Sold Price
$580,000
Premium/Discount to List
-$45,000
-7.2%
Total Days on Market
40
Views
91
Current Estimated Value
$610,245

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$30,245
Avg. Annual Appreciation
4.77%
Original Mortgage
$551,000
Outstanding Balance
$544,969
Interest Rate
6.61%
Mortgage Type
New Conventional
Estimated Equity
$72,143

Purchase Details

Closed on
Sep 26, 2016
Sold by
Shidler Aaron T and Shidler Chasity
Bought by
Ochs Brian and Ochs Cammie S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$355,500
Interest Rate
3.45%
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

    $454,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
  • 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
  • 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
  • 8809 Marais Dr, Union, KY 41091

    $499,900

    • 3 Beds
    • 3 Baths
    • 2,820 Sq Ft
    • 8809 Marais Dr
    • Union, KY

    The Kenai showcases luxury living all on one level. You'll love entertaining in the open family room with cozy fireplace, gourmet kitchen with generous island and dining area. And the relaxing sunroom will be your favorite spot to unwind. Retreat to the spacious primary suite, where you'll find a luxury bath with a super shower, plus a large walk-in closet. Keep your personal items organized and

    John Heisler Drees/Zaring Realty

    Section Image
  • 8791 Marais Dr, Union, KY 41091

    $739,900

    • 3 Beds
    • 3.5 Baths
    • 3,581 Sq Ft
    • 8791 Marais Dr
    • Union, KY

    The Lyndhurst plan offers comfortable one-level living in a ranch plan with flexible options for you to make this home suit your style. Step inside and discover a quiet home office with French doors just off the main foyer. The open central living area includes a large family room with cozy fireplace, casual dining area and well-designed deluxe kitchen with serving island. You'll love relaxing in

    John Heisler Drees/Zaring Realty

    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
Cardosi Joseph Blair $580,000 360 American Title Services
Ochs Brian $395,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Cardosi Joseph Blair $551,000
Previous Owner Ochs Brian $355,500
Previous Owner Shidler Aaron T $294,000
Previous Owner Shidler Aaron T $294,600
Previous Owner Shidler Aaron $50,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/29/2024 01/29/24 Sold $580,000 -7.2% --
12/21/2023 12/21/23 Pending -- -- --
11/10/2023 11/10/23 For Sale $625,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 $4,315 $395,000 $40,000 $355,000
2023 $4,396 $395,000 $40,000 $355,000
2022 $4,415 $395,000 $40,000 $355,000
2021 $4,499 $395,000 $30,000 $365,000
2020 $4,502 $395,000 $30,000 $365,000
2019 $4,536 $395,000 $30,000 $365,000
2018 $4,542 $395,000 $30,000 $365,000
2017 $4,495 $395,000 $30,000 $365,000
2015 $2,904 $257,000 $30,000 $227,000
2013 -- $265,800 $30,000 $235,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 618484

Northern Kentucky Multiple Listing Service

APN: 049.00-08-035.00