6247 Celeste Dr, Franklin, OH 45005
OFF MARKET

$154,000

Last sold price
  • 3 Beds
  • 1 Bath
  • 1,496 sqft (on 0.51 acres)

6247 Celeste Dr, Franklin, OH 45005

Currently Off Market - Sold May 27, 2022 for $154,000

Home Value

Learn more about this home's value by checking out the value of nearby homes and how much similar homes have sold for.

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
209 Arcadia Dr, Middletown, OH
0.87
Single-Family Home
$232,000
11/25/25
3
1
1,504
104 Kenec Dr, Middletown, OH
0.85
Single-Family Home
$125,000
11/21/25
3
1
1,164
5288 S Dixie Hwy, Franklin, OH
0.58
Single-Family Home
$170,700
03/11/26
3
2
1,452
6334 Bevis Ln, Franklin, OH
0.26
Single-Family Home
$75,000
02/18/26
4
2
1,672
11 Kenec Dr, Middletown, OH
0.84
Single-Family Home
$227,500
04/24/26
3
1
1,148
6935 Lesley Ln, Middletown, OH
0.71
Single-Family Home
$71,055
03/06/26
3
1
1,386
4566 S Dixie Hwy, Franklin, OH
0.70
Single-Family Home
$199,900
06/26/26
4
1
2,664
100 Arcadia Dr, Middletown, OH
0.93
Single-Family Home
$225,000
01/09/26
3
1
1,204
5744 Lynn St, Franklin, OH
0.84
Single-Family Home
$227,500
04/06/26
3
1
1,372
4560 Burnham Woods Dr, Franklin, OH
0.39
Single-Family Home
$425,000
07/10/26
3
2
2,370

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
4940 Moreland Dr, Franklin, OH 45005
0.17
$248,800
2
1
1,144
Off Market
6383 Linzie Ct, Franklin, OH 45005
0.23
$650,000
5
3.5
5,457
For Sale
6334 Bevis Ln, Franklin, OH 45005
0.26
$75,000
4
2
1,672
Recently Sold
6595 Stonyrill Ln, Franklin, OH 45005
0.37
$320,800
3
2
1,622
Off Market
4821 Sebald Dr, Franklin, OH 45005
0.37
$441,700
4
2.5
-
Off Market
4794 Sebald Dr, Franklin, OH 45005
0.38
$339,500
5
2.5
-
Off Market
4790 Union Rd, Franklin, OH 45005
0.35
$306,900
3
2
1,363
Off Market
6520 Linzie Ct, Franklin, OH 45005
0.39
$525,000
4
2.5
2,784
Recently Sold
4498 Burnham Woods Dr, Franklin, OH 45005
0.43
$485,800
4
3
2,428
Off Market
5001 Sebald Dr, Franklin, OH 45005
0.45
-
4
3.5
3,974
Off Market
4937 Union Rd, Franklin, OH 45005
0.42
$469,100
4
3
2,474
Off Market
6678 Stonyrill Ln, Franklin, OH 45005
0.47
$372,800
4
2
2,937
Off Market

Local Information

  • Map ViewExplore the area around 6247 Celeste Dr.
  • Schools5 Elementary Schools1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Single-Family Home
Year Built
1957
Lot Size
0.51 acres
Living Area
1,496 sqft

About this House

Move in Ready, Well Maintained Ranch with 1496 sq. ft. in Franklin Township/Warren County! 3 bedroom, 1 bath with large living room and wood burning fireplace. Nice spacious yard with patio, porch and storage shed.
6247 Celeste Dr, Franklin, OH 45005 is a 3 bedroom, 1 bathroom, 1,496 sqft single-family home built in 1957. It last sold for $154,000 on May 27, 2022. This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate rent is $1,865/month.

Home Details for 6247 Celeste Dr

Interior Features

Heating & Cooling
Heating: Forced Air, Heat Pump, Electric, OilAir ConditioningCooling System: CentralHeating Fuel: Forced Air
Levels, Entrance, & Accessibility
Stories: 1Floors: Tile, Carpet, Laminate, Linoleum Vinyl
Interior Details
Types of Rooms: Dining Room, Family Room
Fireplace & Spa
Fireplace

Property Information

Year Built
Year Built: 1957
Property Type / Style
Property Type: Single Family Home

Exterior Features

Exterior Home Features
Exterior: Stone, BrickFoundation Type: Concrete

Community

Units in Building: 1

Lot Information

Lot Area: 0.51 acres

Price and Tax history

