5 months on rocket

944 Squire Oaks Dr, Villa Hills, KY, 41017

$2,995,000

5 Bedrooms
5 Full Baths, 2 Partial
10,700 SqFt
$280/SqFt
House

Location

Image provided by Mapbox

Property Highlights

Home TypeSingle Family Residence
ParkingAttached, Driveway, Garage, Garage Door Opener, Garage Faces Side
Garage3 spaces
Year Built2007
HeatingNatural Gas, Forced Air
CoolingMulti Unit(s), Central Air
BasementYes
FireplaceStone, Ceramic, Gas
MLS #623365
Lot Size1.84 Acres
StatusActive

About 944 Squire Oaks Dr

**LIMITED TIME OFFER: Take advantage of this 2/1 buydown offer and maximize your buying power — secure your dream home now before the opportunity slips away! ** This 10,700-sf brick mansion is a sanctuary of luxury, comfort, and unparalleled beauty on nearly two stunning acres. Enter through an opulent transom door to a grand foyer, where an extravagant formal living room boasting a built-in gas fireplace with marble inlay captures the eye. Off the formal living room is a luxurious in-home bar perfect for crafting cocktails. The formal dining room is the epitome of luxury, and the deluxe office showcases a workspace of unparalleled grace. The lavish theatre room offers a billiard room, open bar, and poker lounge. The great room has an open dining area, oversized den with stone gas fireplace and a gourmet kitchen featuring stainless-steel appliances, dining island and granite countertops. The primary suite offers a private covered terrace, oversized walk-in closet and spa-like bath with soaking tub. Outside features covered patios, lush gardens, a sparkling swimming pool, heated and lit, a fire pit and an oversized hot tub (with room for 14); a perfect spot to unwind from the day

Property Details

Property Features

Property Information:

  • Architectural Style: Traditional
  • Year Built: 2007
  • Living Area: 10,700 SqFt

Listing Office:

  • Office Name: Coldwell Banker Realty FM
  • Office Phone: (859) 341-9000
  • Listing Agent: Varun Varma

Interior Features

Interior Information:

  • Appliances: Stainless Steel Appliance(s), Gas Oven, Dishwasher, Double Oven, Microwave, Refrigerator
  • Basement: Yes
  • Flooring Type: Carpet
  • Interior: Kitchen Island, Wet Bar, Walk-in Closet(s), Storage, Soaking Tub, Pantry, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Coffered Ceiling(s), Chandelier, Bookcases, Beamed Ceilings, Ceiling Fan(s), French Door(s), High Ceilings, Natural Woodwork, Vaulted/Cathedral Ceiling(s)
  • Fireplace: Stone, Ceramic, Gas

Bedroom and Bathroom Information:

  • Partial Bathrooms: 2
  • Full Bathrooms: 5
  • Total Bedroom Count: 5

Exterior Features

Parking Information:

  • Garage Space: 3 spaces
  • Parking: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side

Lot Features

Lot Information:

  • Lot Size: 1.84 Acres

Utilities

Utilities Information:

  • Heating: Natural Gas, Forced Air
  • Cooling: Multi Unit(s), Central Air

School Info

Assigned Schools Information:

  • Dixie Heights High School, Public District Grades 9-12
  • Turkey Foot Middle School, Public District Grades 6-8
  • River Ridge Elementary School, Public District Grades PK-5

Other

Directions Information:

  • Directions: Buttermilk Pike to Rosewood to Squire Oaks

Price Information

Listing Price Info

Price Summary:

  • List Price: $2,995,000
  • Price Per SqFt: $280/SqFt

HOA Fees:

  • Amount: $180
  • Frequency: Annually

Tax Information:

  • Annual Amount: $21,217
  • Tax Year: 2020
House and calculator

What can I afford?

Understand what home price range makes sense for your budget.

Housing Market Comparison

See how this home compares to others in Villa Hills, KY.

Med. List Price

$628.3K

Med. Price/SqFt

$231

Avg. Days On Market

128

944 Squire Oaks Dr vs Villa Hills

157 DAYS ON ROCKET

+29 Days

$2,995,000

+$2.3M More

$280/SqFt

+$49 More

KEY TAKEAWAY

This property is $2.3M more than the Median List Price and $49/SqFt more than other homes in Villa Hills, KY.

Based on homes listed in October 2024

MLS Details

MLS Information:

  • MLS Name: Northern Kentucky Multiple Listing Service
  • MLS Number: #623365

Listing Office:

  • Office Name: Coldwell Banker Realty FM
  • Office Phone: (859) 341-9000
  • Listing Agent: Varun Varma

Disclaimer: 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. (NKMLS). Real estate listings held by other brokerage firms are marked with the Broker Reciprocity Logo and detailed information about them includes the name of the listing broker. The broker providing the data believes the data to be correct, but advises interested parties to confirm the data before relying on it in a purchase decision. MLS content and images © Copyright ©2024, Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

