6247 Celeste Drive Franklin Twp., OH 45005

3
Bed
2
Bath
1,496
Sq. Ft
0.51
Acres
$399,000
MLS# 1892040
3 BR
2 BA
1,496 Sq. Ft
0.51 AC
1/40
    2/40
    3/40
    Virtual Tour

    More About 6247 Celeste Drive

    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!

    Connect with a loan officer to get started!

    Directions to this Listing

    : St. Rt 122 to North on Union, left on Moreland Dr, left on Celeste, last house on left

    Information Refreshed: 10/10/2026 10:19 PM

    Ask a Question

    Contact our Customer Care team or
    513-985-4010
    CallText

    By providing a telephone number and submitting the form, you are consenting to be contacted by SMS text message and agreeing to our Privacy Policy. Message frequency may vary. Message and data rates may apply. Reply STOP to opt out out of further messaging. Reply HELP for more information.

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    Call us now at 513-985-4010

    Property Details

    • MLS#:

      1892040

    • Type:

      Single Family

    • Sq. Ft:

      1,496

    • County:

      Warren

    • Age:

      69

    • Appliances:

      Oven/Range, Dishwasher, Refrigerator, Microwave, Garbage Disposal, Convection Oven

    • Architecture:

      Ranch

    • Basement Type:

      None

    • Construction:

      Brick

    • Cooling:

      Central Air

    • Fireplace:

      Electric

    • Garage:

      Garage Attached, Front, Heated

    • Garage Spaces:

      2

    • Gas:

      Propane

    • Heating:

      Gas

    • Kitchen:

      Tile Floor, Marble/Granite/Slate, Island

    • Lot Description:

      105 x 210

    • Misc:

      Attic Storage

    • Parking:

      Driveway

    • Primary Bedroom:

      Walkout

    • S/A Taxes:

      2321

    • School District:

      Franklin City

    • Sewer:

      Septic Tank

    • Water:

      Public

    Rooms

    • Bath 1:

      F (Level: 1)

    • Bath 2:

      F (Level: 1)

    • Bedroom 1:

      14x15 (Level: 1)

    • Bedroom 2:

      13x14 (Level: 1)

    • Bedroom 3:

      12x11 (Level: 1)

    • Dining Room:

      13x19 (Level: 1)

    • Entry:

      6x6 (Level: 1)

    • Kitchen:

      12x18 (Level: 1)

    • Laundry Room:

      11x11 (Level: 1)

    • Living Room:

      21x15 (Level: 1)
    This listing courtesy of Alexander Schafers (513) 331-1428 , RE/MAX United Associates (513) 655-2300

    Frequently Asked Questions

    How much does 6247 Celeste Drive cost?
    6247 Celeste Drive, Franklin Twp., OH is listed at $399,000.
    How many bedrooms and bathrooms does 6247 Celeste Drive have?
    6247 Celeste Drive has 3 bedrooms and 2 full bathrooms.
    What type of property is 6247 Celeste Drive?
    6247 Celeste Drive is a Single Family with approximately 1,496 square feet on 0.51 acres.
    Is 6247 Celeste Drive still available?
    6247 Celeste Drive is currently listed as Active.
    What school district serves 6247 Celeste Drive?
    6247 Celeste Drive is served by the Franklin City school district.
    OH•45005•Warren County•Franklin Twp.•6247 Celeste Drive

    Ask a Question

    Contact our Customer Care team or
    513-985-4010
    CallText

    By providing a telephone number and submitting the form, you are consenting to be contacted by SMS text message and agreeing to our Privacy Policy. Message frequency may vary. Message and data rates may apply. Reply STOP to opt out out of further messaging. Reply HELP for more information.

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    Call us now at 513-985-4010

    Monthly Cost

    Mortgage Calculator

    Enter your details for an estimated monthly payment. See how much house you can afford

    %
    LEGAL DISCLAIMERS▼

    Your estimated payment

    $2,210
    per month
    PRINCIPAL & INTEREST
    $2,210
    CHAT WITH A LOAN OFFICER

    Sell with Sibcy Cline

    Enter your address for a free market report on your home. Explore your home value estimate, buyer heatmap, supply-side trends, and more.

    Must reads

    The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc. Those listings held by brokerage firms other than Sibcy Cline, Inc. are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. Copyright© 2026 Multiple Listing Services of Greater Cincinnati / All Information is believed accurate, but is NOT guaranteed.