x
Showing 1 of 0
X
Save

943 Squire Oaks Drive
Villa Hills KY 41017 US

$4,900,000

Active Listing ID 641654
bed icon
5 bed
bath icon
7.00 Bath (6 Full , 1 Half)
lot icon
Lot: 0.99 Acres
home icon
Single Family Residence

$4,900,000

Active Listing ID 641654
Save

943 Squire Oaks Drive One of the region's most extraordinary estates, this custom masterpiece by Toebben Builders is truly exceptional. Spanning over 16, 000 square feet, this like-new residence showcases exquisite architectural detail and superior craftsmanship throughout. Re-creating this elegant and inviting home today would come at a significantly higher cost. From the moment you arrive, the symmetric double limestone staircases make a grand statement. Designed for both lavish entertaining and comfortable everyday living, the home features an atrium-style indoor pool, stunning chef's kitchen, luxurious spa-inspired baths, private theater, game room, hibachi grill, and even a private shooting range. Additional highlights include geothermal HVAC systems, a 5+ car garage, advanced security, and fully integrated smart home technology -- delivering the ultimate in comfort, efficiency, and peace of mind. Located in one of Northern Kentucky's most sought-after neighborhoods, just 15 minutes from downtown, this estate offers refined luxury living without sacrificing convenience. A rare opportunity for the most discerning buyer -- this is truly a must-see.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.99 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 6
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air, Zoned, Multi Units, Geothermal
  • Exterior Finish: Private Yard, Balcony, Fountain, Lighting
  • Roof Type: Shingle
  • Heating Fuels: Geothermal (Heating)
  • Additional Features
  • Basement
  • Fireplace

School Information

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

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 4900000
  • unparsedaddress: 943 Squire Oaks Drive
  • postalcity: Villa Hills
  • stateorprovince: KY
  • country: US
  • postalcode: 41017
  • bathroomsfull: 6
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.99
  • lotsizeunits: Acres
  • lotsizearea: 0.99
  • livingarea: 16000
  • livingareaunits: Square Feet
  • latitude: 39.065722
  • longitude: -84.585699
  • 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: 2013
  • listingcontractdate: 2026-04-17
  • listagentfax: 8882177287
  • listagenturl: http://https://www.dwellwellgroup.com/
  • countyorparish: Kenton
  • parcelnumber: 013-40-15-019.00
  • elementaryschool: River Ridge Elementary
  • highschool: Dixie Heights High
  • elementaryschooldistrict: Kenton Co Public
  • middleorjuniorschooldistrict: Kenton Co Public
  • highschooldistrict: Kenton Co Public
  • appliances: Wine Cooler, Stainless Steel Appliance(s), Gas Cooktop, Gas Range, Gas Oven, Convection Oven, Dishwasher, Disposal, Double Oven, Dryer, ENERGY STAR Qualified Appliances, Ice Cooler, Microwave, Refrigerator, Tankless Water Heater, Washer
  • cooling: Central Air, Zoned, Multi Units, Geothermal
  • constructionmaterials: Brick, Stucco
  • heating: Geothermal (Heating)
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 3
  • parkingtotal: 0
  • parkingfeatures: Garage, Off Street, Open, Driveway
  • roof: Shingle
  • waterfrontyn: False
  • franchiseaffiliation: None
  • interiorfeatures: Pocket Door(s), Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Stone Counters, Sound System, Soaking Tub, Smart Thermostat, Smart Home, Pantry, Open Floorplan, High Speed Internet, Entrance Foyer, Double Vanity, Crown Molding, Coffered Ceiling(s), Chandelier, Bookcases, Breakfast Bar, Built-in Features, Beamed Ceilings, Butler's Pantry, Ceiling Fan(s), Elevator, High Ceilings, Multi Panel Doors, Recess Ceiling(s), Recessed Lighting, Wired for Data, Wired for Sound
  • exteriorfeatures: Private Yard, Balcony, Fountain, Lighting
  • windowfeatures: Insulated Windows
  • architecturalstyle: Other
  • rooms: Bathroom 7, Bedroom 2, Bathroom 3, Bathroom 5, Bedroom 1, Bathroom 2, Game Room, Dining Room, Bathroom 1, Basement, Bedroom 5, Bathroom 6, Exercise Room, Laundry Room, Bedroom 3, Bedroom 4, Bathroom 4
  • securityfeatures: Security Lighting
  • otherstructures: Storage
  • utilities: Cable Available
  • accessibilityfeatures: Accessible Elevator Installed
  • basement: Storage Space, Full, Finished, Walk-Out Access
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • vegetation: Partially Wooded
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -84.5857, 39.065723
  • 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 - Other - Villa Hills, KY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/943-Squire-Oaks-Dr_Villa-Hills_KY_41017_M48049-27718?f=listhub&s=NKARKY&m=641654&c=rexren", "MLSModificationTimestamp":"2026-04-17 18:16:33", "Neighborhoods":[{"Description":null, "Name":"K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi"}], "PostalCode":null, "RoomCount":20, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 4/24/2026 2:18:42 AM GMT
Source Updated Date: 4/27/2026 6:49:05 AM 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.