Active

6247 Celeste Drive

Franklin, OH 45005
Mark as Favorite
Bed 3

Bed

Bath 2

Bath

SqFt1,496

Sqft

Acres0.51

Acre(Lot)

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, wind ows and roof, along with additions to the garage, laundry room, primary bedroom and bathroom. Move-in ready with thoughtful updates throughout!

Read More Expand

Detail Ic Property Details

Property Type : Residential

Price : $399,000

AD Id : 90905656

MLS Id : 1892040

Beds : 3

Lot Size : 0.51 Acre

Living Area Size : 1,496

Year Built : 1957

Garage : 2

County : Warren

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total beds: 3

    Bathroom Information

    Total Baths: 2 Full Baths: 2

    Room Information

    Rooms Total: 8 Basement: None
  • Roofing Information

    Shingle
  • Interior Features

    Kitchen Island Roof: Shingle Appliances: Disposal, Range, Oven, Electric Water Heater, Convection Oven, Dishwasher, Microwave, Refrigerator
  • Heating & Cooling

    Has Heating: Yes Heating: Natural Gas Has Cooling: Yes Cooling: Central Air

  • Building Information

    Year Built: 1957 Construction Materials: Brick Patio And Porch Features: Patio Private Pool: No

  • Lot Information

    Lot Dimensions: 105 x 210 Lot Size Acres: 0.51 Lot Size Square Feet: 22216

  • Listing Price Information

    Listing Price: $399000

  • Tax Information

    Parcel Number: 07042280011

  • Parking Information

    Driveway, Attached

    Garage Information

    Has Garage: Yes Has Attached Garage: Yes Garage Space: 2

  • Utility Information

    Propane
  • Location Information

    Direction: St. Rt 122 to North on Union, left on Moreland Dr, left on Celeste, last house on left WaterSource: Public
Sell a home like this and save $23,441 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
3083 Canvasback Court, Franklin, OH, 45005 $499,900 4 3 2,382 14,039 Sqft
3083 Canvasback Court, Franklin, OH, 45005 $499,900 4 3 2,382 0.32 Acre
3009 Doe Drive, Franklin, OH, 45005 $415,000 4 3 2,054 0.32 Acre
3009 Doe Drive, Franklin, OH, 45005 $415,000 4 3 2,054 14,039 Sqft
3008 Doe Drive, Franklin, OH, 45005 $419,990 3 4 -- 0.32 Acre
3086 Canvasback Court, Franklin, OH, 45005 $550,000 5 4 2,971 0.32 Acre
3077 Canvasback Court, Franklin, OH, 45005 $495,000 4 3 2,422 0.32 Acre
3092 Canvasback Court, Franklin, OH, 45005 $589,900 4 3 3,048 0.32 Acre
3089 Canvasback Court, Franklin, OH, 45005 $475,000 3 2 1,704 14,039 Sqft
3071 Canvasback Court, Franklin, OH, 45005 $470,000 4 3 2,117 14,039 Sqft

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than ByOwner are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. The properties displayed may not be all the properties available through Broker Reciprocity. IDX information is provided exclusively 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. Data is deemed reliable but is not guaranteed accurate by the MLS. Copyright © 2026 MLS of Greater Cincinnati. All Rights Reserved.

ByOwner last updated this listing 09/01/2026 @ 08:22

MLS: 1892040 LISTED BY: Alexander Schafers, RE/MAX United Associates SOURCE: MLS of Greater Cincinnati (CincyMLS)

Homes around $399,000

Selling? Save $23,441 when you sell a home like this

Tour with a ByOwner Agent