Listing provided courtesy of eXp Realty LLC- MLS# 642348
Images
Request Info- 006
- 011
- 015
- 018
- 020
- 023
- 025
- 028
- 031
- 033
- 035
- 038
- 039
- 041
- 044
- 048
- 049
- 052
- 054
- 055
- 057
- 059
- 060
- 062
- 064
- 066
- 069
- 070
- 072
- 076
- 079
- 083
- 086
- 090
- 096
- 099
- 103
- 106
- 114
- 116
- 120
- 121
- 123
- 125
- 134
- 003
- 004
- 005
878 Squire Oaks DriveVilla Hills, KY 41017
Single Family · 4 Beds · 3 Full Baths · 1 Half Bath · 4,800 Sq. ft. | 0.96 Acres$1,100,000
Pending
878 Squire Oaks Drive Overview
- Time on Site:
- 0 days
- Visits:
- 55
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.
Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
View Map
878 Squire Oaks Drive Facts & Features
- Type Single Family
- Sq. ft. 4,800
- Price/Sq.ft. $229
- Lot 0.96 Acres
Details
General
Association/HOA
- Association: No
School Information
- Elementary School: River Ridge Elementary
- Middle Or Junior School: Turkey Foot Middle School
- High School: Dixie Heights High
Building Information
- New Construction: No
- Sewer: Public Sewer: true
- Year Built: 1986
Location/Region
- County Or Parish: Kenton
- MLS Area Major: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
- MLS Area Minor: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
Parking Information
- Parking Features: Attached: true
- Parking Features: Garage Faces Side: true
General Information
- Parcel Number: 013-40-13-012.00
- Property Condition: Existing Structure
- Property Sub Type: Single Family Residence
- Property Type: Residential
Interior
Building Information
- Cooling: Central Air: true
- Heating: Forced Air: true
Parking Information
- Garage Spaces: 2.0
- Garage: Yes
Beds/Baths
- Bathrooms Full: 3
- Bathrooms Half: 1
- Bathrooms Total: 4
- Bedrooms Total: 4
Building Interior
- FloorPlansChangeTimestamp: 2026-05-07T18:34:04Z
- Interior Features: Beamed Ceilings: true
- Interior Features: Granite Counters: true
- Interior Features: High Ceilings: true
- Interior Features: Open Floorplan: true
- Interior Features: Recessed Lighting: true
- Laundry Features: Electric Dryer Hookup: true
- Laundry Features: Main Level: true
- Laundry Features: Washer Hookup: true
General Information
- Appliances: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Double Oven, Dryer, Microwave, Refrigerator, Washer
- Fireplace Features: Gas
- Fireplace: Yes
- Fireplaces Total: 2
- Foundation Details: Poured Concrete
- Interior 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, Multi Panel Doors, Recess Ceiling(s), Recessed Lighting
- Laundry Features: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup
- Living Area: 4800.0
- Rooms Total: 11
Exterior
Parking Information
- Parking Features: Attached, Garage, Garage Faces Side, Off Street
Lot Information
- Lot Features: Sloped Down
- Lot Size Acres: 0.96
- Lot Size Area: 0.96
- Lot Size Dimensions: irregular
- Lot Size Square Feet: 41818.0
- Lot Size Units: Acres
- Water Source: Public
Waterfront/View
- View: Pond
- View: Pond2: true
Building Exterior/Construction
- Attached Garage: Yes
- Construction Materials: Brick, Wood Siding
- Exterior Features: Lighting: true
- Patio And Porch Features: Covered, Deck
- Property Attached: No
- Roof: Shingle
General Information
- Exterior Features: Fire Pit, Balcony, Lighting
- Fencing: Aluminum, Perimeter
- Sewer: Public Sewer
- Utilities: Natural Gas Available
878 Squire Oaks Drive Neighborhood
Community
41017 (EDGEWOOD) Demographics
39
Median Age
1,847
Population Density (per sq. mile)
52%
College Educated
$84,360
Estimated Median Income
11,844
Estimated Total Home Owners
3,689
Estimated Total Renters
76% / 24%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Schools
School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.878 Squire Oaks Drive Monthly Cost
878 Squire Oaks Drive Market Data
Based on the last 30 days in this zip code
$571,440
Average List Price
$346
Average Price per Square Foot
37
Properties Sold
62
Average Days on Market
177
Properties for Sale
878 Squire Oaks Drive History
| Date | Value | Agent |
|---|---|---|
| 6/24/2026Source: Northern Kentucky MLS | Pending |
|
| 6/18/2026Source: Northern Kentucky MLS | $1,100,000 -7.6% |
|
| 5/29/2026Source: Northern Kentucky MLS | $1,190,000 -4.8% |
|
| 5/7/2026Source: Northern Kentucky MLS | May 07, 2026 |