NOT LISTED FOR SALE

54100 Elm Rd Celina, OH 45822

Estimated Value: $281,000 - $671,000

3 Beds
2.5 Baths
2,838 Sq Ft
$171/Sq Ft Est. Value

Sale Details

Date Sold: May 14, 2025

Last sale price $500,000 $176 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $2,922 / mo

23 Days on Market

Highlights

  • Above Ground Pool
  • Porch
  • Walk-In Closet
  • Wooded Lot
  • 2 Car Attached Garage
  • Patio

About This Home

As of May 2025

Charming Club Island Retreat on 4 lots - Updated & Move-In Ready!Discover the perfect blend of modern updates and peaceful living in this beautifully transformed 3+ bed/2.5 bath home. Over the last six years, this 2,838 sq ft home has undergone extensive renovations, including a new 30 yr roof, a completely redesigned kitchen & island, an upgraded primary bath with a spacious closet, and an updated laundry room/half bath.Enjoy fresh flooring and paint throughout. Plus have comfort knowing that one of the two furnaces was installed within the past year Outside, take a short walk to the deeded dock for easy access to the lake--perfect for fishing and water activities. Surrounded by nature, this home offers tranquility with the added bonus of an above-ground pool for summer relaxation. Don't forget to check out the amazing view of the channel across the wooded lots in the back. Walk there & fish or sit outside at the fire pit. Whether you're seeking full-time living or a relaxing vacation getaway, this home has room for everyone. Don't miss out on this beautifully updated retreat!

Last Agent to Sell the Property

Kelly Westgerdes

Lake Shore Realtors License #2016000384 Listed on: 04/03/2025

Last Buyer's Agent

Kelly Westgerdes

Lake Shore Realtors License #2016000384 Listed on: 04/03/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,971

Year Built

  • Built in 1959

Lot Details

  • Fenced
  • Wooded Lot

HOA Fees

  • $27 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Carport
  • Workshop in Garage

Home Design

  • Block Foundation
  • Vinyl Siding

Interior Spaces

  • 2,838 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Window Treatments
  • French Doors
  • Crawl Space

Kitchen

  • Range
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Above Ground Pool
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Connected
  • Well
  • Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 090962000000

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,971

Year Built

Built in 1959

Lot Details

5,968 Sq Ft Lot

HOA Fees

$27 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: House
  • Additional Tax Info: Additional Parcels, Assessments
  • Includedin Fee: Other
  • Level Style: Two
  • Semi-Annual Tax: 1985.58
  • Year Built: 1959
  • Additional Parcel I Ds: 090961000000, 090974000000, 090973000000
  • Documents: Other, Property Disclosure and Lead Based Paint
  • Listing I D: 1037831
  • M L S Approved: Y
  • M L S Identifier: 20190724221641160008000000
  • New Financing: 1031 Exchange, VA Loan, Cash, FHA, Conventional
  • Parcel I D Number Formatted: 09-096200.0000
  • Property Group I D: 19990816212109142258000000
  • Subtype: Single Family Residence
  • Type Of Contract: Exclusive Right To Sell
  • Condo Lot Y N: No
  • H O A C O A Fee Amount: 325.00
  • H O A C O A Fee Frequency: Annually
  • H O A C O A Y N: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances: Dishwasher, Washer, Refrigerator, Range, Gas Water Heater, Dryer
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Basement: Crawl Space
  • Inside Features: Ceiling Fan(s), Walk-in Closet(s), Window Coverings, French Doors
  • Price/ Sq Ft: 190.27
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Total Square Footage: 2838.00

Exterior Features

  • Exterior: Vinyl Siding
  • Foundation: Block
  • Outside Features: Above Ground Pool, Patio, Porch, Fenced
  • Waterfront Features: Lake Related

Garage/Parking

  • Garage: Attached, Workshop in Garage, Carport
  • Garage Spaces: 2.00

Utilities

  • Cooling: Central Air
  • Heating System: Forced Air, Natural Gas
  • Utilities: Natural Gas Connected, Sewer Connected
  • Sewer: Public Sewer
  • Water Source: Well

Lot Info

  • Lot Dimensions: 120X221 IRR
  • Zoning: Residential
  • Land Info: Residential Lot, Wooded
  • Parcel Id Number: 090962000000

Tax Info

  • Tax Year: 2024

MLS Schools

  • School District: 5401 Celina CSD

Ownership 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 Name Owned For Owner Type

Purchase Details

Listed on
Apr 3, 2025
Closed on
May 14, 2025
Sold by
Bought by
Seller's Agent
Kelly Westgerdes
Lake Shore Realtors
Buyer's Agent
Kelly Westgerdes
Lake Shore Realtors
List Price
$575,000
Sold Price
$500,000
Premium/Discount to List
-$75,000
-13.04%
Views
35
Current Estimated Value
$484,295

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$15,705
Avg. Annual Appreciation
-2.78%

Purchase Details

Closed on
Mar 21, 2024
Sold by
Bought by

Purchase Details

Closed on
Feb 25, 2011
Sold by
Bought by
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

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 Buyer Sale Price Title Company
$583,333 Four Diamond Title
-- None Listed On Document
$160,000 None Available
Source: Public Records

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
05/14/2025 05/14/25 Sold $500,000 -7.4% $176 / Sq Ft
04/26/2025 04/26/25 Pending -- -- --
04/08/2025 04/08/25 Price Changed $540,000 -6.1% $190 / Sq Ft
04/03/2025 04/03/25 For Sale $575,000 +162.9% $203 / Sq Ft
08/30/2019 08/30/19 Sold $218,750 -6.9% $84 / Sq Ft View Prior Sale
08/27/2019 08/27/19 Pending -- -- --
06/25/2019 06/25/19 Price Changed $234,900 -2.1% $91 / Sq Ft
10/27/2018 10/27/18 For Sale $239,900 -- $92 / Sq Ft
Source: Western Regional Information Systems & Technology (WRIST)

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 $3,352 $72,170 $7,490 $64,680
2024 $4,071 $72,170 $7,490 $64,680
2023 $3,352 $72,170 $7,490 $64,680
2022 $2,795 $50,300 $6,860 $43,440
2021 $2,423 $50,300 $6,860 $43,440
2020 $2,054 $50,300 $6,860 $43,440
2019 $1,984 $45,640 $6,300 $39,340
2018 $2,059 $45,640 $6,300 $39,340
2017 $556 $45,640 $6,300 $39,340
2016 $2,056 $46,210 $6,550 $39,660
2015 $2,000 $46,210 $6,550 $39,660
2014 $1,999 $46,210 $6,550 $39,660
2013 -- $44,450 $6,300 $38,150
Source: Public Records

Agents Affiliated with this Home

  • Kelly Westgerdes

    Seller's Agent in 2025

    Kelly Westgerdes

    Lake Shore Realtors

    (419) 305-2346

    129 Total Sales

    Kelly Westgerdes
    Section Image
  • Shawn Dues

    Seller's Agent in 2019

    Shawn Dues

    1st Call Realty, Ltd.

    (419) 733-1088

    120 Total Sales

    Shawn Dues
    Section Image
See All Agents

Map

Source: Western Regional Information Systems & Technology (WRIST)

MLS Number: 1037831

Western Regional Information Systems & Technology (WRIST)

APN: 09-096200.0000

Ohio Mercer County Celina 45822

54100 Elm Rd, Celina, OH

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.

Western Regional Information Systems & Technology (WRIST) 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.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.