NOT LISTED FOR SALE

4195 Stillbrook Ln de Witt, MI 48820

Estimated Value: $578,822 - $745,000

5 Beds
3.5 Baths
3,101 Sq Ft
$210/Sq Ft Est. Value

Sale Details

Date Sold: November 22, 2022

Last sale price $603,966 $195 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $3,534 / mo

5 Days on Market

Highlights

  • New Construction
  • Deck
  • Stainless Steel Appliances
  • Scott Elementary School Rated A-
  • Bonus Room
  • 3 Car Direct Access Garage

About This Home

As of November 2022

Welcome home to the Waterfront of Lakeside Preserve! This home is the ideal backdrop for any family gathering and holiday festivities. The large rear entry is conveniently equipped with a ''drop zone'' for everything your family may need on their way in or out the door! This home is over 2360 square feet of pure charm. Quartz countertops; water proof and scratch resistant laminate wood flooring, a first floor study and an open great room showcasing a gas fireplace with stone surround. The dining room is flooded with natural light from the full panes of glass on all 3 walls completing the charisma of this spectacular new home. With 4 bedrooms upstairs including the sizeable primary suite; double closets, double vanities and an elegant ceramic tile shower for you to enjoy. If more space is desired, head to the finished basement with an additional 730+ square feet, large lookout windows, a guest bedroom and bathroom suite and rec room.

Last Agent to Sell the Property

Steven Mittleman

Mayberry Real Estate License #6502372121 Listed on: 09/15/2022

Last Buyer's Agent

Steven Mittleman

Mayberry Real Estate License #6502372121 Listed on: 09/15/2022

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $285

Year Built

  • Built in 2022 | New Construction

Lot Details

  • 20,909 Sq Ft Lot
  • Lot Dimensions are 111x189

HOA Fees

  • $38 Monthly HOA Fees

Parking

  • 3 Car Direct Access Garage
  • Garage Door Opener

Home Design

  • Shingle Roof
  • Vinyl Siding
  • Stone Exterior Construction

Interior Spaces

  • 2-Story Property
  • Ceiling Fan
  • Gas Fireplace
  • Living Room with Fireplace
  • Dining Room
  • Bonus Room
  • Fire and Smoke Detector

Kitchen

  • Gas Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Flooring

  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry Room
  • Laundry on upper level

Finished Basement

  • Bedroom in Basement
  • Basement Window Egress

Outdoor Features

  • Deck
  • Porch

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Connected

Listing and Financial Details

  • Home warranty included in the sale of the property

Community Details

Overview

  • Built by Mayberry Homes LLC
  • Lakeside Preserve Subdivision

Amenities

  • Office

Home Details

Home Type

Single Family

Est. Annual Taxes

$285

Year Built

Built in 2022 | New Construction

Lot Details

0.48 Acres

HOA Fees

$38 per month

Parking

3

Listing Details

  • Property Conditions Completion Date: 2022-10-01
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Year Built: 2022
  • Above Grade Finished Sq Ft: 2368.0
  • New Construction: Yes
  • General Property Info:Lot Size Dimensions: 111x189
  • General Property Info:Reserved Items: No
  • General Property Info:Above Grade Finished Area: 2368.0
  • General Property Info:Level 2 Finished Area: 1232.0
  • General Property Info:Level 1 Finished Area: 1136.0
  • General Property Info:Total Livable Area: 3101.0
  • Property Conditions:New Construction5: Yes
  • Special Features: NewHome

Interior Features

  • Basement: Egress Windows, Finished
  • Heating: Forced Air, Natural Gas
  • Flooring: Carpet, Laminate
  • Interior Amenities: Ceiling Fan(s), Pantry, Walk-In Closet(s)
  • Total Bedrooms: 5
  • Dining Room Level: First
  • Living Room Level: First
  • Levels: Two
  • Bedroom 3 Level: Second
  • Bedroom 4 Level: Second
  • Bedroom 5 Level: Basement
  • Bonus Room Level: Basement
  • Office Level: First
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Below Grade Sq Ft: 733.0
  • Fireplace Features: Gas, Living Room
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 3101.0
  • Baths:_pound_Full Baths 2: 2
  • Baths:_pound_Full Baths B: 1
  • Baths:_pound_Half Baths 1: 1
  • Rooms:Bedroom 2: Yes
  • Rooms:Bedroom 3: Yes
  • Rooms:Dining Room2: Yes
  • Rooms:Kitchen2: Yes
  • Rooms:Kitchen Level2: First
  • Rooms:Living Room2: Yes
  • Rooms:Primary Bedroom2: Yes
  • Primary Bedroom Level: Second
  • Levels:Two2: Yes
  • Flooring:Carpet: Yes
  • Flooring:Laminate: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Pantry: Yes
  • Appliances:Humidifier: Yes
  • Fireplace Features:Gas3: Yes
  • Percent Basement Finished: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Rooms:Bedroom 4: Yes
  • Laundry Features:Laundry Room: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Laundry Features:Upper Level: Yes
  • Appliances:Gas Range: Yes
  • Rooms:Office: Yes
  • Basement:Egress Windows: Yes
  • Rooms:Bedroom 5: Yes
  • Rooms:Bonus Room: Yes
  • Fireplace Features:Living Room: Yes
  • Appliances:Gas Oven: Yes
  • General Property Info:SqFt - Basement: 1138.0

