NOT LISTED FOR SALE

Estimated Value: $733,000 - $799,000

4 Beds
3 Baths
3,253 Sq Ft
$236/Sq Ft Est. Value

Last Sold September 11, 2013

Last sale price $454,300 $140 Per Sq Ft

Est. 69% increase in value since last sale

Current estimated payment $5,361/month

152 Days on Market

Highlights

  • Whirlpool Bathtub
  • Corner Lot
  • Cul-De-Sac
  • Oliver Julian Kendall Elementary School Rated A+
  • Formal Dining Room
  • Central Air

About This Home

As of September 2013

Deal Fell! Fabulous custom built Crestview home w/3 car sideload gar on premium corner cul-de-sac lot in award-winning NVHS. Impressive 2-story foyer with turned staircase. Spacious open floor plan includes~ granite counters~skylights~vaulted family rm w/beautiful floor to ceiling brick fireplace. 1st flr den/5th bdrm~3 full baths. Master suite w/sitting area, Jacuzzi tub & WIC. Beautifully landscaped yard & more!

Last Listed By

Debra Miller

Baird & Warner License #475122709 Listed on: 03/10/2013

Baird & Warner

Property Details

Home Type

  • Other

Est. Annual Taxes

  • $13,034

Year Built

  • 1999

Lot Details

  • Cul-De-Sac
  • Corner Lot

HOA Fees

  • $23 per month

Parking

  • Garage
  • Garage Transmitter
  • Garage Door Opener
  • Driveway

Home Design

  • Brick Exterior Construction
  • Slab Foundation
  • Asphalt Shingled Roof
  • Cedar

Interior Spaces

  • Formal Dining Room

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • Primary Bathroom is a Full Bathroom
  • Dual Sinks
  • Whirlpool Bathtub
  • Separate Shower

Laundry

  • Dryer
  • Washer

Unfinished Basement

  • Partial Basement
  • Crawl Space

Schools

  • Kendall Elementary School
  • Neuqua Valley High School

Utilities

  • Central Air
  • Lake Michigan Water

Property Details

Home Type

Other

Est. Annual Taxes

$13,034

Year Built

1999

Lot Details

0

HOA Fees

$23 per month

Parking

3

Interior Features

  • Total # Of Rooms: 11
  • Appliances: Oven/Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal
  • Equipment: Ceiling Fan, Sump Pump
  • Fireplace Type/Details: Wood Burning, Gas Logs, Gas Starter
  • Fireplaces: 1
  • Basement: Partial
  • Basement: Unfinished, Crawl
  • Master Bedroom Level: 2nd Level
  • Master Bedroom Size: 17X13
  • Master Bedroom Flooring: Carpet
  • Primary Bedroom Bath: Full
  • Second Bedroom Level: 2nd Level
  • Second Bedroom Size: 13X12
  • Second Bedroom Flooring: Carpet
  • Third Bedroom Level: 2nd Level
  • Third Bedroom Size: 13X11
  • Third Bedroom Flooring: Carpet
  • Fourth Bedroom Level: 2nd Level
  • Fourth Bedroom Size: 12X12
  • Fourth Bedroom Flooring: Carpet
  • Bathroom Amenities: Whirlpool, Separate Shower, Double Sink
  • Living Room Level: Main Level
  • Living Room Size: 17X13
  • Living Room Flooring: Carpet
  • Dining Room: Separate
  • Dining Room Level: Main Level
  • Dining Room Size: 14X13
  • Dining Room Flooring: Carpet
  • Family Room Level: Main Level
  • Family Room Size: 20X17
  • Family Room Flooring: Carpet
  • Kitchen Type: Eating Area-Table Space, Island, Pantry-Walk-in
  • Kitchen Level: Main Level
  • Kitchen Size: 13X10
  • Kitchen Flooring: Hardwood

Exterior Features

  • Foundation: Concrete
  • Lot Size: .25-.49 Acre
  • Exterior Building Type: Brick, Cedar
  • Roof Type: Asphalt/Glass (Shingles)

Garage/Parking

  • Number of Cars: 3
  • Parking Type: Garage
  • Garage Type: Garage Door Opener(s), Transmitter(s)
  • Driveway: Asphalt

