6247 Celeste Drive

Franklin Twp, OH
$ 399,000 Beds 3 Baths 2 Sq 1,496 Virtual Tour
Monthly Estimate* How much can I afford?

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!

Active

  • Price
  • $ 399,000
  • City
  • Franklin Twp
  • Bedrooms
  • 3
  • Full Bathrooms
  • 2
  • County
  • WARREN
  • Half Bathrooms
  • 0
  • Area
  • Warren
  • Lot Size
  • 0.51 Acres
  • Zip
  • 45005
  • Sqr Footage
  • 1,496
  • Year Built
  • 1957
  • Style
  • Ranch
  • MLS#
  • 1892040
Listed By: RE/MAX United Associates;
Data Source: MLS of Greater Cincinnati (CABR)

Features

General

Sewer Septic Tank
Heating Gas
Cooling Central Air
Roof Shingle
Appliances Convection Oven,Dishwasher,Garbage Disposal,Microwave,Oven/Range,Refrigerator
HOA Fee 0.0
Garage Spaces 2.0
Architectural Style Ranch
Construction Materials Brick
Year Built 1957
Levels One
Property Subtype Single Family Residence
County Warren
Property Type Residential
HOA No
Total Rooms 8
Full Baths 2
Close Price 0.0
Status Active
Directions St. Rt 122 to North on Union,left on Moreland Dr,left on Celeste,last house on left
City Franklin Twp
High School District Franklin City SD
MLS Area Warren-E15
Lot Size Units Acres
Lot Size Square Feet 22216.0
Carport Spaces 0.0

Interior Features

Basement None
Total Fireplaces 1
Fireplace Features Electric
Window Features Aluminum
Total Bedrooms 3

Exterior Features

Exterior Amenities Covered Deck/Patio
Parking Features Driveway
Water Source Public
Foundation Details Slab
Lot Dimensions 105 x 210
Lot Size Acres 0.51

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Affordability Calculator

$3,786

Per Month

Based on the average sale price from the Cincinnati, OH office

  • Monthly Principal & interest $2,658
  • Monthly Property Taxes $1,062
  • Monthly Home Insurance $67
Adjust Payment Options
Agent Photo

Let's determine your purchasing power. Working with my mortgage partner, you'll have the information you need to shop for a home with confidence.

Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA, or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

Schools

Elementary School Unknown Elementary School
Middle School Unknown Middle School
High School Unknown High School

Price History

8/31/2026 Listed $399,000

Property vs Zip Code Average in 45005

Price
AVG $390K
$400K
Year Built
AVG 1980
1957
Visits
AVG 71
61
Data Provided by Inside Real Estate®

In The Neighborhood

Areas That We Cover

6247 Celeste Drive Franklin Twp, OH is a Single Family Home for sale at $399000 with 1496 sqft and a lot size of 0.51 Acres Acre(s). 6247 Celeste Drive Franklin Twp has 3 bedrooms, 2 baths and was built in 1957. The property's zip code is 45005 which is in Franklin Twp, OH

*Information deemed reliable but not guaranteed.

Financial calculator disclaimer: Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

All information deemed reliable, but not guaranteed, and should be independently verified. The real estate information and related content displayed on this site 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.

Your Agent
Kimberly Hartzler

Kimberly Hartzler

513-986-5767

Equal Housing Logo
Equal Housing Provider
Find your home's value