Property Attributes
- MLS#639467
- TypeSingle Family
- Listing Status Active
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodOther
- Zip41091
- StyleRanch
- Year Built2025
- Price$ 659,900
- Bedrooms3
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage3339
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
The Hialeah showcases an open arrangement of the large family room with a gas fireplace, spectacular kitchen with generous island and a spacious dining area. Expand your living with a covered outdoor area. Relaxing is easy in your secluded primary suite which includes a luxurious bath ad large walk0in closet. For quiet times, a home office from the main foyer is a perfect retreat. This ranch is complete with a finished lower level rec room with den/bedroom and full bath.
| Elementary School | Middle School | High School |
|---|---|---|
| Longbranch Elementary School | Ballyshannon Middle School Middle School | Cooper High School High School |
| Price History | |
|---|---|
| 6/29/2026 | Listed $684,606 |
| 7/20/2026 | 1$674,900 |
| 8/11/2026 | 1$669,900 |
| 9/4/2026 | 1$659,900 |
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 |
| Patio/Porch Features | Patio |
| Architectural Style | Ranch |
| Construction Materials | HardiPlank Type,Concrete,Stone,Vinyl Siding |
| Year Built | 2025 |
| Electric | 220 Volts |
| Levels | One |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Monthly |
| County | Boone |
| New Construction | true |
| Property Type | Residential |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Other |
| Garage Y/N | true |
| Total Rooms | 14 |
| Status | Active |
| Directions | From I-75 S take US 42 SW. Turn right onto Old Union Rd. Turn right on Longbranch Rd. Turn left on Ballyshannon Way. Turn left into the entrance on Westbrook Blvd. |
| 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,Cathedral Ceiling(s),High Ceilings,Wired for Data |
|---|---|
| Basement | Full |
| Total Fireplaces | 1 |
| Fireplace Features | Gas |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Vinyl Frames |
| Fireplace Y/N | true |
| 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 |
| Building Area Total | 3339 |
| 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 The LAZO Group are marked with the BR logo and detailed information about them includes the name of the listing brokers. Listing broker has attempted to offer accurate data, but buyers are advised
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 The LAZO Group 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 by the property owner in good faith
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