Property Attributes
- MLS#644214
- TypeSingle Family
- Listing Status Pending
- CountyKenton
- CityVilla Hills
- AreaCr Sp-Cr Pk-Ft Wr-Kent Hi-Park Hi-Villa Hi
- NeighborhoodCountry Squire Estates
- Zip41017
- StyleRanch
- Year Built2007
- Price$ 1,770,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage5595
- Lot Size0.71 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
Welcome home to this extraordinary custom-built brick and stone ranch by Toebben Builders, perfectly situated in the prestigious Country Squire Estates. Lovingly maintained by its original owners, this exceptional 5-bedroom, 4.5-bath home offers timeless craftsmanship, luxurious amenities, and thoughtful updates throughout. Inside, you'll find gleaming hardwood floors, newer carpet in the living room, extensive crown molding, tray ceilings, stately columns, and elegant arched doorways. The beautifully renovated kitchen (2017) features custom wood cabinetry, granite countertops, stainless steel appliances, a stunning walnut butcher block island, pantry, and a coffee bar with water hookup. A 2013 addition created a spacious mudroom with custom built-ins, granite countertops, utility sink, planning desk, and direct access to the attached garage. Designed for entertaining, the backyard is a private retreat featuring a heated 30' x 15' in-ground pool with attached hot tub, plus an expansive covered patio complete with a built-in grill, refrigerator, and impressive stone fireplace. The oversized 4-car garage addition includes a workshop and a private guest suite with a full bath and walk-in closet. Recent updates include the HVAC (4 years), water heater (2 years), roof (12 years), and the added security of a whole-house generator. This one-of-a-kind home seamlessly blends quality construction, elegant design, and modern convenience in one of the area's most desirable neighborhoods. A truly rare opportunity that must be seen to be fully appreciated. Preapproval/POF required prior to showing confirmation.
| Elementary School | Middle School | High School |
|---|---|---|
| River Ridge Elementary Elementary School | Turkey Foot Middle School Middle School | Dixie Heights High High School |
| Price History | |
|---|---|
| 7/1/2026 | Listed $1,770,000 |
General Features
| Living Area | 5595 |
|---|---|
| Sewer | Public Sewer |
| Heating | Natural Gas,Forced Air |
| Cooling | Central Air |
| Roof | Shingle |
| HOA Fee | 260 |
| Garage Spaces | 5 |
| Association Fee Includes | Association Fees,Maintenance Grounds |
| Patio/Porch Features | Covered,Patio,Porch |
| Architectural Style | Ranch |
| Pool Features | In Ground |
| Security Features | Closed Circuit Camera(s),Smoke Detector(s) |
| Construction Materials | Brick,Stone |
| Year Built | 2007 |
| View | Neighborhood,Trees/Woods |
| Levels | One |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Annually |
| County | Kenton |
| New Construction | false |
| Property Type | Residential |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Country Squire Estates |
| Garage Y/N | true |
| Other Structures | Garage(s),Guest House,Workshop |
| Total Rooms | 16 |
| Status | Pending |
| Directions | I-75 to Buttermilk. RIGHT on Collins. RIGHT on Amsterdam. RIGHT on Squire Oaks - Home is on the RIGHT |
| High School | Dixie Heights High |
| City | Villa Hills |
| Zoning Description | Residential |
| MLS Area | K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi |
| Lot Size Units | Acres |
| Lot Size Square Feet | 30928 |
| Elementary School | River Ridge Elementary |
| Property Attached Y/N | false |
| Home Warranty Y/N | false |
| Middle/Junior High School | Turkey Foot Middle School |
| Property Condition | Existing Structure |
| MLS Area Minor | K07 - Cr Sp/Cr Pk/Ft Wr/Kent Hi/Park Hi/Villa Hi |
| Virtual Tour | https://listings.nextdoorphotos.com/vd/254316276 |
| Structure Type | House |
| Living Area Units | Square Feet |
| Standard Status | Pending |
Interior Features
| Interior Amenities | Kitchen Island,Walk-In Closet(s),Tray Ceiling(s),Storage,Stone Counters,Soaking Tub,Pantry,Open Floorplan,Granite Counters,Entrance Foyer,Eat-in Kitchen,Double Vanity,Crown Molding,Chandelier,Bookcases,Breakfast Bar,Built-in Features,Attic Storage,Ceiling Fan(s),High Ceilings,Multi Panel Doors,Natural Woodwork,Recessed Lighting |
|---|---|
| Basement | Full Finished Bath,Full,Finished,Storage Space,Walk-Out Access |
| Total Fireplaces | 2 |
| Fireplace Features | Stone,Gas |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Insulated Windows,Casement |
| Fireplace Y/N | true |
| Laundry Features | Laundry Room,Main Level |
| Total Baths | 5 |
Exterior Features
| Exterior Amenities | Outdoor Kitchen,Private Yard,Hot Tub,Outdoor Grill,Other |
|---|---|
| Parking Features | Attached,Driveway,Garage,Garage Door Opener,Garage Faces Front,Garage Faces Side,Oversized |
| Lot Features | Cleared,Level,Sprinklers In Front,Sprinklers In Rear |
| Water Source | Public |
| Lot Size Area | 0.71 |
| Foundation Details | Poured Concrete |
| Building Area Total | 5595 |
| Lot Dimensions | 30,928 |
| Lot Size Acres | 0.71 |
| Lot Size Source | Realist |
| Door Features | French Doors |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Data last updated: September 20, 2026 7:44 PM UTC and updating occurs daily
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of Metro Search, Inc. Real estate listings held by brokerage firms other than United Real Estate Louisville are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about each listing includes the name of the listing broker.
© 2026 Metro Search, Inc.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided 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. The data relating
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program. Real estate listings held by IDX Brokerage firms other than United Real Estate Louisville are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing IDX Brokers. This information is provided exclusively for personal, non-commercial use and may not be used for any purpose other than to
REALTOR® Association of Southern Kentucky All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
Heart of Kentucky Association of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating