NOT LISTED FOR SALE

15400 Schultz Rd Berlin, MI 48002

Estimated Value: $589,000 - $731,000

5 Beds
2 Baths
2,710 Sq Ft
$238/Sq Ft Est. Value

Sale Details

Date Sold: December 14, 2020

Last sale price $445,000 $164 Per Sq Ft

Est. 45% increase in value since last sale

Current estimated payment $3,728 / mo

4 Days on Market

Highlights

  • 11.34 Acre Lot
  • Deck
  • Pole Barn
  • Colonial Architecture
  • Cathedral Ceiling
  • 2 Car Attached Garage

About This Home

As of December 2020

WOW WHAT AN INCRDEBLE HOME FOR THE MONEY THIS 5 BEDROOM HOME IS OUTSTANDING AND NESTLED ON 11.34 ACRES , HOME FEATURES GEOTHERMAL HEAT THROUGHOUT ENTIRE HOME, 2 BEDRROMS ON MAIN FLOOR, BEAUTIFUL CUSTOM KITCHEN CABINETS WITH GRANITE COUNTERS ALL STAINLESS STEAL APPLIANCES STAY, GREAT LAYOUT INCLUDING FORMAL DINING ROOM, GREAT ROOM WITH FIREPLACE, HUGE WALK OUT BASEMENT, AND CHECK OUT THE DETAILED MASONRY ON THIS HOME , AND LETS NOT FORGET THAT STOCKED POND FOR THOSE HOT SUMMER DAYS AND A FEW OUT BUIDINGS FOR EXTRA STORAGE , YOU CAN NOT DUPLICATE THIS HOME FOR THIS PRICE WITH THIS LAND!!!

Last Agent to Sell the Property

Hank Mendez

Real Estate One Inc-Shelby License #MISPE-6506048711 Listed on: 11/06/2020

Real Estate One Inc-Shelby

Co-Listed By

Haralambous Kourlos

Real Estate One Inc-Shelby License #MISPE-6501389374

Last Buyer's Agent

Michael Bailey

Realty Executives Home Towne License #6501409670

Realty Executives Home Towne

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2007

Lot Details

  • 11.34 Acre Lot
  • Lot Dimensions are 363 x 1322
  • Rural Setting

Parking

  • 2 Car Attached Garage

Home Design

  • Colonial Architecture
  • Split Level Home
  • Brick Exterior Construction

Interior Spaces

  • 2,710 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Great Room with Fireplace

Kitchen

  • Oven or Range
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Sump Pump

Outdoor Features

  • Property is near a pond
  • Deck
  • Pole Barn
  • Shed

Utilities

  • Forced Air Heating and Cooling System
  • Geothermal Heating and Cooling
  • Well
  • Geothermal Hot Water System
  • Septic Tank

Listing and Financial Details

  • Assessor Parcel Number 09-004-1003-500

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,253

Year Built

Built in 2007

Lot Details

11.34 Acres

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Architecture Style: Colonial, Split Level
  • Structure Style: 2 Story
  • Total Tax Amount: 4253
  • Total Tax Year: 2020
  • Year Built: 2007
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Cathedral/Vaulted Ceiling, Sump Pump, Walk-In Closet
  • Appliances: Dishwasher, Dryer, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Grt Rm Fireplace
  • Basement: Yes
  • Basement: Walk Out
  • Bedrooms: 5
  • Bedroom 1: On Entry Level, Dimensions: 17 x 13
  • Bedroom 2: On Entry Level, Dimensions: 12 x 11
  • Bedroom 3: On Upper Floor, Dimensions: 23 x 12
  • Bedroom 4: On Upper Floor, Dimensions: 14 x 13
  • Bedroom 5: On Upper Floor, Dimensions: 11 x 12
  • Bathrooms Description: First Flr Lavatory, MstrBdrm Full Bathroom, First Flr Full Bathroom
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Bathroom 1: On Level: Upper
  • Bathroom 2: On Level: Upper
  • Great Room: On Entry Level, Dimensions: 18 x 16
  • Kitchen: On Entry Level, Dimensions: 22 x 9
  • Kitchen Features: Breakfast Nook/Room, Dining "L", Eat-In Kitchen, Formal Dining Room
  • Below Grade Sq Ft: 1807
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 2710
  • Total Finished Sq Ft: 2710

