Brand New, Energy efficient home by Arlinghaus Builders under construction in the Westbrook community. Popular Mariemont floor plan offers an amazing layout, a third car garage & numerous upgrades. Upgrades include 9' ceilings on the 1st flr, a large kitchen with an island, staggered cabinets, walk in pantry, granite countertops & luxury vinyl plank flooring. Study with french doors. Great room has a gas fireplace with cabinets/built-in bookshelves. Mudroom with built-in cubbies. Walk-in closets in all bedrooms. Second floor laundry & loft area. Owner's suite/bath has tray ceiling, soaking tub & tile shower. Covered patio, finished basement with half bath. Brick wrap home with Trane gas heat & a tankless water heater. A must see!
Sold for $599,900 on 03/26/24
$599,900
2004 Mayfield Ct, Union, KY 41091
4beds
--sqft
Single Family Residence, Residential
Built in 2024
0.42 Acres Lot
$605,800 Zestimate®
$--/sqft
$2,996 Estimated rent
Home value
$605,800
$576,000 - $636,000
$2,996/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 02, 2024 at 08:29pm
Listed by:
John Arlinghaus 859-393-7794,
A+ Realty LLC
Bought with:
Kylie Royer, 276225
Keller Williams Advisors
Source: NKMLS,MLS#: 618579
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 2
- 1/2 bathrooms: 2
Primary bedroom
- Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Tray Ceiling(s), Ceiling Fan(s)
- Level: Second
- Area: 336
- Dimensions: 21 x 16
Bedroom 2
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Bedroom 3
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Second
- Area: 168
- Dimensions: 12 x 14
Bedroom 4
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Second
- Area: 168
- Dimensions: 14 x 12
Other
- Features: Recessed Lighting, Plank Flooring
- Level: First
- Area: 110
- Dimensions: 11 x 10
Breakfast room
- Features: Plank Flooring
- Level: First
- Area: 180
- Dimensions: 15 x 12
Family room
- Features: Carpet Flooring, Recessed Lighting
- Level: Basement
- Area: 396
- Dimensions: 18 x 22
Great room
- Features: Fireplace(s), Built-in Features, Bookcases, Recessed Lighting, Plank Flooring
- Level: First
- Area: 323
- Dimensions: 17 x 19
Kitchen
- Features: Kitchen Island, Pantry, Recessed Lighting, Plank Flooring
- Level: First
- Area: 180
- Dimensions: 15 x 12
Laundry
- Level: Second
- Area: 48
- Dimensions: 6 x 8
Loft
- Features: Carpet Flooring
- Level: Second
- Area: 154
- Dimensions: 11 x 14
Other
- Description: Mudroom w/cubbies
- Features: Built-in Features, Plank Flooring
- Level: First
- Area: 50
- Dimensions: 5 x 10
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Dishwasher, Disposal, Microwave, Tankless Water Heater
Features
- Windows: Vinyl Clad Window(s)
- Number of fireplaces: 1
- Fireplace features: Blower Fan, Gas
Property
Parking
- Total spaces: 3
- Parking features: Attached, Driveway, Garage Faces Side, Oversized
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
Lot
- Size: 0.42 Acres
- Dimensions: front 80' x L side 151' x Back 172' x R side 142'
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Brick, Vinyl Siding
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- New construction: Yes
- Year built: 2024
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Location
- Region: Union
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $600 annually
Price history
| Date | Event | Price |
|---|---|---|
| 3/26/2024 | Sold | $599,900 |
Source:  NKMLS #618579 | ||
| 2/20/2024 | Pending sale | $599,900 |
Source: NKMLS #618579 | ||
| 11/14/2023 | Listed for sale | $599,900 |
Source: NKMLS #618579 | ||
Public tax history
Tax history is unavailable.
Neighborhood: 41091
Nearby schools
GreatSchools rating
- 8/10Erpenbeck Elementary SchoolGrades: PK-5Distance: 1.5 mi
- 8/10Ballyshannon Middle SchoolGrades: 6-8Distance: 1 mi
- 8/10Randall K. Cooper High SchoolGrades: 9-12Distance: 2.1 mi
Schools provided by the listing agent
- Elementary: Erpenbeck Elementary
- Middle: Ballyshannon Middle School
- High: Cooper High School
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.