Clay Horan
Horan Rosenhagen Real Estate
(513) 866-2497
61 Total Sales
1 in Union
$240,000 Price
2009 Mayfield Ct Union, KY 41091
Union Area
4
Beds
2.5
Baths
3,273
Sq Ft
0.52
Acre Lot
Highlights
- New Construction
- 0.52 Acre Lot
- Loft
- Shirley Mann Elementary School Rated A
- Traditional Architecture
- Great Room
About This Home
As of March 2024Brand New, energy efficient home by Arlinghaus Builders under construction in the Westbrook community. Popular Marietta flr plan situated on a 1/2 acre lot on small cul de sac street. This home is perfect for entertaining with gourmet open kitchen and family room with gas fireplace. Amenities include LVP flooring, granite kitchen counters, double ovens, walk in pantry, mudroom w/ cubbies, 3rd car garage, formal dining room, private study with french doors, owners suite with large walk in shower, 2 walk in closets and 2 vanities. 3 additional large bedrooms with walk in closets, spacious loft, and laundry room complete the 2nd floor, covered deck and walk out basement. This is a must see!
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Year Built
- Built in 2024 | New Construction
Lot Details
- 22,738 Sq Ft Lot
- Lot Dimensions are 50x180x235x160
HOA Fees
- $50 Monthly HOA Fees
Parking
- 3 Car Garage
- Driveway
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vertical Siding
- Vinyl Siding
Interior Spaces
- 3,273 Sq Ft Home
- 2-Story Property
- Tray Ceiling
- Ceiling Fan
- Recessed Lighting
- Fireplace Features Blower Fan
- Gas Fireplace
- Insulated Windows
- Great Room
- Breakfast Room
- Formal Dining Room
- Home Office
- Loft
- Laundry Room
Kitchen
- Double Oven
- Electric Cooktop
- Microwave
- Dishwasher
- Kitchen Island
- Granite Countertops
- Disposal
Flooring
- Carpet
- Tile
- Luxury Vinyl Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Primary Bedroom
- Walk-In Closet
Unfinished Basement
- Walk-Out Basement
- Stubbed For A Bathroom
- Rough-In Basement Bathroom
Schools
- Erpenbeck Elementary School
- Ballyshannon Middle School
- Cooper High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Tankless Water Heater
Community Details
- Stonegate Property Management Association, Phone Number (859) 534-0900
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Union, KY
-
Clay Horan
-
Heather Townsend
Heather Townsend
Huff Realty - Florence
(859) 739-3465
54 Total Sales
5 in Union
$170K - $725K Price Range
-
David Schneider
David Schneider
Blue Chicken Realty
(513) 586-5839
94 Total Sales
1 in Union
$398,250 Price
-
Kimberly Nachazel
Kimberly Nachazel
eXp Realty, LLC
(513) 802-9458
132 Total Sales
2 in Union
$377K - $570K Price Range
-
Jody Connett
JC
Jody Connett
Huff Realty - CC
(513) 586-6213
115 Total Sales
4 in Union
$310K - $661K Price Range
-
Chris Kennedy
Chris Kennedy
Sibcy Cline, REALTORS-Florence
(513) 586-6325
104 Total Sales
7 in Union
$255K - $3.9M Price Range
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 03/29/2024 03/29/24 | Sold | $620,462 | -1.8% | $190 / Sq Ft |
| 01/25/2024 01/25/24 | Pending | -- | -- | -- |
| 12/17/2023 12/17/23 | For Sale | $631,900 | -- | $193 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Agents Affiliated with this Home
-
John Arlinghaus
Seller's Agent in 2024
John Arlinghaus
A+ Realty LLC
(859) 392-8900
53 Total Sales
-
Caldwell Group
C
Buyer's Agent in 2024
Caldwell Group
eXp Realty, LLC
(859) 780-5511
735 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 619270
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Ten-X 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 Brokers.
Listing information is deemed reliable, but not guaranteed.
Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 2524 Three Trees Ln
- 10642 Aspen Place
- 4720 Donegal Ave
- 10651 Aspen Place
- 2622 Twin Hills Ct
- 2641 Twin Hills Ct
- 2751 Zachary Ct
- 6672 Gordon Blvd
- 10194 Lucille Ln
- 12994 Pavilion Ct
- 2009 Rice Pike
- 3884 Emerald Isle Dr
- 14933 Cool Springs Blvd
- 4920 Kerry Crossing St
- 11065 Galileo Blvd
- 11069 Galileo Blvd
- 10551 Brookhurst Ln S
- 10555 Brookhurst Ln S
- 10667 Bridlepath Ln
- 1212 Adison Ridge
- 258 Mallory Ln
- 262 Mallory Ln
- 151 Zennon Ct
- 285 Mallory Ln
- 286 Mallory Ln
- 269 Mallory Ln
- 289 Mallory Ln
- 150 Zennon Ct
- 2004 Mayfield Ct
- 2008 Mayfield Ct
- 158 Zennon Ct
- 154 Zennon Ct
- 2266 Double Eagle Dr
- 4 Nolan Rd
- 10730 Jacobs Run
- 10734 Jacobs Run
- 10738 Jacobs Run
- 2564 Twin Hills Ct
- 2563 Twin Hills Ct
- 2072 Bayberry Ln
Your Personal Tour Guide
Ask me questions while you tour the home.