Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$399,000

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 1,496 Sq. Ft.
  • 0.51 Acres
  • 2 Car Garage
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 6247 Celeste Dr

General

  • Price: $399,000
  • Status: Active
  • Type: Single Family
  • Source: 506
  • MLS ID: 967698
  • Updated: 8/31/2026
  • Added to Site: 42 day(s) ago

Interior

  • Number of Rooms: 8
  • Interior Features: Granite Counters, Kitchen Island
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Electric, One
  • Appliances: Built-In Oven, Dishwasher, Disposal, Microwave, Range, Refrigerator, Electric Water Heater

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2
  • Main Floor Baths: 2

Bedrooms

  • Total Bedrooms: 3

Exterior

  • Exterior Features: Porch
  • Porch/Patio/Deck: Porch

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 2
  • Parking Features: Attached, Garage, Two Car Garage, Heated Garage, Storage

Location

  • County: Warren

School Information

  • Elem School District: Franklin
  • Midd School District: Franklin
  • High School District: Franklin

Heating & Cooling

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

Utilities

  • Sewer: Septic Tank
  • Water: Public
  • Utility Description: Septic Available, Water Available

Structural Information

  • Architectural Style: Ranch
  • Construction: Brick
  • Windows: Aluminum Frames
  • Stories/Levels: 1
  • Square Feet: 1,496
  • Sq. Ft. Source: Assessor
  • Living Area: 1,496 Sq. Ft.
  • Year Built: 1957

Lot Features

  • Lot Size (Acres): 0.51
  • Lot Size Source: Assessor
  • Lot Dimensions: 105 x 210
  • Zoning: Residential

Financial Considerations

  • For Sale/Rent/Lease: For Sale

Disclosures and Reports

  • Legal Description: Warren County Tax ID 07042280011
  • Property ID: 7042280011

Listed by RE/MAX United Associates (513) 655-2300, Alex Schafers (513) 331-1428

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 agent

— 6247 Celeste Dr —

  • Alex Schafers

    RE/MAX United Associates

    (513) 655-2300

513-331-1428

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 6247 Celeste Dr

School District:Franklin City School District
NameGradesDistance
Hunter Elementary School
4418 State Route 122, Franklin, OH 45005
2-2.3 mi
George H Gerke Elementary School
312 Sherman Drive, Franklin, OH 45005
1-3.7 mi
William C Schenck Elementary School
350 Arlington Drive, Franklin, OH 45005
PK-K4.2 mi
Franklin High School
750 East 4th Street, Franklin, OH 45005
9-123.3 mi
Franklin Junior High School
750 East 4th Street, Franklin, OH 45005
6-83.3 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 6247 Celeste Dr Get Price Alerts and Save Property

Date
Details
Price
Change
Source
8/31/2026
Listed
$399,000
166%
MLS
7/23/2021
Sold
$150,000
—
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 6247 Celeste Dr

Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,669
5267%
$104,510
7365%
2024
$87
40%
$1,400
69%
2023
$62
-97%
$826
-98%
2022
$2,237
4%
$46,942
—
2021
$2,157
-1%
$46,942
18%
2021
$2,188
15%
$39,781
—
2019
$1,909
—
$39,781
—
2018
$1,912
7%
$39,781
18%
2017
$1,783
-2%
$33,730
—
2016
$1,820
2%
$33,730
—
2015
$1,792
—
$33,730
3%
2014
$1,791
17%
$32,746
—
2013
$1,529
—
$32,746
—
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 6247 Celeste 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 RE/MAX United Associates (513) 655-2300, Alex Schafers (513) 331-1428

6247 Celeste Drive, Franklin Twp, OH 45005 (MLS# 967698) is a Single Family property with 3 bedrooms and 2 full bathrooms. 6247 Celeste Drive is currently listed for $399,000 and was received on August 31, 2026. Want to learn more about 6247 Celeste Drive? Do you have questions about finding other Single Family real estate for sale in Franklin Twp? You can browse all Franklin Twp real estate or contact a Coldwell Banker agent to request more information.

Tour this property