Property Attributes
- MLS#646262
- TypeSingle Family
- Listing Status Active
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodOther
- Zip41091
- StyleRanch
- Year Built2026
- Price$ 547,048
- Bedrooms3
- Full Bathrooms3
- Half Bathrooms0
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
One-level living translates beautifully in the McKenzie floor plan. From the welcoming foyer, you'll view an open arrangement of the family room, kitchen with island and walk-in pantry, and dining area - a great space for relaxing or entertaining friends and family. A secluded primary suite is tucked away in the rear of the home offering all the privacy you'll need. Off the main foyer are a secondary bedroom, a home office and a full bath. As you enter from the garage, you'll find a family foyer with storage bench and laundry room. The lower level is completed with a recreation room, full batn and third bedroom for ultimate privacy.
| Elementary School | Middle School | High School |
|---|---|---|
| Longbranch Elementary School | Ballyshannon Middle School Middle School | Cooper High School High School |
| Price History | |
|---|---|
| 9/2/2026 | Listed $547,048 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Natural Gas |
| Cooling | Central Air |
| Utilities | Cable Available,Natural Gas Available,Sewer Available,Water Available |
| Roof | Shingle |
| HOA Fee | 1100 |
| Garage Spaces | 2 |
| Association Fee Includes | Association Fees,Maintenance Grounds,Snow Removal |
| Patio/Porch Features | Patio |
| Architectural Style | Ranch |
| Construction Materials | HardiPlank Type,Brick,Vinyl Siding |
| Year Built | 2026 |
| Electric | 220 Volts |
| Levels | One |
| Property Subtype | Patio Home |
| Assoc Fee Paid Per | Annually |
| County | Boone |
| New Construction | true |
| Property Type | Residential |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Other |
| Garage Y/N | true |
| Total Rooms | 13 |
| Status | Active |
| Directions | Highway US 42 south to Orleans Blvd. Go west/NW to west on Longbranch Rd., to west on Ballyshannon Way, south to Westbrook Blvd., then east on Marais Drive. |
| High School | Cooper High School |
| City | Union |
| Zoning Description | Residential |
| MLS Area | K11 - Richwd/Un/Wal/Ver/SB |
| Elementary School | Longbranch |
| Property Attached Y/N | false |
| Middle/Junior High School | Ballyshannon Middle School |
| MLS Area Minor | K11 - Richwd/Un/Wal/Ver/SB |
| Structure Type | House |
| Standard Status | Active |
Interior Features
| Interior Amenities | Kitchen Island,Walk-In Closet(s),Storage,Stone Counters,Smart Thermostat,Smart Home,Pantry,Open Floorplan,Entrance Foyer,Eat-in Kitchen,Double Vanity,Built-in Features,Attic Storage,Ceiling Fan(s),High Ceilings,Vaulted Ceiling(s),Wired for Data |
|---|---|
| Basement | Full |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Vinyl Frames |
| Fireplace Y/N | false |
| Total Baths | 3 |
Exterior Features
| Parking Features | Attached,Driveway,Garage,Garage Door Opener,Garage Faces Front |
|---|---|
| Water Source | Public |
| Total Parking | 2 |
| Foundation Details | Poured Concrete |
| Lot Dimensions | Irregular |
| Lot Size Source | Builder |
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 14, 2026 4:42 AM 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