Skip main navigation
PendingPrice cut: $24K (10/23)
$375,000
3beds
1,496sqft

6247 Celeste Dr, Franklin, OH 45005

3beds
1,496sqft
Single Family Residence
Built in 1957
0.51 Acres Lot
$251/sqft

What's special

Large islandContemporary flooringSleek cabinetryOpen layoutOversized heated garagePrivate primary suiteRecessed lighting

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!

55 days
522
47
Source: DABR MLS,MLS#: 967698MLS LogoOriginating MLS: Dayton Area Board of REALTORS
Travel times

Living Room

Kitchen

Primary Bedroom

Zillow last checked:

Listing updated:

Listed by:

Alex Schafers 513-331-1428,

RE/MAX United Associates

Source: DABR MLS,MLS#: 967698MLS LogoOriginating MLS: Dayton Area Board of REALTORS

Facts & features

Interior

Bedrooms & bathrooms
  • Bedrooms: 3
  • Bathrooms: 2
  • Full bathrooms: 2
  • Main level bathrooms: 2
Primary bedroom
  • Level: Main
  • Dimensions: 14 x 15
Bedroom
  • Level: Main
  • Dimensions: 13 x 14
Bedroom
  • Level: Main
  • Dimensions: 12 x 11
Dining room
  • Level: Main
  • Dimensions: 13 x 19
Entry foyer
  • Level: Main
  • Dimensions: 6 x 6
Kitchen
  • Level: Main
  • Dimensions: 12 x 18
Laundry
  • Level: Main
  • Dimensions: 11 x 11
Living room
  • Level: Main
  • Dimensions: 21 x 15
Heating
  • Natural Gas
Cooling
  • Central Air
Appliances
  • Included: Built-In Oven, Dishwasher, Disposal, Microwave, Range, Refrigerator, Electric Water Heater
Features
  • Granite Counters, Kitchen Island
  • Windows: Aluminum Frames
  • Number of fireplaces: 1
  • Fireplace features: Electric, One
Interior area
  • Total structure area: 1,496
  • Total interior livable area: 1,496 sqft

Property

Parking
  • Total spaces: 2
  • Parking features: Attached, Garage, Two Car Garage, Heated Garage, Storage
  • Attached garage spaces: 2
Features
  • Levels: One
  • Stories: 1
  • Patio & porch: Porch
  • Exterior features: Porch
Lot
  • Size: 0.51 Acres
  • Dimensions: 105 x 210
Details
  • Parcel number: 07042280011
  • Zoning: Residential
  • Zoning description: Residential

Construction

Type & style
  • Home type: SingleFamily
  • Architectural style: Ranch
  • Property subtype: Single Family Residence
Materials
  • Brick
  • Foundation: Slab
Condition
  • Year built: 1957

Utilities & green energy

  • Sewer: Septic Tank
  • Water: Public
  • Utilities for property: Septic Available, Water Available

Community & HOA

HOA
  • Has HOA: No
Location
  • Region: Franklin

Financial & listing details

  • Price per square foot: $251/sqft
  • Tax assessed value: $134,120
  • Annual tax amount: $2,237
  • Date on market: 8/31/2026

Price history

