$739,900
OPEN SUN 1PM - 4PM NEW CONSTRUCTION $10K PRICE DROP

8791 Marais Dr Union, KY 41091

Estimated payment $4,705/month

3 Beds
3.5 Baths
3,581 Sq Ft
$207 Price per Sq Ft

Highlights

  • New Construction
  • Open Floorplan
  • Freestanding Bathtub
  • Erpenbeck Elementary School Rated A
  • Recreation Room
  • Ranch Style House

About This Home

The Lyndhurst plan offers comfortable one-level living in a ranch plan with flexible options for you to make this home suit your style. Step inside and discover a quiet home office with French doors just off the main foyer. The open central living area includes a large family room with cozy fireplace, casual dining area and well-designed deluxe kitchen with serving island. You'll love relaxing in the bright, airy sunroom while the covered outdoor living space with fireplace lets you enjoy the outdoors. A secluded primary suite offers a spa-like bath experience with a freestanding tub, separate walk-in super shower and enormous walk-in closet. A large secondary bedroom on the first floor includes a full bath. The finished lower level has a bedroom with a full bath and a spacious recreation with a walkout to the rear yard.

Listing Agent

John Heisler

Drees/Zaring Realty License #199763 Listed on: 04/02/2025

Open House Schedule

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2025 | New Construction

HOA Fees

  • $92 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Front Facing Garage
  • Driveway
  • Assigned Parking

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stone

Interior Spaces

  • 3,581 Sq Ft Home
  • Open Floorplan
  • Wired For Data
  • 2 Fireplaces
  • Electric Fireplace
  • Vinyl Clad Windows
  • Entrance Foyer
  • Family Room
  • Breakfast Room
  • Home Office
  • Recreation Room
  • Storage
  • Laundry Room
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Freestanding Bathtub

Home Security

  • Smart Home
  • Smart Thermostat

Outdoor Features

  • Covered Patio or Porch

Schools

  • Longbranch Elementary School
  • Ballyshannon Middle School
  • Cooper High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • High Speed Internet

Community Details

  • Association fees include association fees
  • Stonegate Property Mgmt. Association, Phone Number (859) 534-0900
  • Aberdeen Highlands Subdivision

Home Details

Home Type

Single Family

Year Built

Built in 2025 | New Construction

Lot Details

0

HOA Fees

$92 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: New Construction
  • Property Sub Type: Single Family Residence
  • Year Built: 2025
  • Lot Size: Irregular
  • Ownership: Builder/Developer
  • Subdivision Name: Aberdeen Highlands
  • Directions: Highway US 42 south to Orleans Blvd. west/northwest to Longbranch Road. West to Ballyshannon Way. South to West Brook Blvd. East to Marais Drive.
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • New Construction: Yes
  • Property Attached Yn: No
  • Structure Type: House
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: Yes
  • Location Tax Legal Info:Elementary School: Longbranch
  • Location Tax Legal Info:Middle or Junior School: Ballyshannon Middle School
  • Location Tax Legal Info:High School: Cooper High School
  • Location Tax Legal Info:Subdivision2: Other
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Irregular
  • General Property Description:Approx SqFt2: 3581.0
  • Architecture:Ranch: Yes
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Property Condition:New Construction4: Yes
  • Sewer:Public Sewer: Yes
  • Levels:One: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone County Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: No
  • Structure Type:House: Yes
  • General Property Description:Fireplaces Total: 2
  • Utilities:Water Available: Yes
  • Percent Basement Finished: Yes
  • Special Features: 3

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Storage, Smart Thermostat, Smart Home, Pantry, Open Floorplan, High Speed Internet, Entrance Foyer, Eat-in Kitchen, Wired for Data
  • Basement: Full, Finished
  • Heating: Natural Gas
  • Levels: One
  • Property Type: Residential
  • Appliances: Dishwasher, Disposal, Microwave
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace Features: Electric
  • Fireplaces: 2
  • Fireplace: Yes
  • Window Features: Vinyl Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Smart Home: Yes
  • Interior Features:Smart Thermostat: Yes
  • Interior Features:Storage2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wired for Data: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Interior Features:High Speed Internet: Yes
  • Fireplace Features:Electric: Yes

Exterior Features

  • Roof: Shingle
  • Construction Type: Brick, Stone
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered
  • Construction Materials:Brick2: Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Covered: Yes
  • Construction Materials:Stone2: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Assigned, Driveway, Garage, Garage Faces Front
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Garage Faces Front: Yes
  • Parking Features:Assigned: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Natural Gas Available, Water Available
  • Heating:Natural Gas2: Yes

Condo/Co-op/Association

  • Association Fee: 1100.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Stonegate Property Mgmt.
  • Association Information:Association Management Phone 1: 859-534-0900
  • Association Information:Total Yearly Fees: 1100.0
  • Association Fee Includes:Association Fees: Yes
  • Association Information:Association Fee: 1100.0
  • Association Information:Association Fee Frequency: Annually

Fee Information

  • Association Fee Includes: Association Fees

Schools

  • Elementary School: Longbranch
  • Junior High Dist: Boone Co Public
  • High School: Cooper High School
  • Middle Or Junior School: Ballyshannon Middle School

Lot Info

  • Zoning Description: Residential

Map

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 Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/20/2025 08/20/25 For Sale $739,900 -- $207 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Source: Northern Kentucky Multiple Listing Service

MLS Number: 631166

Northern Kentucky Multiple Listing Service
Kentucky Boone County Union 41091

8791 Marais Dr, Union, KY

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.

Northern Kentucky Multiple Listing Service 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 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

Nearby Homes
Listing Agent
John Heisler
Section Image
Drees/Zaring Realty
(859) 517-5215