$499,000
PENDING

Estimated payment $3,066/month

Total Views 2,586
4 Beds
3 Baths
-- Sq Ft
-- Price per Sq Ft

Highlights

  • In Ground Pool
  • Open Floorplan
  • Ranch Style House
  • Thornwilde Elementary School Rated A
  • Deck
  • Wood Flooring

About This Home

Incredible opportunity to own a meticulously maintained, hard-to-find ranch home with a private inground pool, custom pool deck, & covered rear deck—ideal for entertaining or quiet relaxation. This beautiful property features an oversized 3-car side-entry garage, 9ft ceilings, an open floor plan, gleaming hardwood floors, French doors, curved archways, & neutral décor enhanced by modern lighting throughout. The kitchen offers granite countertops, recessed lighting, & transom windows that bring in ample natural light. Elegant touches include multiple bay windows, wainscoting, & crown molding. The enormous owner's suite boasts a walk-in closet & a luxury remodeled bath with a custom-tiled shower featuring multiple jets & a rain head, stand-alone soaking tub, custom tile, & dual vanity. The finished walkout lower level includes a full bar, additional bedroom, full bath, theatre room, & generous entertaining & storage space. Enjoy total backyard privacy with no HOA restrictions—this is a rare find!

Listing Agent

Bradley Treas

Huff Realty - Florence License #203389 Listed on: 06/10/2025

Huff Realty - Florence

Co-Listing Agent

Andrea Domec

Huff Realty - Florence License #280458

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,715

Year Built

  • Built in 2001

Lot Details

  • 0.47 Acre Lot
  • Wrought Iron Fence

Parking

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

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • Open Floorplan
  • Wet Bar
  • Home Theater Equipment
  • Built-In Features
  • Crown Molding
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Gas Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Bay Window
  • Transom Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Game Room
  • Storage
  • Laundry Room

Kitchen

  • Electric Range
  • <<microwave>>
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Utility Sink

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • 3 Full Bathrooms
  • Double Vanity
  • Soaking Tub
  • Built-In Shower Bench

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Finished Basement Bathroom
  • Basement Storage

Outdoor Features

  • In Ground Pool
  • Deck
  • Covered patio or porch
  • Shed

Schools

  • Thornwilde Elementary School
  • Conner Middle School
  • Conner Senior High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 035.00-04-195.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,715

Year Built

Built in 2001

Lot Details

0

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.47
  • Year Built: 2001
  • Lot Size: of record
  • Co List Office Mls Id: o432500054
  • Co List Office Phone: 859-525-7900
  • Ownership: Consumer
  • Directions: 237 To Treetop Lane
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: Thornwilde
  • Location Tax Legal Info:Middle or Junior School: Conner Middle School
  • Location Tax Legal Info:High School: Conner Senior 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
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Levels:One: Yes
  • Utilities Electric Company: Owen
  • Utilities Gas Company: Duke
  • Water Company: Boone County Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.47
  • Structure Type:House: Yes
  • Location Tax Legal Info:Tax ID: 035.00-04-195.00
  • Appliances Refrigerators: Yes
  • Other Structures:Shed(s): Yes
  • General Property Description:Fireplaces Total: 1
  • Percent Basement Finished: Yes
  • Other Equipment:Home Theater: Yes
  • Pool Features:In Ground: Yes
  • Fencing:Wrought Iron: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Soaking Tub, Open Floorplan, Granite Counters, Entrance Foyer, Double Vanity, Crown Molding, Chandelier, Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting, Built-in Features, Master Downstairs
  • Basement: Full Finished Bath, Full, Finished, Storage Space, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: One
  • Property Type: Residential
  • Appliances: Electric Range, Dishwasher, Microwave, Refrigerator
  • Other Equipment: Home Theater
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Window Features: Insulated Windows, Vinyl Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Entrance Foyer2: 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:Storage2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wet Bar4: Yes
  • Basement:Walk-Out Access7: Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Primary Downstairs: Yes
  • Interior Features:Crown Molding: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Recessed Lighting: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Soaking Tub: Yes
  • Basement:Built-in Features3: Yes

