Please stand by.
USDAProperties.com is running hot! 🔥 🔥 🔥...

 

 

 

$5,900,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
943 Squire Oaks Dr
Villa Hills, KY 41017
5 bed 7 bath 16,106 SqFt ($366/SqFt)
0.99 acre lot. Built 2013
Listed 2024-03-22, HOA $14, Taxes $17,148
Ⓧ USDA Ineligible
due to price & location

near Villa Hills

Exclusive Opportunity!

Crafted by renowned local artisans, Toebben Builders, this exceptional home offers a captivating journey around the world. Elegant and inviting, it showcases exquisite details and top-tier craftsmanship. From double limestone staircases to a stunning a trium pool, every corner exudes luxury.

Indulge your culinary desires in the state-of-the-art kitchen and entertain guests with amenities like a Game Room, Theater Room, Shooting Range and Hibachi Grill. Experience comfort and convenience with geothermal HVAC systems, smart home features and advanced security. Schedule your private tour today and discover the epitome of refined living. Cntact us now!


Presented by Michele Mamo at
eXp Realty LLC.
Listing Agent Photo

Property MLS #621435 from NKentucky

Total Rooms: 20
Solarium: 23.30 x 16.10
Solarium Level: First
Solarium Features: Skylights, Wet Bar, Vaulted Ceiling, Ceiling Fans, Connects to Courtyard, Walks out to Side yard
Exercise Room: 16.90 x 12.80
Exercise Room Level: First
Exercise Room Features: Foam Florring, Ceiling Fan, Crown Molding, Mirror Wall, Glass Double Door Entry
Primary Bedroom: 21.11 x 20.60
Primary Bedroom Level: First
Primary Bedroom Features: Gas Fireplace, Canvas painting opens to TV, Motorized shades
Primary Bath: 29.20 x 28.30
Primary Bath Level: First
Primary Bath Features: Heated Granite Floors, Coffee Station, mini sink, Sub zero Beverage frig, Walk through shower with body jets, Lighted sinks,
Game Room: 23.30 x 20.11
Game Room Level: Second
Game Room Features: Art Deco Bar, Bev. Frig, Sub Zero Refrigerator drawers, microwave, Wet sink, Crown Molding, Wall Feature, Mirror with TV
Other Room: 27.50 x 20.30
Other Room Level: Lower
Other Room Features: Ceiling, Wall Treatment
Other Room: 32.70 x 19.00
Other Room Level: Lower
Other Room Features: Hibachi Grill, Theater, Bar
Other Room: 14.20 x 12.20
Other Room Level: Lower
Other Room Features: Crown Molding, Niches
Library: 14.80 x 12.20
Library Level: Lower
Library Features: Theodore Roosevelt Library, Crown Molding, Niche, Gallery Lighting, Hanging Display system, Built in bookcases
Recreation Room: 19.11 x 17.00
Recreation Room Level: Lower
Recreation Room Features: Fireplace
Recreation Room: 61.40 x 8.80
Recreation Room Level: Lower
Recreation Room Features: Special Hobby Space
Basement Features: Full, Finished, Bath/Stubbed, Storage Space, Walk-Out Access
Great Room Dimensions: 21.1 x 20.9
Living Room Dimensions: 16.4 x 19.1
Media Room Dimensions: 19.3 x 20.1
Office/Study Room Dimensions: 12.1 x 13.1
Game/Recreation Room Level: Second
Great Room Level: First
Living Room Level: First
Media Room Level: Second
Office/Study Room Level: First
Great Room Features: Hearthroom, Beam Ceiling, Gas Fireplace, Crown Molding, Wall of windows, Floating shelves, Opens to courtyard
Living Room Features: Porcelain Tile Flooring, Graffiti Style Chandelier with electric hoist, Limestone Fireplace
Office/Study Room Features: Floor to ceiling bookcases, Display niches, Rolling ladder, built in desk with wiring, TV niche
Basement Description: Full, Finished, Bath/Stubbed, Storage Space, Walk-Out Access

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
Wine/Beverage Cooler
Laundry Facilities: Laundry Room, Main Level
Laundry Features: Laundry Room, Main Level

Bedrooms: 5
Bedroom 2 Dimensions: 15.0 x 12.2
Bedroom 3 Dimensions: 16.1 x 14.2
Bedroom 4 Dimensions: 20.1 x 19.5
Primary Bedroom Level: First
Bedroom 2 Level: First
Bedroom 3 Level: Second
Bedroom 4 Level: Second
Bedroom 2 Features: Florida Bedroom, Chair Rail, Ensuite
Bedroom 3 Features: English Garden Room, Chandelier, French Doors, Balcony, Crown Molding Dressing area, Outside Balcony
Bedroom 4 Features: Asian Room, Chandelier, Balcony

