$739,900
NEW CONSTRUCTION $10K PRICE DROP

8791 Marais Dr Union, KY 41091

Estimated payment $4,759/month

Total Views 8,130
3 Beds
3.5 Baths
3,581 Sq Ft
$207 Price per Sq Ft

Highlights

  • New Construction
  • Open Floorplan
  • Ranch Style House
  • Erpenbeck Elementary School Rated A
  • Recreation Room
  • 2 Fireplaces

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.

Last Listed By

John Heisler

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

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

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
  • ResoPropertyType: Residential
  • 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: NewHome

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
  • ResoAssociationFeeFrequency: Annually

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 Change Sq Ft Price
04/11/2025 04/11/25 Price Changed $739,900 -1.3% $207 / Sq Ft
04/02/2025 04/02/25 For Sale $749,900 -- $209 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Similar Homes in Union, KY

  • 8665 Marais Dr, Union, KY 41091

    $619,000

    • 4 Beds
    • 5 Baths
    • 3,941 Sq Ft
    • 8665 Marais Dr
    • Union, KY

    Beautiful executive home boasts 4 large BR's, 3 full & 2 half baths. Located in prestigious Du Monde in Orleans South and Cooper school district. Beautiful wood floors throughout most of first and second floors, w/soft carpet where desired in Family Room & bsmnt Great Room. Walk through the lited front door into a large entry way w/detailed moldings, leading to Formal Living Room & Dining

    Jeff Forlenza Diversified Property Services

    Section Image
  • 9014 Countrybrook Pass, Union, KY 41091

    $581,900

    • 4 Beds
    • 3 Baths
    • 9014 Countrybrook Pass
    • Union, KY

    Brand new, energy-efficient home by Arlinghaus Builders located in the desirable Westbrook community. The Avalon floor plan features an open layout with a side-entry garage, covered patio, and a finished lower level, offering exceptional space and flexibility. Upgrades include cathedral ceilings, a large kitchen with granite countertops and an island, luxury vinyl plank flooring throughout the

    John Arlinghaus A+ Realty LLC

    Section Image
  • 8394 Saint Louis Blvd, Union, KY 41091

    $625,000

    • 6 Beds
    • 4.5 Baths
    • 4,326 Sq Ft
    • 8394 Saint Louis Blvd
    • Union, KY

    A truly remarkable, 6 bedrm, 4 full bathrms and 1 half bath located in the French Quarter at Orleans North! Step inside to be greeted by a soaring 2 story entry offering hardwood floors. Spacious living room and formal dining room with an added touch of crown molding and chair rail. Hot water heater May 2025. ROOF 2023. Entertain in the expansive kitchen remodeled in 2020. Beautiful oversized

    Blaire Hancock Simple Fee Realty

    Section Image
  • 6901 Green Isle Ln, Union, KY 41091

    $575,943

    • 4 Beds
    • 3.5 Baths
    • 6901 Green Isle Ln
    • Union, KY

    New Construction by Fischer Homes in the beautiful Ballyshannon community with the Grandin Cambridge Cottage floorplan featuring an island kitchen with upgraded oak cabinetry, quartz countertops, slate appliances and pantry. Walkout morning room open to family room with electric fireplace. Living room and study with double doors. Primary bedroom with en suite, double vanity, tub and shower.

    Alexander Hencheck HMS Real Estate

    Section Image
  • 2709 Longbranch Rd, Union, KY 41091

    $689,900

    • 4 Beds
    • 4 Baths
    • 4,832 Sq Ft
    • 2709 Longbranch Rd
    • Union, KY

    Tucked away on 5 private, heavily wooded acres in the heart of Union, 2709 Longbranch Road offers the ultimate in peace and privacy - yet remains just minutes from the expressway, Blue Ribbon schools, shopping, and dining. This custom brick ranch features a split-bedroom floor plan with 3 bedrooms and 3 full baths on the main level, highlighted by hardwood floors, cathedral ceilings, and large

    Varun Varma Coldwell Banker Realty FM

    Section Image
  • 8508 Robert Grant Dr, Union, KY 41091

    $909,969

    • 5 Beds
    • 5.5 Baths
    • 4,097 Sq Ft
    • 8508 Robert Grant Dr
    • Union, KY

    New Construction in the beautiful community of Ballyshannon, featuring the Pearson Modern Farmhouse plan. This designer floorplan offers an open-concept kitchen with island, pantry, lots of cabinet space and quartz countertops. Family room with stunning gas fireplace connects to light filled morning room. The morning room walks out to the covered deck which features an exterior gas fireplace.

    Alexander Hencheck HMS Real Estate

    Section Image
  • 2140 Hathaway Rd, Union, KY 41091

    $625,000

    • 4 Beds
    • 3 Baths
    • 2,170 Sq Ft
    • 2140 Hathaway Rd
    • Union, KY

    Lush Mini Farm - Own Your Piece of Paradise! This beautifully maintained and thoughtfully updated mini farm offers the ideal blend of rural charm and modern comfort. Set on a peaceful parcel, it's perfect for hobby farmers, animal lovers, or anyone seeking space to thrive.Property Features:Chicken coop comfortably houses up to 26 birds. Horse barn with stalls, plus a tractor barn for

    Tammie Iverson KW Seven Hills Realty

    Section Image
  • 6191 Vintage Fleet Ln, Union, KY 41091

    $744,450

    • 5 Beds
    • 3.5 Baths
    • 3,675 Sq Ft
    • 6191 Vintage Fleet Ln
    • Union, KY

    Gorgeous new Pearson plan by Fischer Homes in beautiful Ballyshannon featuring one floor living at it's finest with an island kitchen with stainless steel appliances, oak cabinetry with soft close hinges, quartz counters, and walk-in pantry room. Large family room with linear fireplace. Study room off entry way with french doors. Rec room just off morning room. Guest room on main level with full

    Alexander Hencheck HMS Real Estate

    Section Image
  • 8509 Robert Grant Dr, Union, KY 41091

    $792,403

    • 4 Beds
    • 3.5 Baths
    • 3,382 Sq Ft
    • 8509 Robert Grant Dr
    • Union, KY

    Stunning new Leland Modern Farmhouse plan by Fischer Homes in beautiful Ballyshannon featuring a welcoming covered front porch. Once inside you'll fall in love with the open and airy design with a furniture island kitchen with built-in stainless steel appliances, upgraded maple cabinetry with soft close hinges, gleaming granite counters, mega sized walk-in pantry, and oversized breakfast room all

    Alexander Hencheck HMS Real Estate

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 631166

Northern Kentucky Multiple Listing Service