Skip To Content

2004 Mayfield

Union, KY 41091
  • $599,900
  • STATUS: Active
  • ON SITE: 13 Days
  • MLS #: 618579
UPDATED: 52 min ago
$599,900
  • 4
    BEDS
  • 0.42
    ACRES
  • 2
    BATHS
  • 2
    1/2 BATHS
Neighborhood:
Type:
Single-Family Home
Built:
2024
County:

School Information

Elementary School:
High School:
School District:

Description

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!

Monthly Payment Calculator



Northern Kentucky MLS logo © 2023 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2023-11-28T16:24:31.123.
www.jimsimpsonrealtors.com/homes/145250319
Print Image

2004 Mayfield Union, KY 41091

  • Price: $599,900
  • Status: Active
  • On Site: 13 Days
  • Updated: 52 min ago
  • MLS #: 618579
4
Beds
2
Baths
2
½ Baths
0.42
Acres
2024
Built
Neighborhood:
Richwd/Un/Wal/Ver/Sb
County:
Boone
Area:
Richwd/Un/Wal/Ver/Sb
Elementary School:
Erpenbeck Elementary
Middle School:
Ballyshannon Middle School
High School:
Cooper High School
School District:
Boone Co Public
Property Description
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!
Exterior Features

Architectural Style Traditional Attached Garage YN Yes Construction Materials BrickVinyl Siding Foundation Details Poured Concrete Garage YN Yes Levels Two Parking Features AttachedDrivewayGarage Faces SideOversized

Interior Features

Appliances Stainless Steel Appliance(s)DishwasherDisposalMicrowaveTankless Water Heater Basement FinishedBath/Stubbed Cooling Central Air Cooling YN Yes Fireplace Features Blower FanGas Fireplace YN Yes Fireplaces Total 1 Flooring CarpetConcrete Heating Natural Gas Heating YN Yes Rooms Total 11 Window Features Vinyl Clad Window(s)

Property Features

Association Fee 600 Association Fee Frequency Annually Association YN Yes Lot Size Dimensions front 80' x L side 151'x Back 172' x R side 142' New Construction YN Yes Property Attached YN No Property Class Residential Property Sub Type Single Family Residence Sewer Public Sewer Structure Type House Water Source Public

Northern Kentucky MLS logo Courtesy of A+ Realty Llc: 859-392-8980. © 2023 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. Information has not been verified, is not guaranteed, and subject to change.


Northern Kentucky MLS logo © 2023 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2023-11-28T16:24:31.123.
 
https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_2_618579-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_2_618579-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_2_618579-2.jpg
Logo
Jim Simpson Realtors Inc
39 Broadway
Dry Ridge KY, 41035