MLS # 20250028555 (Realcomp)

RARE 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.
Source: SparkMLS
4-bedroom, 2-bath, 2,578 sq ft home in Warren in Warren built in 1962.
Final sale price: $285,000 (about $111/sq ft).
Annual property taxes run approximately $5,009 ($417/month). Tax figure is from the MLS listing record; verify with the county treasurer for the most current amount.
Fiber internet is available at this address with download speeds up to 5,000 Mbps across 10 providers. Electric service is provided by DTE Electric Company; natural gas by Consumers Energy Company.
Location
Construction & Systems
Sale & Financing
Source: SparkMLS
Source: Public Records
Legal Description
"KINGSWOOD SUBDIVISION NO. 4" LOT 491 L.45 P.25-26
FEMA Flood Zone: Zone X — Minimal flood risk
Source: FEMA NFHLUSDA Rural Development: Not Eligible
Verify eligibility at USDAListed by Amira Kassab
Lighthouse Real Estate Group Inc
Estimate only. Does not include PMI or other fees. Consult a lender for exact rates.
Download
5 Gbps
Upload
5 Gbps
FCC Broadband Data Collection (Dec 2025). Max advertised speeds.
DTE Electric Company
Investor-Owned
Consumers Energy Company
Investor-Owned
MI Public Service Commission service territory boundaries.
Property
5137 GERALD Street, Warren, MI 48092
View full property history →
Municipality
Warren
View all listings →
County
Macomb County
View county overview →
We'll notify you when something hits the market in Warren or nearby.
Munro Real Estate · MI Broker #6502405404 · No spam, one-click unsubscribe.