Exterior Features

  • Roof: Shingle
  • Builder Name: Mayberry Homes LLC
  • RoadSurfaceType: Paved
  • Patio And Porch Features: Deck, Porch
  • Home Warranty: Yes
  • Construction Type: Stone, Vinyl Siding
  • Property Condition: New Construction
  • Patio Porch Features:Deck: Yes
  • Patio Porch Features:Porch: Yes
  • Roof:Shingle: Yes
  • Exterior:Vinyl Siding: Yes
  • Exterior:Stone: Yes
  • Road Surface Type:Paved: Yes

Garage/Parking

  • Parking Features: Attached, Concrete Driveway, Direct Access, Finished, Garage Door Opener
  • Parking Features Garage Spaces: 3.0
  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Attached: Yes
  • Parking Features:Finished2: Yes
  • Parking Features:Concrete Driveway: Yes
  • Parking Features:Direct Access: Yes

Utilities

  • Sewer: Public Sewer
  • Appliances: Disposal, Gas Oven, Microwave, Stainless Steel Appliance(s), Refrigerator, Humidifier, Gas Range, Dishwasher
  • Cooling: Central Air
  • LaundryFeatures: Laundry Room, Upper Level
  • Utilities: Natural Gas Connected
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Sewer:Public Sewer: Yes
  • Security Features:Smoke Detector(s): Yes
  • Cooling:Central Air: Yes
  • Utilities:Natural Gas Connected: Yes

Condo/Co-op/Association

  • Association Fee: 450.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • Location Legal Info:Association Fee: 450.0
  • Location Legal Info:Association Fee Frequency: Annually

Schools

  • Junior High Dist: DeWitt

Lot Info

  • Lot Size Acres: 0.48
  • Lot Size: 111x189
  • Lot Size Sq Ft: 20908.8
  • ResoLotSizeUnits: Acres
  • Land Acreage:_one_4 thru 12 Acre: Yes

Tax Info

  • Tax Annual Amount: 285.0
  • Tax Info:Taxable Value: 1277.0
  • Tax Info:State Eq Value: 35250.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 15, 2022
Closed on
Nov 21, 2022
Sold by
Mayberry Homes Llc
Bought by
Geschke Patrick
Seller's Agent
Steven Mittleman
Mayberry Real Estate
Buyer's Agent
Steven Mittleman
Mayberry Real Estate
List Price
$601,000
Sold Price
$603,966
Premium/Discount to List
$2,966
0.49%
Current Estimated Value
$650,956

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$46,990
Avg. Annual Appreciation
2.18%
Original Mortgage
$500,000
Outstanding Balance
$484,467
Interest Rate
6.94%
Mortgage Type
Balloon
Estimated Equity
$166,489

Purchase Details

Closed on
Sep 1, 2022
Sold by
Lakeside Preserve Llc
Bought by
Mayberry Homes Llc
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
Geschke Patrick $603,966 Bell Title
Mayberry Homes Llc $75,000 Bell Title
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
Open Geschke Patrick $500,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/22/2022 11/22/22 Sold $603,966 +0.5% $195 / Sq Ft
09/19/2022 09/19/22 Pending -- -- --
09/14/2022 09/14/22 For Sale $601,000 -- $194 / Sq Ft
Source: Greater Lansing Association of 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 $252 $308,950 $43,150 $265,800
2024 $164 $279,650 $36,550 $243,100
2023 $164 $0 $0 $0
2022 $164 $35,250 $35,250 $0
2021 $284 $34,800 $34,800 $0
2020 $275 $34,700 $34,700 $0
2019 $257 $33,200 $33,200 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Greater Lansing Association of Realtors®

MLS Number: 268548

Greater Lansing Association of Realtors®

APN: 150-210-000-221-00

Your Personal Tour Guide

Ask me questions while you tour the home.