Utilities

  • Electricity: 200+ Amp Service
  • Air Conditioner: Central Air
  • Water: Lake Michigan, Public
  • Heat/Fuel: Gas, Forced Air

Condo/Co-op/Association

  • Fee Frequency: Annual
  • Assessment/Association Fees: 280

Schools

  • Elementary School: Kendall Elementary School
  • High School: Neuqua Valley High School
  • Junior High Dist: 204
  • Junior High: Crone Middle School

Lot Info

  • Lot Dimensions: 180X125
  • Lot Description: Corner, Cul-de-sac

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 10, 2013
Closed on
Sep 9, 2013
Sold by
Hsieh Duane T and Hsieh Jo
Bought by
Shihn Harmanjeet and Shihn Deepika
Seller's Agent
Debra Miller
Baird & Warner
Buyer's Agent
AJ|Abhijit Leekha
Property Economics Inc.
List Price
$469,900
Sold Price
$454,300
Premium/Discount to List
-$15,600
-3.32%
Total Days on Market
152
Current Estimated Value
$766,990

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$312,690
Avg. Annual Appreciation
4.59%
Original Mortgage
$416,000
Outstanding Balance
$299,090
Interest Rate
3.12%
Mortgage Type
Adjustable Rate Mortgage/ARM
Estimated Equity
$467,900

Purchase Details

Closed on
Apr 20, 2000
Sold by
Rider Johna and Rider Wanda J
Bought by
Hsieh Duane T and Hsieh Jo

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$240,000
Interest Rate
8.26%

Purchase Details

Closed on
May 28, 1999
Sold by
First Midwest Trust Company Natl Assn
Bought by
Rider John A and Rider Wanda J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$305,800
Interest Rate
6.5%

Range of Values:

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
Shihn Harmanjeet $454,300 None Available
Hsieh Duane T $372,500 Chicago Title Insurance Co
Rider John A $337,500 Chicago Title Insurance Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Shihn Harmanjeet $416,000
Previous Owner Hsieh Duane T $207,000
Previous Owner Hsieh Duane T $210,900
Previous Owner Hsieh Duane T $210,000
Previous Owner Hsieh Duane T $240,000
Previous Owner Hsieh Duane T $240,000
Previous Owner Rider John A $305,800
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/11/2013 09/11/13 Sold $454,300 -3.3% $140 / Sq Ft
08/13/2013 08/13/13 For Sale $469,900 0.0% $144 / Sq Ft
08/09/2013 08/09/13 Pending -- -- --
08/07/2013 08/07/13 Pending -- -- --
08/03/2013 08/03/13 For Sale $469,900 0.0% $144 / Sq Ft
07/23/2013 07/23/13 Pending -- -- --
07/19/2013 07/19/13 Price Changed $469,900 0.0% $144 / Sq Ft
07/19/2013 07/19/13 For Sale $469,900 -1.1% $144 / Sq Ft
05/28/2013 05/28/13 Pending -- -- --
05/15/2013 05/15/13 Price Changed $474,900 -2.1% $146 / Sq Ft
04/22/2013 04/22/13 Price Changed $484,900 -1.0% $149 / Sq Ft
03/10/2013 03/10/13 For Sale $489,900 -- $151 / Sq Ft
Source: Midwest Real Estate Data (MRED)

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
2023 $13,034 $191,393 $38,647 $152,746
2022 $11,989 $171,477 $36,560 $134,917
2021 $11,459 $163,311 $34,819 $128,492
2020 $11,241 $160,723 $34,267 $126,456
2019 $11,048 $156,193 $33,301 $122,892
2018 $11,596 $160,794 $32,568 $128,226
2017 $11,419 $156,643 $31,727 $124,916
2016 $11,398 $153,271 $31,044 $122,227
2015 $11,428 $147,376 $29,850 $117,526
2014 $11,428 $142,652 $29,850 $112,802
2013 $11,428 $142,652 $29,850 $112,802
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: MRD08288268

Midwest Real Estate Data (MRED)

APN: 01-15-108-003