NOT LISTED FOR SALE

941 Rosewood Dr Villa Hills, KY 41017

Estimated Value: $1,952,216 - $2,471,000

5 Beds
7 Baths
-- Sq Ft
1.2 Acres

Last Sold June 28, 2021

Last sale price $1,900,000

Est. 16% increase in value since last sale

Current estimated payment $13,258/month

56 Days on Market

Highlights

  • Wine Cellar
  • In Ground Pool
  • View of Trees or Woods
  • River Ridge Elementary School Rated A-
  • Eat-In Gourmet Kitchen
  • Granite Flooring

About This Home

As of June 2021

Executive Masterpiece in prestigious Country Squire Estates! Handcrafted finishes, elaborate amenities & not a single detail overlooked! Expansive living areas w/1st Floor Master Suite, stunning 2-story study, gourmet kitchen & jaw dropping lower level. An entertainer's dream w/lavish bar, 800-bottle wine cellar, media + game rooms & walkout to a private oasis featuring saltwater pool, chef's bbq & multiple covered lounge areas! State of the art electronics inside & out & spacious gym w/full bath. 5-car oversized garage w/mahogany doors. True 5-star resort style living in this timeless estate!

Last Agent to Sell the Property

Susan Huff

Huff Realty - Florence License #181847 Listed on: 03/29/2021

Huff Realty - Florence

Co-Listed By

Joey Zembrodt

Huff Realty - Florence License #206943

Last Buyer's Agent

Douglas Manzler

Keller Williams Advisors License #214172

Keller Williams Advisors

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $19,475

Year Built

  • Built in 2006

Lot Details

  • 1.2 Acre Lot
  • Cul-De-Sac
  • Aluminum or Metal Fence
  • Front and Back Yard Sprinklers

HOA Fees

  • $14 Monthly HOA Fees

Parking

  • 5 Car Garage
  • Driveway
  • On-Street Parking
  • Off-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 2-Story Property
  • Wired For Sound
  • Wired For Data
  • Bookcases
  • Chair Railings
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Tray Ceiling
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Marble Fireplace
  • Stone Fireplace
  • Gas Fireplace
  • Insulated Windows
  • Window Treatments
  • Picture Window
  • Wood Frame Window
  • French Doors
  • Panel Doors
  • Wine Cellar
  • Family Room with Fireplace
  • 3 Fireplaces
  • Great Room
  • Living Room with Fireplace
  • Formal Dining Room
  • Loft
  • Bonus Room
  • Views of Woods
  • Storage In Attic

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Carpet
  • Granite
  • Marble
  • Slate Flooring
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Dressing Area
  • Dual Vanity Sinks in Primary Bathroom
  • Primary Bathroom Bathtub Only
  • Primary Bathroom includes a Walk-In Shower

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Home Security

  • Home Security System
  • Fire and Smoke Detector

Eco-Friendly Details

  • Air Purifier

Outdoor Features

  • In Ground Pool
  • Deck
  • Covered Patio or Porch
  • Exterior Lighting
  • Outdoor Grill

Schools

  • River Ridge Elementary School
  • Turkey Foot Middle School
  • Dixie Heights High School

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Cable TV Available

Community Details

  • Country Squire Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 013-30-02-217.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$19,475

Year Built

Built in 2006

Lot Details

0

HOA Fees

$14 per month

Parking

5

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 1.2
  • Year Built: 2006
  • Lot Size: --
  • Co List Office Mls Id: o432500054
  • Co List Office Phone: 859-525-7900
  • Subdivision Name: Country Squire Estates
  • Directions: Buttermilk Pike to Right on Rosewood (Country Squire Estates)
  • Architectural Style: Traditional
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: River Ridge Elementary
  • Location Tax Legal Info:Middle or Junior School: Turkey Foot Middle School
  • Location Tax Legal Info:High School: Dixie Heights High
  • Location Tax Legal Info:Subdivision2: Country Squire Estates
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 2
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: --
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • Water Company: NKY Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 1.2
  • General Property Description:Lot Size Square Feet: 52272.0
  • Structure Type:House: Yes
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Room Type:Loft3: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 013-30-02-217.00
  • Appliances Refrigerators: Yes
  • General Property Description:Fireplaces Total: 3
  • View:TreesWoods: Yes
  • Room Type:Bonus Room2: Yes
  • Percent Basement Finished: Yes
  • Other Equipment:Humidifier: Yes
  • Room Type:Great Room4: Yes
  • Security Features:Security System: Yes
  • Pool Features:In Ground: Yes
  • Fencing:Metal4: Yes
  • Other Equipment:Air Purifier: Yes
  • Room Type:Wine Cellar: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Crown Molding, Attic Storage, Beamed Ceilings, Ceiling Fan(s), French Doors, High Ceilings, Multi Panel Doors, Natural Woodwork, Recess Ceiling(s), Recessed Lighting, Wired for Data, Wired for Sound
  • Basement: Full, Finished, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator
  • Other Equipment: Air Purifier, Humidifier
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Total Bedrooms: 5
  • Fireplace Features: Stone, Gas, Marble
  • Fireplaces: 3
  • Fireplace: Yes
  • Window Features: Insulated Window(s), Picture Window(s), Wood Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Wired for Data: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Basement:Walk-Out Access7: Yes
  • Interior Features:French Doors: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Natural Woodwork: Yes
  • Basement:Fireplace(s)7: Yes
  • Interior Features:Crown Molding: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Family Room Features:Fireplace(s)4: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Living Room Features:Carpet Flooring2: Yes
  • Family Room Features:Window Treatments4: Yes
  • Interior Features:Attic Storage: Yes
  • Living Room Features:Fireplace(s): Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Kitchen Features:Window Treatments3: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Interior Features:Wired for Sound: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Marble Flooring2: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Fireplace Features:Stone4: Yes
  • Interior Features:Recess Ceiling(s): Yes
  • Primary Bath Features:Ceramic Tile Flooring: Yes
  • Appliances Range: Yes
  • Kitchen Features:Granite Flooring2: Yes
  • Kitchen Features:Slate Flooring2: Yes
  • Dining Room Features:Window Treatments2: Yes
  • Primary Bath Features:Tub: Yes
  • Family Room Features:Wood Flooring5: Yes
  • Interior Features:Beamed Ceilings: Yes
  • Primary Bedroom Features:Dressing Area: Yes
  • Primary Bath Features:Granite Flooring3: Yes
  • Primary Bath Features:Marble Flooring3: Yes
  • Primary Bath Features:Slate Flooring3: Yes
  • Family Room Features:Bookcases2: Yes
  • Primary Bath Features:Window Treatments7: Yes
  • Dining Room Features:Chair Rail: Yes
  • Fireplace Features:Marble: Yes

