5 days on Rocket
#634467, Kelly Barrett, Listing office: Huff Realty - Florence
$1,169,000 List price
879 Squire Oaks Dr Villa Hills, KY 41017
5 beds
3 full, 1 partial
4,041 sqft
1.1 acres
$289 / sqft
House
Property details
About 879 Squire Oaks Dr
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.
Highlights
Home typeSingle Family Residence
HeatingNatural Gas
StatusActive
CoolingCentral Air
Size4,041 sqft
BasementYes
Lot size1.05 Acres
Year built1983
ParkingAttached, Driveway, Garage
MLS #615379
Garage5 spaces
FireplaceStone, Gas
ViewLake
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 3
- Appliances: Other, Stainless Steel Appliance(s), Electric Cooktop, Gas Oven, Dishwasher, Disposal, Microwave, Refrigerator
- Basement: Yes
- Interior: Kitchen Island, Wet Bar, Walk-in Closet(s), Soaking Tub, Smart Home, Pantry, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Chandelier, Built-in Features, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Natural Woodwork, Recessed Lighting, Wired Audio
- Fireplace: Stone, Gas
- Total Bedroom Count: 5
- Garage Space: 5 spaces
- Parking: Attached, Driveway, Garage
- View: Lake
- Exterior: Private Yard, Dock, Fountain, Hot Tub
- Architectural Style: Traditional
- Heating: Natural Gas
- Cooling: Central Air
- List Price: $1,169,000
- Price/SqFt: $289
- Annual Tax Amount: $7,654
- Tax Year: 2023
- Lot: Cleared, Level, Waterfront, Wooded
- Directions: Buttermilk Pike to Rosewood to Squire Oaks Dr.
- Year Built: 1983
- Living Area: 4,041 SqFt
- Lot Size: 1.05 Acres
- MLS Number: 615379
- MLS Name: Northern Kentucky Multiple Listing Service
- Office Name: Coldwell Banker Realty FM
- Office Phone: (859) 341-9000
- Office Email: NorthernKYDeals@cbws.com
- Listing Agent: Trina Ellis
Disclaimer: The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. (NKMLS). Real estate listings held by other brokerage firms are marked with the Broker Reciprocity Logo and detailed information about them includes the name of the listing broker. The broker providing the data believes the data to be correct, but advises interested parties to confirm the data before relying on it in a purchase decision. MLS content and images © Copyright ©2025, Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
The information on this web site is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. We are not responsible or liable for misinformation, misprints, or typographical errors. All information provided is deemed reliable but is not guaranteed and should be independently verified through personal inspection by and/or with the appropriate professionals. Properties subject to prior sale, change, withdrawal or rental.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/24/2025, 12:50:31 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2023 | $764,500 | $7,654 |
| 2022 | $764,500 | $7,906 |
| 2021 | $764,500 | $8,151 |
| 2020 | $764,500 | $8,151 |
| 2019 | $695,000 | $7,384 |
| 2018 | $695,000 | $7,384 |
| 2017 | $695,000 | $7,174 |
History based on county public records data.
Nearby schools
7
River Ridge Elementary School
Public District PK-5
1.5 mi
•2772 Amsterdam Rd
7
Beechwood Elementary School
Public District PK-6
1.6 mi
•54 Beechwood Rd
4
Delshire Elementary School
Public District PK-5
2.1 mi
•4402 Glenhaven Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $67,919. Residents of Villa Hills, KY typically earn between $35k-100k each year. Residents typically live in single, no kids family. Residents of this area typically have post secondary degree education.
How much money do the neighbors make?
28%
<35k
33%
35k-100k
20%
100k-200k
19%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
44%
Single, No Kids
4%
Single, with Kids
34%
Married, No Kids
18%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
11%
<11 yrs old
9%
12-17 yrs old
16%
18-34 yrs old
45%
35-64 yrs old
19%
65+ yrs old
What do the neighbors do for fun?
Symphony or Opera
Hiking/backpacking
PGA/LPGA
Where do the neighbors shop?
Chico's
Nordstrom Rack
Stein Mart
Where do the neighbors go to eat?
Boston Market
Chipotle
Bonefish Grill
What do the neighbors drive?
Volvo
Mazda
Lincoln
What do the neighbors listen to?
Talk/Personality
Rock
Classical
All data provided by Home Junction and Claritas
Similar homes for sale
#633225, Lee Robinson, Listing office: Robinson Sotheby's International Realty
#634192, Nicole Riegler, Listing office: RE/MAX Victory + Affiliates
#633787, Laura Speed, Listing office: Huff Realty - Florence
Frequently asked questions
About 879 Squire Oaks Dr
The listing price of 879 Squire Oaks Dr property is $1,169,000.
The property 879 Squire Oaks Dr is a house located in Villa Hills, Kentucky, 41017.
Active Listing: 879 Squire Oaks Dr is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 879 Squire Oaks Dr are: River Ridge Elementary School (GreatSchools Rating 7/10), Beechwood Elementary School (GreatSchools Rating 7/10), Delshire Elementary School (GreatSchools Rating 4/10), Riverside Academy (GreatSchools Rating 4/10), Tichenor Middle School (GreatSchools Rating 3/10), Turkey Foot Middle School (GreatSchools Rating 5/10), Beechwood High School (GreatSchools Rating 9/10), Ludlow High School (GreatSchools Rating 7/10), Dixie Heights High School (GreatSchools Rating 6/10).
According to the records, the last property tax for 2023 is $7,654 (source: MLS/based on county public records data).
The property at 879 Squire Oaks Dr has 5 bedrooms and 3 full and 1 half bathrooms.
The property 879 Squire Oaks Dr is 4,041 SqFt (source: MLS/tax record).
The year of construction for 879 Squire Oaks Dr is 1983.
This home is located at 879 Squire Oaks Dr in Villa Hills, KY and zip code 41017. This 4,041 square foot home, which was built in 1983, sits on a 1.05 acre lot. Features: 5 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since July 19, 2023 and is currently priced at $1,169,000.
In June 2025 in Villa Hills, KY there were 36% more homes for sale than in May. While the average time on the market in June 2025 was 120 days, the median list price was $626,224.
From Rocket Homes Real Estate and based on county public records data.