Total Bathrooms: 6.5
Full Bathrooms: 6
1/2 Bathrooms: 1
Primary Bathroom Level: First

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
220 Volts
Beamed Ceilings
Butler's Pantry
Ceiling Fan(s)
Elevator
French Doors
High Ceilings
Multi Panel Doors
Recess Ceiling(s)
Recessed Lighting
Wired for Data
Window Features: Casement, Insulated Window(s), Picture Window(s)

Cooling Features: Zoned, Multi Units, Geothermal, Central Air
Fireplace Features: Stone, Blower Fan, Gas, Wood Burning
Heating Features: Geothermal
Heating: Yes
Number of Fireplaces: 5

Dining Room Dimensions: 16.4 x 20.1
Dining Room Features: Porcelain Tile Flooring, Graffiti Chandelier with electric hoist, limestone Gas FP, (LR and DR can be woodburning)
Dining Room Level: First
Kitchen Dimensions: 17.9 x 15.0
Kitchen Features: Sub Zero Frig, Wolf Gas Range, Dual electric ovens, Built-in Features, Aquarium, Kinsella Cabinetry, Dual Temp wine Unit with Refrig drawers
Kitchen Level: First

Private Yard
Balcony
Fountain
Lighting
Patio And Porch Features: Covered
Road Frontage Type: City Street
Road Surface Type: Paved

Pool Features: In Ground

Lot Description: Corner Lot, Level
Lot Size Acres: 0.99
Lot Size Dimensions: .992
Lot Size Source: Realist
Vegetation: Partially Wooded
Lot Size Square Feet: 43212

Garage Spaces: 3
Off Street Parking: true
Parking Features: Driveway, Garage, Garage Door Opener, Garage Faces Front, Heated Garage, Off Street

View: Pond, Trees/Woods
Other Equipment: Home Theater, Humidifier
Security Features: Closed Circuit Camera(s), Security Lights, Security System, Smoke Detector(s)

Association: Yes
Association Fee: 162
Association Fee Frequency: Annually
Association Fee Includes: Management
Calculated Total Monthly Association Fees: 14

Elementary School: River Ridge Elementary
High School: Dixie Heights High
Middle School: Turkey Foot Middle School
School District: Kenton Co Public

River Ridge Elementary School is a public elementary school located approximately 1.2 miles away.
directions icon Map directions

Dixie Heights High School is a public high school located approximately 2.9 miles away.
directions icon Map directions

Turkey Foot Middle School is a public middle school located approximately 3.6 miles away.
directions icon Map directions

Villa Madonna Academy Elementary And Jr High School is a private elementary and middle school located approximately 0.3 miles away.
directions icon Map directions

Source Listing Status: Active
County: Kenton
Directions: I-75 to Buttermilk Pike West, Right on Rosewood, Left on Squire Oaks Drive.
Source Property Type: Residential
Area: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
MLS Area Minor: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
Source Neighborhood: K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
Parcel Number: 013-40-15-019.00
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$1,475,900 + $160,000
$1,635,900
$17,148
2021$1,475,900 + $160,000
$1,635,900
$17,515
2020$1,398,000 + $160,000
$1,558,000
$16,857
2019$1,398,000 + $160,000
$1,558,000
$16,911
2018$1,398,000 + $160,000
$1,558,000
$17,397
2017$1,398,000 + $160,000
$1,558,000
$16,899
2016$1,398,000 + $160,000
$1,558,000
$16,614
2015$1,400,000 + $158,000
$1,558,000
$16,423
2014$1,400,000 + $158,000
$1,558,000
$16,143
2013$1,400,000 + $158,000
$1,558,000
$9,815
2012$unknown + $158,000
$158,000
$1,631
2010$unknown + $130,000
$130,000
$1,301
2009$unknown + $130,000
$130,000
$1,290
2009$unknown + $130,000
$130,000
$1,290
2008$unknown + $130,000
$130,000
$1,267
2007$unknown + $100,000
$100,000
$977

Listing removed 2024-03-23
$0
NKentucky
Listed 2024-03-22
$5,900,000
NKentucky
Listed 2023-06-17
$7,500,000
NKentucky
Sold 2011-12-20
$158,000
Public Record

Total Square Feet Living: 16106
Year Built: 2013
Building Exterior Type: Brick, Stucco
Construction Materials: Brick, Stucco
Foundation Details: Poured Concrete
Levels: Three Or More
Living Area Units: Square Feet
Property Age: 11
Property Condition: Existing Structure
Levels or Stories: Three Or More
Architectural Style: Transitional

Sewer: Public Sewer
Cable Available
Water Source: Public
Click Thumbnail Images To View Full Size
unknownunknownhouse_viewhouse_viewhouse_view
garageunknownunknownunknownunknown
living_roomdining_roomunknowndining_roomkitchen
living_roomliving_roomporchporchliving_room
bedroomunknownliving_roombathroombathroom
bathroombedroomunknownunknownunknown
bedroombathroombedroomdining_roomunknown
living_roomunknownliving_roomliving_roomunknown
unknowndining_roomliving_roomliving_roomkitchen
garageunknownunknownporch

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.