Seller's Agent in 2024
Susan Huff
Huff Realty - Florence
(859) 802-2338
56 in this area
486 Total Sales
903 Squire Oaks Dr Villa Hills, KY 41017
Estimated Value: $1,571,000 - $1,706,000
5
Beds
6
Baths
7,825
Sq Ft
$212/Sq Ft
Est. Value
Highlights
- In Ground Pool
- View of Trees or Woods
- Deck
- River Ridge Elementary School Rated A-
- 3.67 Acre Lot
- Contemporary Architecture
About This Home
As of April 2024One-of-a-kind contemporary home nestled in the serene woods, offering complete privacy on almost 3.67 acres. This stunning property boasts a host of luxurious features, including a nicely finished, heated 4 car garage, an inviting in-ground pool, and a relaxing hot tub. Additional free standing hot tub outside of exercise room.For all the dog lovers out here, there's even a separately fenced area for your furry friends to run freely in their very own kennel. Step onto your private par 3 golf hole and perfect your swing amidst the tranquil surroundings. With five bedrooms, four full and two half baths, this home offers ample space for family and guests. Inside, the finished lower level is a true gem, featuring a kitchenette area, an exercise room, 5th Bedroom and an additional great/media room. With a total of 7825 SF of living space you will have plenty of room to relax, entertain and create lasting memories. Located in prestigious Country Squire Estates, this remarkable home is just minutes to downtown Cincinnati and CVG airport. Experience the best of both worlds- tranquility and privacy with convenience of city amenities.
Last Agent to Sell the Property
Huff Realty - Florence License #181847 Listed on: 10/24/2023
Home Details
Home Type
- Single Family
Year Built
- Built in 1989
Lot Details
- 3.67 Acre Lot
- Wooded Lot
- Private Yard
Parking
- 4 Car Garage
- Side Facing Garage
- Garage Door Opener
- Driveway
Home Design
- Contemporary Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Wood Siding
Interior Spaces
- 7,825 Sq Ft Home
- 2-Story Property
- Wet Bar
- Central Vacuum
- Vaulted Ceiling
- Recessed Lighting
- Gas Fireplace
- Insulated Windows
- Entryway
- Family Room
- Living Room
- Breakfast Room
- Formal Dining Room
- Home Office
- Game Room Downstairs
- Home Gym
- Carpet
- Views of Woods
Kitchen
- Eat-In Kitchen
- Electric Cooktop
- Microwave
- Dishwasher
- Granite Countertops
- Disposal
Bedrooms and Bathrooms
- 5 Bedrooms
- Walk-In Closet
- Double Vanity
Laundry
- Laundry Room
- Laundry on main level
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Kitchen in Basement
- Finished Basement Bathroom
- Stubbed For A Bathroom
- Basement Storage
Home Security
- Home Security System
- Fire and Smoke Detector
Pool
- In Ground Pool
- Spa
Outdoor Features
- Deck
- Patio
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
- Cable TV Available
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 013-40-13-007.00
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Oct 24, 2023
Closed on
Apr 1, 2024
Sold by
Hemmer Mary A and Hemmer Paul W
Bought by
Crowe Michael D and Crowe Teresa L
Seller's Agent
Susan Huff
Huff Realty - Florence
Buyer's Agent
Lori Taylor
Coldwell Banker Realty FM
List Price
$1,700,000
Sold Price
$1,500,000
Premium/Discount to List
-$200,000
-11.76%
Views
171
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$156,919
Avg. Annual Appreciation
5.15%
Purchase Details
Closed on
Jan 29, 2011
Sold by
Pomeroy David B and Pomeroy Catherine
Bought by
Hemmer Mary A
Purchase Details
Closed on
Dec 18, 1997
Sold by
Toebben Ltd
Bought by
Pomeroy David B and Pomeroy Catherine
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
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Crowe Michael D | $1,500,000 | None Listed On Document | |
| Hemmer Mary A | -- | None Available | |
| Pomeroy David B | $35,000 | -- |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 04/01/2024 04/01/24 | Sold | $1,500,000 | -11.8% | $192 / Sq Ft |
| 01/16/2024 01/16/24 | Pending | -- | -- | -- |
| 10/24/2023 10/24/23 | For Sale | $1,700,000 | -- | $217 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
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 |
|---|---|---|---|---|
| 2025 | $14,865 | $1,500,000 | $175,000 | $1,325,000 |
| 2024 | $10,941 | $1,067,400 | $175,000 | $892,400 |
| 2023 | $9,798 | $931,200 | $225,000 | $706,200 |
| 2022 | $10,040 | $931,200 | $225,000 | $706,200 |
| 2021 | $10,255 | $931,200 | $225,000 | $706,200 |
| 2020 | $10,365 | $931,200 | $225,000 | $706,200 |
| 2019 | $10,052 | $900,000 | $225,000 | $675,000 |
| 2018 | $10,081 | $900,000 | $225,000 | $675,000 |
| 2017 | $9,794 | $900,000 | $225,000 | $675,000 |
| 2015 | $9,513 | $900,000 | $225,000 | $675,000 |
| 2014 | $9,351 | $900,000 | $225,000 | $675,000 |
Source: Public Records
Agents Affiliated with this Home
-
Susan Huff
-
Lori Taylor
Buyer's Agent in 2024
Lori Taylor
Coldwell Banker Realty FM
(859) 486-8239
10 in this area
117 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 618029
APN: 013-40-13-007.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 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 886 Squire Oaks Dr
- 12 Linden Hill Dr
- 2479 High Crossing Dr
- 944 Squire Oaks Dr
- 968 Woodchuck Dr
- 2319 Amsterdam Rd
- 2280 Edenderry Dr Unit 304
- 2280 Edenderry Dr Unit 305
- 632 Hidden Pine Way
- 2084 Lakelyn Ct
- 2097 Clareglen Dr Unit 102
- 723 Western Reserve Rd
- 2533 Frank St
- 752 Meadow View Dr
- 2121 Highwater Rd
- 725 Ferncliff Ave
- 648 Foxhill Dr Unit 9-203
- 2160 Edenderry Dr
- 2120 Edenderry Dr
- 637 Euclid Ave
- 895 Squire Oaks Dr
- 2458 Kremers Ln
- 2457 Kremers Ln
- 894 Squire Oaks Dr
- 900 Squire Oaks Dr
- 2459 Kremers Ln
- 890 Squire Oaks Dr
- 2433 Cecelia Dr
- 2460 Kremers Ln
- 2460 Kremer Ln
- 817 Squire Hill Dr
- 841 Rosewood Dr
- 883 Squire Oaks Dr
- 904 Squire Oaks Dr
- 2461 Kremer La
- 2461 Kremers Ln
- 2461 Kremer Ln
- 2435 Cecelia Dr
- 2462 Kremers Ln
- 889 Squire Lake Ct
Your Personal Tour Guide
Ask me questions while you tour the home.