Exterior Features

  • Fencing: Wrought Iron
  • Roof: Shingle
  • Pool Features: In Ground
  • Construction Type: Brick, Vinyl Siding
  • Foundation Details: Poured Concrete
  • Other Structures: Shed(s)
  • Patio And Porch Features: Covered, Deck, Patio
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Insulated Window(s): Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Thornwilde
  • Junior High Dist: Boone Co Public
  • High School: Conner Senior High
  • Middle Or Junior School: Conner Middle School

Lot Info

  • Lot Size Sq Ft: 20473.2

Map

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

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 $3,715 $350,500 $45,000 $305,500
2023 $3,460 $324,000 $40,000 $284,000
2022 $3,476 $324,000 $40,000 $284,000
2021 $3,545 $324,000 $40,000 $284,000
2020 $3,077 $282,100 $40,000 $242,100
2019 $2,606 $237,100 $35,000 $202,100
2018 $2,640 $237,100 $35,000 $202,100
2017 $2,584 $237,100 $35,000 $202,100
2015 $2,166 $237,100 $35,000 $202,100
2013 -- $237,100 $35,000 $202,100
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/12/2025 06/12/25 Pending -- -- --
06/10/2025 06/10/25 For Sale $499,000 -- --
Source: Northern Kentucky Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
Warranty Deed $324,000 Millennial Title Llc
Interfamily Deed Transfer -- None Available
Deed $229,420 --
Deed $139,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $307,000 New Conventional
Previous Owner $100,000 Credit Line Revolving
Previous Owner $136,000 New Conventional
Previous Owner $150,000 New Conventional
Source: Public Records

About the Listing Agent

Bradley Treas

Huff Realty - Florence

(859) 651-8018

Section Image

Our business is built upon the principles of integrity, professionalism, hard work, communication and a strong belief in people.

The Treas Team offers unparalleled service to ALL clients in the Northern Kentucky real estate market. Whether you are considering buying a home, selling a home or both, we know this area inside and out. Your complete satisfaction with our service and representation is our number one priority.

As a 3rd generation realtor Brad has grown up in the

