Jon Glista
Join Sign In
Email ListingPRINT Email ListingSAVE Click to CallCALL
Active

6247 Celeste Drive, Franklin Township, OH 45005$399,000

Beds: 3 Baths: 2 full Sq. Feet: 1,496 Days on Site: 7 MLS#: 967698 View Map
6247 Celeste Drive, Franklin Township, OH 45005
6247 Celeste Drive, Franklin Township, OH 45005
6247 Celeste Drive, Franklin Township, OH 45005
6247 Celeste Drive, Franklin Township, OH 45005
6247 Celeste Drive, Franklin Township, OH 45005

41 Photos

Comments for 6247 Celeste Drive, Franklin Township, OH 45005

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!

6247 Celeste Drive | MLS# 967698

This single family home located at 6247 Celeste Drive, Franklin Township, OH 45005 is currently listed for sale with an asking price of $399,000. This property was built in 1957 and has 3 bedrooms and 2 full baths with 1496 sq. ft. Celeste Drive is located within the Franklin school district. Search Franklin Township real estate on jonglista.irongaterealtors.com today.

Property Type: Residential - Single Family Garage Features: 2 Car, Attached, Heated, Overhead Storage
Appliance Features: Dishwasher, Garbage Disposal, Microwave, Range, Refrigerator, Wall Oven Heating: Natural Gas
Basement Features: Slab Lot Dimensions: 105 x 210
Cooling: Central Lot Size: 0.51 Acres
Days on Site: 7 Outside Features: Porch
Exterior: Brick Stories: 1.0
Fireplace. Features: Electric, One Taxes: $4,642
Fireplaces: 1 Utilities: Public Water, Septic
Garage: 2 car attached Year Built: 1957
Primary Bedroom: 14 X 15 Level - Main Entry Room: 6 X 6 Level - Main
Bedroom: 13 X 14 Level - Main Kitchen: 12 X 18 Level - Main
Bedroom: 12 X 11 Level - Main Laundry: 11 X 11 Level - Main
Dining Room: 13 X 19 Level - Main Living Room: 21 X 15 Level - Main
School District: Franklin

Listed By

Agency Name: RE/MAX United Associates
Agency Phone: (513) 655-2300

Shown By

Agent Name: Jon Glista
Agent Phone: (937) 620-8913
Agency Title: Irongate Inc., Realtors

IDX logo

Franklin School District Residential Market Trend Graphs

  • Franklin School District
  • Zip Code 45005
  • Franklin Township
  • Warren County

Warren County Demographic Information for 6247 Celeste Drive, Franklin Township, OH 45005

Fips
Fips Code39165
Population
2020 to 2025 Changeup 6.1%
2010 Count212,693
2020 Count242,337
2025 Estimate (V2025)257,181
2020 Estimate (V2025)242,346
Age Distribution (Years Old)
0 to 45.1%
5 to 1723.3%
18 to 6454.7%
65 and Older16.9%
Gender
Male50.6%
Female49.4%
Place of Birth
Foreign9.1%
US90.9%
Education
High School Graduate, Age 25+95.1%
Bachelor's Degree or Higher, Age 25+45.6%
Computer and Internet use
Households with a computer97.5%
Households with a broadband Internet subscription94.9%
Language
English is Second Language, Age 5+10.8%
English is First Language, Age 5+89.2%
Veterans
Veterans12,646
Income
Per Capita Income$53,621
Median Household Income$110,132
People in Poverty6.6%
Commute
Average Work Commute Time26 minutes
Housing
Total Housing Units96,489
Households92,052
Average Household Size2.66
Owner-Occupied79.4%
Multi-Family15.5%
Owner-Occupied Median Value$349,400
Median selected monthly owner costs -with a mortgage$1,974
Median selected monthly owner costs -without a mortgage$756
Median gross rent$1,361
Building Permits
New Private Housing Issued 20241,232
Years at Residence
1 Year or More90.0%
Less Than 1 Year10.0%
Business and Employment
Private non-farm Establishments4,826
Private non-farm Employment82,752
Private non-farm Employment Growthup 1.2%
Nonemployer Establishments21,640
Number of Firms3,663
Business Production
Value of Shipments$4,514,123,000
Wholesale Trade$3,800,320,000
Retail Trade$2,934,129,000
Retail Sales Per Capita$13,461
Accommodation and Food Services$463,168,000
Land
Land Area401.31 sq. miles
Population Per Square Mile530
Schedule a showing...
or ask questions!

Jon Glista
Call: (937) 620-8913
Text: (937) 620-8913

All fields labeled with an asterisk(*) are required.

Contact Form

Mortgage Payment Calculation for 6247 Celeste Drive, Franklin Township, OH 45005

  • %
  • years/fixed
  • yearly
  • yearly (estimated)

  • Est. Payment: $2,961.72 / per month

(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 09/07/2026. The listing information on this page last changed on 09/07/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Mon 09/07/2026 12:03:45 AM EST) or Dayton MLS (last updated Sun 09/06/2026 11:46:46 PM EST) or Multiple Listing Service of Greater Cincinnati (last updated Sun 09/06/2026 11:53:25 PM EST) or Wrist MLS (last updated Sun 09/06/2026 11:24:21 PM EST). Real estate listings held by brokerage firms other than Irongate Inc., Realtors® may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Company Logo
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Login to My Homefinder

Forgot Password

Register