Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

943 Squire Oaks Dr, Villa Hills, KY, 41017

5beds
7baths
16,000sqft
$4,900,000
$306price/sqft
$32,289/moest. monthly cost
$1,291,560/yrincome needed

About This Home

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.

Getting Around

5
WalkingCar-Dependent
0
TransitVery Limited Transit
18
BikeSomewhat Bikeable

Schools

5/10
River Ridge Elementary SchoolGrades PK-51.2 mi
6/10
Turkey Foot Middle SchoolGrades 6-83.6 mi
9/10
Dixie Heights High SchoolGrades 9-122.9 mi

Construction

Condition

  • Property condition: Existing Structure
  • Year built: 2013

Materials

  • Foundation: Poured Concrete
  • Roof: Shingle
  • Construction materials: Brick,Stucco

Type & Style

  • Home type: SingleFamily
  • Architectural style: Transitional
  • Property subType: Single Family Residence,Residential

Interior

Appliances

  • Appliances included: Other,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,Humidifier
  • Laundry features: Laundry Room,Main Level

Basement

  • Has basement: Yes
  • Basement: Full

Bedroom2

  • Features: Bath Adjoins,Ceiling Fan(s),Carpet Flooring,Window Treatments,See Remarks,Walk-In Closet(s)
  • Level: First
  • Area: 183
  • Dimensions: 15 x 12.2

Bedroom3

  • Features: Bath Adjoins,Carpet Flooring,See Remarks,Walk-In Closet(s),Walk-Out Access,Window Treatments
  • Level: Second
  • Area: 228.62
  • Dimensions: 16.1 x 14.2

Bedroom4

  • Features: Walk-Out Access,Carpet Flooring,Hardwood Floors,See Remarks,Wood Flooring,Walk-In Closet(s),Bath Adjoins
  • Level: Second
  • Area: 391.95
  • Dimensions: 20.1 x 19.5

Bedrooms & Bathrooms

  • Bedrooms: 5
  • Bathrooms: 7
  • Full bathrooms: 6
  • 1/2 bathrooms: 1

Dining Room

  • Features: Tile Flooring,Fireplace(s),See Remarks,Chandelier
  • Level: First
  • Area: 329.804
  • Dimensions: 16.4 x 20.11

Exercise Room

  • Features: See Remarks,Tile Flooring
  • Level: First
  • Area: 216.32
  • Dimensions: 16.9 x 12.8

Features

  • 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,Recess Ceiling(s),Recessed Lighting,Wired for Data,Wired for Sound
  • Door features: Pocket Door(s),Multi Panel Doors
  • Window features: Casement,Picture Window(s)
  • Number of fireplaces: 5
  • Fireplace features: Stone,Blower Fan,Gas,Wood Burning
  • Fireplace: Yes

Game Room

  • Features: Hardwood Floors,See Remarks
  • Level: Second
  • Area: 468.563
  • Dimensions: 23.3 x 20.11

Great Room

  • Features: Hardwood Floors,Recessed Lighting,Wood Flooring,Fireplace(s),Walk-Out Access,See Remarks,Sound System
  • Level: First
  • Area: 440.99
  • Dimensions: 21.1 x 20.9

Heating & Cooling

  • Heating features: Geothermal
  • Cooling features: Zoned,Multi Units,Geothermal,Central Air

Interior Area

  • Total structure area: 16,000
  • Total interior livable area: 16,000 sqft

Kitchen

  • Features: Pantry,Recessed Lighting,See Remarks,Breakfast Bar,Kitchen Island,Gourmet Kitchen,Hardwood Floors
  • Level: First
  • Area: 268.5
  • Dimensions: 17.9 x 15

Library

  • Features: See Remarks,Wood Flooring,Bookcases,Hardwood Floors
  • Level: Lower
  • Area: 180.56
  • Dimensions: 14.8 x 12.2

Living Room

  • Features: Built-in Features,Fireplace(s),See Remarks,Tile Flooring
  • Level: First
  • Area: 313.24
  • Dimensions: 16.4 x 19.1

Media Room

  • Features: Wired for Sound,See Remarks,Sound System,Wired for Data
  • Level: Second
  • Area: 388.123
  • Dimensions: 19.3 x 20.11

Office

  • Features: See Remarks,Wood Flooring,Bookcases,French Doors,Hardwood Floors,Recessed Lighting
  • Level: First
  • Area: 158.7621
  • Dimensions: 12.11 x 13.11

Other

  • Features: Plank Flooring,Recessed Lighting,See Remarks
  • Level: Lower
  • Area: 324.87
  • Dimensions: 19.11 x 17

Other

  • Features: Built-in Features
  • Level: Lower
  • Area: 540.32
  • Dimensions: 61.4 x 8.8

Other

  • Features: Built-in Features,Ceramic Tile Flooring
  • Level: Lower
  • Area: 558.25
  • Dimensions: 27.5 x 20.3

Other

  • Features: Built-in Features,Ceramic Tile Flooring,Walk-Out Access
  • Level: Lower
  • Area: 621.3
  • Dimensions: 32.7 x 19

Other

  • Level: Lower
  • Area: 173.24
  • Dimensions: 14.2 x 12.2

Other

  • Features: Tile Flooring,Walk-Out Access,See Remarks
  • Level: First
  • Area: 375.13
  • Dimensions: 23.3 x 16.1

Primary Bath

  • Features: Double Vanity,Granite Flooring,Shower With Bench,Soaking Tub,Shower
  • Level: First
  • Area: 826.36
  • Dimensions: 29.2 x 28.3

Primary Bedroom

  • Features: Dressing Area,Carpet Flooring,Walk-Out Access,Window Treatments,Recessed Lighting,See Remarks,Tray Ceiling(s),Bath Adjoins,Sitting Room
  • Level: First
  • Area: 434.866
  • Dimensions: 21.11 x 20.6

Property

Details

  • Parcel number: 0134015019.00
  • Zoning description: Residential
  • Other equipment: Home Theater

Features

  • Levels: Three Or More
  • Stories: 3
  • Pool features: In Ground
  • Patio & porch: Covered
  • Exterior features: Private Yard,Balcony,Fountain,Lighting
  • Has view: Yes
  • View description: Pond,Trees/Woods
  • Has water view: Yes
  • Water view: Pond
  • Residential vegetation: Partially Wooded

Lot

  • Lot size: 0.99 Acres
  • Features: Corner Lot,Level
  • Lot size dimensions: .992

Parking

  • Total spaces: 3
  • Parking features: Driveway,Garage,Garage Door Opener,Garage Faces Front,Heated Garage,Off Street
  • Has garage: Yes
  • Attached garage spaces: 3
  • Covered spaces: 3
  • Has uncovered spaces: Yes