Bradley's Other Listings

  • 7627 River Rd, Hebron, KY 41048

    $600,000 Pending

    • 2 Beds
    • 2 Baths
    • 7627 River Rd
    • Hebron, KY

    Discover peace, privacy, and modern comfort on 3.87 acres at this custom-built retreat with panoramic river and valley views. Designed to blend sleek, contemporary living with a tranquil country setting, the home showcases an open floor plan, quartz countertops, floating shelves, stainless steel appliances, an exterior-vented kitchen hood, a wood-burning fireplace, luxury vinyl plank flooring,

    Bradley Treas Huff Realty - Florence

    Section Image
  • 8300 Camp Ernst Rd, Burlington, KY 41005

    $625,000

    • 4 Beds
    • 3 Baths
    • 8300 Camp Ernst Rd
    • Burlington, KY

    An amazing opportunity to own a beautifully remodeled ranch home on 7 private acres just 1 mile from Cooper High School! This mini farm offers in-town convenience with the freedom of country living, featuring a barn with horse stalls & ample storage, multiple fenced pastures with lean-to outbuildings, electric fencing, fruit trees, garden space, and room for goats & chickens. The property also

    Bradley Treas Huff Realty - Florence

    Section Image
  • 67 Surrey Ct, Florence, KY 41042

    $269,000 Pending

    • 2 Beds
    • 2 Baths
    • 1,400 Sq Ft
    • 67 Surrey Ct
    • Florence, KY

    100 percent Financing Available Through KY Housing! Lakefront property in the heart of Florence, KY offering the perfect blend of comfort & tranquility. This immaculate home features an open floor plan, soaring vaulted ceilings, ample natural light, & neutral decor. Bedrooms boast large walk in closets. The kitchen includes stainless steel appliances, updated lighting, & the washer and dryer

    Bradley Treas Huff Realty - Florence

    Section Image
  • 102 Stevenson Rd, Erlanger, KY 41018

    $219,000 Pending

    • 4 Beds
    • 1 Bath
    • 102 Stevenson Rd
    • Erlanger, KY

    100 percent Financing Available Through KY Housing! This true 4-bedroom home features a remodeled kitchen with granite countertops, stainless steel appliances, & tiled flooring, along with a renovated bathroom offering a custom tiled shower/tub & stylish finishes. Enjoy ample natural light, neutral decor, arched doorways, & maintenance-free vinyl plank flooring throughout. The home includes an

    Bradley Treas Huff Realty - Florence

    Section Image
  • 1426 Taramore Dr, Florence, KY 41042

    $330,000

    • 4 Beds
    • 3 Baths
    • 1426 Taramore Dr
    • Florence, KY

    This enormous 0-step townhome offers the perfect blend of comfort, space, & accessibility in a prime Florence location! With a true 4-bedroom layout, this home is ideal for multigenerational living. Enjoy a private entry, open floor plan, soaring ceilings, transom windows, updated lighting, and ample natural light throughout. The main level features 2 spacious bedrooms, including an owner's suite

    Bradley Treas Huff Realty - Florence

    Section Image
  • 10239 Knob Hill Dr, Florence, KY 41042

    $230,000 Pending

    • 3 Beds
    • 2 Baths
    • 10239 Knob Hill Dr
    • Florence, KY

    100 percent Financing Available Through KY Housing! This well-maintained step-free ranch home in the sought-after Ryle School District offers convenience, space, and comfort all on one level. Features include an open floor plan, neutral decor, ceramic tiled flooring, and modern lighting throughout. The kitchen includes all appliances and opens to a bright living area filled with natural light.

    Bradley Treas Huff Realty - Florence

    Section Image
  • 10746 Us Highway 42, Union, KY 41091

    $315,000

    • 3 Beds
    • 1 Bath
    • 10746 Us Highway 42
    • Union, KY

    This beautifully updated 3-bedroom, 1-bath brick-wrapped home offers charm, functionality, & convenience—just one mile from Ryle High School. Outside, enjoy two driveways for extra parking, a fire pit for gatherings, & an oversized detached garage complete with a finished hobby room or workshop—ideal for creative projects or extra workspace. The exterior also features a brand new septic system &

    Bradley Treas Huff Realty - Florence

    Section Image
  • 214 Clifton Ave, Newport, KY 41071

    $650,000

    • 5 Beds
    • 4.5 Baths
    • 214 Clifton Ave
    • Newport, KY

    Priced $165,000 under appraised value-Truly Unique Opportunity with Unmatched Views! This breathtaking 5-bedroom, 4.5-bath home offers panoramic Cincinnati skyline & Licking River Valley views, making it an amazing spot to watch the WEBN fireworks right from your own deck! With over 4,400 sq ft of living space, this sprawling home features custom wood ceilings, coffered ceilings, ornate woodwork,

    Bradley Treas Huff Realty - Florence

    Section Image
  • 3926 Huntington Ave, Covington, KY 41015

    $229,900

    • 2 Beds
    • 1.5 Baths
    • 3926 Huntington Ave
    • Covington, KY

    100 percent Financing Available Through the City of Covington! This immaculate brick home blends timeless character with thoughtful updates throughout. Enjoy soaring ceilings, gleaming hardwood floors, and an open floor plan filled with natural light. The original stained-glass windows, stunning woodwork, cased openings, and shadow box archways showcase the home's historic charm, while modern

    Bradley Treas Huff Realty - Florence

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 633319

Northern Kentucky Multiple Listing Service

APN: 035.00-04-195.00