Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$775,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 0.45 Acres
  • 3 Car Garage
  • Updated 1 day ago
See This Home
Save This Home
See This Home
Save This Home
This executive custom-built ranch by Bold Homes offers luxury living, breathtaking lake views, & exceptional entertaining space in the highly desirable Triple Crown community. Situated on a private cul-de-sac lakefront lot, this home delivers a rare lifestyle opportunity perfect for relaxing, fishing, feeding ducks, and enjoying peaceful waterfront views. The exterior showcases full brick with stone accents, meticulous landscaping, a brand-new shingled roof, & an oversized side-entry 3-car garage. Outdoor living is unmatched with a motorized screened-in porch, expansive deck with motorized awning, oversized patio, hot tub, firepit, and private garden. Inside, the open floor plan features soaring 11-foot ceilings, gleaming hardwood floors, tray ceilings, arched windows, & abundant natural light. A stunning stone fireplace anchors the main living space, while custom cabinetry, cased windows, & detailed craftsmanship add warmth & elegance throughout. The custom kitchen includes built-in appliances, tiled backsplash, crown molding, breakfast bar seating, & beautiful display cabinetry, making it ideal for entertaining & everyday living. The adjacent 4-season room offers panoramic lake views and year-round enjoyment. The first-floor primary suite is a true retreat with tray ceilings, lake views, walk-in closet, dual vanity, sitting bench, and a remodeled custom-tiled shower. A convenient first-floor laundry room adds everyday functionality. The finished walkout lower level expands the living space with a custom wet bourbon bar, built-in entertainment system, theatre room, workout room, abundant storage, and the option for an additional guest suite ideal for multigenerational living or extended guests. Located just minutes from the Triple Crown clubhouse, playground, private golf course, shopping, dining, and everyday amenities, this one-of-a-kind luxury ranch combines waterfront living, executive finishes, and resort-style amenities in one extraordinary package.

Full Property Details for 1067 Aristides Dr

General

  • Price: $775,000
  • HOA FEE: $42/month
  • HOA FEE FREQ.: Annually
  • Status: Active
  • Type: Single Family
  • Source: Northern_Kentucky
  • MLS ID: 642719
  • Updated: 5/19/2026
  • Added to Site: 1 day(s) ago

Interior

  • Number of Rooms: 14
  • Interior Features: Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Soaking Tub, Pantry, Open Floorplan, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Bookcases, Breakfast Bar, Built-in Features, Ceiling Fan(s), High Ceilings, Multi-Panel Doors, Natural Woodwork, Recessed Lighting, Master Downstairs
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Stone, Gas
  • Appliances: Electric Cooktop, Dishwasher, Double Oven, Microwave, Refrigerator

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 4

Other Rooms

  • Laundry: Laundry Room, Main Level

Additional Information

  • Shared Amenities: Playground, Trail(s)

Exterior

  • Porch/Patio/Deck: Covered, Patio, Porch, Tiered Deck

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 3
  • Parking Features: Attached, Driveway, Garage Faces Side, Off Street, On Street, Oversized

Location

  • County: Boone
  • Driving Directions: Frogtown to War Admiral to Aristides

School Information

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

Community

  • Community Name: K11 - Richwd/Un/Wal/Ver/SB
  • Association: Yes
  • Assoc. Fees Include: Association Fees, Management

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air Conditioning
  • Heating Type: Natural Gas, Forced Air

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Cable Available: Yes
  • Utility Description: Cable Available

Structural Information

  • Architectural Style: Ranch
  • Construction: Brick, Stone
  • Basement Desc.: Full Finished Bath, Finished, Storage Space, Walk-Out Access
  • Roof: Shingle
  • Windows: Insulated Windows, Vinyl Frames, Wood Frames
  • Year Built: 2006
  • Property Condition: Existing Structure

Lot Features

  • Property View: Lake
  • Lot Size (Acres): 0.45
  • Lot Size (Sq. Ft.): 19,671.7
  • Lot Size: .45
  • Lot Dimensions: of record
  • Lot Features: Waterfront

Water Features

  • Water View: Yes

Financial Considerations

  • Association Fee: $500
  • Assoc Fee Freq.: Annually

Disclosures and Reports

  • Property ID: 064.19-07-043.00

Listed by Huff Realty - Florence, Bradley Treas and Huff Realty - Florence, The Treas Team

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agents

— 1067 Aristides Dr —

  • Bradley Treas

    Huff Realty - Florence

  • The Treas Team

    Huff Realty - Florence

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 1067 Aristides Dr

School District:Boone County School District
NameGradesDistance
Shirley Mann Elementary School
10435 U.S. 42, Union, KY 41091
K-50.6 mi
Gray Middle School
10400 U.S. 42, Union, KY 41091
6-80.8 mi
Larry A. Ryle High School
10379 U.S. 42, Union, KY 41091
9-120.8 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 1067 Aristides Dr Get Price Alerts and Save Property

