Sold982d on market
875 Squire Oaks Dr
Villa Hills, KY, 41017 • 41017 • Kenton County
$2,250,000
$300/sqft
4Beds
7Baths
7,500Sqft
3.3 acLot
Property DNA
Waterfront Property
Direct water access
Scenic Views
Lake · Pond
Transitional Style
Transitional architecture
Enhanced Security
Security System · Smoke Detector(s)
Outdoor Living
Deck · Enclosed · Patio · Porch
2 Fireplaces
Gas · Marble
Special Features
Pergola · Guest House · Storage · Workshop
7-Car Garage
Attached · Detached · Driveway · Garage Faces Side · Heated Garage
This home is getting attention
Listed 982 days ago · 106 views · 2 saves
Market activity
Demand and pricing signals for this listing
106 views
People checking out this listing
2 saves
Buyers have saved this home
982 days on market
Established listing
$300/sqft
Price per square foot
Selling Soon Prediction
ModerateThis home ranks in the top 49% of listings most likely to go under contract soon, based on market activity and demand signals.
Likelihood score
Want the full market analysis?
Get the detailed selling prediction score, comparable sales data, and price trend forecast for this property.
Free · Delivered to your inbox in minutes
About this home
Single Family
Escape to your own private oasis in prestigious Country Squire Estates in Villa Hills. This stunning home offers luxurious outdoor living with a heated pool and hot tub, perfect for year round relaxation. Take advantage of the convenience and elegance of an elevator, first floor master suite. Work from home in the beautiful 2 story office, attached to the home. The finished Lower level boasts a movie theater, exercise room, bar area, lower level access to pool and hot tub area. This one-of-a-kind property is situated on 3.3 acres, with a carriage house that has two bedrooms, two full baths , vaulted ceilings, and exquisite workmanship, offering plenty of space for family and friends. The property also features a total of seven garages, perfect for car enthusiasts and collectors. Approximately 7500 SF in main home and additional 2300 in Carriage house. Enjoy the serenity of living amongst beautifully landscaped grounds creating an ambiance of privacy and tranquility. It's time to make this dream home your reality!
Standout features identified
Our analysis highlights bar area, heated pool, and hot tub as key attractions of this home.
Estimated monthly payment
Based on current rates
$14,675/month
Principal & Interest$11,675
Property Tax$2,250
Insurance$750
Down payment20% ($450,000)
3%50%
Est. 6.75% rate · 30yr fixed · $1,800,000 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence, Residential
HeatingForced Air
CoolingCentral Air
Parking7 Attached Garage spaces
Lot3.30 Acres
Property
Home typeSingle Family
Sub-typeSingle Family Residence, Residential
StyleTransitional
ConditionExisting Structure
Stories2
Systems
HeatingForced Air
CoolingCentral Air
RoofShingle
ConstructionStone
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingAttached, Detached, Driveway, Garage Faces Side, Heated Garage
Garage7 spaces
BasementFull
Fireplaces2
Lot3.30 Acres
Location & Tax
Neighborhood41017
Annual tax$18,757
Parcel013401300300
Bathrooms & Fees
Full baths5
Features & details
18 categories of property features
Interior Features
Interior
Kitchen Island
Walk-In Closet(s)
Sound System
Eat-in Kitchen
Double Vanity
Built-in Features
Elevator
High Ceilings
Sauna
Wet Bar
Appliances
Dishwasher
Disposal
Dryer
Microwave
Refrigerator
Washer
Heating
Forced Air
Cooling
Central Air
Laundry
Lower Level
Main Level
Upper Level
Fireplace
Gas
Marble
Windows
Casement
Exterior Features
Exterior
Fountain
Lighting
Outdoor Grill
Parking
Attached
Detached
Driveway
Garage Faces Side
Heated Garage
Construction
Stone
Patio & Porch
Deck
Enclosed
Patio
Porch
Lot Features
Flag Lot
Security
Security System
Smoke Detector(s)
Views
Lake
Pond
Pool Features
In Ground
Utilities
Cable Available
Natural Gas Available
Other Equipment
Home Theater
Other Structures
Pergola
Guest House
Storage
Workshop
Room details
20 rooms detailed
Primary Bedroom
First22×18 ft396 sqft
Bedroom2
Second17×13 ft221 sqft
Bedroom3
Second17×16 ft272 sqft
Bedroom4
Second23×14 ft322 sqft
Bathroom2
Second10×10 ft100 sqft
Bathroom3
Second11×11 ft121 sqft
Listing insights
Market data and value estimates
StatusSold
Days on market982
Est. value$2,033,400
Est. rent$4,618/mo
Tax rate0.97%
Price/sqft$300
On marketAug 28, 2025
PostedAug 28, 2025
Last sold$2,250,000
MLS updatedOct 1, 2024
Tour days6
Views106
Favorites2
How are the schools in Villa Hills?
3 schools rated nearby
Location
Villa Hills, KY, 41017
Price history
7 events
DateEventPrice$/sqftSource
Jul 31, 2023Sold$2,250,000$300NKMLS
Jun 19, 2023Pending Sale$2,500,000$333NKMLS
Apr 26, 2023Listed For Sale$2,500,000$333NKMLS
Nov 1, 2022Listing Removed——Huff Realty
Jun 22, 2022Price Change$2,500,000$333NKMLS
Jul 6, 2021Listed For Sale$2,950,000$393Huff Realty
Nov 4, 1983Sold$224,000$30Agent Provided
Sold$2,250,000
Jul 31, 2023•$300/sqft•NKMLS
Pending Sale$2,500,000
Jun 19, 2023•$333/sqft•NKMLS
Listed For Sale$2,500,000
Apr 26, 2023•$333/sqft•NKMLS
Listing Removed—
Nov 1, 2022•Huff Realty
Price Change$2,500,000
Jun 22, 2022•$333/sqft•NKMLS
Listed For Sale$2,950,000
Jul 6, 2021•$393/sqft•Huff Realty
Sold$224,000
Nov 4, 1983•$30/sqft•Agent Provided
Tax history
23 years of records
YearTax paidAssessed value
Apr 9, 2023$18,757$1,759,600
Apr 9, 2022$19,215$1,759,600
Apr 9, 2021$12,455$1,116,500
Apr 9, 2020$11,520$1,015,000
Apr 9, 2019$11,520$1,015,000
Apr 9, 2018$11,360$1,015,000
Apr 9, 2017$11,360$1,015,000
Apr 9, 2015$10,721$1,015,000
Apr 9, 2014$10,538$1,015,000
Apr 9, 2013$10,538$1,015,000
Apr 9, 2012—$1,015,000
Apr 9, 2011—$1,015,000
Apr 9, 2010—$1,015,000
Apr 9, 2009—$1,015,000
Apr 9, 2008—$1,015,000
Apr 9, 2007—$940,000
Apr 9, 2006—$940,000
Apr 9, 2005—$940,000
Apr 9, 2004—$595,000
Apr 9, 2003—$595,000
Apr 9, 2002—$495,000
Apr 9, 2001—$495,000
Apr 9, 2000—$495,000
Nearby homes
Neighborhood details
Local context around this listing
Villa Hills, KY • Kenton County
Nearby cities
CovingtonCrittendenEdgewoodElsmereErlangerFort MitchellFort WrightIndependence
Nearby zip codes
41017
Similar homes
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Zillow, Inc. are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Listing information is deemed reliable, but not guaranteed. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
No obligation · Same-day response