Seller's Agent in 2025
Kevin Kostka
Epique Inc.
(586) 610-4850
15 in this area
131 Total Sales
15750 Lamont Dr Macomb, MI 48042
3
Beds
2.5
Baths
1,875
Sq Ft
8,276
Sq Ft Lot
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
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
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
Bagi Raid and Yaghub Raghad
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
$10,259
Avg. Annual Appreciation
8.28%
Original Mortgage
$340,000
Outstanding Balance
$340,000
Interest Rate
6.58%
Mortgage Type
New Conventional
Estimated Equity
$95,259
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 Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$192,000
Interest Rate
6.72%
Mortgage Type
Purchase Money Mortgage
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $425,000 | None Listed On Document | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Deed | $240,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $340,000 | New Conventional | |
| Previous Owner | $192,000 | Purchase Money Mortgage |
Source: Public Records
Property History
| 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 Compared to Growth
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 | $2,200 | $197,900 | $0 | $0 |
| 2024 | $2,141 | $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
-
Ereny Gaied
Buyer's Agent in 2025
Ereny Gaied
Century 21 Professionals Troy
(586) 243-7274
3 in this area
68 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 2025 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
- 53260 Villa Rosa Dr
- 54680 Chickasaw Dr
- 16040 Violet Dr
- 54454 Cambridge Dr
- 54676 Carnation Dr
- 15029 24 Mile Rd
- 52921 Sawmill Creek Dr
- 54880 Burlington Dr
- 14621 Towering Oaks Dr
- 16102 Thames Ln
- 16200 Thames Ln
- 52531 Lasalle Dr
- 16738 Fieldstone Ridge Unit 11
- 16701 25 Mile Rd
- 52522 Charing Way
- 54344 Sweetwood Dr
- 14345 24 Mile Rd
- 16655 Pearlcreek Ct Unit 31
- 53650 Romeo Plank Rd
- 14153 Jode Park Ct