Exterior Features

  • Exterior: Brick
  • Exterior Features: Deck
  • Foundation: Basement
  • Frontage: 363
  • Water Features: Pond
  • Out Buildings: Pole Barn, Shed
  • Frontage Type: Road

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 2
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Geothermal
  • Sewer: Septic
  • Water: Private Well
  • Water Heater: Geothermal
  • Cooling: Central A/C

Lot Info

  • Assessor Parcel Number: 09-004-1003-500
  • Location: Rural
  • Lot Description: Deep Lot - 150+ Ft., Large Lot - 65+ Ft.
  • Lot Dimensions: 363 X 1322
  • Acreage: 11.34
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2020, Amount: $1,789.00
  • Winter Tax: Year: 2020, Amount: $2,464.00
  • Total Tax: Year: 2020, Amount: $4,253.00

MLS Schools

  • School District: Capac Community School District

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 6, 2020
Closed on
Dec 14, 2020
Sold by
Bought by
Seller's Agent
Hank Mendez
Real Estate One Inc-Shelby
Buyer's Agent
Michael Bailey
Realty Executives Home Towne
List Price
$439,413
Sold Price
$445,000
Premium/Discount to List
$5,587
1.27%
Current Estimated Value
$645,615

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$200,615
Avg. Annual Appreciation
6.91%
Original Mortgage
$445,000
Interest Rate
0.027%
Mortgage Type
VA

Purchase Details

Closed on
Jan 16, 2009
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$174,000
Interest Rate
0.0519%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 12, 2008
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$174,000
Interest Rate
0.0519%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 11, 2008
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$174,000
Interest Rate
0.0519%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 22, 2006
Sold by
Bought by

Purchase Details

Closed on
Nov 24, 2004
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$215,000
Interest Rate
0.0325%
Mortgage Type
Adjustable Rate Mortgage/ARM
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$445,000 Liberty Title
$217,500 None Available
-- None Available
-- None Available
-- None Available
$325,000 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Closed $590,000
Closed $445,000
Closed $174,000
Closed $215,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
12/14/2020 12/14/20 Sold $445,000 +1.3% $164 / Sq Ft
11/12/2020 11/12/20 Pending -- -- --
11/07/2020 11/07/20 For Sale $439,413 -- $162 / Sq Ft
Source: Michigan Multiple Listing Service

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $3,136 $327,300 $0 $0
2024 $3,042 $308,700 $0 $0
2023 $2,897 $274,200 $0 $0
2022 $2,513 $225,300 $0 $0
2020 $4,457 $198,200 $198,200 $0
2019 $1,756 $183,500 $0 $0
2018 $4,078 $190,100 $0 $0
2017 $3,998 $187,800 $0 $0
2016 $1,664 $187,800 $0 $0
2015 -- $146,500 $146,500 $0
2014 -- $135,400 $135,400 $0
2013 -- $147,900 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Hank Mendez

    Seller's Agent in 2020

    Hank Mendez

    Real Estate One Inc-Shelby

    (586) 405-3333

    140 Total Sales

    Hank Mendez
    Section Image
  • Haralambous Kourlos

    Seller Co-Listing Agent in 2020

    Haralambous Kourlos

    Real Estate One Inc-Shelby

    (586) 883-3333

    43 Total Sales

    Haralambous Kourlos
    Section Image

  • M

    Buyer's Agent in 2020

    Michael Bailey

    Realty Executives

    (810) 292-9206

    34 Total Sales

    Michael Bailey
    Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 50028395

Michigan Multiple Listing Service

APN: 09-004-1003-500

Michigan St. Clair County Berlin 48002

15400 Schultz Rd, Berlin, MI

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Michigan Multiple Listing Service Source MLS: MiRealSource
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.

The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.

Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.