Please stand by!
USDAProperties.com is making sense of this chaotic market...

 

 

 

$2,995,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
944 Squire Oaks Dr
Villa Hills, KY 41017
5 bed 7 bath 10,700 SqFt ($279/SqFt)
1.84 acre lot. Built 2007
Listed 2024-05-31, HOA $15, Taxes $20,140
Ⓧ USDA Ineligible
due to price & location

near Villa Hills

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 boastng 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 workspa ce of unparalleled grace.

The lavish theatre room offers a billiard room, open bar and poker lounge. The fantastic 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 multiple 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. Nearby the Villa Madonna Academy, an award-winning private school, downtown Cincinnati and Covington. For more photos visit: hiddeninvillahills.com


Presented by Varun Varma at
Coldwell Banker Realty.
Listing Agent Photo

Property MLS #623365 from NKentucky

Total Rooms: 15
Bedroom 2: 13.00 x 17.00
Bedroom 2 Level: Second
Entry: 25.00 x 17.00
Entry Level: First
Primary Bedroom: 20.00 x 19.00
Primary Bedroom Level: First
Breakfast Room: 14.00 x 9.00
Breakfast Room Level: First
Laundry: 8.00 x 10.00
Laundry Level: First
Recreation Room: 30.00 x 31.00
Recreation Room Level: Basement
Game Room: 20.00 x 17.00
Game Room Level: Basement
Bonus Room: 9.00 x 13.00
Bonus Room Level: Basement
Gym: 14.00 x 17.00
Gym Level: Basement
Basement Features: Full, Finished, Bath/Stubbed, Storage Space, Walk-Out Access
Family Room Dimensions: 17.0 x 20.0
Living Room Dimensions: 17.0 x 20.0
Media Room Dimensions: 15.0 x 9.0
Office/Study Room Dimensions: 13.0 x 13.0
Extra Room-1 Level: Basement
Family Room Level: First
Game/Recreation Room Level: Basement
Living Room Level: First
Media Room Level: Basement
Office/Study Room Level: First
Basement Description: Full, Finished, Bath/Stubbed, Storage Space, Walk-Out Access

Stainless Steel Appliance(s)
Gas Oven
Dishwasher
Double Oven
Microwave
Refrigerator
Laundry Facilities: Main Level
Laundry Features: Main Level

Bedrooms: 5
Bedroom 2 Dimensions: 15.0 x 18.0
Bedroom 3 Dimensions: 25.0 x 14.0
Bedroom 5 Dimensions: 21.0 x 14.0
Primary Bedroom Level: First
Bedroom 2 Level: Second
Bedroom 3 Level: Second
Bedroom 5 Level: Basement

Total Bathrooms: 6
Full Bathrooms: 5
1/2 Bathrooms: 2

Kitchen Island
Wet Bar
Walk-In Closet(s)
Tray Ceiling(s)
Storage
Soaking Tub
Pantry
Open Floorplan
High Speed Internet
Granite Counters
Entrance Foyer
Eat-in Kitchen
Double Vanity
Crown Molding
Coffered Ceiling(s)
Chandelier
Bookcases
Built-in Features
Beamed Ceilings
Butler's Pantry
Ceiling Fan(s)
French Doors
High Ceilings
Multi Panel Doors
Natural Woodwork
Recess Ceiling(s)
Recessed Lighting
Vaulted Ceiling(s)
Flooring: Carpet
Window Features: Vinyl Frames

Cooling Features: Multi Units, Central Air
Fireplace Features: Stone, Ceramic, Gas
Heating Features: Natural Gas, Forced Air
Heating: Yes
Number of Fireplaces: 3

Breakfast Room Level: First
Dining Room Dimensions: 20.0 x 14.0
Dining Room Level: First
Kitchen Dimensions: 20.0 x 14.0
Kitchen Level: First

Pool Features: In Ground

Attached Garage: Yes
Garage Spaces: 3
Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side
Parking Total: 3

Patio And Porch Features: Covered, Patio
Road Frontage Type: City Street

Lot Size Acres: 1.84
Lot Size Dimensions: 1.84 acres
Lot Size Source: Assessor
Lot Size Square Feet: 80150

Association: Yes
Association Fee: 180
Association Fee Frequency: Annually
Calculated Total Monthly Association Fees: 15

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.3 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.4 miles away.
directions icon Map directions

Source Listing Status: Active
County: Kenton
Directions: Buttermilk Pike to Rosewood to Squire Oaks
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-018.00
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$1,705,000 + $170,000
$1,875,000
$20,140
2021$1,705,000 + $170,000
$1,875,000
$20,572
2020$1,705,000 + $170,000
$1,875,000
$20,794
2019$1,705,000 + $170,000
$1,875,000
$20,861
2018$1,730,000 + $170,000
$1,900,000
$21,199
2017$1,130,000 + $170,000
$1,300,000
$14,113
2016$1,130,000 + $170,000
$1,300,000
$13,873
2015$1,130,000 + $170,000
$1,300,000
$13,713
2014$1,130,000 + $170,000
$1,300,000
$13,480
2013$1,130,000 + $170,000
$1,300,000
$12,279
2012$1,030,000 + $170,000
$1,200,000
$11,833
2010$1,345,000 + $170,000
$1,515,000
$15,165
2009$1,345,000 + $170,000
$1,515,000
$15,043
2009$1,345,000 + $170,000
$1,515,000
$15,043
2008$1,345,000 + $170,000
$1,515,000
$14,771
2007$unknown + $170,000
$170,000
$1,660

Listed 2024-05-31
$2,995,000
NKentucky
Listing removed 2018-06-16
$2,000,000
NKentucky
Sold 2018-06-15
$1,875,000
Public Record
Listed 2018-06-12
$2,000,000
NKentucky
Sold 2017-08-11
$1,900,000
Public Record
Listing removed 2017-07-11
$1,950,000
NKentucky
Listing removed 2016-09-13
$1,950,000
NKentucky
Listed 2016-09-12
$1,950,000
NKentucky
Listed 2016-02-29
$1,950,000
NKentucky
Listing removed 2016-02-29
$2,300,000
NKentucky
Listed 2014-07-16
$2,300,000
NKentucky
Sold 2006-06-08
$170,000
Public Record

Total Square Feet Living: 10700
Year Built: 2007
Building Area Total: 10700
Building Exterior Type: Brick
Construction Materials: Brick
Foundation Details: Poured Concrete
Levels: Two
Living Area Units: Square Feet
Property Age: 17
Property Condition: Existing Structure
Roof: Shingle
Levels or Stories: Two
Total Area Sqft: 10700
Architectural Style: Traditional

Sewer: Public Sewer
Cable Available
Natural Gas Available
Water Available
Water Source: Public

Other Equipment: Home Theater
Click Thumbnail Images To View Full Size
house_viewhouse_viewhouse_viewunknownunknown
porchporchunknownporchporch
house_viewunknownunknownliving_roomliving_room
living_roomdining_roomdining_roomdining_roomliving_room
living_roomkitchenkitchenliving_roomunknown
unknownliving_roomliving_roombedroombedroom
bedroombedroombedroombedroombathroom
bathroombathroomunknownporchliving_room
dining_roomunknownliving_roomunknownunknown
dining_roomunknownporchunknowngarage

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.