DateEventPrice
10/25/2026Pending sale$375,000$251/sqft
Source: Cincy MLS #1892040 Report a problem
10/23/2026Price change$375,000-6%$251/sqft
Source: Cincy MLS #1892040 Report a problem
8/31/2026Listed for sale$399,000-4.8%$267/sqft
Source: Cincy MLS #1892040 Report a problem
4/21/2025Listing removed$419,000$280/sqft
Source: DABR MLS #926160 Report a problem
3/25/2025Price change$419,000-4.6%$280/sqft
Source: Cincy MLS #1827933 Report a problem
2/20/2025Price change$439,000-4.4%$293/sqft
Source: Cincy MLS #1827933 Report a problem
1/9/2025Listed for sale$459,000-15%$307/sqft
Source: Cincy MLS #1827933 Report a problem
12/31/2024Listing removed$540,000$361/sqft
Source: Cincy MLS #1821676 Report a problem
12/5/2024Price change$540,000-3.6%$361/sqft
Source: Cincy MLS #1821676 Report a problem
10/17/2024Listed for sale$560,000+263.6%$374/sqft
Source: Cincy MLS #1821676 Report a problem
5/27/2022Sold$154,000-3.1%$103/sqft
Source: Cincy MLS #1738836 Report a problem
5/22/2022Pending sale$159,000$106/sqft
Source: Cincy MLS #1738836 Report a problem
5/13/2022Listed for sale$159,000+6%$106/sqft
Source: Cincy MLS #1738836 Report a problem
7/23/2021Sold$150,000-3.2%$100/sqft
Source: DABR MLS #832937 Report a problem
6/4/2021Pending sale$155,000$104/sqft
Source: DABR MLS #832937 Report a problem
5/6/2021Listing removed--
Source: Keller Williams Report a problem
4/22/2021Pending sale$155,000$104/sqft
Source: Keller Williams #832937 Report a problem
4/3/2021Listed for sale$155,000$104/sqft
Source: Keller Williams #832937 Report a problem
3/7/2021Pending sale$155,000$104/sqft
Source: Keller Williams Community Partners #832937 Report a problem
2/16/2021Price change$155,000-2.5%$104/sqft
Source: Keller Williams Community Partners #832937 Report a problem
1/23/2021Listed for sale$159,000-3.6%$106/sqft
Source: Keller Williams Community Partners #832937 Report a problem
1/1/2021Listing removed--
Source: RE/MAX International Report a problem
11/15/2020Price change$165,000-2.9%$110/sqft
Source: RE/MAX United Associates #1673632 Report a problem
10/15/2020Price change$169,900-2.9%$114/sqft
Source: RE/MAX United Associates #1673632 Report a problem
8/25/2020Listed for sale$175,000$117/sqft
Source: RE/MAX United Associates #1673632 Report a problem

Public tax history

YearProperty taxesTax assessment
2022$2,237 +3.7%$46,942
2021$2,157 +3.9%$46,942 +18%
2020$2,076 +10.5%$39,781
2019$1,878 -1.8%$39,781
2018$1,912 +7.2%$39,781 +17.9%
2017$1,783 -2.1%$33,730
2016$1,820 0%$33,730
2015$1,821 +0.1%$33,730 +3%
2014$1,819 +19%$32,750 -16.4%
2013$1,529 +4.5%$39,170
2012$1,463 -3.1%$39,170
2011$1,509 +3.7%$39,170
2010$1,456 -0.7%$39,170
2009$1,465 +2.8%$39,170
2008$1,426 $39,170
2007-- $39,170 +15.8%
2006-- $33,820 +5.3%
2005-- $32,130
2004-- $32,130
2003-- $32,130 +10%
2002-- $29,210
2001-- $29,210
2000-- $29,210 +2.5%
1999-- $28,510
Find assessor info on the county website

Monthly payment

Est. payment
$2,388/mo
Principal & interest
$2038
Property taxes
$350
More affordability toolsChevron Right

Estimated market value

Not available

Estimated sales range

Not available

Not available

Climate risks

Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.

Neighborhood: 45005

Nearby schools

Hunter Elementary School
Grades 2 • 2.3 miles
N/A
GreatSchools® Rating
Franklin Junior High School
Grades 5-8 • 3.2 miles
4/10
GreatSchools® Rating
Test Score Rating
6/10
Student Progress Rating
2/10
Franklin High School
Grades 9-12 • 3.2 miles
4/10
GreatSchools® Rating
Test Score Rating
5/10
College Readiness Rating
5/10
Student Progress Rating
3/10

    Nearby cities

    Nearby zip codes

    Other Franklin Topics

      Search
      Updates
      Favorites
      Plan
      Inbox