$1,169,000
$131K PRICE DROP

879 Squire Oaks Dr Villa Hills, KY 41017

Estimated payment $6,973/month

Total Views 76,210
5 Beds
3.5 Baths
4,041 Sq Ft
$289 Price per Sq Ft

Highlights

  • Docks
  • Oak Trees
  • Lake On Lot
  • River Ridge Elementary School Rated A-
  • In Ground Pool
  • Eat-In Gourmet Kitchen

About This Home

Elegant, Understated Home! Custom Built in 1983, Previous Cavalcade of Home Property. Located on 1.05 Acres in Sought after Country Squire Estates. 5 bedrooms, 3 1/2 baths, 5 1/2 garages. Updated Gourmet Kitchen with Granite Countertops, Stainless Appliances, and Hardwood Floors. Home offers Marble Entry and Sitting Room, Cut Glass Transom Windows with Matching Bar in Great Room, Most Chandeliers are Strauss. Also offers a Fabulous Outdoor Entertaining area with Heated Inground Pool, Hot tub with Stereo System and Quartzite Patio, Stone Bar with Granite Top and Gazebo Overlooking Water Fountain and Lake. Owners Suite with Adjacent with Custom Closet and Sitting Room Overlooks Courtyard, Pool and Lake. Recent Upgrades include New Roof and Skylight in April, 2022, Carrier Central Air and Furnace installed May, 2022. New Humidifier Oct. 2022. Recently exterior painted and recently power washed. Pride of Home Ownership shows throughout this Beautiful home. The Estimated Cost for Reproducing this Home would exceed the current asking price by a substantial margin.

Listing Agent

Trina Ellis

Coldwell Banker Realty FM License #193281 Listed on: 07/19/2023

Coldwell Banker Realty FM

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,942

Year Built

  • Built in 1983

Lot Details

  • 1.05 Acre Lot
  • Waterfront
  • Wrought Iron Fence
  • Aluminum or Metal Fence
  • Level Lot
  • Cleared Lot
  • Oak Trees
  • Pine Trees
  • Wooded Lot
  • Private Yard

Parking

  • 5.5 Car Attached Garage
  • Driveway

Home Design

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

Interior Spaces

  • 4,041 Sq Ft Home
  • 1.5-Story Property
  • Wet Bar
  • Sound System
  • Built-In Features
  • Bookcases
  • Woodwork
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Stone Fireplace
  • Gas Fireplace
  • Double Hung Windows
  • Wood Frame Window
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Great Room
  • Family Room
  • Living Room
  • Formal Dining Room
  • Home Office
  • Recreation Room
  • Loft
  • Home Gym
  • Lake Views

Kitchen

  • Eat-In Gourmet Kitchen
  • Gas Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Carpet
  • Concrete
  • Granite
  • Tile

Bedrooms and Bathrooms

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

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Walk-Out Basement
  • Finished Basement Bathroom
  • Crawl Space

Home Security

  • Home Security System
  • Security Lights
  • Smart Thermostat
  • Fire and Smoke Detector

Pool

  • In Ground Pool
  • Spa

Outdoor Features

  • Docks
  • Lake On Lot
  • Patio
  • Water Fountains
  • Gazebo
  • Porch

Schools

  • River Ridge Elementary School
  • Turkey Foot Middle School
  • Dixie Heights High School

Utilities

  • Humidifier
  • Central Air
  • Heating System Uses Natural Gas
  • 220 Volts
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 013-40-13-004.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,942

Year Built

Built in 1983

Lot Details

0

Parking

