Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$399,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 1,496 Sq. Ft.
  • 0.51 Acres
  • 2 Car Garage
  • Updated 1 day ago
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: Cincinnati
  • MLS ID: 1892040
  • Updated: 8/31/2026
  • Added to Site: 2 day(s) ago

Interior

  • Number of Rooms: 8
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Electric
  • Appliances: Convection Oven, Dishwasher, Garbage Disposal, Microwave, Oven/Range, Refrigerator

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2
  • Primary Bathroom: Shower, Tile Floor
  • Bathroom 1: Full, Level 1
  • Bathroom 2: Full, Level 1

Bedrooms

  • Total Bedrooms: 3
  • Primary Bedroom: Walk-Out, 14 x 15, Level 1, 210 Sq. Ft.
  • Bedroom 2: 13 x 14, Level 1, 182 Sq. Ft.
  • Bedroom 3: 12 x 11, Level 1, 132 Sq. Ft.

Other Rooms

  • Foyer/Entry: Tile Floor, Level 1
  • Living Room: Walk-Out, Fireplace, Wood Floor, 21 x 15, Level 1, 315 Sq. Ft.
  • Kitchen: Tile Floor, Island, Marble/Granite/Slate, 12 x 18, 12x18, 216 Sq. Ft.
  • Dining Room: Open, Wood Floor, 13 x 19, Level 1, 247 Sq. Ft.
  • Laundry: 11 x 11, Level 1, 121 Sq. Ft.

Additional Information

  • Other Features: Attic Storage, Recessed Lights

Exterior

  • Exterior Features: Covered Deck/Patio

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 2
  • Parking: Driveway
  • Garage Description: Front, Garage Attached, Heated

Location

  • Area: Franklin Twp.
  • County: Warren
  • Suburb: Franklin Twp.
  • Driving Directions: St. Rt 122 to North on Union, left on Moreland Dr, left on Celeste, last house on left

School Information

  • School District: Franklin City SD
  • High School District: Franklin City SD

Community

  • Home Owners Assn.: False

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air Conditioning
  • Heating Type: Gas
  • Heating Fuel: Propane
  • Water Heater: Electric

Utilities

  • Sewer: Septic Tank
  • Water: Public

Structural Information

  • Architectural Style: One Story Ranch
  • Description/Design: Single Family
  • Exterior Const.: Brick
  • Basement Desc.: None
  • Foundation: Slab
  • Roof: Shingle
  • Windows: Aluminum
  • Stories/Levels: One
  • Square Feet: 1,496
  • Year Built: 1957

Lot Features

  • Lot Size (Acres): 0.51
  • Lot Dimensions: 105 x 210

Financial Considerations

  • Semi-Annual Taxes: $2321

Disclosures and Reports

  • APN: 7042280011

Listed by RE/MAX United Associates (513) 655-2300, Alexander Schafers

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 —

  • Alexander Schafers

    RE/MAX United Associates

    513-655-2300

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, Alexander Schafers

Just Listed near 6247 Celeste Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1084 Brown Rd, Washington Township, OH 45177 - Photo 1 Just Listed
$469,900

1084 Brown Rd  Washington Township, OH 45177

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,554
    Sq. Ft.
13178 Stieman Rd, Washington Township, OH 45171 - Photo 1 Just Listed
$249,900

13178 Stieman Rd  Washington Township, OH 45171

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,248
    Sq. Ft.
857 Settlemyre Rd, Washington Township, OH 45054 - Photo 1 Just Listed
$475,000

857 Settlemyre Rd  Washington Township, OH 45054

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,874
    Sq. Ft.
112 Oklahoma Dr, Jackson Township, OH 45171 - Photo 1 Just Listed
$325,000

112 Oklahoma Dr  Jackson Township, OH 45171

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,626
    Sq. Ft.

Price Reduced near 6247 Celeste Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

3135 Wahl Rd, Scott Township, OH 45130 - Photo 1 Price Reduced
-$10,000 (-2.87%)
$339,000

3135 Wahl Rd  Scott Township, OH 45130

  • Farm
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 1
    Total Bath
  • 4,020
    Sq. Ft.
0 Fairground, Russellville, OH 45168 - Photo 1 Price Reduced
-$10,000 (-16.69%)
$49,900

0 Fairground  Russellville, OH 45168

  • Acreage
  • Active
  • Updated 1 day ago
  • 3.79
    Acres
224 Gregory St, Mount Orab, OH 45154 - Photo 1 Price Reduced
-$10,000 (-3.13%)
$309,900

224 Gregory St  Mount Orab, OH 45154

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 1,732
    Sq. Ft.
324 Glover Mdws Wy, Mount Orab, OH 45154 - Photo 1 Price Reduced
-$3,000 (-0.95%)
$311,900

324 Glover Mdws Wy  Mount Orab, OH 45154

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 1,732
    Sq. Ft.

Recent Sales near 6247 Celeste Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

4577 Fisher Rd, Franklin Township, OH 45005 - Photo 1 Sold
$370,000

4577 Fisher Rd  Franklin Township, OH 45005

  • Single Family
  • Closed
  • 4
    Beds
  • 2
    Total Baths
  • 1,740
    Sq. Ft.
2714 Leonardo Way, Franklin Township, OH 45005 - Photo 1 Sold
$441,000

2714 Leonardo Way  Franklin Township, OH 45005

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
3063 Lynn Dr, Franklin Township, OH 45005 - Photo 1 Sold
$357,500

3063 Lynn Dr  Franklin Township, OH 45005

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 2,056
    Sq. Ft.
3621 Wilson Farms Blvd, Franklin Township, OH 45005 - Photo 1 Sold
$353,500

3621 Wilson Farms Blvd  Franklin Township, OH 45005

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 1,784
    Sq. Ft.

6247 Celeste Drive, Franklin Township, OH 45005 (MLS# 1892040) 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 Township? You can browse all Franklin Township real estate or contact a Coldwell Banker agent to request more information.

Tour this property