Skip main navigation
Sold for $2,100,000
  • $2,100,000

    944 Squire Oaks Dr, Villa Hills, KY 41017

    5beds
    10,700sqft
    Single Family Residence, Residential
    Built in 2007
    1.84 Acres Lot
    $2,108,700 Zestimate®
    $196/sqft
    $7,198 Estimated rent

    Home value

    $2,108,700

    $2.00M - $2.21M

    $7,198/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $7,198/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,198/mo

    Rent Zestimate®

    Refinance and save

    $10,800/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $10,800/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    High-end finishes throughoutExpansive entertaining spaces
    Experience over 10,700 sq ft of refined living in this stunning 5-bedroom, 5-full-bath, 2-half-bath custom estate in Villa Hills. Designed for both elegance and comfort, this home features expansive entertaining spaces, high-end finishes throughout, and luxurious amenities inside and out. Situated on a premier lot with privacy and scenic views, this home blends sophistication with modern convenience. Recently reduced from $2,499,000 to $2,250,000, offering exceptional value for a property of this caliber. Perfectly located just 15 minutes from Cincinnati/Northern Kentucky International Airport and 15 minutes to downtown Cincinnati, this estate is ideal for executives, relocations, or those seeking the ultimate combination of luxury and convenience. Don't miss this rare opportunity — schedule your private showing today!

    Zillow last checked:

    Listing updated:

    Listed by:

    Melissa Van Treeck 859-393-6469,

    Simple Fee Realty,

    Jim Murray 859-802-3733,

    Simple Fee Realty

    Bought with:

    Natasha Maag, 273306

    Coldwell Banker Realty FM

    Source: NKMLS,MLS#: 639723MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 7
    • Full bathrooms: 5
    • 1/2 bathrooms: 2
    Primary bedroom
    • Features: Walk-Out Access, Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Tray Ceiling(s)
    • Level: First
    • Area: 437
    • Dimensions: 23 x 19
    Bedroom 2
    • Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Ceiling Fan(s)
    • Level: Second
    • Area: 350
    • Dimensions: 25 x 14
    Bedroom 3
    • Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Ceiling Fan(s)
    • Level: Second
    • Area: 286
    • Dimensions: 22 x 13
    Bedroom 4
    • Features: Carpet Flooring, Bath Adjoins
    • Level: Second
    • Area: 285
    • Dimensions: 19 x 15
    Bedroom 5
    • Description: walk-in closet
    • Features: Carpet Flooring, Bath Adjoins
    • Level: Lower
    • Area: 280
    • Dimensions: 20 x 14
    Bathroom 2
    • Features: Full Finished Bath, Shower With Bench, Soaking Tub, Tile Flooring
    • Level: Second
    • Area: 99
    • Dimensions: 11 x 9
    Bathroom 3
    • Features: Full Finished Bath, Shower, Tile Flooring
    • Level: Second
    • Area: 96
    • Dimensions: 16 x 6
    Bathroom 4
    • Features: Full Finished Bath, Shower With Bench, Tile Flooring
    • Level: Second
    • Area: 72
    • Dimensions: 9 x 8
    Bathroom 5
    • Features: Full Finished Bath, Shower, Tile Flooring
    • Level: Lower
    • Area: 66
    • Dimensions: 11 x 6
    Other
    • Description: walk-out acces
    • Features: Carpet Flooring, French Doors, Recessed Lighting
    • Level: Lower
    • Area: 551
    • Dimensions: 29 x 19
    Bonus room
    • Features: Recessed Lighting, Hardwood Floors
    • Level: Lower
    • Area: 135
    • Dimensions: 15 x 9
    Bonus room
    • Features: Recessed Lighting, Hardwood Floors
    • Level: Lower
    • Area: 108
    • Dimensions: 12 x 9
    Dining room
    • Features: Wood Flooring, Chandelier
    • Level: First
    • Area: 315
    • Dimensions: 21 x 15
    Entry
    • Features: Wood Flooring, Transom, Entrance Foyer
    • Level: First
    • Area: 442
    • Dimensions: 26 x 17
    Exercise room
    • Features: Ceiling Fan(s), Sound System
    • Level: Lower
    • Area: 255
    • Dimensions: 17 x 15
    Family room
    • Features: Fireplace(s), Wood Flooring, Recessed Lighting
    • Level: First
    • Area: 414
    • Dimensions: 23 x 18
    Game room
    • Level: Lower
    • Area: 441
    • Dimensions: 21 x 21
    Kitchen
    • Features: Wood Flooring, Kitchen Island, Gourmet Kitchen, Pantry, Wood Cabinets, Recessed Lighting, Hardwood Floors
    • Level: First
    • Area: 418
    • Dimensions: 22 x 19
    Living room
    • Features: Walk-Out Access, Fireplace(s), Wood Flooring
    • Level: First
    • Area: 420
    • Dimensions: 21 x 20
    Media room
    • Features: Sound System
    • Level: Lower
    • Area: 377
    • Dimensions: 29 x 13
    Office
    • Features: Wood Flooring, French Doors, Recessed Lighting
    • Level: First
    • Area: 169
    • Dimensions: 13 x 13
    Other
    • Features: Wood Flooring
    • Level: First
    • Area: 285
    • Dimensions: 15 x 19
    Other
    • Features: Hardwood Floors
    • Level: First
    • Area: 40
    • Dimensions: 8 x 5
    Other
    • Features: Ceramic Tile Flooring
    • Level: First
    • Area: 30
    • Dimensions: 6 x 5
    Other
    • Features: Ceramic Tile Flooring, Recessed Lighting
    • Level: Lower
    • Area: 190
    • Dimensions: 19 x 10
    Primary bath
    • Features: Ceramic Tile Flooring, Double Vanity, Shower, Soaking Tub
    • Level: First
    • Area: 208
    • Dimensions: 16 x 13
    Heating
    • Forced Air
    Cooling
    • Multi Units, Central Air
    Appliances
    • Included: Stainless Steel Appliance(s), Gas Cooktop, Gas Oven, Dishwasher, Disposal, Double Oven, Dryer, Microwave, Refrigerator, Washer
    • Laundry: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup
    Features
    • Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Sound System, Soaking Tub, Pantry, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Double Vanity, Crown Molding, Coffered Ceiling(s), Chandelier, Bookcases, Built-in Features, Beamed Ceilings, Butler's Pantry, Ceiling Fan(s), Central Vacuum, High Ceilings, Natural Woodwork, Recess Ceiling(s), Recessed Lighting, Sauna
    • Doors: Multi Panel Doors
    • Windows: Casement, Double Hung, Picture Window(s)
    • Basement: Full
    • Number of fireplaces: 2
    • Fireplace features: Stone, Gas, Marble
    Interior area
    • Total structure area: 10,700
    • Total interior livable area: 10,700 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Assigned, Driveway, Garage, Garage Door Opener, Garage Faces Side, Heated Garage, Oversized
    • Garage spaces: 3
    • Has uncovered spaces: Yes
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Covered, Patio, Porch
    • Exterior features: Private Yard, Fire Pit, Lighting, Outdoor Grill
    • Pool features: In Ground
    • Has spa: Yes
    • Spa features: Heated
    • Fencing: Wrought Iron,Full
    Lot
    • Size: 1.84 Acres
    • Features: Cleared, Level, Sprinklers In Front, Sprinklers In Rear, Wooded
    Details
    • Parcel number: 0134015018.00
    • Zoning description: Residential

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional
    • Property subtype: Single Family Residence, Residential
    Materials
    • Brick
    • Foundation: Poured Concrete
    • Roof: Slate
    Condition
    • Existing Structure
    • New construction: No
    • Year built: 2007

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Available, Natural Gas Available, Sewer Available, Underground Utilities, Water Available

    Community & HOA

    Community
    • Security: Security System, Smoke Detector(s)
    HOA
    • Has HOA: Yes
    • Services included: Association Fees
    • HOA fee: $224 annually
    Location
    • Region: Villa Hills

    Financial & listing details

    • Price per square foot: $196/sqft
    • Tax assessed value: $1,875,000
    • Annual tax amount: $18,581
    • Date on market: 4/3/2026
    • Cumulative days on market: 322 days
    • Road surface type: Paved

    Price history

    DateEventPrice
    5/29/2026Sold$2,100,000-6.7%$196/sqft
    Source: NKMLS #639723 Report a problem
    5/6/2026Pending sale$2,250,000$210/sqft
    Source: NKMLS #639723 Report a problem
    2/8/2026Listed for sale$2,250,000-10%$210/sqft
    Source: NKMLS #639723 Report a problem
    2/3/2026Listing removed$2,499,000$234/sqft
    Source: NKMLS #636438 Report a problem
    9/19/2025Listed for sale$2,499,000-9.1%$234/sqft
    Source: NKMLS #636438 Report a problem
    9/11/2025Listing removed$2,750,000$257/sqft
    Source: Huff Realty #633787 Report a problem
    6/25/2025Listed for sale$2,750,000$257/sqft
    Source: NKMLS #633787 Report a problem
    5/27/2025Listing removed$2,750,000$257/sqft
    Source: NKMLS #632193 Report a problem
    5/6/2025Listed for sale$2,750,000-8.2%$257/sqft
    Source: NKMLS #632193 Report a problem
    11/11/2024Listing removed$2,995,000$280/sqft
    Source: NKMLS #623365 Report a problem
    5/31/2024Listed for sale$2,995,000+59.7%$280/sqft
    Source: NKMLS #623365 Report a problem
    6/15/2018Sold$1,875,000-6.3%$175/sqft
    Source: Public Record Report a problem
    6/15/2018Listed for sale$2,000,000$187/sqft
    Source: Robinson Sotheby's Int. Realty #516637 Report a problem
    6/13/2018Pending sale$2,000,000$187/sqft
    Source: Robinson Sotheby's International Realty #516637 Report a problem
    6/13/2018Listed for sale$2,000,000+5.3%$187/sqft
    Source: Robinson Sotheby's International Realty #516637 Report a problem
    7/8/2017Sold$1,900,000-2.6%$178/sqft
    Source: Agent Provided Report a problem
    5/24/2017Pending sale$1,950,000$182/sqft
    Source: Florence #459718 Report a problem
    2/29/2016Price change$1,950,000-15.2%$182/sqft
    Source: Florence #452474 Report a problem
    7/17/2014Listed for sale$2,300,000+1252.9%$215/sqft
    Source: HUFF Realty, LLC #433578 Report a problem
    6/8/2006Sold$170,000$16/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$18,581 -3.3%$1,875,000
    2024$19,219 -3.8%$1,875,000
    2023$19,988 -2.4%$1,875,000
    2022$20,475 -2.1%$1,875,000
    2021$20,916 -1.4%$1,875,000
    2020$21,217 $1,875,000
    2019$21,217 +0.1%$1,875,000 -1.3%
    2018$21,200 $1,900,000 +46.2%
    2017$21,200 +54.6%$1,300,000
    2015$13,714 +1.7%$1,300,000
    2014$13,480 $1,300,000
    2013$13,480 $1,300,000 +8.3%
    2012-- $1,200,000 -20.8%
    2011-- $1,515,000
    2010-- $1,515,000
    2009-- $1,515,000
    2008-- $1,515,000 +791.2%
    2007-- $170,000 +13.3%
    2006-- $150,000
    2005-- $150,000
    2003-- $150,000
    2002-- $150,000
    2001-- $150,000
    Find assessor info on the county website

    Neighborhood: 41017

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: River Ridge Elementary
    • Middle: Turkey Foot Middle School
    • High: Dixie Heights High

    Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,108,700
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,108,700