$674,900
PENDING NEW CONSTRUCTION $75K PRICE DROP

10400 Brookhurst Ln N Union, KY 41091

Estimated payment $3,675/month

Total Views 11,422
3 Beds
3 Baths
3,839 Sq Ft
$176 Price per Sq Ft

Highlights

  • Under Construction
  • Open Floorplan
  • Recreation Room
  • Shirley Mann Elementary School Rated A
  • Contemporary Architecture
  • High Ceiling

About This Home

The Naples offers easy one-story living in an open spacious design. An inviting main foyer opens to a gallery and private study. Upon entering the home from the garage, you'll find a family foyer, which is the perfect drop zone for your family's personal items. The open arrangement of the family room, kitchen and dining room is an entertainer's dream and a covered outdoor area with stone expands your living space. You'll love relaxing in the secluded primary suite, which is highlighted by a super shower. For added enjoyment, a finished lower level rec room, entertainment room and full bath and bedroom.

Last Listed By

John Heisler

Drees/Zaring Realty License #199763 Listed on: 08/27/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $549

Year Built

  • Built in 2024 | Under Construction

Lot Details

  • Cul-De-Sac

HOA Fees

  • $48 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Driveway

Home Design

  • Contemporary Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • HardiePlank Type
  • Stone

Interior Spaces

  • 3,839 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Wired For Data
  • Tray Ceiling
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room with entrance to outdoor space
  • Family Room
  • Breakfast Room
  • Home Office
  • Recreation Room

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Stone Countertops
  • Disposal

Flooring

  • Carpet
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Walk-In Closet
  • 3 Full Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Shower Only
  • Primary Bathroom includes a Walk-In Shower

Finished Basement

  • Finished Basement Bathroom
  • Basement Storage

Outdoor Features

  • Patio
  • Porch

Schools

  • Shirley Mann Elementary School
  • Gray Middle School
  • Ryle High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Underground Utilities
  • Cable TV Available

Community Details

  • Association fees include association fees, ground maintenance
  • Stonegate Property Association, Phone Number (859) 534-0900
  • On-Site Maintenance

Home Details

Home Type

Single Family

Est. Annual Taxes

$549

Year Built

Built in 2024 | Under Construction

Lot Details

0

HOA Fees

$48 per month

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Under Construction
  • Property Sub Type: Single Family Residence
  • Year Built: 2024
  • Lot Size: Irregular
  • Directions: South on Rt. 42 to right on Frogtown Rd., to right on Traemore Place into community. Model is on corner of Traemore Place and Brookhurst Lane. Straight on Brookhurst.
  • Architectural Style: Contemporary
  • New Construction: Yes
  • Property Attached Yn: No
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: Yes
  • Location Tax Legal Info:Elementary School: Shirley Mann School
  • Location Tax Legal Info:Middle or Junior School: Gray Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Location Tax Legal Info:Subdivision2: Traemore
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: No
  • General Property Description:Lot Size Dimensions: Irregular
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Levels:One: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone Co Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: No
  • General Property Description:Living Area: 3839.0
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Room Type:Study: Yes
  • Utilities:Underground Utilities: Yes
  • Percent Basement Finished: Yes
  • Architecture:Contemporary: Yes
  • Property Condition:Under Construction: Yes
  • Recreation Room Features:Carpet Flooring14: Yes
  • Study Room Features:Luxury Vinyl Flooring23: Yes
  • Special Features: NewHome

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Tray Ceiling(s), Stone Counters, Pantry, Open Floorplan, Entrance Foyer, Eat-in Kitchen, Double Vanity, Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting, Wired for Data
  • Basement: Full Finished Bath, Finished, Storage Space
  • Heating: Natural Gas
  • Levels: One
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Gas Cooktop, Gas Oven, Dishwasher, Disposal, Double Oven, Microwave
  • Full Bathrooms: 3
  • Total Bedrooms: 3
  • Door Features: French Doors
  • Fireplace: No
  • Living Area: 3839.0
  • Window Features: Insulated Windows, Vinyl Frames
  • Appliances Dishwasher: Yes
  • Appliances:Double Oven: Yes
  • Appliances:Gas Cooktop: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wired for Data: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Family Room Features:Luxury Vinyl Flooring8: Yes
  • Kitchen Features:Luxury Vinyl Flooring11: Yes
  • Kitchen Features Pantry: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Primary Bath Features:Shower: Yes
  • Family Room Features:Walk-Out Access4: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Basement:Carpet Flooring7: Yes
  • Interior Features:Stone Counters: Yes
  • Interior Features:Recessed Lighting: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Appliances:Gas Oven: Yes
  • Interior Features:Tray Ceiling(s): Yes