Date
Details
Price
Change
Source
5/19/2026
Listed
$775,000
67.12%
MLS
3/02/2007
Sold
$463,746
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 1067 Aristides Dr

Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,225
20%
$420,500
17%
2024
$3,525
-3%
$360,400
—
2023
$3,649
2%
$360,400
—
2022
$3,592
-2%
$360,400
—
2021
$3,674
—
$360,400
9%
2021
$3,674
-4%
$330,000
—
2018
$3,840
2%
$330,000
—
2017
$3,765
-1%
$330,000
—
2019
$3,822
3%
$330,000
—
2016
$3,712
—
$330,000
—
2015
$3,719
2%
$330,000
—
2014
$3,650
—
$330,000
—
2013
$3,646
—
$330,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 1067 Aristides Dr

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Huff Realty - Florence, Bradley Treas and Huff Realty - Florence, The Treas Team

Similar Properties near 1067 Aristides Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

4741 Donegal Ave, Union, KY 41091 - Photo 1
$775,000

4741 Donegal Ave  Union, KY 41091

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 3,671
    Sq. Ft.
10723 St Leger Cir, Union, KY 41091 - Photo 1 Just Listed
$745,000

10723 St Leger Cir  Union, KY 41091

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 3,978
    Sq. Ft.
1549 Smarty Jones Ct, Union, KY 41091 - Photo 1
$760,000

1549 Smarty Jones Ct  Union, KY 41091

  • Single Family
  • Active
  • Updated 12 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 3,500
    Sq. Ft.
10400 Brookhurst Ln, Union, KY 41091 - Photo 1
$735,000

10400 Brookhurst Ln  Union, KY 41091

  • Single Family
  • Active
  • Updated 8 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,905
    Sq. Ft.
Listed by Teresa Kraft (859) 512-3000 and Gabriella DeAngelis (859) 308-9733

Just Listed near 1067 Aristides Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2435 Preservation Way, Florence, KY 41042 - Photo 1 Just Listed
$634,900

2435 Preservation Way  Florence, KY 41042

  • Single Family
  • Active
  • Updated 5 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 3,184
    Sq. Ft.
Listed by Adam Hayhow (513) 315-1501
1129 Cayton Rd, Florence, KY 41042 - Photo 1 Just Listed
$425,000

1129 Cayton Rd  Florence, KY 41042

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,004
    Sq. Ft.
7607 Cloudstone Dr, Florence, KY 41042 - Photo 1 Just Listed
$379,900

7607 Cloudstone Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,266
    Sq. Ft.
6900 Houston Rd, Florence, KY 41042 - Photo 1 Just Listed
$134,500

6900 Houston Rd  #40  Florence, KY 41042

  • Office
  • Active
  • Updated 8 hours ago

Price Reduced near 1067 Aristides Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1837 Waverly Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$4,000 (-1.03%)
$385,000
Open House

1837 Waverly Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,028
    Sq. Ft.
Listed by Liz Jacobs (859) 655-5818
713 Somerset Blvd, Florence, KY 41042 - Photo 1 Price Reduced
-$10,000 (-3.72%)
$259,000

713 Somerset Blvd  #9D  Florence, KY 41042

  • Condo
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,339
    Sq. Ft.
356 Cornwall Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$2,500 (-0.88%)
$281,500

356 Cornwall Dr  Florence, KY 41042

  • Condo
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
7687 Big Cedar Ct, Florence, KY 41042 - Photo 1 Price Reduced
-$15,001 (-2.22%)
$659,999

7687 Big Cedar Ct  Florence, KY 41042

  • Single Family
  • Active
  • Updated 2 days ago
  • 5
    Beds
  • 4
    Total Baths

Recent Sales near 1067 Aristides Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

10730 Stone St, Union, KY 41091 - Photo 1 Sold
$752,650

10730 Stone St  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
812 Johnstown Ct, Union, KY 41091 - Photo 1 Sold
$700,005

812 Johnstown Ct  Union, KY 41091

  • Single Family
  • Closed
  • 5
    Beds
  • 4
    Total Baths
14890 Cool Springs Blvd, Union, KY 41091 - Photo 1 Sold
$730,000

14890 Cool Springs Blvd  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 5,800
    Sq. Ft.
10596 Brookhurst Ln S, Union, KY 41091 - Photo 1 Sold
$734,900

10596 Brookhurst Ln S  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths

1067 Aristides Drive, Union, KY 41091 (MLS# 642719) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 1067 Aristides Drive is currently listed for $775,000 and was received on May 19, 2026. Want to learn more about 1067 Aristides Drive? Do you have questions about finding other Single Family real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.

Tour this property