The information on this web site is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. We are not responsible or liable for misinformation, misprints, or typographical errors. All information provided is deemed reliable but is not guaranteed and should be independently verified through personal inspection by and/or with the appropriate professionals. Properties subject to prior sale, change, withdrawal or rental.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 11/5/2024, 8:20:53 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Property Sales & Tax

Listing History

Jun 15, 2018Home Sold
$1,875,000
Aug 11, 2017Home Sold
$1,900,000
Aug 11, 2017Home Sold
$1,900,000
Jun 08, 2006Home Sold
$170,000

Tax History

YEARPROP. TAXASSESSMENT
2020$21,217$1,875,000
2019$21,199$1,875,000
2018$21,200$1,900,000
2017$14,113$1,300,000

History based on county public records data.

Payment Calculator

$15K

Per Month

Recommended Financing

30-Year Fixed

Rate/APR

7.5% / 6.68%

Total Monthly Payment

$9,046

Schools

Schools Nearby

The school rating is a score out of 10, where 10 is the highest and 1 is the lowest. Assigned schools have a bold outline.

Elementary School

school-card-donut-2078925
8
/10
  • River Ridge Elementary School

  • 2772 Amsterdam Rd

  • 1.25 miles

  • Public District Grades PK-5

Middle School

school-card-donut-2078926
6
/10
  • Turkey Foot Middle School

  • 3230 Turkeyfoot Rd

  • 3.63 miles

  • Public District Grades 6-8

High School

school-card-donut-2078927
6
/10
  • Dixie Heights High School

  • 3010 Dixie Hwy

  • 2.94 miles

  • Public District Grades 9-12

Neighborhood

What Are The Neighbors Like?

The neighbors living near this home have an average income of $67,919. Residents of Villa Hills, KY typically earn between $35k-100k each year. Most families are single, no kids. The majority of residents in this area have post secondary degree education.

All data provided by Home Junction and Claritas

Frequently Asked Questions About 944 Squire Oaks Dr

What is the listing price of this property?

The listing price of 944 Squire Oaks Dr property is $2,995,000.

What type of property is this?

The property 944 Squire Oaks Dr is a house located in Villa Hills, Kentucky, 41017.

Is this property for sale now?

Active Listing: 944 Squire Oaks Dr is For Sale (Active/New) which means the seller is accepting offers.

What are the assigned schools for this property?

The assigned schools for 944 Squire Oaks Dr are:
River Ridge Elementary School: GreatSchools Rating 8/10
Turkey Foot Middle School: GreatSchools Rating 6/10
Dixie Heights High School: GreatSchools Rating 6/10

What is the annual property tax for this property?

According to the records, the last property tax for 2020 is $21,217 (source: MLS/based on county public records data).

When was this property sold last time and for how much?

The last sale was on June 15, 2018 for $1,875,000. (source: MLS/tax record).

How many bedrooms and bathrooms does this property have?

The property at 944 Squire Oaks Dr has 5 bedrooms and 5 full and 2 half bathrooms.

What is the square footage of this property?

The property 944 Squire Oaks Dr is 10,700 SqFt (source: MLS/tax record).

Which year was this property built?

The year of construction for 944 Squire Oaks Dr is 2007.
Rocket Homes logo

Interested in 944 Squire Oaks Dr? Let's connect.

Let Us Contact You

By checking this box and submitting your personal information, you agree to our Terms of Use and Privacy Policy. You also expressly consent to having Rocket Homes Real Estate LLC, its Family of Companies, Rocket Homes Network Partners, and potentially our mortgage partners contact you about your inquiry by text message or phone (including automatic telephone dialing system, AI voice, or an artificial or prerecorded voice) to the residential or cellular telephone number you have provided, even if that telephone number is on a corporate, state, or national Do Not Call Registry. You do not have to agree to receive such calls or messages as a condition of getting any services from Rocket Homes Real Estate, LLC or its partners. By communicating with us by phone, you consent to calls being recorded and monitored. You also agree that we can share your personal data and contact information with third parties such as mortgage partners, partner companies, and affiliates, and that these parties may use your personal data and contact information for marketing and analytic purposes, and to improve your experience.


Rocket HomesKentuckyKenton CountyVilla Hills41017944 Squire Oaks Dr

This home is located at 944 Squire Oaks Dr in Villa Hills, KY and zip code 41017. This 10,700 square foot home, which was built in 2007, sits on a 1.84 acre lot. Features: 5 bedrooms, 7 bathrooms. It has been listed on Rocket Homes since May 31, 2024 and is currently priced at $2,995,000.

The number of listings in Villa Hills, KY increased by 39.3% between September 2024 and October 2024. Listings spent 128 days on the market in October 2024, and had a median list price of $628,318 during the same period.

From Rocket Homes Real Estate and based on county public records data.

More Resources