About This Home
True 6 BEDROOM, 4 Full Bath SUPER UPGRADED Drees Brennan Model*Open Floor Plan With Beamed, Cathedral Ceilings In Both The Living Room And Kitchen*Living Room Features A Gas Fireplace And Plenty Of Natural Lighting From A Wall Of Windows*Gourmet Kitchen With Large Kitchen Island/Breakfast Bar, Carrara Mist (Polished) Quartz Countertops By MS International,6 Burner Gas Range, 42''Aristokraft Ellis Purestyle Colada Cabinetry, Upgraded Kitchen-Aid Stainless Steel Appliances, Spacious Butler's Pantry*Breakfast Room With Walk-Out To Covered, Raised Patio With Ceiling Fan And TV Hookups*Large Office With French Doors Adjacent To The Spacious Entry Foyer*First Floor Primary Bedroom With Adjoining, Large Primary Bath Featuring A Soaking Tub, Newport Bay Matte/Satin Tiled Shower with Moroccan Concrete Off White 1.5 Inch Hexagonal Tiled Shower Floor, Dual Silestone Miami White Quartz Top Vanities With Lots Of Extra Counter Space, AND, A 14'x12' Walk-In California Closet*Bedroom #2 Is Also On The First Floor*Upstairs Features A 16'x13' Loft Which Separates 3 Bedrooms (2 With Walk-In Closets) and A Full Finished Bathroom With Granite Countertop*Basement Features A Sizable Family Room, The 6th True Bedroom, and A Full Finished Bath With Quartz Countertop And Stand-Up Shower*Basement Also Includes A Workout Room With Rubber Gym Style Flooring*Unfinished Storage Space Measures In At Around 1200 ft/2, with Tankless Water Heater, Gas HVAC Unit, and Sump Pump With Backup Battery*Quality Fixtures Throughout Home*Lifeseal Rigid Core Luxury Vinyl Flooring*Backyard Is Closed In With Black,Aluminum Fencing and Contains Extra Patio Space With A Fire Pit*Home Is Wired For Data And Has Closed Circuit Surveillance Cameras*Seconds From Publix, Five Minutes From The New Union Promenade Featuring Restaurants and Businesses*20 Minutes To CVG Airport*25 Minutes To Downtown Cincinnati*To Build This Model Today, With Out The Upgrades, The Cost Would Be 890k*Instant Equity With This Purchase*
Home Highlights
Property Details
Interior Details
- Basement: Full
- Number of Rooms: 15
- Types of Rooms: Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Bathroom 2, Bathroom 3, Bathroom 4, Breakfast Room, Entry, Family Room, Gym, Kitchen, Laundry, Living Room, Office, Other Room, Primary Bath
- ✓ Wet Bar
Beds & Baths
- Number of Bedrooms: 6
- Number of Bathrooms: 4
- Number of Bathrooms (full): 4
Dimensions and Layout
- Living Area: 4462 Square Feet
Appliances & Utilities
- Utilities: Cable Available, Natural Gas Available, Sewer Available, Water Available
- Appliances: Stainless Steel Appliance(s), Gas Oven, Dishwasher, Disposal, Microwave, Refrigerator, Tankless Water Heater
- ✓ Dishwasher
- ✓ Disposal
- Laundry: Electric Dryer Hookup,Main Level,Washer Hookup
- ✓ Microwave
- ✓ Refrigerator
Heating & Cooling
- Heating: Has Heating Unspecified Type
- ✓ Has Cooling
- Air Conditioning: Central Air
- ✓ Has Heating
- Heating Fuel: Has Heating Unspecified Type
Fireplace & Spa
- Number of Fireplaces: 1
- Fireplace: Gas
- ✓ Has a Fireplace
Windows, Doors, Floors & Walls
- Window: Picture Window(s)
- Door: Multi Panel Doors
Levels, Entrance, & Accessibility
- Stories: 2
- Levels: Two
Security
- Security: Closed Circuit Camera(s)
Exterior Home Features
- Roof: Shingle
- Patio / Porch: Covered, Patio, Porch
- Fencing: Aluminum, Metal
- Exterior: Fire Pit
- Foundation: Poured Concrete
Parking & Garage
- Number of Garage Spaces: 2
- Number of Covered Spaces: 2
- ✓ No Carport
- ✓ Has a Garage
- ✓ Has an Attached Garage
- ✓ Has Open Parking
- Parking Spaces: 2
- Parking: Attached,Driveway,Garage,Garage Door Opener,Garage Faces Front
Frontage
- Road Frontage: City Street
- Road Surface Type: Paved
Water & Sewer
- Sewer: Public Sewer
Year Built
- Year Built: 2024
Property Type / Style
- Property Type: Residential
- Property Subtype: Single Family Residence, Residential
- Structure Type: House
- Architecture: Traditional
Building
- Construction Materials: HardiPlank Type, Stone
- ✓ Not a New Construction
- ✓ Not Attached Property
Property Information
- Condition: Existing Structure
- Parcel Number: 064.3407049.00
Price
- List Price: $835,000
- Price Per Sqft: $187
Direction & Address
- City: Union
School Information
- Elementary School: New Haven Elementary
- Jr High / Middle School: Gray Middle School
- High School: Ryle High
- High School District: Boone Co Public
Listing Agent
- Listing ID: 644907
Building Area
- Building Area: 5664 Square Feet
Mobile Home Park
- Mobile Home Units: Feet
Price History
| Date | Event | Price | Source |
|---|---|---|---|
| Jul 22, 2026 | Listed For Sale | $835,000 | NKMLS #644907 |