Exterior Features

  • Roof: Shingle
  • Lot Features: Cul-De-Sac
  • Construction Type: HardiPlank Type, Brick, Stone
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Patio, Porch
  • Construction Materials:Brick2: Yes
  • Construction Materials:HardiPlank Type: Yes
  • Window Features:Insulated Window(s): Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Construction Materials:Stone2: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Study Room Features:French Doors7: Yes
  • Door Features:French Doors: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee: 575.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Stonegate Property
  • Association Information:Association Management Phone 1: (859)534-0900
  • Association Information:Total Yearly Fees: 575.0
  • Association Fee Includes:Association Fees: Yes
  • Association Fee Includes:Maintenance Grounds: Yes
  • Association Information:Association Fee: 575.0
  • Association Information:Association Fee Frequency: Annually

Fee Information

  • Association Fee Includes: Association Fees, Maintenance Grounds

Schools

  • Elementary School: Shirley Mann School
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Gray 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

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $549 $50,000 $50,000 $0
2023 $569 $50,000 $50,000 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/16/2025 05/16/25 Pending -- -- --
03/28/2025 03/28/25 Price Changed $674,900 -2.2% $176 / Sq Ft
03/04/2025 03/04/25 Price Changed $689,900 -1.4% $180 / Sq Ft
12/09/2024 12/09/24 Price Changed $699,900 -3.4% $182 / Sq Ft
10/25/2024 10/25/24 Price Changed $724,900 -3.3% $189 / Sq Ft
08/27/2024 08/27/24 For Sale $749,900 -- $195 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Similar Homes in Union, KY

  • 10376 Brookhurst Ln N, Union, KY 41091

    $645,000

    • 3 Beds
    • 2 Baths
    • 10376 Brookhurst Ln N
    • Union, KY

    Why Wait & Spend Tens Of Thousands More On New Construction? This Gorgeous Home Has Barely Been Occupied A Year 7 Is Priced Over $20,000 Less Than Duplication! Enjoy Main Level Living With Dramatic 9' Main Level Ceilings & An Entertainer's Dream Layout*Oversized Granite Island With Breakfast Bar Accentuates A Beautiful Kitchen Offering Loads Of Cabinetry*Expanded Dining Room Overlooks Recently

    Carl Kappes III RE/MAX Victory + Affiliates

    Section Image
  • 10377 Brookhurst Ln N, Union, KY 41091

    $674,900

    • 5 Beds
    • 4 Baths
    • 3,364 Sq Ft
    • 10377 Brookhurst Ln N
    • Union, KY

    Celebrate living in the open, spacious Drees Homes Vanderburgh. From the charming exterior, step inside to discover an elegant formal dining room just off the main foyer. Beyond the foyer, a large central living area features an open arrangement of the family room with wall of windows, a well-equipped kitchen with convenient island, and casual dining area - the perfect space for relaxing or

    John Heisler Drees/Zaring Realty

    Section Image
  • 962 Traemore Place, Union, KY 41091

    $739,000

    • 4 Beds
    • 3.5 Baths
    • 3,278 Sq Ft
    • 962 Traemore Place
    • Union, KY

    So many upgrades in this 4 year old Drees Alden floorplan. Gourmet kitchen with quartz countertops, large island, double ovens, gas cooktop, built-in microwave, walk-in pantry. Main level office. Elegant upgraded posts and spindles on main staircase overlooking the impressive two-story great room with stone fireplace. Upgraded flooring on entire main level. Bright sunroom with a vaulted ceiling

    Catherine Kiefer eXp Realty, LLC

    Section Image
  • 1239 Adison Ridge, Union, KY 41091

    $640,000

    • 4 Beds
    • 3.5 Baths
    • 1239 Adison Ridge
    • Union, KY

    Stunning 2-Sty Home in Sought-After Traemore Subdivision! Skip the wait of building—this brand new Buchanan model is move-in ready & priced $44K below reproduction cost! Located on a cul-de-sac st this home offers a spacious layout w/high-end finishes throughout. Inviting covered front porch*open-concept floor plan w/9-foot ceilings*LVP flooring throughout the 1st floor*Gourmet kitchen w/quartz

    Paula Ritter Sibcy Cline, REALTORS-Florence

    Section Image
  • 1048 Aristides Dr, Union, KY 41091

    $650,000

    • 4 Beds
    • 2.5 Baths
    • 3,814 Sq Ft
    • 1048 Aristides Dr
    • Union, KY

    Spacious and beautifully maintained 4-bedroom, 2.5-bath two-story home with a 3-car side-entry garage located in the desirable Triple Crown community. The open-concept main level features a gourmet kitchen with rich wood cabinetry, stainless steel appliances, granite countertops, an oversized center island, and a walk-in pantry. A formal dining room and private office complete the first floor.

    Michael Parker Huff Realty - Florence

    Section Image
  • 2011 Holderness Dr, Union, KY 41091

    $639,900

    • 4 Beds
    • 3.5 Baths
    • 3,213 Sq Ft
    • 2011 Holderness Dr
    • Union, KY

    Stunning 5 bedroom home in highly sought after Hampshire subdivision. Boasting over 5,000 sq ft. of beautifully designed living space, this home offers the perfect blend of elegance and comfort. The gourmet eat-in-kitchen features granite countertops, a over sized center island, updated appliances and an expansive breakfast room for casual dining or entertaining. Step out onto the huge Trex deck

    Aimee Pelletier Sibcy Cline, REALTORS-Florence

    Section Image
  • 10203 Waterside Ct, Union, KY 41091

    $625,000

    • 4 Beds
    • 3.5 Baths
    • 3,617 Sq Ft
    • 10203 Waterside Ct
    • Union, KY

    This home truly has it all! Located in the Hempsteade community on almost half an acre. 4 bedrooms, 3.5 baths, 3 finished levels including a walk out lower level & 3 car garage. Completely updated and upgraded! 1st floor is perfect for entertaining, featuring LVP flooring, open floor plan, large rooms- living and dining room, office space with French doors, gourmet kitchen with SS appliances,

    Bryson Warner Huff Realty - Florence

    Section Image
  • 10678 War Admiral Dr, Union, KY 41091

    $512,000

    • 4 Beds
    • 3.5 Baths
    • 10678 War Admiral Dr
    • Union, KY

    Welcome home to this Beautiful 4 bedroom, 3.5 bath, updated and well maintained 2 story in highly desired Triple Crown. This open floor plan offers a two story grand, family room with hardwood flooring and numerous windows for plenty of natural light .Gourmet Kitchen offers tile floors, granite countertops, plenty of cabinet space and stainless steel appliances. First floor also offers a formal

    Scarlett Sackmann Berkshire Hathaway Home Services Professional Realty

    Section Image
  • 10073 Hempsteade Dr, Union, KY 41091

    $515,000

    • 4 Beds
    • 3.5 Baths
    • 3,200 Sq Ft
    • 10073 Hempsteade Dr
    • Union, KY

    Welcome to your dream home! Nestled in the heart of Union, this beautifully renovated 4-bedroom, 3.5-bathroom residence offers the perfect blend of modern luxury and everyday comfort. From the moment you step inside, you'll be captivated by the spacious, open-concept layout, stylish finishes, and abundant natural light.The gourmet kitchen features new custom cabinets, quartz countertops, and cafe

    William Santiago Haven Homes Group

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 625982

Northern Kentucky Multiple Listing Service

APN: 063.00-30-139.00