NOT LISTED FOR SALE

400 Celia Ln Unit 20 Madison, OH 44057

Estimated Value: $261,449 - $279,000

4 Beds
2.5 Baths
1,920 Sq Ft
$142/Sq Ft Est. Value

Last Sold September 15, 2021

Last sale price $209,500 $109 Per Sq Ft

Est. 30% increase in value since last sale

Current estimated payment $2,110/month

34 Days on Market

Highlights

  • View of Trees or Woods
  • Wooded Lot
  • 2 Car Attached Garage
  • Colonial Architecture
  • Cul-De-Sac
  • Patio

About This Home

As of September 2021

Welcome Home! Wonderful opportunity to own a newer construction, four bedroom Colonial in eastern Lake County! Located on a quiet cul-de sac in Madison Preserve Condominiums this home is just minutes from all of the Madison Village Main Street area restaurants and shops, local parks, golf, highway access and many of Northeastern Ohio's wineries. This 4 bedroom, 2.5 bedroom colonial was built in 2017 and offers an open floor plan with an eat-in kitchen that includes a center Island and all appliances open to a large living room ideal for entertaining. First floor office/flex room area and bath. The second floor features a spacious Master suite with Master bath with dual vanity sinks and a walk-in closet and 3 additional bedrooms along with a full bath and a convenient 2nd floor laundry room. The fenced yard provides privacy as well as beautiful views of the parklike setting. Shed for storage. Must see to appreciate!

Last Agent to Sell the Property

Melinda Chamberlin

Keller Williams Living License #351576 Listed on: 07/01/2021

Keller Williams Living

Last Buyer's Agent

Sara Breese

Deleted Agent License #2018003675

Deleted Agent

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,098

Year Built

  • Built in 2017

Lot Details

  • 1,159 Sq Ft Lot
  • Cul-De-Sac
  • Street terminates at a dead end
  • North Facing Home
  • Property is Fully Fenced
  • Vinyl Fence
  • Wooded Lot

HOA Fees

  • $50 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,920 Sq Ft Home
  • 2-Story Property
  • Views of Woods
  • Fire and Smoke Detector

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Patio
  • Shed

Utilities

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

Community Details

  • Association fees include insurance, reserve fund
  • Madison Preserve Condo Ph 17 Community

Listing and Financial Details

  • Assessor Parcel Number 02-A-005-E-00-043-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,098

Year Built

Built in 2017

Lot Details

0

HOA Fees

$50 per month

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family
  • Dwelling Type: Detached
  • Style: Colonial
  • House Faces: North
  • Price Per Square Foot: 109.11
  • Estimated Price per Sq Ft: 109.11
  • Year Built Exception: Actual YBT
  • Num Of Stories: 2.00
  • Total Sq Ft: 1920
  • Year Built: 2017
  • Court Ordered Y N: No
  • Geocode Confidence: High
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 2017

Interior Features

  • Appliances Equipment: Dishwasher, Garbage Disposal, Microwave, Range, Refrigerator, Smoke Detector
  • Total Bedrooms: 4
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Main Half Bathrooms: 1
  • Room Count: 12
  • Basement Detail: Slab
  • Laundry: 1
  • Sq Ft Approx Above Grade Finished: 1920.00
  • Sq Ft Approx Total Finished: 1920.00

Exterior Features

  • View: Wooded
  • Exterior: Vinyl
  • Exterior Features: Patio, Shed
  • Fences: Full, Vinyl/Plastic
  • Roof: Asphalt/Fiberglass

Garage/Parking

  • Driveway: Paved
  • Garage Features: Attached, Door Opener
  • Garage Num Of Cars: 2

Utilities

  • Cooling Type: Central Air
  • Heating Fuel: Gas
  • Heating Type: Forced Air
  • Water/Sewer: Public Water, Public Sewer

Condo/Co-op/Association

  • HOA Fees: 50.00
  • HOA Fee Frequency: Monthly
  • Hoa Name: Madison Preserve
  • Subdivision Complex: Madison Preserve Condo Ph 17

Fee Information

  • HOA Fee Includes: Association Insurance, Reserve Fund

Schools

  • School District: Madison LSD

Lot Info

  • Lot Description: Cul de Sac, Dead End Street, Wooded/Treed
  • Lot Size Units: Acres
  • Acres: 0.0266
  • Parcel Number: 02-A-005-E-00-043-0

Tax Info

  • Tax: 4098

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 1, 2021
Closed on
Sep 14, 2021
Sold by
Radsteen Connor J and Radsteen Erica L
Bought by
Brenneman Connor J
Seller's Agent
Melinda Chamberlin
Keller Williams Living
Buyer's Agent
Sara Breese
Deleted Agent
List Price
$209,900
Sold Price
$209,500
Premium/Discount to List
-$400
-0.19%
Current Estimated Value
$271,862

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$62,362
Avg. Annual Appreciation
6.29%
Original Mortgage
$191,260
Outstanding Balance
$173,773
Interest Rate
2.7%
Mortgage Type
New Conventional
Estimated Equity
$98,089

Purchase Details

Closed on
Jun 18, 2020
Sold by
Covert Steven and Covert Cassandra
Bought by
Radsteen Connor J and Radsteen Erica L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$191,900
Interest Rate
3.2%
Mortgage Type
VA

Purchase Details

Closed on
Oct 3, 2017
Sold by
Madison Bear Path Llc
Bought by
Covert Steven and Covert Cassandra

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$170,900
Interest Rate
3.92%
Mortgage Type
VA
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
Brenneman Connor J $209,500 Enterprise Title Agency Inc
Radsteen Connor J $191,900 Enterprise Title Agency Inc
Covert Steven -- Nvr Title Agency Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Brenneman Connor J $191,260
Previous Owner Radsteen Connor J $191,900
Previous Owner Covert Steven $170,900
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/15/2021 09/15/21 Sold $209,500 -0.2% $109 / Sq Ft
08/04/2021 08/04/21 Pending -- -- --
07/21/2021 07/21/21 For Sale $209,900 0.0% $109 / Sq Ft
07/08/2021 07/08/21 Pending -- -- --
07/01/2021 07/01/21 For Sale $209,900 -- $109 / Sq Ft
Source: MLS Now

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 -- $78,310 $20,160 $58,150
2023 $7,578 $73,610 $16,240 $57,370
2022 $4,206 $73,610 $16,240 $57,370
2021 $4,197 $73,610 $16,240 $57,370
2020 $4,098 $63,460 $14,000 $49,460
2019 $4,101 $63,460 $14,000 $49,460
2018 $0 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Now

MLS Number: 4280170

MLS Now

APN: 02-A-005-E-00-043