x
Showing 1 of 0
X
Save

878 Squire Oaks Drive
Villa Hills KY 41017 US

$1,250,000

Active Listing ID 642348
bed icon
4 bed
bath icon
4.00 Bath (3 Full , 1 Half)
lot icon
Lot: 0.96 Acres
home icon
Single Family Residence

$1,250,000

Active Listing ID 642348
Save

878 Squire Oaks Drive 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.96 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Exterior Finish: Fire Pit, Balcony, Lighting
  • Roof Type: Shingle
  • Heating Fuels: Forced Air, Natural Gas
  • Additional Features
  • Basement
  • Fireplace
  • Patio

School Information

  • School
  • River Ridge Elementary(Elementary)
  • Turkey Foot Middle School(MiddleSchool)
  • Dixie Heights High(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1250000
  • unparsedaddress: 878 Squire Oaks Drive
  • postalcity: Villa Hills
  • stateorprovince: KY
  • country: US
  • postalcode: 41017
  • bathroomsfull: 3
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.96
  • lotsizeunits: Acres
  • lotsizearea: 0.96
  • livingarea: 2882
  • livingareaunits: Square Feet
  • latitude: 39.062788
  • longitude: -84.580506
  • listagentfullname: Michele Mamo
  • listagentemail: michelemamo@gmail.com
  • listagentkey: 3yd-NKARKY-846519361
  • listagentmlsid: 846519361
  • listagentpreferredphone: 8595127772
  • listagentofficephone: 8595127772
  • listofficekey: 3yd-NKARKY-432502002
  • listagentstatelicense: 216745
  • listofficemlsid: 432502002
  • disclaimer: Copyright © 2026 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: NKARKY
  • yearbuilt: 1986
  • listingcontractdate: 2026-05-06
  • listagentfax: 8882177287
  • listagenturl: http://https://www.dwellwellgroup.com/
  • countyorparish: Kenton
  • parcelnumber: 013-40-13-012.00
  • elementaryschool: River Ridge Elementary
  • highschool: Dixie Heights High
  • elementaryschooldistrict: Kenton Co Public
  • middleorjuniorschooldistrict: Kenton Co Public
  • highschooldistrict: Kenton Co Public
  • appliances: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Double Oven, Dryer, Microwave, Refrigerator, Washer
  • cooling: Central Air
  • constructionmaterials: Brick, Wood Siding
  • heating: Forced Air, Natural Gas
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 2
  • parkingfeatures: Off Street, Garage
  • roof: Shingle
  • waterfrontyn: False
  • franchiseaffiliation: None
  • interiorfeatures: 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
  • exteriorfeatures: Fire Pit, Balcony, Lighting
  • windowfeatures: Insulated Windows, Vinyl Frames
  • architecturalstyle: Contemporary
  • rooms: Bedroom 2, Laundry Room, Dining Room, Bathroom 2, Bedroom 4, Bathroom 4, Bedroom 1, Basement, Bathroom 1, Bathroom 3, Bedroom 3, Laundry Room, Family Room
  • otherstructures: Storage
  • utilities: Natural Gas Available
  • patioandporchfeatures: Deck
  • basement: Full, Walk-Out Access, Finished
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • vegetation: Partially Wooded
  • fencing: Perimeter
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -84.580505, 39.062786
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"eXp Realty LLC", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"michelemamo@gmail.com", "ListBrokerageCity":"20230818185955290933000000", "ListBrokerageCountry":"US", "ListBrokerageEmail":null, "ListBrokerageLogoUrl":null, "ListBrokerageName":"eXp Realty LLC", "ListBrokeragePhone":"859-512-7772", "ListBrokeragePostalCode":null, "ListBrokerageStateOrProvince":"KY", "ListBrokerageUnitNumber":"Suite 201", "ListBrokerageUnparsedAddress":"100 Riverside Place", "ListBrokerageWebsiteUrl":null, "ListOfficeAddress1":"100 Riverside Place 201 ", "ListOfficeAddress2":"Suite 201", "ListOfficeBrokerMlsId":"432502002", "ListOfficeCity":"Covington", "ListOfficeCountry":"US", "ListOfficeEmail":"michelemamo@gmail.com", "ListOfficePostalCode":"41011", "ListOfficeStateOrProvince":"KY", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Contemporary - Villa Hills, KY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/878-Squire-Oaks-Dr_Villa-Hills_KY_41017_M34062-47509?f=listhub&s=NKARKY&m=642348&c=rexren", "MLSModificationTimestamp":"2026-05-07 18:43:29", "Neighborhoods":[{"Description":null, "Name":"K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi"}], "PostalCode":null, "RoomCount":11, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 5/10/2026 2:18:35 AM GMT
Source Updated Date: 5/10/2026 12:36:50 PM GMT

Courtesy of: Michele Mamo, eXp Realty LLC, michelemamo@gmail.com

Copyright © 2026 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.