For Sale
Single family home for sale at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-08-31
Photo 1 of Single family home for sale at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-08-31
Photo 2 of Single family home for sale at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-08-31
Photo 3 of Single family home for sale at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-08-31
Photo 4 of Single family home for sale at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-08-31
37+
Beds Icon

Street View

$399,000

Monthly Est:$1,986

  • Beds Icon3 Beds
  • Beds Icon
    2 Baths
  • Beds Icon1,496sqft

6247 Celeste Dr, Franklin, OH 45005

$1,986/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1957

  • $-- HOA

  • 22,215.6 sqft lot

  • $267/sq.ft

Description

Completely renovated in 2024, this stunning ranch offers modern style, an open layout and plenty of room to enjoy both indoors and out. The spacious living and dining areas flow seamlessly into the updated kitchen featuring granite countertops, sleek cabinetry, stainless steel appliances and a large island. A striking fireplace accent wall, recessed lighting and contemporary flooring add to the home's fresh, polished feel. Both bathrooms have been beautifully updated, while the private primary suite provides a comfortable retreat. Step outside to a large covered patio overlooking the expansive, tree-lined yard perfect for relaxing or entertaining. The oversized heated gar...

Continue Reading
  • Houzeo last checked: 8 minutes ago
  • Listing updated: August 31, 2026 at 12:46 pm
  • Listing Provided by: Alex Schafers (513) 331-1428 | RE/MAX United Associates (513) 655-2300
  • Source: Dayton Realtors MLS-OH | MLS#: 967698 Dayton Realtors MLS-OH

Property Details

  • Status

    Active

  • Type

    Single Family Residence

  • No. of Stories

    1

  • County

    Warren County

  • City

    Franklin

  • Neighborhood

    --

  • Year Built

    1957

  • HOA Fees

    -

  • Finished Area

    1,496 sqft

  • Lot Size

    22,215.6 sqft lot

  • Basement Area

    - sqft

  • MLS Name

    Dayton Realtors MLS

  • MLS Number

    967698

  • MLS Status

    Active

  • Days on Market

    15

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 3

    Bathrooms: 2

  • LivingRoom

    Level: Main

    Area: 315.00 Square Feet

    Dimensions: 21 x 15

  • Laundry

    Level: Main

    Area: 121.00 Square Feet

    Dimensions: 11 x 11

  • Kitchen

    Level: Main

    Area: 216.00 Square Feet

    Dimensions: 12 x 18

  • EntryFoyer

    Level: Main

    Area: 36.00 Square Feet

    Dimensions: 6 x 6

  • DiningRoom

    Level: Main

    Area: 247.00 Square Feet

    Dimensions: 13 x 19

  • Bedroom

    Level: Main

    Area: 132.00 Square Feet

    Dimensions: 12 x 11

  • Bedroom

    Level: Main

    Area: 182.00 Square Feet

    Dimensions: 13 x 14

  • PrimaryBedroom

    Level: Main

    Area: 210.00 Square Feet

    Dimensions: 14 x 15

Interior

  • Interior Features

    Granite Counters, Kitchen Island

  • Exterior Features

    Porch

  • Heating

    Natural Gas

  • Sewer

    Septic Tank

  • Appliances

    Built In Oven, Dishwasher, Disposal, Microwave, Range, Refrigerator, Electric Water Heater

  • Cooling

    Central Air

  • Window Features

    Aluminum Frames

Construction

  • Year Built

    Year Built: 1957

  • Home type

    Single Family Residence

  • Architectural Style

    Ranch

  • Foundation Details

    Slab

  • Construction Materials

    Brick

Utilities & Energy

  • Parking Features

    Attached, Garage, Two Car Garage, Heated Garage, Storage

  • Water Source

    Public

  • Fireplace Features

    Electric, One

  • Utilities

    Septic Available, Water Available

Other Features

  • Patio And Porch Features

    Porch

Price History

DateEventPrice

08/31/2026

Source: mls_logoDayton Realtors MLS-OH #967698

Price Decreased

$399,000 -9.11%

$267/sqft

02/20/2025

Source: mls_logoDayton Realtors MLS-OH #926160

Listed for Sale

$439,000

$293/sqft

01/09/2025

Source: mls_logoDayton Realtors MLS-OH #926160

Off Market

$439,000 +166.06%

$293/sqft

11/17/2020

Source: mls_logoDayton Realtors MLS-OH #824638

Price Increased

$165,000 +32.53%

$110/sqft

09/01/2007

Source: mls_logoCincinnati MLS-OH #1046168

Listing Removed

$124,500

$83/sqft

Getting Around 6247 Celeste Dr

Bike Score®

Bike Score

Somewhat Bikeable

24/100

Walk Score®

Walk Score

Car-Dependent

1/100

Data provided by Redfin

Based on information from Dayton Realtors® MLS through Sep 16, 2026, 03:00AM. Information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS. The MLS may, at its discretion, require use of other disclaimers as necessary to protect participants and/or the MLS from liability. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 Dayton Area Board of Realtors®, Inc. All rights reserved.

Advertising Broker: Nicholas Huscroft | Chosen Realty

Click to see all homes
static map image
Satellite
Close IconHouzeo

Do Real Estate on the Go!

For Sale
Price
Beds & Baths
Home Type
Filters
Save Search Share