WOW is the only word that comes to mind.
This stunning custom-built Toebben home is gracefully nestled on nearly one acre in the prestigious Country Squire community, offering a rare blend of privacy, sophistication, and breathtaking lake views.
Designed with a contemporary aesthetic, this 4-bedroom, 4-bath residence features an open-concept layout ideal for both everyday living and elegant entertaining. The beautifully updated kitchen flows seamlessly into the spacious family room highlighted by a striking stone fireplace -- the perfect centerpiece for gathering.
Step outside and experience resort-style living at its finest. The covered porch and expansive sun deck overlook a picturesque lake complete with a lighted fountain. Entertain year-round with the outdoor fireplace, or unwind on your private dock -- perfect for fishing or simply enjoying the peaceful setting.
All of this just minutes from downtown Cincinnati, premier shopping, and top dining destinations.
Opportunities like this don't come often. Don't let this one slip away.
Sold for $1,100,000
$1,100,000
878 Squire Oaks Dr, Villa Hills, KY 41017
4beds
4,800sqft
Single Family Residence, Residential
Built in 1986
0.96 Acres Lot
$1,100,400 Zestimate®
$229/sqft
$5,619 Estimated rent
Home value
$1,100,400
$1.05M - $1.16M
$5,619/mo
Zestimate® history
Owner options
List your home for rent
$5,619/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,619/mo
Rent Zestimate®
Refinance and save
$5,540/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,540/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Michele Mamo 859-512-7772,
eXp Realty LLC
Bought with:
Bridget Erna, 222718
Lohmiller Real Estate
Source: NKMLS,MLS#: 642348
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Fireplace(s), Bath Adjoins, Hardwood Floors, Recessed Lighting, Skylight(s)
- Level: First
- Area: 360
- Dimensions: 24 x 15
Bedroom 2
- Features: Ceiling Fan(s), Hardwood Floors
- Level: Second
- Area: 187
- Dimensions: 11 x 17
Bedroom 3
- Features: Ceiling Fan(s), Hardwood Floors
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom 4
- Features: Carpet Flooring
- Level: Lower
- Area: 192
- Dimensions: 16 x 12
Breakfast room
- Features: Hardwood Floors
- Level: First
- Area: 154
- Dimensions: 14 x 11
Dining room
- Features: Chandelier, Hardwood Floors, Recessed Lighting
- Level: First
- Area: 224
- Dimensions: 16 x 14
Entry
- Features: Entrance Foyer, Hardwood Floors
- Level: First
- Area: 165
- Dimensions: 15 x 11
Family room
- Features: Bookcases, Carpet Flooring, Recessed Lighting, Wet Bar
- Level: First
- Area: 144
- Dimensions: 12 x 12
Kitchen
- Features: Breakfast Bar, Hardwood Floors, Wood Cabinets, Kitchen Island, Recessed Lighting
- Level: First
- Area: 238
- Dimensions: 17 x 14
Laundry
- Features: Built-in Features, Tile Flooring, Walk-Out Access
- Level: First
- Area: 56
- Dimensions: 8 x 7
Living room
- Features: Hardwood Floors, Skylight(s), Fireplace(s), Built-in Features, Bookcases, Ceiling Fan(s)
- Level: First
- Area: 352
- Dimensions: 22 x 16
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Double Oven, Dryer, Microwave, Refrigerator, Washer
- Laundry: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup
Features
- Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Chandelier, Bookcases, Breakfast Bar, Beamed Ceilings, Butler's Pantry, High Ceilings, Recess Ceiling(s), Recessed Lighting
- Doors: Multi Panel Doors
- Windows: Vinyl Frames
- Basement: Full
- Number of fireplaces: 2
- Fireplace features: Gas
Interior area
- Total structure area: 4,800
- Total interior livable area: 4,800 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage, Garage Faces Side, Off Street
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Deck
- Exterior features: Fire Pit, Balcony, Lighting
- Fencing: Aluminum,Perimeter
- Has view: Yes
- View description: Pond
- Has water view: Yes
- Water view: Pond
Lot
- Size: 0.96 Acres
- Features: Sloped Down
- Residential vegetation: Partially Wooded
Details
- Parcel number: 0134013012.00
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence, Residential
Materials
- Brick, Wood Siding
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- Existing Structure
- New construction: No
- Year built: 1986
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available
Community & HOA
HOA
- Has HOA: No
Location
- Region: Villa Hills
Financial & listing details
- Price per square foot: $229/sqft
- Tax assessed value: $814,000
- Annual tax amount: $8,067
- Date on market: 6/10/2026
- Cumulative days on market: 49 days
Price history
| Date | Event | Price |
|---|---|---|
| 7/27/2026 | Sold | $1,100,000$229/sqft |
Source:  NKMLS #642348 Report a problem | ||
| 6/24/2026 | Pending sale | $1,100,000$229/sqft |
Source: NKMLS #642348 Report a problem | ||
| 6/18/2026 | Price change | $1,100,000-7.6%$229/sqft |
Source: eXp Realty #642348 Report a problem | ||
| 5/29/2026 | Price change | $1,190,000-4.8%$248/sqft |
Source: eXp Realty #642348 Report a problem | ||
| 5/7/2026 | Listed for sale | $1,250,000+68.9%$260/sqft |
Source: NKMLS #642348 Report a problem | ||
| 7/25/2016 | Sold | $740,000-3.9%$154/sqft |
Source: Public Record Report a problem | ||
| 6/25/2016 | Pending sale | $769,900$160/sqft |
Source: Keller Williams - Keller Williams Advisor's Realty #456168 Report a problem | ||
| 6/7/2016 | Listed for sale | $769,900+26.2%$160/sqft |
Source: Keller Williams - Keller Williams Advisor's Realty #456168 Report a problem | ||
| 11/21/2012 | Sold | $610,000-6.2%$127/sqft |
Source: Public Record Report a problem | ||
| 6/27/2012 | Listed for sale | $650,000$135/sqft |
Source: RE/MAX Affiliates #409705 Report a problem | ||
| 3/19/2012 | Listing removed | $650,000$135/sqft |
Source: HUFF Realty, LLC #395058 Report a problem | ||
| 3/25/2011 | Price change | $650,000-7.1%$135/sqft |
Source: Huff Realty - Florence #395058 Report a problem | ||
| 1/23/2010 | Listed for sale | $699,900$146/sqft |
Source: RE/MAX Affiliates #380627 Report a problem | ||
| 11/3/2009 | Listing removed | $699,900$146/sqft |
Source: HUFF Realty, LLC #361561 Report a problem | ||
| 7/22/2009 | Listed for sale | $699,900$146/sqft |
Source: HUFF Realty, LLC #361561 Report a problem | ||
| 6/11/2009 | Listing removed | $699,900$146/sqft |
Source: Luxury Real Estate #932297 Report a problem | ||
| 5/22/2009 | Listed for sale | $699,900-6.7%$146/sqft |
Source: Luxury Real Estate #932297 Report a problem | ||
| 2/14/2009 | Listing removed | $750,000$156/sqft |
Source: NCI #361561 Report a problem | ||
| 10/13/2008 | Price change | $750,000-2%$156/sqft |
Source: NCI #361561 Report a problem | ||
| 8/28/2008 | Price change | $765,000-1.3%$159/sqft |
Source: NCI #361561 Report a problem | ||
| 7/20/2008 | Price change | $775,000-3.1%$161/sqft |
Source: NCI #361561 Report a problem | ||
| 2/1/2008 | Listed for sale | $799,900$167/sqft |
Source: NCI #353619 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $8,067 -3.3% | $814,000 |
| 2024 | $8,344 -3.8% | $814,000 |
| 2023 | $8,677 -2.4% | $814,000 |
| 2022 | $8,889 -2.1% | $814,000 |
| 2021 | $9,080 +7.9% | $814,000 +10% |
| 2020 | $8,419 | $740,000 |
| 2019 | $8,419 +1.4% | $740,000 |
| 2018 | $8,302 | $740,000 |
| 2017 | $8,302 +28.4% | $740,000 +21.3% |
| 2015 | $6,467 | $610,000 |
| 2014 | $6,467 +1.7% | $610,000 |
| 2013 | $6,357 | $610,000 +11.9% |
| 2012 | -- | $545,000 |
| 2011 | -- | $545,000 |
| 2010 | -- | $545,000 |
| 2009 | -- | $545,000 |
| 2008 | -- | $545,000 +17.2% |
| 2007 | -- | $465,000 |
| 2006 | -- | $465,000 |
| 2005 | -- | $465,000 |
| 2004 | -- | $465,000 +1.1% |
| 2003 | -- | $460,000 |
| 2002 | -- | $460,000 |
| 2001 | -- | $460,000 |
| 2000 | -- | $460,000 |
Find assessor info on the county website
Neighborhood: 41017
Nearby homes
- $878,8005 bd4 ba2.8k sqft882 Squire Oaks Dr, Villa Hills, KY 41017Off Market
- $1,435,0005 bd5 ba4.5k sqft881 Squire Lake Ct, Villa Hills, KY 41017Sold
- $958,4005 bd3 ba2.9k sqft870 Squire Oaks Dr, Villa Hills, KY 41017Off Market
- $873,9004 bd3 ba3.1k sqft874 Squire Oaks Dr, Villa Hills, KY 41017Off Market
- $1,189,0006 bd6 ba5k sqft886 Squire Oaks Dr, Villa Hills, KY 41017For Sale
- $715,3004 bd3 ba3.4k sqft877 Squire Lake Ct, Villa Hills, KY 41017Off Market
- $877,6004 bd2 ba2.9k sqft885 Squire Lake Ct, Villa Hills, KY 41017Off Market
- $833,8004 bd4 ba6k sqft869 Rosewood Dr, Villa Hills, KY 41017Off Market
Nearby schools
GreatSchools rating
- 5/10River Ridge Elementary SchoolGrades: PK-5Distance: 1.5 mi
- 6/10Turkey Foot Middle SchoolGrades: 6-8Distance: 3.4 mi
- 9/10Dixie Heights High SchoolGrades: 9-12Distance: 2.7 mi
Schools provided by the listing agent
- Elementary: River Ridge Elementary
- Middle: Turkey Foot Middle School
- High: Dixie Heights High
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,100,400
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,100,400
- Kentucky
- Kenton County
- Villa Hills
- 41017
- 878 Squire Oaks Dr
Nearby cities
Nearby zip codes
Other Villa Hills Topics
