Kurt Bernas
RE/MAX New Trend
(947) 210-6162
93 Total Sales
1 in Macomb
$395,000 Price
15750 Lamont Dr Macomb, MI 48042
Macomb AreaEstimated Value: $431,791
3
Beds
2.5
Baths
1,875
Sq Ft
$230/Sq Ft
Est. Value
Highlights
- Ranch Style House
- Wood Flooring
- Breakfast Area or Nook
- Shelby Junior High School Rated A-
- Great Room with Fireplace
- Porch
About This Home
As of September 2025Welcome home to this beautifully maintained 3-bedroom, 2.5-bath ranch offering 1,875 sq. ft. of comfortable living space in one of Macomb Township’s most desirable neighborhoods. Located in the highly rated Utica Community School District, this home combines quality updates, functional features, and outstanding curb appeal. Inside, you’ll find a bright, open layout adorned with beautiful hardwood flooring and neutral paint colors. Perfect for both everyday living and entertaining. Enjoy peace of mind with Wallside replacement windows that bring in natural light while enhancing energy efficiency. The kitchen features a 1-year-old GE dishwasher and a reverse osmosis water system, ideal for modern living. Major mechanical updates include a furnace and A/C replaced in 2017, hot water tank updated in 2012, and a new 50-year roof, vinyl siding, and seamless gutters installed in 2024—all designed for long-term durability. The attached insulated garage is a true bonus, complete with a natural gas heater, insulated garage door (2020), and heavy-duty pull-down attic stairs for convenient overhead storage. The home sits on a spacious, well-kept lot with a fantastic yard—perfect for outdoor enjoyment in a peaceful, well-established neighborhood. This move-in ready gem offers the ideal blend of comfort, updates, and location. Get here soon... Before someone else does.
Last Agent to Sell the Property
Epique Inc. License #MISPE-6506046875 Listed on: 07/10/2025
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 Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 1994
Lot Details
- 8,276 Sq Ft Lot
- Lot Dimensions are 70x120
- Sprinkler System
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Vinyl Trim
Interior Spaces
- 1,875 Sq Ft Home
- Entryway
- Great Room with Fireplace
- Wood Flooring
- Basement
- Sump Pump
Kitchen
- Breakfast Area or Nook
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
- Bathroom on Main Level
Parking
- 2 Car Attached Garage
- Heated Garage
Outdoor Features
- Patio
- Porch
Schools
- Beck Elementary School
- Shelby Jr. High Middle School
- Eisenhower High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
- Internet Available
Community Details
- Bayberry Place Sub Subdivision
Listing and Financial Details
- Assessor Parcel Number 20-08-07-332-019
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
Jul 10, 2025
Closed on
Sep 16, 2025
Sold by
David C Stuben Revocable Living Trust and Stuben David C
Bought by
Seller's Agent
Kevin Kostka
Epique Inc.
Buyer's Agent
Ereny Gaied
Century 21 Professionals Troy
List Price
$464,900
Sold Price
$425,000
Premium/Discount to List
-$39,900
-8.58%
Views
64
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$6,791
Avg. Annual Appreciation
1.60%
Original Mortgage
$340,000
Outstanding Balance
$336,578
Interest Rate
6.58%
Mortgage Type
New Conventional
Estimated Equity
$95,213
Purchase Details
Closed on
May 10, 2017
Sold by
Stuben David C and Stuben David
Bought by
Stuben David C and The David C Stuben Revocable Living Trus
Purchase Details
Closed on
Oct 19, 2012
Sold by
Stuben Karen
Bought by
Stuben David
Purchase Details
Closed on
Sep 13, 2001
Sold by
Watson Mark R
Bought by
Stuben David C
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Macomb, MI
-
Kurt Bernas
-
Donna Hicks
Donna Hicks
Vision Realty Centers
(947) 600-5190
31 Total Sales
1 in Macomb
$474,900 Price
-
Saif Lateef
Saif Lateef
Keller Williams Lakeside
(586) 400-2875
151 Total Sales
9 in Macomb
$330K - $505K Price Range
-
Emily Whiting
Emily Whiting
Venta Realty Group
(855) 947-1883
7 Total Sales
1 in Macomb
$435,000 Price
-
Marc Johnson
Marc Johnson
Johnson Realty Group, LLC
(313) 631-3883
41 Total Sales
2 in Macomb
$509,000 Price Range
-
Clayton Waldschlager-Arnold
Clayton Waldschlager-Arnold
ERA Prime Real Estate Group
(248) 653-1898
157 Total Sales
1 in Macomb
$417,000 Price
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 |
|---|---|---|---|
| $425,000 | None Listed On Document | ||
| Stuben David C | -- | None Available | |
| Stuben David | -- | None Available | |
| Stuben David C | $240,000 | -- |
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 | $340,000 | ||
| Closed | Bagi Raid | $340,000 | |
| Previous Owner | Stuben David C | $129,000 | |
| Previous Owner | Stuben David | $163,000 | |
| Previous Owner | Stuben David C | $170,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 |
|---|---|---|---|---|
| 09/16/2025 09/16/25 | Sold | $425,000 | -5.5% | $227 / Sq Ft |
| 09/12/2025 09/12/25 | Pending | -- | -- | -- |
| 08/09/2025 08/09/25 | Price Changed | $449,900 | -1.1% | $240 / Sq Ft |
| 07/22/2025 07/22/25 | Price Changed | $454,900 | -2.2% | $243 / Sq Ft |
| 07/10/2025 07/10/25 | For Sale | $464,900 | -- | $248 / 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 |
|---|---|---|---|---|
| 2026 | $3,310 | $209,700 | $0 | $0 |
| 2025 | $2,200 | $197,900 | $0 | $0 |
| 2024 | $21 | $190,500 | $0 | $0 |
| 2023 | $2,028 | $165,600 | $0 | $0 |
| 2022 | $2,929 | $149,400 | $0 | $0 |
| 2021 | $2,852 | $143,700 | $0 | $0 |
| 2020 | $1,867 | $139,100 | $0 | $0 |
| 2019 | $2,616 | $130,600 | $0 | $0 |
| 2018 | $2,587 | $124,000 | $0 | $0 |
| 2017 | $2,543 | $116,370 | $32,500 | $83,870 |
| 2016 | $2,393 | $116,320 | $0 | $0 |
| 2015 | $2,364 | $109,990 | $0 | $0 |
| 2014 | $2,364 | $96,740 | $21,500 | $75,240 |
| 2011 | $693 | $91,850 | $18,500 | $73,350 |
Source: Public Records
Agents Affiliated with this Home
-
Kevin Kostka
Seller's Agent in 2025
Kevin Kostka
Epique Inc.
(586) 610-4850
124 Total Sales
-
Ereny Gaied
Buyer's Agent in 2025
Ereny Gaied
Century 21 Professionals Troy
(586) 243-7274
67 Total Sales
Map
Source: Michigan Multiple Listing Service
MLS Number: 50181220
APN: 20-08-07-332-019
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.
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
- 53639 Cranston Dr
- 53721 Beck Ct
- 15408 Prentice Ct
- 53707 Addington Dr
- 53731 Addington Dr
- 53755 Addington Dr
- 53260 Villa Rosa Dr
- 53725 Arabian Trail
- 15133 Towering Oaks Dr
- 53303 Hayes Rd
- 54439 Nicholas
- 53303 Hayes Rd Hayes Rd
- 16185 24 Mile Rd
- 53106 Celtic Dr Unit 31
- 52844 Karon Dr
- 53183 Celtic Dr
- 53167 Celtic Dr
- 53710 Wellington Dr
- 54375 Jeffery Dr
- 16371 Paint Creek Cir
- 15744 Lamont Dr
- 15749 Clarion Ct
- 15738 Lamont Dr
- 15733 Clarion Ct
- 15762 Lamont Dr
- 15747 Lamont Dr
- 15753 Lamont Dr
- 15741 Lamont Dr
- 15781 Clarion Ct
- 15717 Clarion Ct
- 15732 Lamont Dr
- 15759 Lamont Dr
- 15735 Lamont Dr
- 15726 Lamont Dr
- 15729 Lamont Dr
- 15701 Clarion Ct
- 15748 Howard Dr
- 15754 Howard Dr
- 15754 Clarion Ct
- 15742 Howard Dr
Your Personal Tour Guide
Ask me questions while you tour the home.