Exterior Features

  • View: Trees/Woods
  • Fencing: Metal
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear
  • Pool Features: In Ground
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Lighting, Outdoor Grill
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Patio
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Window Features:Picture Window(s): Yes
  • Lot Features:Cul-De-Sac: Yes
  • Exterior Features:Lighting: Yes
  • Window Features:Wood Frames: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Exterior Features:Outdoor Grill: Yes
  • Lot Features:Sprinklers In Rear: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Off Street, On Street
  • General Property Description:Garage Spaces: 5.0
  • Parking Features:Driveway: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:On Street: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Security: Security System, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association Fee: 162.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: NA
  • Association Information:Association Management Phone 1: Na
  • Association Information:Association Fee: 162.0
  • Association Information:Association Fee Frequency: Annually

Schools

  • Elementary School: River Ridge Elementary
  • Junior High Dist: Kenton Co Public
  • High School: Dixie Heights High
  • Middle Or Junior School: Turkey Foot Middle School

Lot Info

  • Lot Size Sq Ft: 52272.0
  • Zoning Description: {"Residential":true}
  • ResoLotSizeUnits: Acres

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 29, 2021
Closed on
Aug 23, 2021
Sold by
Wagner Michael Anthony
Bought by
Wagner Michael Anthony and Wagner Michael Anthony
Seller's Agent
Susan Huff
Huff Realty - Florence
Buyer's Agent
Douglas Manzler
Keller Williams Advisors
List Price
$2,100,000
Sold Price
$1,900,000
Premium/Discount to List
-$200,000
-9.52%
Current Estimated Value
$2,209,304

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$309,304
Avg. Annual Appreciation
3.54%

Purchase Details

Listed on
Mar 29, 2021
Closed on
Jun 28, 2021
Sold by
Way Brian J and Way Alison R
Bought by
Wagner Michael Anthony
Seller's Agent
Susan Huff
Huff Realty - Florence
Buyer's Agent
Douglas Manzler
Keller Williams Advisors
List Price
$2,100,000
Sold Price
$1,900,000
Premium/Discount to List
-$200,000
-9.52%

Purchase Details

Closed on
Dec 13, 2013
Sold by
Way Brian J and Way Alison R
Bought by
Way Alison R

Purchase Details

Closed on
Jun 30, 2004
Sold by
Toebben Builders & Developers Inc
Bought by
Way Brian J and Way Alison R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$170,000
Interest Rate
6.25%
Mortgage Type
Seller Take Back
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Wagner Michael Anthony -- None Available
Wagner Michael Anthony $1,900,000 None Available
Way Alison R -- None Available
Way Brian J $170,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Way Brian J $170,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/28/2021 06/28/21 Sold $1,900,000 -9.5% --
05/24/2021 05/24/21 Pending -- -- --
03/29/2021 03/29/21 For Sale $2,100,000 -- --
Source: Northern Kentucky Multiple Listing Service

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $19,475 $1,900,000 $175,000 $1,725,000
2023 $20,254 $1,900,000 $170,000 $1,730,000
2022 $20,408 $1,900,000 $170,000 $1,730,000
2021 $16,473 $1,500,000 $170,000 $1,330,000
2020 $10,573 $950,000 $170,000 $780,000
2019 $10,607 $950,000 $170,000 $780,000
2018 $10,637 $950,000 $170,000 $780,000
2017 $10,334 $950,000 $170,000 $780,000
2015 $9,875 $934,500 $170,000 $764,500
2014 $9,707 $934,500 $170,000 $764,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 547145

Northern Kentucky Multiple Listing Service

APN: 013-30-02-217.00