Seller's Agent in 2023
Susan Huff
Huff Realty - Florence
(859) 802-2338
53 in this area
482 Total Sales
875 Squire Oaks Dr Villa Hills, KY 41017
Estimated Value: $2,107,000 - $2,461,000
4
Beds
7
Baths
7,500
Sq Ft
$307/Sq Ft
Est. Value
Highlights
- Guest House
- In Ground Pool
- Lake View
- River Ridge Elementary School Rated A-
- Sauna
- 3.3 Acre Lot
About This Home
As of July 2023Escape 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!
Last Agent to Sell the Property
Huff Realty - Florence License #181847 Listed on: 04/26/2023
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $17,999
Lot Details
- 3.3 Acre Lot
- Flag Lot
Parking
- 7 Car Garage
- Heated Garage
- Side Facing Garage
- Driveway
Property Views
- Lake
- Pond
Home Design
- Transitional Architecture
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 7,500 Sq Ft Home
- 2-Story Property
- Elevator
- Wet Bar
- Home Theater Equipment
- Sound System
- Built-In Features
- High Ceiling
- 2 Fireplaces
- Marble Fireplace
- Gas Fireplace
- Insulated Windows
- Casement Windows
- Entryway
- Family Room
- Breakfast Room
- Formal Dining Room
- Library
- Bonus Room
- Game Room Downstairs
- Sauna
- Home Gym
Kitchen
- Eat-In Kitchen
- Microwave
- Dishwasher
- Wine Cooler
- Kitchen Island
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
- Double Vanity
Laundry
- Laundry Room
- Laundry on lower level
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Home Security
- Home Security System
- Fire and Smoke Detector
Pool
- In Ground Pool
- Spa
Outdoor Features
- Deck
- Enclosed Patio or Porch
- Water Fountains
- Exterior Lighting
- Separate Outdoor Workshop
- Pergola
- Outdoor Storage
- Outdoor Grill
Additional Homes
- Guest House
Schools
- River Ridge Elementary School
- Turkey Foot Middle School
- Dixie Heights High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- 220 Volts
- Cable TV Available
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 013-40-13-003.00
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
Average Home Value in this Area
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Closed | Griffin John M | $30,000,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 07/31/2023 07/31/23 | Sold | $2,250,000 | -10.0% | $300 / Sq Ft |
| 06/19/2023 06/19/23 | Pending | -- | -- | -- |
| 04/26/2023 04/26/23 | For Sale | $2,500,000 | -- | $333 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Tax History Compared to Growth
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 | $17,999 | $1,756,000 | $175,000 | $1,581,000 |
| 2023 | $18,757 | $1,759,600 | $175,000 | $1,584,600 |
| 2022 | $18,906 | $1,759,600 | $175,000 | $1,584,600 |
| 2021 | $12,281 | $1,116,500 | $175,000 | $941,500 |
| 2020 | $11,291 | $1,015,000 | $175,000 | $840,000 |
| 2019 | $11,327 | $1,015,000 | $175,000 | $840,000 |
| 2018 | $11,360 | $1,015,000 | $175,000 | $840,000 |
| 2017 | $11,036 | $1,015,000 | $175,000 | $840,000 |
| 2015 | $10,721 | $1,015,000 | $175,000 | $840,000 |
| 2014 | $10,538 | $1,015,000 | $175,000 | $840,000 |
Source: Public Records
Agents Affiliated with this Home
-
Susan Huff
-
Joey Zembrodt
Buyer's Agent in 2023
Joey Zembrodt
Huff Realty - Florence
(859) 250-4557
9 in this area
98 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 613016
APN: 013-40-13-003.00
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 879 Squire Oaks Dr
- 835 Rosewood Dr
- 883 Willowdale Dr
- 2064 Lakelyn Ct
- 944 Squire Oaks Dr
- 943 Squire Oaks Dr
- 2111 Clareglen Dr Unit 304
- 2418 Harris St
- 2139 Bromley Crescent Springs - 2 Rd
- 2429 Felice Dr
- 2421 Felice Dr
- 2120 Edenderry Dr
- 2160 Edenderry Dr
- 2454 Horton St
- 816 Winterberry Ct
- 1034 Colina Dr
- 2228 Dominion Dr
- 2520 Frank St
- 2139 Bromley-Crescent Springs Rd
- 2534 Buttermilk Pike
- 873 Squire Oaks Dr
- 849 Rosewood Dr
- 853 Rosewood Dr
- 1000 Squire Valley Dr
- 871 Squire Oaks Dr
- 857 Rosewood Dr
- 845 Rosewood Dr
- 861 Rosewood Dr
- 883 Squire Oaks Dr
- 865 Rosewood Dr
- 844 Rosewood Dr
- 874 Squire Oaks Dr
- 882 Squire Oaks Dr
- 856 Rosewood Dr
- 858 Rosewood Dr
- 841 Rosewood Dr
- 862 Rosewood Dr
- 10 Linden Hill Dr
- 886 Squire Oaks Dr
- 866 Rosewood Dr