Sean Shields
Max Broock, REALTORS-Royal Oak
(248) 422-0346
66 Total Sales
1 in Northwest Warren
$225,000 Price
5137 Gerald St Warren, MI 48092
Northwest Warren NeighborhoodEstimated Value: $270,000 - $303,000
4
Beds
1.5
Baths
2,578
Sq Ft
$110/Sq Ft
Est. Value
About This Home
As of September 2025RARE FOUR BEDROOM RANCH AVAILABLE WITH MAGNIFICENT UPDATES THROUGHOUT. UPDATES INCLUDE: BRAND NEW DESIGNER KITCHEN WITH CALACATTA MARBLE COUNTER TOPS, CERAMIC BACKSPLASH, HIGH END STAINLESS STEEL APPLIANCES, TONS OF CABINET SPACE AND LARGE BASIN SINK. ALL NEW FLOORING THROUGHOUT THE ENTIRE HOME. FULL BATH WITH DOUBLE SINKS, SMART MIRRORS, HIGH END FIXTURES, CERAMIC FLOORS AND SURROUNDING WALLS. EXTENSIVE USE OF RECESSED LIGHTING. NEW DOORS AND CLOSET DOORS THROUGHOUT. UPDATED LIGHTING AND OUTLETS. BRIGHT AND CLEAN FULL SIZED FINISHED BASEMENT. NEWER ROOF AND WINDOWS. UPGRADED COVERED DECK IN THE BACKYARD. COVERED FRONT PORCH. EXTRA LONG DRIVEWAY LEADING TO AN OVERSIZED TWO CAR GARAGE. LARGE FENCED YARD AND MORE. SCHEDULE YOUR PRIVATE VIEWING TODAY.
Last Agent to Sell the Property
Lighthouse Real Estate Group Inc License #6501263256 Listed on: 04/23/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 1962 | Remodeled in 2024
Lot Details
- 6,970 Sq Ft Lot
- Lot Dimensions are 63.00 x 113.00
- Back Yard Fenced
Parking
- Garage
Home Design
- Brick Exterior Construction
- Poured Concrete
- Asphalt Roof
Bedrooms and Bathrooms
- 4 Bedrooms
Location
- Ground Level
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
Additional Features
- Basement
Community Details
- Kingswood # 04 Subdivision
Listing and Financial Details
- Assessor Parcel Number 1317202048
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
Apr 23, 2025
Closed on
Sep 25, 2025
Sold by
Bought by
Seller's Agent
Alvin Kassab
Lighthouse Real Estate Group Inc
Buyer's Agent
Tongyu Guo
@properties Christie's Int'l RE Grosse Pointe
List Price
$299,999
Sold Price
$285,000
Premium/Discount to List
-$14,999
-5%
Views
68
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
-$535
Avg. Annual Appreciation
-0.22%
Original Mortgage
$185,000
Outstanding Balance
$183,485
Interest Rate
6.58%
Mortgage Type
New Conventional
Estimated Equity
$100,980
Purchase Details
Listed on
Apr 28, 2021
Closed on
May 28, 2021
Sold by
Bought by
Seller's Agent
Michael Cowper
Braven Enterprises LLC
Buyer's Agent
Michael Cowper
Braven Enterprises LLC
List Price
$192,500
Sold Price
$180,000
Premium/Discount to List
-$12,500
-6.49%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.22%
Original Mortgage
$135,000
Interest Rate
2.9%
Mortgage Type
New Conventional
Purchase Details
Listed on
Apr 28, 2021
Closed on
Apr 28, 2021
Sold by
Bought by
Seller's Agent
Michael Cowper
Braven Enterprises LLC
Buyer's Agent
Michael Cowper
Braven Enterprises LLC
List Price
$192,500
Sold Price
$180,000
Premium/Discount to List
-$12,500
-6.49%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$135,000
Interest Rate
2.9%
Mortgage Type
New Conventional
Purchase Details
Closed on
Apr 2, 2014
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Northwest Warren, MI
-
Sean Shields
-
Michelle Caldwell
Michelle Caldwell
Epique Realty
(810) 535-6442
78 Total Sales
1 in Northwest Warren
$145,000 Price
-
Raymond Karoumy
Raymond Karoumy
Responds QuicklyTop Agent Realty
(586) 788-0902
96 Total Sales
2 in Northwest Warren
$185K - $239K Price Range
-
Shannon Hall
Shannon Hall
Real Estate One-Plymouth
(947) 282-9573
174 Total Sales
1 in Northwest Warren
$211,000 Price
-
Shana Sine Cameron
Shana Sine Cameron
Sine & Monaghan LLC
(313) 474-6840
305 Total Sales
3 in Northwest Warren
$229K - $246K Price Range
-
Kevin Stewart
Kevin Stewart
Stewart Team R E Partners Inc
(586) 371-6887
146 Total Sales
1 in Northwest Warren
$226,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 |
|---|---|---|---|
| $285,000 | Lighthouse Title | ||
| $180,000 | Devon Title Agency | ||
| $137,500 | Ata National Title Group Llc | ||
| -- | 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 |
|---|---|---|---|
| Open | $185,000 | ||
| Previous Owner | $135,000 | ||
| Previous Owner | $125,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 | Prior Sale |
|---|---|---|---|---|---|
| 09/25/2025 09/25/25 | Sold | $285,000 | -1.7% | $111 / Sq Ft | |
| 09/02/2025 09/02/25 | Pending | -- | -- | -- | |
| 06/06/2025 06/06/25 | Price Changed | $289,900 | -3.0% | $112 / Sq Ft | |
| 05/18/2025 05/18/25 | Price Changed | $298,900 | -0.4% | $116 / Sq Ft | |
| 04/27/2025 04/27/25 | For Sale | $299,999 | +66.7% | $116 / Sq Ft | |
| 06/01/2021 06/01/21 | Sold | $180,000 | -6.5% | $131 / Sq Ft | View Prior Sale |
| 05/17/2021 05/17/21 | Pending | -- | -- | -- | |
| 04/28/2021 04/28/21 | For Sale | $192,500 | -- | $140 / Sq Ft |
Source: Realcomp
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 | $5,119 | $129,650 | $0 | $0 |
| 2025 | $4,973 | $125,620 | $0 | $0 |
| 2024 | $49 | $113,100 | $0 | $0 |
| 2023 | $4,613 | $96,940 | $0 | $0 |
| 2022 | $5,733 | $84,610 | $0 | $0 |
| 2021 | $3,065 | $80,080 | $0 | $0 |
| 2020 | $2,955 | $76,410 | $0 | $0 |
| 2019 | $2,849 | $68,260 | $0 | $0 |
| 2018 | $2,894 | $64,120 | $0 | $0 |
| 2017 | $2,858 | $55,310 | $10,280 | $45,030 |
| 2016 | $2,855 | $55,310 | $0 | $0 |
| 2015 | -- | $50,660 | $0 | $0 |
| 2012 | -- | $43,730 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Alvin Kassab
Seller's Agent in 2025
Alvin Kassab
Lighthouse Real Estate Group Inc
(248) 865-9400
2 in this area
24 Total Sales
-
Tongyu Guo
T
Buyer's Agent in 2025
Tongyu Guo
@properties Christie's Int'l RE Grosse Pointe
(571) 519-8053
1 in this area
6 Total Sales
-
Michael Cowper
Seller's Agent in 2021
Michael Cowper
Braven Enterprises LLC
(248) 896-5395
2 in this area
78 Total Sales
Map
Source: Realcomp
MLS Number: 20250028555
APN: 12-13-17-202-048
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.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2026 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 5026 Gerald St
- 5240 Gerald St
- 28621 Milton Ave
- 5383 Gerald St
- 28542 Grobbel Ave
- 4940 Stanley Ave
- 28644 Grobbel Ave
- 27663 Audrey Ave
- 4432 Thornwood Ct
- 5812 E 12 Mile Rd
- 5873 Elmgrove Ave
- 5873 Elmgrove Ave
- 4644 Kingsley Dr
- 29364 Woodpark Cir
- 29021 van Laan Dr
- 27481 Cosgrove Dr
- 28530 Ryan Rd
- 27469 Cosgrove Dr
- 27400 Milton Ave
- 29509 Woodpark Cir
- 5149 Gerald St
- 28416 Audrey Ave
- 28422 Audrey Ave
- 28417 Patricia Ave
- 28423 Patricia Ave
- 28434 Audrey Ave
- 28435 Patricia Ave
- 5136 Gerald St
- 5124 Gerald St
- 28417 Audrey Ave
- 5148 Gerald St
- 28446 Audrey Ave
- 5112 Gerald St
- 28447 Patricia Ave
- 5160 Gerald St
- 28421 Audrey Ave
- 28458 Audrey Ave
- 5227 Gerald St
- 5015 Gerald St
- 5216 Gerald St
Your Personal Tour Guide
Ask me questions while you tour the home.