6247 Celeste Dr Franklin, OH 45005
Franklin AreaEstimated payment $2,589/month
Highlights
- Open-Concept Dining Room
- Ranch Style House
- No HOA
- 0.51 Acre Lot
- Wood Flooring
- 2 Car Attached Garage
About 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!
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $4,642
Year Built
- Built in 1957
Lot Details
- 22,216 Sq Ft Lot
- Lot Dimensions are 105 x 210
Parking
- 2 Car Attached Garage
- Front Facing Garage
- Driveway
Home Design
- Ranch Style House
- Brick Exterior Construction
- Slab Foundation
- Shingle Roof
Interior Spaces
- 1,496 Sq Ft Home
- Recessed Lighting
- Electric Fireplace
- Living Room with Fireplace
- Open-Concept Dining Room
- Storage In Attic
- Laundry Room
Kitchen
- Convection Oven
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- 2 Full Bathrooms
Outdoor Features
- Covered Deck
Utilities
- Central Air
- Heating System Uses Gas
- Propane
- Electric Water Heater
- Septic Tank
Community Details
- No Home Owners Association
Map
Home Values in the Area
Average Home Value in this Area
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $4,669 | $104,510 | $17,500 | $87,010 |
| 2024 | $2,904 | $63,890 | $17,500 | $46,390 |
| 2023 | $2,372 | $46,942 | $10,325 | $36,617 |
| 2022 | $2,268 | $46,942 | $10,325 | $36,617 |
| 2021 | $2,188 | $46,942 | $10,325 | $36,617 |
| 2020 | $2,107 | $39,781 | $8,750 | $31,031 |
| 2019 | $1,909 | $39,781 | $8,750 | $31,031 |
| 2018 | $1,883 | $39,781 | $8,750 | $31,031 |
| 2017 | $1,783 | $33,730 | $7,536 | $26,194 |
| 2016 | $1,820 | $33,730 | $7,536 | $26,194 |
| 2015 | $1,821 | $33,730 | $7,536 | $26,194 |
| 2014 | $1,791 | $32,750 | $7,320 | $25,430 |
| 2013 | $1,529 | $39,170 | $8,750 | $30,420 |
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 08/31/2026 08/31/26 | For Sale | $399,000 | +159.1% | $267 / Sq Ft | |
| 05/27/2022 05/27/22 | Sold | $154,000 | -3.1% | $103 / Sq Ft | View Prior Sale |
| 05/21/2022 05/21/22 | Pending | -- | -- | -- | |
| 05/13/2022 05/13/22 | For Sale | $159,000 | -- | $106 / Sq Ft |
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $150,000 | None Available | |
| Warranty Deed | $89,000 | Attorney |
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $216,933 | FHA | |
| Previous Owner | $71,200 | Purchase Money Mortgage |
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1892040
APN: 07-04-228-001-1
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
- 6383 Linzie Ct
- 6601 Cherrywood Ln
- 0 Union Rd Unit 964836
- 0 Manchester Rd Unit 966354
- 4575 S Dixie Hwy
- 6631 Jennifer Ln
- 122 Kenec Dr
- 6639 Crystal Harbour Dr
- 5771 Manchester Rd
- 5025 Gerber Dr
- 4102 Gregory Dr
- 5567 Millbrook Dr
- 4916 Talton Dr
- 6648 Washington Cir
- 6714 Washington Cir Unit 8
- 4911 Sir Gregory Way
- 509 Tara Oaks Dr
- 4733 Donham Dr
- 5935 Regatta Dr
- 508 Regent Dr
- 5549 Innovation Dr
- 154 Bavarian St
- 2001 Wellington Rd
- 4540 Bonita Dr Unit 4
- 2759 Towne Blvd
- 11 Redbud Dr
- 2689 Audubon Dr
- 302 Fulton Ln
- 6460 Calloway Ct
- 4373 Bonita Dr
- 2515 Bridgewood Dr
- 40 Sprucewood Ct
- 2150 S Breiel Blvd
- 8385 Hendrickson Rd
- 2279 Joshua Cir
- 2281 Joshua Cir
- 1074 Park Ln
- 1221 Jackson Ln
- 967-975 Park Ln
- 32 Ascot Glen Dr
Ask me questions while you tour the home.