Welcome to Country Squire Estates! This exceptional 5-bedroom, 4-full and 2-half-bath home offers over 4,000 sq. ft. of beautifully finished living space in one of Villa Hills' most desirable locations. Situated on a quiet cul-de-sac street with a turnaround driveway and no HOA fees, this home offers an ideal combination of space, comfort, and privacy.
The main level features beautiful natural woodwork, granite countertops, a spacious study, and an inviting floor plan designed for everyday living and entertaining. The lower level provides even more versatility with a full bedroom and full bath, making it perfect for guests, extended family, a private retreat, or someone needing first-floor-style living for either a short-term or permanent stay. An additional exercise room and generous finished space provide plenty of options to fit your lifestyle.
Step outside to your own private oasis! The fully fenced wrought-iron yard features an inground pool, patio cover, and deck, creating the perfect setting for summer gatherings, relaxing, and entertaining.
Additional highlights include brand-new gutters in 2026, ample living and storage space, and a location that puts you close to shopping, dining, parks, and all that Villa Hills has to offer. To provide additional peace of mind, the seller is offering a one-year home warranty.
A rare opportunity to own a spacious and versatile home in the highly sought-after Country Squire Estates--come see all this property has to offer!
Pending
$1,100,000
804 Windgate, Villa Hills, KY 41017
5beds
4,109sqft
Single Family Residence, Residential
Built in 1991
0.89 Acres Lot
$-- Zestimate®
$268/sqft
$-- HOA
What's special
Inground poolPatio coverBeautiful natural woodworkGenerous finished spaceSpacious studyAdditional exercise roomGranite countertops
- 69 days
- 174
- 2
Zillow last checked:
Listing updated:
Listed by:
Krista Crone 859-391-1950,
Coldwell Banker Realty FM
Source: NKMLS,MLS#: 645294
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Features: Walk-In Closet(s), Window Treatments, Bath Adjoins, Carpet Flooring, Dressing Area
- Level: Second
- Area: 252
- Dimensions: 21 x 12
Bedroom 2
- Description: Jack & Jill Bathroom
- Features: Bath Adjoins, Carpet Flooring, Window Treatments
- Level: Second
- Area: 132
- Dimensions: 12 x 11
Bedroom 3
- Description: Jack & Jill Bathroom
- Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins
- Level: Second
- Area: 132
- Dimensions: 12 x 11
Bedroom 4
- Features: Carpet Flooring
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Bedroom 5
- Description: Lower Level
- Features: Carpet Flooring
- Level: Lower
- Area: 169
- Dimensions: 13 x 13
Den
- Features: Bookcases, Built-in Features
- Level: First
- Area: 130
- Dimensions: 13 x 10
Dining room
- Features: Hardwood Floors, Window Treatments, Chair Rail
- Level: First
- Area: 180
- Dimensions: 15 x 12
Entry
- Features: Tile Flooring, Entrance Foyer
- Level: First
- Area: 143
- Dimensions: 13 x 11
Exercise room
- Description: carpet flooring
- Features: See Remarks
- Level: Lower
- Area: 165
- Dimensions: 15 x 11
Game room
- Features: Walk-Out Access
- Level: Lower
- Area: 345
- Dimensions: 23 x 15
Kitchen
- Features: Walk-Out Access, Planning Desk, Pantry, Kitchen Island, Solid Surface Counters, Recessed Lighting, Wood Flooring, Wood Cabinets
- Level: First
- Area: 210
- Dimensions: 15 x 14
Laundry
- Features: Tile Flooring, Utility Sink, Walk-Out Access
- Level: First
- Area: 81
- Dimensions: 9 x 9
Living room
- Features: Window Treatments, Carpet Flooring
- Level: First
- Area: 169
- Dimensions: 13 x 13
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Electric Cooktop, Electric Oven, Dishwasher, Disposal, Microwave, Refrigerator, Trash Compactor
- Laundry: Laundry Room, Main Level
Features
- Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Stone Counters, Soaking Tub, Pantry, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Bookcases, Breakfast Bar, Built-in Features, Butler's Pantry, Ceiling Fan(s), High Ceilings, Natural Woodwork, Recessed Lighting
- Doors: Multi Panel Doors
- Windows: Bay Window(s), Slider Window(s), Wood Frames
- Basement: Other,See Remarks
- Number of fireplaces: 2
- Fireplace features: See Remarks, Stone, Wood Burning
Interior area
- Total structure area: 4,109
- Total interior livable area: 4,109 sqft
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Enclosed, Patio, Porch
- Exterior features: Private Yard, Lighting
- Pool features: In Ground
- Has spa: Yes
- Spa features: Heated
- Fencing: Wrought Iron
- Has view: Yes
- View description: Neighborhood, Trees/Woods
Lot
- Size: 0.89 Acres
- Dimensions: 4792
- Features: Cul-De-Sac
- Residential vegetation: Partially Wooded
Details
- Additional structures: Pergola, Shed(s)
- Parcel number: 0133000153.15
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Brick
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- Existing Structure
- New construction: No
- Year built: 1991
Details
- Warranty included: Yes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Security System, Smoke Detector(s)
- Subdivision: Country Squire Estates
HOA
- Has HOA: No
Location
- Region: Villa Hills
Financial & listing details
- Price per square foot: $268/sqft
- Tax assessed value: $916,200
- Annual tax amount: $9,080
- Date on market: 8/24/2026
- Cumulative days on market: 69 days
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 9/29/2026 | Pending sale | $1,100,000$268/sqft |
Source:  NKMLS #645294 Report a problem | ||
| 9/21/2026 | Listed for sale | $1,100,000$268/sqft |
Source: NKMLS #645294 Report a problem | ||
| 9/2/2026 | Pending sale | $1,100,000$268/sqft |
Source: NKMLS #645294 Report a problem | ||
| 8/3/2026 | Listed for sale | $1,100,000+67.9%$268/sqft |
Source: NKMLS #645294 Report a problem | ||
| 4/19/2013 | Sold | $655,000-6.3%$159/sqft |
Source: Public Record Report a problem | ||
| 1/30/2013 | Price change | $699,000-3.6%$170/sqft |
Source: HUFF Realty, LLC #408383 Report a problem | ||
| 9/12/2012 | Price change | $725,000-3.2%$176/sqft |
Source: HUFF Realty, LLC #408383 Report a problem | ||
| 7/27/2012 | Price change | $749,000-3.4%$182/sqft |
Source: HUFF Realty, LLC #408383 Report a problem | ||
| 5/19/2012 | Listed for sale | $775,000$189/sqft |
Source: HUFF Realty, LLC #408383 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,080 -3.3% | $916,200 |
| 2024 | $9,391 +27.7% | $916,200 +32.8% |
| 2023 | $7,353 -2.4% | $689,800 |
| 2022 | $7,533 -2.1% | $689,800 |
| 2021 | $7,695 -2% | $689,800 |
| 2020 | $7,853 | $689,800 +6.1% |
| 2019 | $7,853 +7.5% | $650,000 |
| 2018 | $7,302 | $650,000 |
| 2017 | $7,302 +6% | $650,000 |
| 2015 | $6,887 +1% | $650,000 -0.8% |
| 2014 | $6,822 | $655,000 |
| 2013 | $6,822 | $655,000 -14.4% |
| 2012 | -- | $765,000 |
| 2011 | -- | $765,000 |
| 2010 | -- | $765,000 |
| 2009 | -- | $765,000 |
| 2008 | -- | $765,000 +24.4% |
| 2007 | -- | $615,000 |
| 2006 | -- | $615,000 |
| 2005 | -- | $615,000 |
| 2004 | -- | $615,000 |
| 2003 | -- | $615,000 |
| 2002 | -- | $615,000 |
| 2001 | -- | $615,000 |
| 2000 | -- | $615,000 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 41017
Nearby schools
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.
Similar homes
- $1,174,9504 bd3 ba3.7k sqft2612 Amsterdam Rd, Villa Hills, KY 41017For Sale
MLS ID #643903, Joseph Lockaby, ERA Real Solutions Realty. NKMLS - $1,200,0006 bd7 ba5.8k sqft109 Brittany Ct, Lakeside Park, KY 41017For Sale
MLS ID #647786, Susan Huff, Huff Realty - Florence. NKMLS - $765,0004 bd4 ba2.9k sqft2620 Marlo Way, Lakeside Park, KY 41017For Sale
MLS ID #647978, Sharon Hilinski, Sibcy Cline, REALTORS-Florence. NKMLS - $999,9904 bd4 ba2.3k sqft4412 Grove Ave, Cincinnati, OH 45227For Sale
MLS ID #1898761, Michael W. Jordan, Jordan, Inc.. Cincy MLS - $1,195,0004 bd5 ba3.9k sqft1046 Tuscany Pl, Cincinnati, OH 45226For SaleMLS ID #1892320, Elijah Price, Coldwell Banker Realty. Cincy MLS
- $1,190,3334 bd4 ba4k sqft5800 Windsong Ct, Cincinnati, OH 45243For Sale
MLS ID #970693, Tammy Doughman, Coldwell Banker Heritage. DABR MLS - $1,295,0005 bd5 ba4.1k sqft3914 Middleton Ct, Cincinnati, OH 45220For SaleMLS ID #1893224, Lee G. Robinson, Robinson Sotheby's Internat'l. Cincy MLS
- $980,0005 bd5 ba5.2k sqft8188 Wycliffe Dr, Cincinnati, OH 45244For SaleMLS ID #1891972, Laura Connock, Coldwell Banker Realty. Cincy MLS
- $950,0005 bd4 ba4.1k sqft7350 Willowbrook Ln, Cincinnati, OH 45237For SaleMLS ID #1896139, Diane Tafuri, Sibcy Cline, Inc.. Cincy MLS
