878 Squire Oaks Drive, Villa Hills, KY 41017 - Photo 1

1/1

$1,100,000

Sold
Closed
Single Family
4 Beds
3 Full Baths
1 Partial Bath
4,800 Sq. Ft.
0.96 Acres
2 Car Garage

1/1

Property Description

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.

Full Property Details

Full Property Details for 878 Squire Oaks Dr

General

Sold For: $1,100,000
Status: Closed
Type: Single Family
Source: Northern_Kentucky
MLS ID: 642348
Added to Site: 100 day(s) ago

Interior

Number of Rooms: 11
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
Fireplace: Yes
Number of Fireplaces: 2
Fireplace(s): Gas
Appliances: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Double Oven, Dryer, Microwave, Refrigerator, Washer

Rooms

Bathrooms

Total Bathrooms: 4
Full Bathrooms: 3
Half Bathrooms: 1

Bedrooms

Total Bedrooms: 4

Other Rooms

Laundry: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup

Exterior

Exterior Features: Fire Pit, Balcony, Lighting
Porch/Patio/Deck: Covered, Deck

Parking

Garage: Yes
Attached garage: Yes
Garage Spaces: 2
Total Spaces: 2
Parking Features: Attached, Garage, Garage Faces Side, Off Street

Location

County: Kenton
Driving Directions: Turn off Buttermilk Pike on to Rosewood Dr. Then turn left on to Squire Oaks Dr and the property is on the right hand side.

School Information

Elementary School: River Ridge Elementary
Middle School: Turkey Foot Middle School
High School: Dixie Heights High

Community

Community Name: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi

Heating & Cooling

Central air: Yes
Air Conditioning: Yes
Cooling Type: Central Air Conditioning
Heating Type: Natural Gas, Forced Air

Utilities

Sewer: Public Sewer
Water: Public
Utility Description: Natural Gas Available

Structural Information

Architectural Style: Contemporary
Construction: Brick, Wood Siding
Basement Desc.: Full Finished Bath, Full, Finished, Walk-Out Access
Roof: Shingle
Windows: Insulated Windows, Vinyl Frames
Square Feet: 4,800
Living Area: 4,800 Sq. Ft.
Year Built: 1986
Property Condition: Existing Structure

Lot Features

Property View: Pond
Lot Size (Acres): 0.96
Lot Size (Sq. Ft.): 41,818
Lot Size: .96
Lot Dimensions: irregular
Lot Features: Sloped Down
Trees/Vegetation: Partially Wooded
Zoning: Residential
Fencing (Description): Aluminum, Perimeter

Disclosures and Reports

Property ID: 013-40-13-012.00

Listed by eXp Realty LLC, Michele Mamo
Sold by Lohmiller Real Estate, Bridget Erna

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code *

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Comment *

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Submit, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

Listing agent

— 878 Squire Oaks Dr —

Michele Mamo

eXp Realty LLC

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 878 Squire Oaks Dr

School District:Kenton County School District

Name	Grades	Distance
River Ridge Elementary School 2772 Amsterdam Road, Villa Hills, KY 41017	PK-5	1.5 mi
Turkey Foot Middle School 3230 Turkeyfoot Road, Edgewood, KY 41017	6-8	3.4 mi
Dixie Heights High School 3010 Dixie Highway, Fort Mitchell, KY 41017	9-12	2.7 mi

Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 878 Squire Oaks Dr

Date

Details

Price

Change

Source

7/27/2026

Sold

$1,100,000

—

MLS

6/18/2026

Price Reduced

$1,100,000

-7.56%

MLS

5/30/2026

Price Reduced

$1,190,000

-4.8%

MLS

5/07/2026

Listed

$1,250,000

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

588 Foxhill Dr, Crescent Springs, KY 41017 - Photo 1

Just Listed

$253,000

588 Foxhill Dr Crescent Springs, KY 41017

Condo
Active
Updated 1 day ago

2
Beds
2
Total Baths
1,111
Sq. Ft.

Listed by Oyler Hines (513) 623-1351

2506 Crosshill Dr, Crescent Springs, KY 41017 - Photo 1

Just Listed

$199,800

2506 Crosshill Dr Crescent Springs, KY 41017

Condo
Active
Updated 5 days ago

2
Beds
2
Total Baths
1,111
Sq. Ft.

2072 Periwinkle Ct, Crescent Springs, KY 41017 - Photo 1

Just Listed

$460,000

2072 Periwinkle Ct Crescent Springs, KY 41017

Single Family
Active
Updated 5 days ago

4
Beds
3
Total Baths

550 Park St, Crescent Springs, KY 41017 - Photo 1

Just Listed

$235,000

550 Park St Crescent Springs, KY 41017

Single Family
Active
Updated 2 days ago

2
Beds
2
Total Baths
1,554
Sq. Ft.

2820 University Cir, Crescent Springs, KY 41017 - Photo 1

Price Reduced

-$15,000 (-3.26%)

$445,000

2820 University Cir Crescent Springs, KY 41017

Single Family
Active
Updated 3 days ago

4
Beds
4
Total Baths
4,694
Sq. Ft.

690 Daphne Wy, Crescent Springs, KY 41017 - Photo 1

Price Reduced

-$5,000 (-2.38%)

$205,000

690 Daphne Wy Crescent Springs, KY 41017

Condo
Active
Updated 5 days ago

2
Beds
2
Total Baths

5 Pleasant Ridge Ave, Fort Mitchell, KY 41017 - Photo 1

Price Reduced

-$10,000 (-1.82%)

$540,000

5 Pleasant Ridge Ave Fort Mitchell, KY 41017

Multi-Family
Active
Updated 4 days ago

4
Total Beds

2309 Dixie Hwy, Fort Mitchell, KY 41017 - Photo 1

Price Reduced

-$10,000 (-3.24%)

$299,000

2309 Dixie Hwy Fort Mitchell, KY 41017

Single Family
Active
Updated 4 days ago

2
Beds
1
Total Bath
1,260
Sq. Ft.

913 Rosewood Dr, Villa Hills, KY 41017 - Photo 1

Sold

$1,150,000

913 Rosewood Dr Villa Hills, KY 41017

Single Family
Closed

4
Beds
4
Total Baths
3,810
Sq. Ft.

932 Rosewood Dr, Villa Hills, KY 41017 - Photo 1

Sold

$1,100,000

932 Rosewood Dr Villa Hills, KY 41017

Single Family
Closed
Updated 4 days ago

5
Beds
5
Total Baths
3,805
Sq. Ft.

213 Prather Ct, Fort Mitchell, KY 41017 - Photo 1

Sold

$1,235,000

213 Prather Ct Fort Mitchell, KY 41017

Single Family
Closed

4
Beds
5
Total Baths

3 Harvard Dr, Fort Mitchell, KY 41017 - Photo 1

Sold

$1,237,500

3 Harvard Dr Fort Mitchell, KY 41017

Single Family
Closed
Updated 2 days ago

5
Beds
5
Total Baths
2,616
Sq. Ft.

878 Squire Oaks Drive, Villa Hills, KY 41017 (MLS# 642348) is a Single Family property that was sold at $1,100,000 on July 27, 2026. Want to learn more about 878 Squire Oaks Drive? Do you have questions about finding other Single Family real estate for sale in Villa Hills? You can browse all Villa Hills real estate or contact a Coldwell Banker agent to request more information.

878 Squire Oaks Dr Villa Hills, KY 41017