Pending
Price CutPrice Drop: $24K (10/25)
Sale Pending at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-10-25
Photo 1 of Sale Pending at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-10-25
Photo 2 of Sale Pending at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-10-25
Photo 3 of Sale Pending at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-10-25
Photo 4 of Sale Pending at 6247 Celeste Dr, Franklin, OH 45005 | MLS# 967698 | Listing updated on 2026-10-25
37+
Beds Icon

Street View

$375,000

Monthly Est:$1,867

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

6247 Celeste Dr, Franklin, OH 45005

$1,867/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1957

  • $-- HOA

  • 22,215.6 sqft lot

  • $251/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 garage includes two attics for exceptional storage. Major 2024 improvements include the furnace, electrical, plumbing, windows and roof, along with additions to the garage, laundry room, primary bedroom and bathroom. Move-in ready with thoughtful updates throughout!

  • Houzeo last checked: 11 minutes ago
  • Listing updated: October 25, 2026 at 1:49 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

    Pending

  • 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

    Pending

  • Days on Market

    61

Continue Your Journey in App

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

Location

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

  • Heating

    Natural Gas

  • Appliances

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

  • Interior Features

    Granite Counters, Kitchen Island

  • Exterior Features

    Porch

  • Cooling

    Central Air

  • Window Features

    Aluminum Frames

  • Sewer

    Septic Tank

Construction

  • Year Built

    Year Built: 1957

  • Home type

    Single Family Residence

  • Architectural Style

    Ranch

  • Foundation Details

    Slab

  • Construction Materials

    Brick

Utilities & Energy

  • Utilities

    Septic Available, Water Available

  • Parking Features

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

  • Water Source

    Public

  • Fireplace Features

    Electric, One

Other Features

  • Patio And Porch Features

    Porch

Price History

DateEventPrice

10/25/2026

Source: mls_logoDayton Realtors MLS-OH #967698

Pending

$375,000

$251/sqft

10/23/2026

Source: mls_logoDayton Realtors MLS-OH #967698

Price Decreased

$375,000 -6.02%

$251/sqft

08/31/2026

Source: mls_logoDayton Realtors MLS-OH #967698

Price Decreased

$399,000 -4.77%

$267/sqft

03/25/2025

Source: mls_logoCincinnati MLS-OH #1827933

Off Market

$419,000 -4.56%

$280/sqft

02/20/2025

Source: mls_logoDayton Realtors MLS-OH #926160

Listed for Sale

$439,000

$293/sqft

Show more

Nearby Homes

Based on information from Dayton Realtors® MLS through Oct 31, 2026, 07:30PM. 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

Skip to Main Content