Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$1,250,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 2,882 Sq. Ft.
  • 0.96 Acres
  • 2 Car Garage
  • Updated 19 hours ago
See This Home
Save This Home
See This Home
Save This Home
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 for 878 Squire Oaks Dr

General

  • Price: $1,250,000
  • Status: Active
  • Type: Single Family
  • Source: Northern_Kentucky
  • MLS ID: 642348
  • Updated: 5/7/2026
  • Added to Site: Today

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, Built-in Features
  • 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: 2,882
  • Living Area: 2,882 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

Quickly Find Out More

* Indicates a required field

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 Send Message, 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.

We Value Your Privacy

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

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 878 Squire Oaks Dr

School District:Kenton County School District
NameGradesDistance
River Ridge Elementary School
2772 Amsterdam Road, Villa Hills, KY 41017
PK-51.5 mi
Turkey Foot Middle School
3230 Turkeyfoot Road, Edgewood, KY 41017
6-83.4 mi
Dixie Heights High School
3010 Dixie Highway, Fort Mitchell, KY 41017
9-122.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 Get Price Alerts and Save Property

Date
Details
Price
Change
Source
5/07/2026
Listed
$1,250,000
68.92%
MLS
7/19/2016
Sold
$740,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 878 Squire Oaks Dr

Year
Property Taxes
Change
Tax Assessment
Change
2025
$8,067
-3%
$814,000
—
2024
$8,344
-4%
$814,000
—
2023
$8,677
-2%
$814,000
—
2022
$8,889
-3%
$814,000
—
2021
$9,155
—
$814,000
10%
2021
$9,155
10%
$740,000
—
2018
$8,302
—
$740,000
—
2019
$8,279
3%
$740,000
—
2017
$8,066
23%
$740,000
21%
2016
$6,541
1%
$610,000
—
2015
$6,467
2%
$610,000
—
2014
$6,357
1%
$610,000
—
2013
$6,272
—
$610,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 878 Squire Oaks Dr

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by eXp Realty LLC, Michele Mamo

Similar Properties near 878 Squire Oaks Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

542 Karlenia Ct, Edgewood, KY 41017 - Photo 1
$1,200,000

542 Karlenia Ct  Edgewood, KY 41017

  • Single Family
  • Active
  • 4
    Beds
  • 5
    Total Baths
  • 4,893
    Sq. Ft.
41 Floral Ave, Fort Mitchell, KY 41017 - Photo 1
$1,156,480

41 Floral Ave  Fort Mitchell, KY 41017

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
3049 Heritage Ln, Edgewood, KY 41017 - Photo 1
$1,200,000

3049 Heritage Ln  Edgewood, KY 41017

  • Single Family
  • Active
  • 3
    Beds
  • 5
    Total Baths
  • 4,576
    Sq. Ft.
968 Woodchuck Dr, Villa Hills, KY 41017 - Photo 1
$1,050,000

968 Woodchuck Dr  Villa Hills, KY 41017

  • Single Family
  • Active
  • Updated 7 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 3,083
    Sq. Ft.

Just Listed near 878 Squire Oaks Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

818 Carrieview Dr, Crescent Springs, KY 41017 - Photo 1 Just Listed
$950,000
Open House

818 Carrieview Dr  Crescent Springs, KY 41017

  • Single Family
  • Active
  • Updated 6 days ago
  • 5
    Beds
  • 4
    Total Baths
1785 Amsterdam Rd, Fort Mitchell, KY 41017 - Photo 1 Just Listed
$150,000

1785 Amsterdam Rd  Fort Mitchell, KY 41017

  • Lots/Land
  • Active
  • Updated 6 days ago
  • 4.45
    Acres
906 Treeline Dr, Fort Mitchell, KY 41017 - Photo 1 Just Listed
$15,000

906 Treeline Dr  Fort Mitchell, KY 41017

  • Lots/Land
  • Active
  • Updated 5 days ago
  • 0.09
    Acres
910 Treeline Dr, Fort Mitchell, KY 41017 - Photo 1 Just Listed
$15,000

910 Treeline Dr  Fort Mitchell, KY 41017

  • Lots/Land
  • Active
  • Updated 5 days ago
  • 0.16
    Acres

Price Reduced near 878 Squire Oaks Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

193 Kruempelman Dr, Fort Mitchell, KY 41017 - Photo 1 Price Reduced
-$384,000 (-39.02%)
$600,000

193 Kruempelman Dr  Fort Mitchell, KY 41017

  • Lots/Land
  • Active
  • Updated 6 days ago
  • 3.7
    Acres
5467 Starcrest Dr, Delhi Township, OH 45238 - Photo 1 Price Reduced
-$5,000 (-1.56%)
$314,900

5467 Starcrest Dr  Delhi Township, OH 45238

  • Single Family
  • Active
  • Updated 22 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,489
    Sq. Ft.
4805 Mayhew Ave, Delhi Township, OH 45238 - Photo 1 Price Reduced
-$10,000 (-3.64%)
$265,000

4805 Mayhew Ave  Delhi Township, OH 45238

  • Single Family
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,601
    Sq. Ft.
562 Rivers Breeze Dr, Ludlow, KY 41016 - Photo 1 Price Reduced
-$5,100 (-2.04%)
$244,900

562 Rivers Breeze Dr  Ludlow, KY 41016

  • Condo
  • Active
  • Updated 6 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,277
    Sq. Ft.
Listed by The Cagney Group (513) 319-7312

Recent Sales near 878 Squire Oaks Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

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.
519 Enterprise Dr, Erlanger, KY 41018 - Photo 1 Sold
$1,295,000

519 Enterprise Dr  #101  Erlanger, KY 41018

  • Warehouse
  • Closed
392 Crown Point Cir, Crestview Hills, KY 41017 - Photo 1 Sold
$1,080,000

392 Crown Point Cir  Crestview Hills, KY 41017

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
3 Princeton Ave, Fort Mitchell, KY 41017 - Photo 1 Sold
$1,200,000

3 Princeton Ave  Fort Mitchell, KY 41017

  • Single Family
  • Closed
  • 5
    Beds
  • 4
    Total Baths
  • 4,206
    Sq. Ft.

878 Squire Oaks Drive, Villa Hills, KY 41017 (MLS# 642348) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 878 Squire Oaks Drive is currently listed for $1,250,000 and was received on May 07, 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.

Tour this property