Skip To Content

875 Squire Oaks Drive

Villa Hills, KY 41017
  • $2,500,000
  • STATUS: Active
  • ON SITE: 42 Days
  • MLS #: 613016
UPDATED: 54 min ago
$2,500,000
  • 4
    BEDS
  • 3.3
    ACRES
  • 5
    BATHS
  • 2
    1/2 BATHS
  • 7,500
    SQFT
  • $333
    $/SQFT

School Information

Elementary School:
Middle School:
High School:
School District:

Description

Escape to your own private oasis in prestigious Country Squire Estates in Villa Hills. This stunning home offers luxurious outdoor living with a heated pool and hot tub, perfect for year round relaxation. Take advantage of the convenience and elegance of an elevator, first floor master suite. Work from home in the beautiful 2 story office, attached to the home. The finished Lower level boasts a movie theater, exercise room, bar area, lower level access to pool and hot tub area. This one-of-a-kind property is situated on 3.3 acres, with a carriage house that has two bedrooms, two full baths , vaulted ceilings, and exquisite workmanship, offering plenty of space for family and friends. The property also features a total of seven garages, perfect for car enthusiasts and collectors. Approximately 7500 SF in main home and additional 2300 in Carriage house. Enjoy the serenity of living amongst beautifully landscaped grounds creating an ambiance of privacy and tranquility. It's time to make this dream home your reality!

Monthly Payment Calculator



Northern Kentucky MLS logo © 2023 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2023-06-08T22:49:36.377.
www.jimsimpsonrealtors.com/homes/138885167
Print Image

875 Squire Oaks Drive Villa Hills, KY 41017

  • Price: $2,500,000
  • Status: Active
  • On Site: 42 Days
  • Updated: 54 min ago
  • MLS #: 613016
4
Beds
5
Baths
2
½ Baths
3.3
Acres
7,500
SQFT
$333
$/SQFT
Neighborhood:
Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
County:
Kenton
Area:
Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi
Elementary School:
River Ridge Elementary
Middle School:
Turkey Foot Middle School
High School:
Dixie Heights High
School District:
Kenton Co Public
Property Description
Escape to your own private oasis in prestigious Country Squire Estates in Villa Hills. This stunning home offers luxurious outdoor living with a heated pool and hot tub, perfect for year round relaxation. Take advantage of the convenience and elegance of an elevator, first floor master suite. Work from home in the beautiful 2 story office, attached to the home. The finished Lower level boasts a movie theater, exercise room, bar area, lower level access to pool and hot tub area. This one-of-a-kind property is situated on 3.3 acres, with a carriage house that has two bedrooms, two full baths , vaulted ceilings, and exquisite workmanship, offering plenty of space for family and friends. The property also features a total of seven garages, perfect for car enthusiasts and collectors. Approximately 7500 SF in main home and additional 2300 in Carriage house. Enjoy the serenity of living amongst beautifully landscaped grounds creating an ambiance of privacy and tranquility. It's time to make this dream home your reality!
Exterior Features

Architectural Style Transitional Attached Garage YN Yes Construction Materials Stone Exterior Features FountainHot TubLightingOutdoor Grill Foundation Details Poured Concrete Garage YN Yes Levels Two Parking Features AttachedDetachedDrivewayGarage Faces SideHeated Garage Patio And Porch Features DeckEnclosedPatioPorch Pool Features In Ground View LakePond View YN Yes

Interior Features

Appliances DishwasherDisposalDryerMicrowaveRefrigeratorWasherWine/Beverage Cooler Basement FullFinishedWalk-Out Access Cooling Central Air Cooling YN Yes Fireplace Features GasMarble Fireplace YN Yes Fireplaces Total 2 Heating Natural GasForced Air Heating YN Yes Interior Features Kitchen IslandWalk-In Closet(S)Sound SystemEat-In KitchenDouble VanityBuilt-In Features220 VoltsElevatorHigh CeilingsSaunaWet Bar Laundry Features Lower LevelMain LevelUpper Level Other Equipment Home Theater Rooms Total 14 Window Features CasementInsulated Window(S)

Property Features

Association YN No Cross Street Rosewood Lot Features Flag Lot Lot Size Dimensions 3.3 New Construction YN No Other Structures PergolaGuest HouseStorageWorkshop Property Attached YN No Property Class Residential Property Condition Existing Structure Property Sub Type Single Family Residence Security Features Security SystemSmoke Detector(S) Sewer Public Sewer Structure Type House Utilities Cable AvailableNatural Gas Available Water Source Public Zoning Description Residential

Northern Kentucky MLS logo Courtesy of Huff Realty - Florence: 859-525-7900. © 2023 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. Information has not been verified, is not guaranteed, and subject to change.


Northern Kentucky MLS logo © 2023 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2023-06-08T22:49:36.377.
 
https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_613016-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_613016-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_613016-2.jpg
Logo
Jim Simpson Realtors Inc
39 Broadway
Dry Ridge KY, 41035