NOT LISTED FOR SALE

Estimated Value: $518,000 - $550,000

5 Beds
3.5 Baths
3,428 Sq Ft
$157/Sq Ft Est. Value

Last Sold May 27, 2021

Last sale price $400,000 $117 Per Sq Ft

Est. 34% increase in value since last sale

Current estimated payment $3,236/month

1 Day on Market

Highlights

  • Guest House
  • Deck
  • Wood Flooring
  • Frederick Douglass High School Rated A-
  • Recreation Room
  • 5-minute walk to Liberty Park

About This Home

As of May 2021

Location Location Location! Desirable subdivision located in the heart of Hamburg. This immaculate two-story brick home sits on a finished walk out basement. This home has an extremely high level of finish. Main level features a half bath, formal dining room with trey ceiling and home office/study, open concept kitchen overlooking spacious living room with gas fireplace and built in bookshelves. Kitchen features quartz countertops, large island, stainless appliances and subway tile backsplash. Extensive trim package through out, 9ft ceilings, and hardwood floors complete the main level. Outside you can escape with a relaxing fire pit, two story decks, and patio which make for great space to entertain with friends and family. Close to Hamburg shopping, restaurants, New Circle, and the interstate. Schedule your showing today!

Last Agent to Sell the Property

Shane Underwood

Keller Williams Commonwealth License #215563 Listed on: 04/16/2021

Keller Williams Commonwealth

Last Buyer's Agent

Kevin Culp

Real Broker, LLC License #263132

Real Broker, LLC

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2000

Lot Details

  • 7,841 Sq Ft Lot
  • Many Trees

HOA Fees

  • $27 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Brick Veneer
  • Dimensional Roof
  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Ceiling Fan
  • Blinds
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room
  • Home Office
  • Recreation Room
  • Bonus Room
  • Utility Room

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite

Laundry

  • Laundry on main level
  • Washer and Gas Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Deck
  • Patio

Additional Homes

  • Guest House

Schools

  • Liberty Elementary School
  • Crawford Middle School
  • Frederick Douglass High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Underground Utilities
  • Natural Gas Connected
  • Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 38029390

Community Details

Overview

  • The Shetlands Subdivision
  • Mandatory home owners association
  • On-Site Maintenance

Recreation

  • Community Pool
  • Park

Home Details

Home Type

Single Family

Year Built

Built in 2000

Lot Details

7,841 Sq Ft Lot

HOA Fees

$27 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub-Type: Single Family Residence
  • Year Built: 2000
  • Above Grade Finished Sq Ft: 2419.0
  • Levels: Two
  • New Construction: No
  • Roof:Dimensional Style: Yes
  • Foundation Details:Concrete Perimeter: Yes
  • Flooring:Carpet: Yes
  • Flooring:Hardwood: Yes
  • Flooring:Tile2: Yes
  • Sewer:Public Sewer: Yes
  • Water Source:Public: Yes
  • Appliances Microwave: Yes
  • Laundry Features:Washer Hookup: Yes
  • Laundry Features:Electric Dryer Hookup: Yes
  • Laundry Features:Main Level: Yes
  • Appliances Refrigerators: Yes
  • Percent Basement Finished: Yes
  • Cooling:Zoned: Yes
  • Laundry Features:Gas Dryer Hookup: Yes
  • Other Structures:Guest House: Yes
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Range, Refrigerator
  • Interior Amenities: Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, In-Law Floorplan, Walk-In Closet(s)
  • Flooring: Carpet, Hardwood, Tile
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Basement: Concrete, Finished, Full, Walk-Out Access
  • Basement: Yes
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1009.0
  • LivingArea: 3428.0
  • Lot Size Area: 0.18
  • Window Features: Blinds
  • Basement:Concrete: Yes
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances Range: Yes
  • Interior Features:Entrance Foyer: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features:Breakfast Bar: Yes
  • Interior Features:In-Law Floorplan: Yes
  • Basement:Walk-Out Access: Yes

Exterior Features

  • Roof: Dimensional Style
  • Construction Materials: Vinyl Siding, Brick Veneer
  • Foundation Details: Concrete Perimeter
  • List Price: 396500.0
  • Lot Features: Many Trees
  • Other Structures: Guest House
  • Patio And Porch Features: Deck, Patio
  • Waterfront: No
  • Construction Materials:Brick Veneer: Yes
  • Window Features:Blinds: Yes
  • Construction Materials:Vinyl Siding: Yes

