NOT LISTED FOR SALE

3995 W Sterns Rd Lambertville, MI 48144

Estimated Value: $639,000 - $1,095,000

5 Beds
4 Baths
4,423 Sq Ft
$188/Sq Ft Est. Value

Last Sold December 15, 2014

Last sale price $351,000 $79 Per Sq Ft

Est. 137% increase in value since last sale

Current estimated payment $5,091/month

247 Days on Market

Highlights

  • 5.44 Acre Lot
  • Recreation Room
  • Wood Flooring
  • Deck
  • Traditional Architecture
  • Den

About This Home

As of December 2014

Gorgeous, custom-built home on magnificent ravined/wooded lot! Main fl. master suite. Full finished lower lever w/rec rm, office, fireplc & full bath. Large rear deck & covered patio. Gourmet kitchen w/chef's pantry. 4 beds & 2 full baths on upper level. 3-car garage. Beautiful gardens & grounds.

Last Agent to Sell the Property

Tony Bassett

The Danberry Company - Temperance License #MCAR-6501316893 Listed on: 04/12/2014

The Danberry Company - Temperance

Last Buyer's Agent

Mike Sprott

Real Estate Solutions/MI, LLC - Temperance License #MCAR-6502139835

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1989

Lot Details

  • 5.44 Acre Lot

Home Design

  • Traditional Architecture
  • Brick Exterior Construction

Interior Spaces

  • 4,423 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Ceiling Fan
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Den
  • Recreation Room
  • Wood Flooring
  • Fire Sprinkler System
  • Dryer

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • 4 Full Bathrooms

Basement

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

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Internet Available

Listing and Financial Details

  • Assessor Parcel Number 0203101351

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,680

Year Built

Built in 1989

Lot Details

0

Listing Details

  • Originating MLS: Monroe County Association
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Architecture Style: Traditional
  • Structure Style: 2 Story
  • Total Tax Amount: 5680.12
  • Year Built: 1989
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Cable/Internet Avail., Hardwood Floors, Fire Sprinkler, Walk-In Closet, Wet Bar/Bar
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator
  • Fireplace: Yes
  • Fireplaces: Basement Fireplace, FamRoom Fireplace, LivRoom Fireplace
  • Basement: Full, Walk Out
  • Bedrooms: 5
  • Bedroom 1: On Main Floor, Dimensions: 22 x 14
  • Bedroom 2: On Upper Floor, Dimensions: 15 x 14
  • Bedroom 3: On Upper Floor, Dimensions: 15 x 13
  • Bedroom 4: On Upper Floor, Dimensions: 16 x 13
  • Bedroom 5: On Upper Floor, Dimensions: 17 x 12
  • Bathrooms Description: MstrBdrm Full Bathroom
  • Full Bathrooms: 4
  • Total Bathrooms: 5
  • Room Types: Den/Study/Lib, First Floor Laundry, In-Law/AuPair/Ste, Recreation Room, Master Bathroom
  • Dining Room: On Main Floor, Dimensions: 16 x 15
  • Family Room: On Main Floor, Dimensions: 22 x 18
  • Kitchen: On Main Floor, Dimensions: 24 x 13
  • Kitchen Features: Pantry, Formal Dining Room
  • Living Room: On Main Floor, Dimensions: 18 x 15
  • Other Room1: Dimensions: 30x25, On Level: Lower
  • Other Room 2: Dimensions: 12x12, On Level: Lower
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 4423
  • Total Finished Sq Ft: 4423

Exterior Features

  • Exterior: Brick
  • Exterior Features: Deck, Patio
  • Road: Private Road

Garage/Parking

  • Garage: Attached Garage, Gar Door Opener, Side Loading Garage
  • Garage Spaces: 3
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Ceiling Fan(s), Central A/C

Schools

  • Elementary School: MONROE ROAD
  • High School: BEDFORD

Lot Info

  • Assessor Parcel Number: 0203101351
  • Zoning: Residential
  • Lot Description: Ravine, Wooded
  • Lot Dimensions: 80xIrreg
  • Acreage: 5.44

Tax Info

  • Summer Tax: Amount: $2,455.68
  • Winter Tax: Amount: $3,224.44
  • Total Tax: Amount: $5,680.12

MLS Schools

  • School District: Bedford Public Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 12, 2014
Closed on
Dec 15, 2014
Sold by
Ostas Michael and Ostas Linda
Bought by
Roque Stephen and Roque Ashleigh
Seller's Agent
Tony Bassett
The Danberry Company - Temperance
Buyer's Agent
Mike Sprott
Real Estate Solutions/MI, LLC - Temperance
List Price
$475,000
Sold Price
$351,000
Premium/Discount to List
-$124,000
-26.11%
Current Estimated Value
$831,436

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$480,436
Avg. Annual Appreciation
6.36%

Purchase Details

Closed on
Aug 20, 2012
Sold by
Spilak Kimberli C
Bought by
Miller Brian L and Miller Carrie L

Purchase Details

Closed on
Sep 22, 2011
Sold by
Ostas Michael and Ostas Linda
Bought by
Ostas Linda and Ostas Michael

Purchase Details

Closed on
Aug 23, 2011
Sold by
Ostas Michael and Ostas Linda
Bought by
Ostas Nicholas James
Source: Public Records

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
Roque Stephen $351,000 Louisville Title
Miller Brian L $65,000 --
Ostas Linda -- --
Ostas Nicholas James -- --
Ostas Stanley -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Ostas Michael D $157,618
Previous Owner Ostas Michael D $75,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/15/2014 12/15/14 Sold $351,000 -26.1% $79 / Sq Ft
12/15/2014 12/15/14 Pending -- -- --
04/12/2014 04/12/14 For Sale $475,000 -- $107 / Sq Ft
Source: Michigan Multiple Listing Service

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
2025 $6,737 $409,700 $409,700 $0
2024 $2,807 $368,500 $0 $0
2023 $2,673 $299,900 $0 $0
2022 $6,196 $299,900 $0 $0
2021 $5,977 $293,500 $0 $0
2020 $5,722 $266,600 $0 $0
2019 $5,660 $266,600 $0 $0
2018 $5,080 $228,700 $0 $0
2017 $4,825 $228,700 $0 $0
2016 $4,993 $232,900 $0 $0
2015 $4,933 $207,200 $0 $0
2014 $4,933 $207,200 $0 $0
2013 $5,367 $206,800 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 20397545

Michigan Multiple Listing Service

APN: 02-031-013-51