DateEventPrice
Apr 21, 2025
Source: DABR MLS #926160
ListingRemoved
$419,000
Mar 25, 2025
Source: Cincy MLS #1827933
PriceChange
$419,000
Price decreased by 5%
Feb 20, 2025
Source: Cincy MLS #1827933
PriceChange
$439,000
Price decreased by 4%
Jan 9, 2025
Source: Cincy MLS #1827933
Listed For Sale
$459,000
Dec 31, 2024
Source: Cincy MLS #1821676
ListingRemoved
$540,000

Market trends in Franklin

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$252K
$10KMoM
Sale-to-List Price
—
Price per sq ft
$163
$7MoM
Available listings
79
20MoM

Around this home

View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Franklin

At least 66 Trulia users voted on each feature.

  • 86 % Say parking is easy

  • 85 % Say there are sidewalks

  • 81 % Say yards are well-kept

  • 80 % Say car is needed

  • 80 % Say it's dog friendly

  • 80 % Say kids play outside

  • 75 % Say there's holiday spirit

  • 66 % Say people would walk alone at night

  • 59 % Say it's quiet

  • 54 % Say streets are well-lit

  • 47 % Say neighbors are friendly

  • 44 % Say there's wildlife

  • 41 % Say it's walkable to grocery stores

  • 38 % Say it's walkable to restaurants

  • 35 % Say they plan to stay for at least 5 years

  • 24 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Sandra Lester
    "It has a Down to earth community and small town feel! Lots of upgrades citywide as well! Plenty of expansion opportunities "
    0
    Flag
  • Ljsmith26
    "Franklin is small and comforting. Nice people and good businesses. Growing community, great school, and lots of opportunities for kids in sports or creativity. "
    2
    Flag
  • Sadie N.
    "Walking distant to downtown. Minutes away from highway. Everything is semi close together. There is no public transportation Such as buses. "
    0
    Flag
  • Kristiewarren88
    "fall festival is very fun, and the churches around here put on free events for everyone around different Holidays, you dont even have to be a member. "
    2
    Flag
  • Briannadurham2014
    "Don’t let kids ride their bikes on the roads. It’s unsafe! Reckless drivers. I also wouldn’t recommend going to Walmart alone as well. "
    1
    Flag
  • shawnmachelle
    "We have lived here for almost a year, and we love the quiet country feel! Neighbors are friendly and we feel welcomed and safe here!"
    0
    Flag
  • Tgbarnes
    "Kid friendly, little traffic, dogs are fenced in. Good school system. At least one police officer per block lives in the community"
    2
    Flag
  • Jen Chappel
    "I love it here use to play here as a kid and I decided to move my kids for better schooling and for myself a better job haven't had any problems I gotta say best decision I made was moving here 3 years ago my kids are happy and so I'm i"
    0
    Flag
  • Tina T.
    "No public transportation need to have a car. My job is seven minutes away so it’s a good commute. People are not nice."
    1
    Flag
  • Kristiewarren88
    "I have a pretty quiet neighborhood. Though I live right behind a gas station, I never have any trouble with anyone or anything. Kids play outside all the time, people take care of their yards, barely any stray animals, and everyone is pretty respectful :)"
    3
    Flag
  • Tristanfaye66
    "some stay to them selfs and some are drug dealers my left hand neighbors are cool were good freinds. the rest dont really interact often"
    0
    Flag
  • Kristiewarren88
    "People in my neighborhood always take care of their lawns and houses. My neighborhood is relatively quiet and a good place for kids! "
    1
    Flag
  • darcomurphy
    "We have lived in this peaceful neighborhood for years and have been extremely happy with our decision to plant roots in this area."
    2
    Flag

LGBTQ Local Legal Protections

Frequently asked questions about 6247 Celeste Dr

  • What is the price history for 6247 Celeste Dr?
    6247 Celeste Dr in Franklin, OH last sold for $154,000 in May 2022.
  • Is Franklin a buyer's or seller's market?
    Franklin is currently a seller's market, based on recent for-sale activity.
  • What's the median sale price in Franklin?
    The median sale price in Franklin is $252K. That is down $10K from the prior month.
  • What do residents say about Franklin?
    Residents describe Franklin, OH as easy to park in, pedestrian-friendly, and well-kept. See recently sold homes in Franklin, OH.
  • Does 6247 Celeste Dr have air conditioning?
    Yes, 6247 Celeste Dr in Franklin, OH has air conditioning.
  • How big is the lot at 6247 Celeste Dr?
    The lot at 6247 Celeste Dr in Franklin, OH is about 0.51 acres (22,050 sq ft).

Explore by feature - Pet Friendly

9 pet-friendly rentals in Franklin, OH

Explore by feature - Garage

7 rentals with a garage in Franklin, OH

Explore by feature - Air Conditioning

11 rentals with air conditioning in Franklin, OH

Explore by feature - Washer/dryer

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 6247 Celeste Dr

Skip to last item
Skip to first item

Homes for sale near 6247 Celeste Dr

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item