Garage/Parking

  • Attached Garage: No
  • Carport: No
  • Garage Spaces: 2.0
  • Garage: Yes
  • Parking Features: Attached Garage

Utilities

  • Sewer: Public Sewer
  • Heating: Electric, Forced Air, Natural Gas, Zoned
  • Cooling: Electric, Zoned
  • Cooling: Yes
  • Heating: Yes
  • Laundry Features: Electric Dryer Hookup, Gas Dryer Hookup, Main Level, Washer Hookup
  • Utilities: Electricity Connected, Natural Gas Connected, Underground Utilities
  • Water Source: Public
  • Heating:Forced Air: Yes
  • Heating:Zoned2: Yes

Condo/Co-op/Association

  • Association Fee: 325.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • Community Features: Park, Pool

Schools

  • Elementary School: Liberty
  • High School: Frederick Douglass
  • Middle or Junior School: Crawford

Lot Info

  • Lot Size Acres: 0.18
  • Lot Size Sq Ft: 7840.81
  • Parcel Number: 38029390

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 16, 2021
Closed on
Jun 7, 2021
Sold by
Ogden Dorothy J
Bought by
Turcan Marian and Turcan Shuiping
Seller's Agent
Shane Underwood
Keller Williams Commonwealth
Buyer's Agent
Kevin Culp
Real Broker, LLC
List Price
$396,500
Sold Price
$400,000
Premium/Discount to List
$3,500
0.88%
Current Estimated Value
$537,504

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$137,504
Avg. Annual Appreciation
6.34%
Original Mortgage
$260,032
Outstanding Balance
$234,399
Interest Rate
2.9%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$303,105

Purchase Details

Listed on
Mar 30, 2018
Closed on
May 29, 2018
Sold by
Marasa Lauren H and Marasa Nicholas
Bought by
Ogden Dorothy J
Seller's Agent
Shane Underwood
Keller Williams Commonwealth
Buyer's Agent
Shane Underwood
Keller Williams Commonwealth
List Price
$352,000
Sold Price
$352,000

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.32%
Original Mortgage
$242,000
Interest Rate
4.4%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Listed on
Apr 18, 2012
Closed on
Jun 6, 2012
Sold by
Caudill Terry L and Caudill Marcelia R
Bought by
Marasa Lauren H and Marasa Nicholas
Seller's Agent
Brad Johnson
RE/MAX Creative Realty
Buyer's Agent
Jeff Rietze
Rector Hayden Realtors
List Price
$272,900
Sold Price
$272,900

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.36%
Original Mortgage
$272,900
Interest Rate
3.88%
Mortgage Type
Purchase Money Mortgage
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
Turcan Marian $400,000 --
Ogden Dorothy J $352,000 --
Marasa Lauren H $272,900 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Marasa Lauren H $260,032
Closed Marasa Lauren H $260,032
Previous Owner Marasa Lauren H $242,000
Previous Owner Marasa Lauren H $272,900
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/27/2021 05/27/21 Sold $400,000 +0.9% $117 / Sq Ft
04/17/2021 04/17/21 Pending -- -- --
04/16/2021 04/16/21 For Sale $396,500 +12.6% $116 / Sq Ft
05/21/2018 05/21/18 Sold $352,000 0.0% $103 / Sq Ft View Prior Sale
04/10/2018 04/10/18 Pending -- -- --
03/30/2018 03/30/18 For Sale $352,000 +29.0% $103 / Sq Ft
06/05/2012 06/05/12 Sold $272,900 0.0% $81 / Sq Ft View Prior Sale
04/23/2012 04/23/12 Pending -- -- --
04/18/2012 04/18/12 For Sale $272,900 -- $81 / Sq Ft
Source: ImagineMLS (Bluegrass REALTORS®)

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
2025 $4,946 $400,000 $0 $0
2024 $4,946 $400,000 $0 $0
2023 $4,946 $400,000 $0 $0
2022 $5,110 $400,000 $0 $0
2021 $4,496 $352,000 $0 $0
2020 $4,496 $352,000 $0 $0
2019 $4,496 $352,000 $0 $0
2018 $3,996 $312,800 $0 $0
2017 $3,808 $312,800 $0 $0
2015 $2,742 $272,900 $0 $0
2014 $2,742 $272,900 $0 $0
2012 $2,742 $245,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: ImagineMLS (Bluegrass REALTORS®)

MLS Number: 20106689

ImagineMLS (Bluegrass REALTORS®)

APN: 38029390

Your Personal Tour Guide

Ask me questions while you tour the home.