Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (224)
    Mexico Listings (15)
    Advanced Search
Sell Find an Agent
BarrierFreeHome.com BarrierFreeHome.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BarrierFreeHome.com logo
Share
BarrierFreeHome.com logo
Ad #7588422
MLS #641654
Listing photo

One of the region's most extraordinary estates, this custom

943 Squire Oaks Dr, Villa Hills, Kentucky, 41017
$4,900,000
5Beds
7Baths
16,000Sqft
0.990Acres

About this property

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.

Property Features

5 Beds
7 Baths
16,000 Sqft
Built in 2013
0.990 Acres
3 Stories
Garage, Off Street, Open, Driveway
Siding: Brick, Stucco
Shingle Roof
Has Fireplace
Geothermal (Heating)
Kenton County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Michele Mamo

eXp Realty LLC

859-512-7772

Location

Map
Listing Agent: Michele Mamo (License #: 216745) 859-512-7772
Broker: eXp Realty LLC 859-512-7772 Listing Site
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.
BarrierFreeHome.com
Printed Jul 24, 2026

Photo Gallery

One of the region's most extraordinary estates, this custom - photo 1
One of the region's most extraordinary estates, this custom - photo 2
One of the region's most extraordinary estates, this custom - photo 3
One of the region's most extraordinary estates, this custom - photo 4
One of the region's most extraordinary estates, this custom - photo 5
One of the region's most extraordinary estates, this custom - photo 6
One of the region's most extraordinary estates, this custom - photo 7
One of the region's most extraordinary estates, this custom - photo 8
One of the region's most extraordinary estates, this custom - photo 9
One of the region's most extraordinary estates, this custom - photo 10
One of the region's most extraordinary estates, this custom - photo 11
One of the region's most extraordinary estates, this custom - photo 12
One of the region's most extraordinary estates, this custom - photo 13
One of the region's most extraordinary estates, this custom - photo 14
One of the region's most extraordinary estates, this custom - photo 15
One of the region's most extraordinary estates, this custom - photo 16
One of the region's most extraordinary estates, this custom - photo 17
One of the region's most extraordinary estates, this custom - photo 18
One of the region's most extraordinary estates, this custom - photo 19
One of the region's most extraordinary estates, this custom - photo 20
One of the region's most extraordinary estates, this custom - photo 21
One of the region's most extraordinary estates, this custom - photo 22
One of the region's most extraordinary estates, this custom - photo 23
One of the region's most extraordinary estates, this custom - photo 24
One of the region's most extraordinary estates, this custom - photo 25
One of the region's most extraordinary estates, this custom - photo 26
One of the region's most extraordinary estates, this custom - photo 27
One of the region's most extraordinary estates, this custom - photo 28
One of the region's most extraordinary estates, this custom - photo 29
One of the region's most extraordinary estates, this custom - photo 30
One of the region's most extraordinary estates, this custom - photo 31
One of the region's most extraordinary estates, this custom - photo 32
One of the region's most extraordinary estates, this custom - photo 33
One of the region's most extraordinary estates, this custom - photo 34
One of the region's most extraordinary estates, this custom - photo 35
One of the region's most extraordinary estates, this custom - photo 36
One of the region's most extraordinary estates, this custom - photo 37
One of the region's most extraordinary estates, this custom - photo 38
One of the region's most extraordinary estates, this custom - photo 39
One of the region's most extraordinary estates, this custom - photo 40
One of the region's most extraordinary estates, this custom - photo 41
One of the region's most extraordinary estates, this custom - photo 42
One of the region's most extraordinary estates, this custom - photo 43
One of the region's most extraordinary estates, this custom - photo 44
One of the region's most extraordinary estates, this custom - photo 45
One of the region's most extraordinary estates, this custom - photo 46
One of the region's most extraordinary estates, this custom - photo 47
One of the region's most extraordinary estates, this custom - photo 48
One of the region's most extraordinary estates, this custom - photo 49

$4,900,000

5
Beds
7
Baths
16,000
Sqft

943 Squire Oaks Dr, Villa Hills, Kentucky, 41017

By contacting this agent you agree to these Terms and Conditions.
Home Kentucky Villa Hills
One of the region's most extraordinary estates, this custom - photo 1
One of the region's most extraordinary estates, this custom - photo 2
One of the region's most extraordinary estates, this custom - photo 3
One of the region's most extraordinary estates, this custom - photo 4
One of the region's most extraordinary estates, this custom - photo 5
MLS# 641654
Home For Sale

One of the region's most extraordinary estates, this custom

$4,900,000

943 Squire Oaks Dr, Villa Hills, Kentucky, 41017

5
Beds
7
Baths
16,000
Sqft
0.990
Acres
$4,900,000
943 Squire Oaks Dr, Villa Hills, Kentucky, 41017
5 Beds
7 Baths
16,000 Sqft
0.990 Acres

Accessibility Features

Accessible Elevator Installed
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.
98 days
on BarrierFreeHome.com
34
views
0
saves

Property Details

HOME DETAILS

5 Beds
7 Baths
16,000 Sqft
Built in 2013
0.990 Acres
3 Stories

EXTERIOR

Garage, Off Street, Open, Driveway
Siding: Brick, Stucco
Shingle Roof

INTERIOR

Has Fireplace
Geothermal (Heating)

FINANCIAL & COMMUNITY

Kenton County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7588422
Viewed
34 times
Listing Status
Active
Added
Apr 17, 2026
Last Refresh
Jul 24, 2026 04:01:17 PM

Listing Information

Data Source
Northern Kentucky MLS, Inc.
Source Property ID
641654
Listing Agent: Michele Mamo (License #: 216745) 859-512-7772
Broker: eXp Realty LLC 859-512-7772 Listing Site
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.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BarrierFreeHome.com
Sell Your Home

Explore Similar Properties

No similar properties found.

SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
Facebook YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Villa Hills

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Villa Hills Real Estate Agent Info

About Villa Hills

Click to activate
Request Information
By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
Facebook YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy