$1,550,000

Estimated payment $8,720/month

Total Views 10,416
5 Beds
4.5 Baths
5,464 Sq Ft
$284 Price per Sq Ft

Highlights

  • Hot Property
  • In Ground Pool
  • 1.5 Acre Lot
  • Highlands Middle School Rated A
  • View of Trees or Woods
  • Open Floorplan

About This Home

Welcome Home to 42 Stardust Point in Ft Thomas! This one-of-a-kind custom mid-century modern home is sure to impress from the moment you arrive. Nestled on more than 3 private acres, this remarkable property offers the peace, privacy, and natural beauty you've been dreaming of. Enjoy a tranquil retreat with the perfect blend of timeless architecture, spacious surroundings, and an unbeatable location. Boasting more than 5K square feet of thoughtfully designed living space, this exceptional home offers room to live, entertain, and unwind. Car enthusiasts will appreciate the incredible garage space for up to 8 cars, with additional room to accommodate an RV. The open-concept floor plan, soaring vaulted ceilings, and walls of windows fill the home with an abundance of natural light. Outdoor living is equally impressive, featuring multiple composite decks, a spacious patio, an in-ground pool, and a serene spring-fed koi pond--creating your own private backyard oasis. Additional highlights include: 5 spacious bedrooms, each with a walk-in closet * 4.5 baths * heated tile floors * dramatic floor-to-ceiling stone gas fireplace * sunroom that brings the outdoors in. This extraordinary property offers a rare combination of architectural character and unmatched privacy.

Listing Agent

Kim Hermann

Huff Realty - CC License #207927 Listed on: 08/19/2026

Huff Realty - CC

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1993

Lot Details

  • 1.5 Acre Lot
  • Cul-De-Sac
  • Partially Fenced Property
  • Aluminum or Metal Fence
  • Sloped Lot
  • Heavily Wooded Lot
  • Private Yard
  • Land Lease

Parking

  • 8 Car Garage
  • Heated Garage
  • Rear-Facing Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Home Design

  • Transitional Architecture
  • Poured Concrete
  • Shingle Roof
  • Synthetic Stucco Exterior
  • Stone

Interior Spaces

  • 5,464 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Central Vacuum
  • Built-In Features
  • Bookcases
  • Vaulted Ceiling
  • Ceiling Fan
  • Chandelier
  • Wood Burning Fireplace
  • Stone Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Double Hung Windows
  • Sliding Windows
  • Sliding Doors
  • Entrance Foyer
  • Family Room
  • Living Room
  • Formal Dining Room
  • Den
  • Bonus Room
  • Solarium
  • Storage
  • Views of Woods
  • Walk-Out Basement
  • Home Security System

Kitchen

  • Electric Range
  • Microwave
  • Dishwasher
  • Granite Countertops
  • Utility Sink
  • Disposal

Flooring

  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Double Vanity
  • Hydromassage or Jetted Bathtub
  • Bathtub with Shower
  • Shower

Laundry

  • Laundry Room
  • Laundry on upper level
  • Dryer
  • Washer

Accessible Home Design

  • Enhanced Accessible Features

Outdoor Features

  • In Ground Pool
  • Deck
  • Patio

Schools

  • Johnson Elementary School
  • Highlands Middle School
  • Highlands High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • No Home Owners Association
  • Stardust Pointe Subdivision

Home Details

Home Type

Single Family

Year Built

Built in 1993

Lot Details

1.5 Acres

Parking

8

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 1.496
  • Year Built: 1993
  • Lot Size: 2 lots / approx. 3 acres
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Subdivision Name: Stardust Pointe
  • Directions: Memorial Parkway to Stardust Point, end of cul-de-sac.
  • Architectural Style: Transitional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • Utilities Electric Company: Duke
  • Utilities Gas Company: Duke
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • Property Ownership:Property Ownership: Consumer
  • Land Description:Land Description: 1 to 4.9 Acres
  • Special Features: None

Interior Features

  • Interior Amenities: Ceiling Fan(s), Central Vacuum, High Ceilings, Bookcases, Built-in Features, Chandelier, Double Vanity, Entrance Foyer, Granite Counters, Open Floorplan, Pantry, Storage, Walk-In Closet(s)
  • Basement: Walk-Out Access, Full Finished Bath
  • Heating: Forced Air, Natural Gas
  • Levels: Two
  • Property Type: Residential
  • Appliances: Disposal, Dryer, Dishwasher, Microwave, Refrigerator, Washer, Electric Range
  • Accessibility Features: Enhanced Accessible
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Door Features: Sliding Doors
  • Fireplace Features: Gas, Wood Burning, Stone
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 5464.0
  • Window Features: Insulated Windows, Vinyl Frames, Double Hung, Slider Window(s)

Exterior Features

  • View: Trees/Woods
  • Fencing: Partial, Aluminum
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Wooded, Sloped
  • Pool Features: In Ground
  • View: Yes
  • Construction Type: Stone, Synthetic Stucco
  • Exterior Features: Private Yard
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Patio

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage Faces Rear, Heated Garage, On Street, Garage Door Opener, Garage
  • Total Parking Spaces: 8.0

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Laundry Room, Upper Level
  • Security: Security System
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Johnson Elementary
  • Junior High Dist: Ft Thomas Indep
  • High School: Highlands High
  • Middle Or Junior School: Highlands Middle School

Lot Info

  • Land Lease: Yes
  • Lot Size Sq Ft: 65166.0
  • Zoning Description: Residential

3D Interior and Exterior Tours

Floorplans

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $2,605 $755,000 $128,000 $627,000
2024 $2,728 $755,000 $128,000 $627,000
2023 $2,799 $755,000 $128,000 $627,000
2022 $3,067 $755,000 $128,000 $627,000
2021 $3,155 $755,000 $128,000 $627,000
2020 $3,218 $755,000 $128,000 $627,000
2019 $3,246 $755,000 $128,000 $627,000
2018 $3,198 $755,000 $128,000 $627,000
2017 $2,880 $675,000 $128,000 $547,000
2016 $2,822 $675,000 $0 $0
2015 $2,872 $675,000 $0 $0
2014 $2,811 $675,000 $0 $0
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/19/2026 08/19/26 For Sale $1,550,000 -- $284 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

About the Listing Agent

Kim Hermann

Huff Realty - CC

(859) 328-1844

Section Image

Kim Hermann | Northern Kentucky Real Estate Expert

Kim Hermann is consistently recognized as one of the top real estate agents in Northern Kentucky, bringing over 20 years of experience and more than 1,200 successful transactions to every client she serves. Her deep expertise in Northern Kentucky neighborhoods, housing market trends, and pricing strategy makes her a trusted advisor for both buyers and sellers.

Known for her professional, ethical, and client-first approach, Kim is

Kim's Other Listings

  • 616 Linden Ave, Newport, KY 41071

    $699,000 Pending

    • 4 Beds
    • 2 Baths
    • 1,700 Sq Ft
    • 616 Linden Ave
    • Newport, KY

    Simply Stunning! This one will steal your heart! Beautifully landscaped grounds welcome you to the inviting front porch, setting the stage for the historic charm and character found throughout this exceptional home. Step inside and fall in love with the beautiful wood floors, leaded-glass front door, gorgeous stained-glass windows, soaring 9' ceilings and lots of natural light. The recently

    Kim Hermann Huff Realty - CC

    Section Image
  • 922 6th Ave, Dayton, KY 41074

    $199,000

    • 3 Beds
    • 1 Bath
    • 1,065 Sq Ft
    • 922 6th Ave
    • Dayton, KY

    Cute as a button & move-in ready! This charming home is full of warmth and opportunity. Features include 3 bedrooms, with 2 bedrooms conveniently located on the 1st floor * new carpet * freshly painted throughout * brand-new stainless steel appliances * cozy covered front porch * nice yard with plenty of room for gardening, pets or play * 1st-floor laundry hookup * alley access behind the home

    Kim Hermann Huff Realty - CC

    Section Image
  • 121 Highland Ave, Fort Thomas, KY 41075

    $1,375,000 Pending

    • 5 Beds
    • 3.5 Baths
    • 4,100 Sq Ft
    • 121 Highland Ave
    • Fort Thomas, KY

    Your Dream Home Awaits! This exceptional custom home, located in the heart of Ft. Thomas, offers the perfect blend of luxury, quality, and everyday comfort. Nestled on nearly an acre, this stunning Tim Burks custom-built home showcases outstanding craftsmanship and thoughtful design from the moment you step inside. Built for energy efficiency and low-maintenance living, the home features durable

    Kim Hermann Huff Realty - CC

    Section Image
  • 535 Highland Ave, Fort Thomas, KY 41075

    $475,000 Pending

    • 3 Beds
    • 2 Baths
    • 2,000 Sq Ft
    • 535 Highland Ave
    • Fort Thomas, KY

    This charming home will steal your heart! Perfectly located near award-winning schools and all that the heart of Ft. Thomas has to offer, this beauty combines comfort, updates, and an incredible outdoor living space. Features Include: 3 spacious bedrooms * 2 updated baths * updated kitchen with stainless steel appliances, abundant counter space & storage * beautiful wood floors * inviting

    Kim Hermann Huff Realty - CC

    Section Image
  • 82 S Crescent Ave, Fort Thomas, KY 41075

    $545,000 Pending

    • 3 Beds
    • 1.5 Baths
    • 1,600 Sq Ft
    • 82 S Crescent Ave
    • Fort Thomas, KY

    Simply STUNNING! This exceptional home has been meticulously renovated from top to bottom--inside and out. Every detail has been thoughtfully updated, and the professionally designed front and backyard create incredible curb appeal and inviting outdoor living spaces. The custom-designed kitchen is truly the heart of the home, featuring: premium Italian cabinetry * gorgeous quartz countertops *

    Kim Hermann Huff Realty - CC

    Section Image
  • 66 Lockwood Place, Fort Thomas, KY 41075

    $450,000 Pending

    • 3 Beds
    • 2.5 Baths
    • 1,568 Sq Ft
    • 66 Lockwood Place
    • Fort Thomas, KY

    Come Fall in Love! ❤️ This charming home truly has it all--and its setting is hard to beat! Nestled on a quiet cul-de-sac street next to the edge of beautiful Tower Park, this inviting home offers comfort, character, and a wonderful connection to nature.Step inside to find beautiful wood floors * freshly painted interior * new cellular window shades * warm and welcoming living

    Kim Hermann Huff Realty - CC

    Section Image
  • 608 E 21st St, Covington, KY 41014

    $269,900

    • 4 Beds
    • 1 Bath
    • 1,820 Sq Ft
    • 608 E 21st St
    • Covington, KY

    Come fall in love with this charming all-brick home in the desirable Wallace Woods area! This beautiful 3-story home offers timeless character, spacious living, and all the features you've been looking for. You'll love the 9' ceilings, gorgeous wood floors, and classic Rookwood fireplace that add warmth and charm throughout. Features include: 4 bedrooms * renovated bathroom * 2-car detached

    Kim Hermann Huff Realty - CC

    Section Image
  • 715 Elm St, Ludlow, KY 41016

    $274,900

    • 3 Beds
    • 2 Baths
    • 1,500 Sq Ft
    • 715 Elm St
    • Ludlow, KY

    River Views & Renovated Charm! Adorable, beautifully renovated home with river views and a fantastic location just a short walk to the city park, shops & restaurants! You'll love the inviting floor plan and thoughtful updates throughout. Features Include: 3 bedrooms * 2 full baths * spacious primary bedroom with adjoining bath, vaulted ceiling & skylights * updated kitchen with SS appliances,

    Kim Hermann Huff Realty - CC

    Section Image
  • 315 Peggy Ann Ln, Alexandria, KY 41001

    $394,900

    • 4 Beds
    • 1.5 Baths
    • 1,404 Sq Ft
    • 315 Peggy Ann Ln
    • Alexandria, KY

    Looking for the perfect blend of charm, privacy, and acreage--with an incredible bonus? This is the one! Nestled on over 4 beautiful acres, this unique property offers the space, flexibility, and storage you've been searching for. A standout feature is the newly constructed 1,500 sq. ft. detached three-bay commercial garage with oversized doors, electric, and water. Whether you need room for an

    Kim Hermann Huff Realty - CC

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 645811

Northern Kentucky Multiple Listing Service

APN: 999-99-13-964.00

Your Personal Tour Guide

Ask me questions while you tour the home.