Property Attributes
- MLS#646262
- TypeSingle Family
- Listing Status Pending
- 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 | Pending |
| 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 | Pending |
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
© 2026 Dayton Area Board of Realtors. All rights reserved. Information deemed to be reliable but not guaranteed. The data relating to real estate for sale on this website comes from Dayton Area Board of Realtors and the Broker Reciprocity Program.sm. Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices Professional Realty are marked with the BR logo and detailed information about them includes the name of the listing brokers. Listing broker has attempted to
The data relating to real estate for sale on this web site comes
in part from the Broker Reciprocity™ program of the Multiple
Listing Service of Greater Cincinnati. Real estate listings held by
brokerage firms other than Berkshire Hathaway HomeServices Professional Realty are marked with the MLS ™ logo
(the small logo to the left) and detailed information about them includes
the name of the listing brokers. The information herein is furnished
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
© MLS Now, INC - Northern Ohio Regional Multiple Listing Service 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
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. Information on this
Columbus REALTOR® and Central Ohio Regional Multiple Listing Service, 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 consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective
West Central 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 be
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of Western Regional Information Systems and Technology, Inc. Real estate listings held by brokerage firms other than this site owner are marked with the IDX logo. "WRIST, Inc. deems information reliable but not guaranteed."
Copyright 2026 of Western Regional Information Systems and Technology, Inc. All rights reserved.
This content last refreshed on September 24, 2026 2:58 PM UTC
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawl. Neither listing broker(s) nor SE IN BD REALTORS shall be held responsible for typographical errors, misinformation, misprints and shall be held totally harmless.
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2017 All rights reserved.
Greater Erie Board of Realtors® 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 consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
Ashland Board Of Realtors® (AOBOR)
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
Kanawha Valley Board 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 be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices Professional Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright ©2026 All rights reserved.
Last Updated: September 24, 2026 2:56 PM UTC