NOT LISTED FOR SALE

5147 Edgewater Dr Sheffield Lake, OH 44054

Estimated Value: $450,000 - $546,771

3 Beds
3.5 Baths
2,400 Sq Ft
$206/Sq Ft Est. Value

Last Sold July 22, 2019

Last sale price $375,000 $156 Per Sq Ft

Est. 32% increase in value since last sale

Current estimated payment $3,356/month

4 Days on Market

Highlights

  • Lake Front
  • Lake Privileges
  • Community Lake
  • In Ground Pool
  • Colonial Architecture
  • 1 Fireplace

About This Home

As of July 2019

Beautiful Lakefront Home with heated in the ground salt water pool. Located on Edgewater Drive, a private street in Sheffield Lake. The home features classic lakefront living with some modern flair. The 3 bedroom, 3.5 bath home features 2,400 feet of living area with panoramic views of Lake Erie. This private street offers Lake access from two parks. Enjoy the beautiful sunsets and majestic views of Lake Erie from your 28' custom wall of windows installed in 2017 by Renewable by Anderson. Simply fabulous outdoor space, 60' Revetment/break wall installed 1999. Inground heated pool 28x14 installed 2000. Installed new pool chlorine generator, salt water pool 2014. Maintenance free vinyl fence installed 2000. Plenty of yard to enjoy any activity while taking in the incredible view. First floor office with built in book shelf. The first floor laundry room is conveniently located off the garage. This home has been continually updated over the years: New Driveway 2006, New fireplace-exterior locking system 2008, HVAC Duct Insulation System wrap (R9) 2009, New Roof, Vinyl Siding & Gutters. 2009, Master Bath & Walk in Closet Addition 2009, Carpeting 2013, Electrical Panel 2014, Trane HVAC furnace & A/C 2014, Aprilaire humidifier 2016, Bradford White "Power" Water Tank 2016. There is a good deal of storage in this home plus the full unfinished basement offers many opportunities with a full bath too. A rare find on the waterfront.

Last Agent to Sell the Property

Colleen Milner

Howard Hanna License #406610 Listed on: 06/06/2019

Howard Hanna

Last Buyer's Agent

Daniel Malloy

Howard Hanna License #2001023377

Howard Hanna

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,482

Year Built

  • Built in 1949

Lot Details

  • 0.25 Acre Lot
  • Lot Dimensions are 60x192
  • Lake Front
  • Street terminates at a dead end
  • Vinyl Fence

HOA Fees

  • $6 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Colonial Architecture
  • Fiberglass Roof
  • Asphalt Roof
  • Vinyl Siding

Interior Spaces

  • 2,400 Sq Ft Home
  • 2-Story Property
  • 1 Fireplace
  • Unfinished Basement
  • Basement Fills Entire Space Under The House
  • Fire and Smoke Detector
  • Property Views

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3.5 Bathrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • In Ground Pool
  • Lake Privileges
  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas

Listing and Financial Details

  • Assessor Parcel Number 03-00-034-101-004

Community Details

Overview

  • Sheffiled On The Lake Association
  • Sheffield On Lake Subdivision
  • Community Lake

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,482

Year Built

Built in 1949

Lot Details

0

HOA Fees

$6 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family Residence
  • Year Built: 1949
  • Road Frontage Type: Lakefront
  • ResoLotFeatures: Dead End, Lake Erie Front, Lake Front, Waterfront
  • ResoPoolFeatures: In Ground, Community
  • Reso View: Lake
  • ResoSecurityFeatures: Smoke Detector(s)
  • Reso Association Fee Includes: Other
  • Subdivision Name: Sheffield On Lake
  • Above Grade Finished Sq Ft: 2400.0
  • Architectural Style: Colonial
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: Two
  • Property Sub Type Additional: Single Family Residence
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Fireplaces: 1
  • Basement: Full, Unfinished
  • Basement: Yes
  • Appliances: Dryer, Dishwasher, Disposal, Microwave, Range, Refrigerator, Washer
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Main Level Bathrooms: 1
  • Stories: 2

Exterior Features

  • Roof: Asphalt, Fiberglass
  • Fencing: Vinyl
  • Acres: 0.25
  • View: Yes
  • Waterfront Features: Lake Front, Lake Privileges, Waterfront
  • Waterfront: Yes
  • Home Warranty: No
  • Construction Type: Vinyl Siding
  • Patio And Porch Features: Patio

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Parking Features: Attached, Drain, Garage, Garage Door Opener, Paved

Utilities

  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Forced Air, Gas
  • HeatingYN: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Lake, Pool
  • Association Fee: 75.0
  • Association Fee Frequency: Annually
  • Association Name: Sheffiled on the Lake
  • Association: Yes

Schools

  • Junior High Dist: Sheffield-Sheffield - 4713

Lot Info

  • Lot Size Units: Acres
  • Parcel Number: 03-00-034-101-004
  • Lot Dimensions: 60X192
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 6482.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Apr 23, 2025
Sold by
Cesear Thomas M and Cesear Teresa K
Bought by
Cesear Family Trust and Cesear
Current Estimated Value
$493,924

Purchase Details

Listed on
Jun 6, 2019
Closed on
Jul 18, 2019
Sold by
Zaucha Joseph T and Zaucha Sharon A
Bought by
Cesear Thomas M and Cesear Teresa K
Seller's Agent
Colleen Milner
Howard Hanna
Buyer's Agent
Daniel Malloy
Howard Hanna
List Price
$359,900
Sold Price
$375,000
Premium/Discount to List
$15,100
4.2%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.41%

Purchase Details

Closed on
Oct 22, 1998
Sold by
Rifel Erna L and Eifel Erna Louise
Bought by
Zaucha Joseph T and Zaucha Sharon A

Purchase Details

Closed on
Sep 1, 1998
Sold by
Estate Of Raymond Leo Eifel
Bought by
Eifel Erna Louise
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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Cesear Family Trust -- None Listed On Document
Cesear Thomas M $2,875,000 None Available
Zaucha Joseph T $165,000 Chicago Title Insurance Comp
Eifel Erna Louise -- --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
07/22/2019 07/22/19 Sold $375,000 +4.2% $156 / Sq Ft
06/10/2019 06/10/19 Pending -- -- --
06/06/2019 06/06/19 For Sale $359,900 -- $150 / Sq Ft
Source: MLS Now (Howard Hanna)

Tax History Compared to Growth

Source: Public Records

Tax History

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
2024 $9,107 $174,885 $89,026 $85,859
2023 $6,793 $114,678 $58,741 $55,937
2022 $6,728 $114,678 $58,741 $55,937
2021 $6,767 $114,678 $58,741 $55,937
2020 $6,495 $100,680 $51,570 $49,110
2019 $6,457 $100,680 $51,570 $49,110
2018 $6,482 $100,680 $51,570 $49,110
2017 $5,932 $84,000 $41,720 $42,280
2016 $5,987 $84,000 $41,720 $42,280
2015 $5,909 $84,000 $41,720 $42,280
2014 $4,987 $78,140 $38,810 $39,330
2013 $4,964 $78,140 $38,810 $39,330
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Now (Howard Hanna)

MLS Number: 4103757

MLS Now (Howard Hanna)

APN: 03-00-034-101-004