5

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 1.05
  • Year Built: 1983
  • Lot Size: 239x 242 Approximate from PVA website
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Agent/Owner
  • Directions: Buttermilk Pike to Rosewood to Squire Oaks Dr.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: River Ridge 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: Country Squire 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: 239x 242 Approximate from PVA website
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Entry: Yes
  • Room Type:Laundry Room3: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable 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: 1.05
  • General Property Description:Living Area: 4041.0
  • General Property Description:Lot Size Square Feet: 45738.0
  • Laundry Features:Main Level: Yes
  • Miscellaneous Home Warranty: Yes
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Room Type:Loft3: Yes
  • Loft Features:Carpet Flooring9: Yes
  • Location Tax Legal Info:Tax ID: 013-40-13-004.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • Vegetation:Pine Trees: Yes
  • General Property Description:Fireplaces Total: 1
  • Room Type:Study: Yes
  • Percent Basement Finished: Yes
  • Other Equipment:Humidifier: Yes
  • Room Type:Great Room4: Yes
  • Security Features:Security System: Yes
  • Pool Features:In Ground: Yes
  • Great Room Features:Bookcases6: Yes
  • Great Room Features:Recessed Lighting2: Yes
  • Levels:One and One Half: Yes
  • Fencing:Metal4: Yes
  • Great Room Features:Built-in Features5: Yes
  • Recreation Room Features:Carpet Flooring14: Yes
  • Study Room Features:Hardwood Floors22: Yes
  • Entry Features:Entrance Foyer: Yes
  • Laundry Room Features:Built-in Features6: Yes
  • Great Room Features:Wood Flooring9: Yes
  • Great Room Features:Ceiling Fan(s)4: Yes
  • Great Room Features:High Ceiling(s)3: Yes
  • View:Lake2: Yes
  • Great Room Features:Hardwood Floors8: Yes
  • Great Room Features:Sound System3: Yes
  • Security Features:Security Lights: Yes
  • Other Structures:Gazebo: Yes
  • Fencing:Wrought Iron: Yes
  • Recreation Room Features:Bookcases11: Yes
  • Vegetation:Oak Trees: Yes
  • Entry Features:Granite Flooring: Yes
  • Room Type:Gym: Yes
  • Study Room Features:Built-In Features11: Yes
  • Electric 220 Volts: Yes
  • Fencing Fenced: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Soaking Tub, Smart Thermostat, Pantry, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Built-in Features, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Multi Panel Doors, Natural Woodwork, Recessed Lighting, Wired for Sound
  • Basement: Full Finished Bath, Other, See Remarks, Crawl Space, Finished, Walk-Out Access
  • Heating: Natural Gas
  • Levels: One and One Half
  • Property Type: Residential
  • Appliances: Other, Stainless Steel Appliance(s), Electric Cooktop, Gas Oven, Dishwasher, Disposal, Microwave, Refrigerator
  • Other Equipment: Humidifier
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Door Features: French Doors
  • Fireplace Features: Stone, Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 4041.0
  • Window Features: Double Hung, Wood Frames
  • Appliances Dishwasher: Yes
  • Appliances:Stainless Steel Appliance(s): 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:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Smart Thermostat: 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
  • 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:Hardwood Floors13: Yes
  • Dining Room Features:Hardwood Floors4: Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Basement:Concrete Flooring: Yes
  • Interior Features:Natural Woodwork: Yes
  • Interior Features:Crown Molding: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Crawl Space: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Chandelier2: Yes
  • Living Room Features:High Ceiling(s)4: Yes
  • Living Room Features:Window Treatments: Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Window Treatments3: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Appliances:Electric Cooktop: Yes
  • Kitchen Features:Hardwood Floors10: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Soaking Tub: Yes
  • Interior Features:Wired for Sound: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Appliances:Gas Oven: Yes
  • Fireplace Features:Stone4: Yes
  • Appliances:Other5: Yes
  • Dining Room Features:Window Treatments2: Yes
  • Primary Bath Features:Tub: Yes
  • Basement:Built-in Features3: Yes
  • Primary Bath Features:Tile Flooring4: Yes
  • Basement:Other16: Yes
  • Primary Bath Features:Window Treatments7: Yes
  • Primary Bath Features:Carpet Flooring6: Yes
  • Basement:See Remarks36: Yes

Exterior Features

  • View: Lake
  • Fencing: Fenced, Wrought Iron, Metal
  • Roof: Shingle
  • Lot Features: Cleared, Level, Waterfront, Wooded
  • Pool Features: In Ground
  • View: Yes
  • Home Warranty: Yes
  • Construction Type: Brick
  • Exterior Features: Private Yard, Dock, Fountain, Hot Tub
  • Foundation Details: Poured Concrete
  • Other Structures: Garage(s), Gazebo
  • Patio And Porch Features: Patio, Porch
  • Construction Materials:Brick2: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Window Features:Double Hung: Yes
  • Lot Features:Wooded: Yes
  • Lot Features:Level: Yes
  • Exterior Features:Private Yard: Yes
  • Lot Features:Cleared: Yes
  • Window Features:Wood Frames: Yes
  • Lot Features:Waterfront: Yes
  • Exterior Features:Dock: Yes
  • Exterior Features:Fountain: Yes
  • Exterior Features:Hot Tub: Yes
  • Door Features:French Doors: Yes
  • Lot Features:Lake On Lot: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage
  • General Property Description:Garage Spaces: 5.5
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Other Structures:Garage(s): Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Main Level
  • Security: Security Lights, Security System, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: 220 Volts
  • Utilities: Cable Available
  • Heating:Natural Gas2: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: River Ridge 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: 45738.0
  • Zoning Description: Residential

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 $8,942 $918,700 $175,000 $743,700
2023 $7,655 $764,500 $125,000 $639,500
2022 $7,823 $764,500 $125,000 $639,500
2021 $7,990 $764,500 $125,000 $639,500
2020 $8,089 $764,500 $125,000 $639,500
2019 $7,344 $695,000 $125,000 $570,000
2018 $7,384 $695,000 $125,000 $570,000
2017 $7,174 $695,000 $125,000 $570,000
2015 $6,972 $695,000 $175,000 $520,000
2014 $6,863 $695,000 $175,000 $520,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/08/2025 07/08/25 For Sale $1,169,000 0.0% $289 / Sq Ft
06/26/2025 06/26/25 Off Market $1,169,000 -- --
12/03/2024 12/03/24 For Sale $1,169,000 0.0% $289 / Sq Ft
11/28/2024 11/28/24 Off Market $1,169,000 -- --
11/19/2024 11/19/24 Price Changed $1,169,000 -2.6% $289 / Sq Ft
08/12/2024 08/12/24 Price Changed $1,200,000 -3.9% $297 / Sq Ft
05/28/2024 05/28/24 For Sale $1,249,000 0.0% $309 / Sq Ft
04/30/2024 04/30/24 Off Market $1,249,000 -- --
02/07/2024 02/07/24 Price Changed $1,249,000 -3.9% $309 / Sq Ft
11/07/2023 11/07/23 For Sale $1,300,000 0.0% $322 / Sq Ft
10/31/2023 10/31/23 Off Market $1,300,000 -- --
07/19/2023 07/19/23 For Sale $1,300,000 -- $322 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Mortgage History

Date Status Loan Amount Loan Type
Closed $191,200 New Conventional
Closed $300,000 Credit Line Revolving
Closed $200,000 Unknown
Closed $50,000 Credit Line Revolving
Source: Public Records

Source: Northern Kentucky Multiple Listing Service

MLS Number: 615379

Northern Kentucky Multiple Listing Service

APN: 013-40-13-004.00