Sold1013d on market
874 Squire Oaks Dr
Villa Hills, KY, 41017 • 41017 • Kenton County
$725,000
4Beds
4Baths
0.73 acLot
Property DNA
Traditional Style
Traditional architecture
Outdoor Living
Deck
1 Fireplace
Brick
3-Car Garage
Attached · Driveway · Garage · Garage Door Opener · Garage Faces Side · Off Street
Premium Finishes
Walk-In Closet(s) · Crown Molding
Market activity
Demand and pricing signals for this listing
22 views
People checking out this listing
1013 days on market
Established listing
About this home
Single Family
Sold When Submitted. Experience luxury living in the prestigious Country Squire States community, located in the heart of Villa Hills. This stunning home boasts a large chef's kitchen, convenient first-floor laundry room, and a spacious family room with a cozy fireplace. Enjoy the breathtaking views of the wooded backyard from the walkout rear deck. Upstairs, you'll find four generously sized bedrooms, including a luxurious master suite complete with a spa-like master bath. The finished lower level is perfect for entertaining, and the three-car side-entry garage provides ample space for your vehicles. Conveniently located just minutes from downtown Cincinnati and the CVG airport, this home offers the perfect blend of suburban tranquility and easy access to city amenities. Don't miss your chance to make this stunning property your own!
Estimated monthly payment
Based on current rates
$4,502/month
Principal & Interest$3,536
Property Tax$725
Insurance$242
Down payment20% ($145,000)
3%50%
Est. 6.16% rate · 30yr fixed · $580,000 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence, Residential
HeatingForced Air
CoolingCentral Air
Parking3 Attached Garage spaces
Lot0.73 Acres
Property
Home typeSingle Family
Sub-typeSingle Family Residence, Residential
StyleTraditional
ConditionExisting Structure
Stories2
Systems
HeatingForced Air
CoolingCentral Air
RoofComposition,Shingle
ConstructionBrick, Vinyl Siding
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingAttached, Driveway, Garage, Garage Door Opener, Garage Faces Side, Off Street
Garage3 spaces
BasementFull
Fireplaces1
Lot0.73 Acres
Location & Tax
Neighborhood41017
Annual tax$5,597
Parcel013401301300
Bathrooms & Fees
Full baths3
Features & details
11 categories of property features
Interior Features
Interior
Kitchen Island
Wet Bar
Walk-In Closet(s)
Track Lighting
Storage
Pantry
Entrance Foyer
Eat-in Kitchen
Double Vanity
Crown Molding
Chandelier
Bookcases
Built-in Features
Beamed Ceilings
Ceiling Fan(s)
Natural Woodwork
Recessed Lighting
Appliances
Dishwasher
Heating
Forced Air
Cooling
Central Air
Laundry
Laundry Room
Main Level
Fireplace
Brick
Exterior Features
Parking
Attached
Driveway
Garage
Garage Door Opener
Garage Faces Side
Off Street
Construction
Brick
Vinyl Siding
Patio & Porch
Deck
Lot Features
Level
Utilities
Cable Available
Natural Gas Available
Room details
21 rooms detailed
Primary Bedroom
Second18×14 ft252 sqft
Carpet FlooringWalk-In Closet(s)Bath AdjoinsCeiling Fan(s)
Bedroom2
Second15×12 ft180 sqft
Carpet FlooringCeiling Fan(s)
Bedroom3
Second14×13 ft182 sqft
Carpet FlooringCeiling Fan(s)
Bedroom4
Second15×12 ft180 sqft
Carpet FlooringCeiling Fan(s)
Bathroom2
Second00
Full Finished BathTub With Shower
Bathroom3
First00
Full Finished Half BathTile Flooring
Listing insights
Market data and value estimates
StatusSold
Days on market1013
Est. value$844,700
Est. rent$3,627/mo
Tax rate0.97%
On marketJul 5, 2023
PostedJul 5, 2023
Last sold$725,000
MLS updatedOct 1, 2024
Tour days6
Views22
How are the schools in Villa Hills?
3 schools rated nearby
Location
Villa Hills, KY, 41017
Price history
4 events
DateEventPrice$/sqftSource
Jun 30, 2023Sold$725,000—NKMLS
Mar 30, 2017Sold$525,000—Public Record
Feb 17, 2017Pending Sale$549,900—Keller Williams - Keller Williams Advisor's Realty
Jan 20, 2017Listed For Sale$549,900—Keller Williams Advisors
Sold$725,000
Jun 30, 2023•NKMLS
Sold$525,000
Mar 30, 2017•Public Record
Pending Sale$549,900
Feb 17, 2017•Keller Williams - Keller Williams Advisor's Realty
Listed For Sale$549,900
Jan 20, 2017•Keller Williams Advisors
Tax history
23 years of records
YearTax paidAssessed value
Apr 9, 2023$5,597$525,000
Apr 9, 2022$5,733$525,000
Apr 9, 2021$5,856$525,000
Apr 9, 2020$5,995$525,000
Apr 9, 2019$5,995$525,000
Apr 9, 2018$5,912$525,000
Apr 9, 2017$5,912$570,000
Apr 9, 2015$5,659$570,000
Apr 9, 2014$5,573$570,000
Apr 9, 2013$5,573$570,000
Apr 9, 2012—$570,000
Apr 9, 2011—$570,000
Apr 9, 2010—$570,000
Apr 9, 2009—$570,000
Apr 9, 2008—$570,000
Apr 9, 2007—$405,000
Apr 9, 2006—$405,000
Apr 9, 2005—$405,000
Apr 9, 2004—$405,000
Apr 9, 2003—$405,000
Apr 9, 2002—$405,000
Apr 9, 2001—$405,000
Apr 9, 2000—$405,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