Welcome to this beautifully remodeled brick ranch located in one of Sterling Heights’ most desirable neighborhoods. Featuring 3 spacious bedrooms on the main level plus an additional bedroom in the finished basement, this move-in-ready home offers the perfect combination of comfort, style, and functionality.
From the moment you arrive, you’ll appreciate the excellent curb appeal and extensive updates throughout the home, including newer laminate flooring, fresh neutral paint, recessed lighting, a new A/C system, and a furnace installed in 2022.
The fully updated kitchen showcases modern cabinetry, granite countertops, stainless steel appliances, and a stylish backsplash, seamlessly opening into a large family room highlighted by a beautifully updated brick fireplace. The main floor also offers a spacious living room with door wall access leading to the patio and oversized fenced backyard — perfect for entertaining or relaxing outdoors.
The remodeled full bathroom features ceramic tile flooring and a custom tile shower surround, while all three bedrooms offer generous space and natural light.
The finished basement adds valuable extra living space, complete with an additional bedroom, second shower, and a large laundry/storage area.
Additional updates include newer windows, updated doors, trim, baseboards, electrical outlets and switches, and a new front entry door.
Attached 2-car garage. Conveniently located near shopping, dining, parks, and top-rated schools.
A truly turnkey home with modern updates throughout — ready for its next owner to move right in and enjoy.
From the moment you arrive, you’ll appreciate the excellent curb appeal and extensive updates throughout the home, including newer laminate flooring, fresh neutral paint, recessed lighting, a new A/C system, and a furnace installed in 2022.
The fully updated kitchen showcases modern cabinetry, granite countertops, stainless steel appliances, and a stylish backsplash, seamlessly opening into a large family room highlighted by a beautifully updated brick fireplace. The main floor also offers a spacious living room with door wall access leading to the patio and oversized fenced backyard — perfect for entertaining or relaxing outdoors.
The remodeled full bathroom features ceramic tile flooring and a custom tile shower surround, while all three bedrooms offer generous space and natural light.
The finished basement adds valuable extra living space, complete with an additional bedroom, second shower, and a large laundry/storage area.
Additional updates include newer windows, updated doors, trim, baseboards, electrical outlets and switches, and a new front entry door.
Attached 2-car garage. Conveniently located near shopping, dining, parks, and top-rated schools.
A truly turnkey home with modern updates throughout — ready for its next owner to move right in and enjoy.
Property Details
Price:
$374,900
MLS #:
20261031661
Status:
Active
Beds:
3
Baths:
2
Type:
Single Family
Subtype:
SingleFamilyResidence
Neighborhood:
area03101sterlingheights
Listed Date:
May 5, 2026
Finished Sq Ft:
1,610
Year Built:
1959
See this Listing
Schools
School District:
Utica
Interior
Above Grade Finished Area
1610
Appliances
Dishwasher, Dryer, Microwave, RangeHood, Washer, WasherDryerAllinOne
Bathrooms
2 Full Bathrooms
Heating
Forced Air, Natural Gas
Levels
One
Exterior
Architectural Style
Ranch
Attached Garage YN
1
Construction Materials
Brick
Exterior Features
Barbecue
Garage Spaces
2
Parking Features
TwoCarGarage, Attached
Patio And Porch Features
Patio
Security Features
Smoke Detectors
Financial
Taxes
$5,645
Map
Community
- Address37542 Andrew Drive Sterling Heights MI
- CitySterling Heights
- CountyMacomb
- Zip Code48312
Subdivisions in Sterling Heights
- A HENRY KOTNERS RYAN ROAD SUB # 17
- ABERDEEN GARDENS CONDO
- ABERDEEN PINES CONDO
- AMERICANA # 01
- AMERICANA # 02
- ANDOVER HEIGHTS
- ANNA LISA SUB
- ARLINGDALE HEIGHTS SUB
- BEAVER CREEK SUB
- BELMONT ESTATES
- BILTMORE PARK # 02
- BILTMORE PARK # 03
- BIRCHCREST SUB
- BRISTOL HEIGHTS #4
- BRISTOL HEIGHTS SUB
- BRISTOL HGHTS # 01
- BROOKSHIRE OFFICE PLAZA CONDO #1000
- CANDLEWOOD VILLAGE SUB 2
- CARRIER REAL CO CEN LANE ROAD
- CHELSEA GLEN
- CHERRY HILL FARMS
- CHERRY HILL FARMS SUB
- COACHWOOD SQUARE SUB
- CORNERSTONE CONDO
- COVENTRY ESTATES SUB
- COVENTRY SQUARE
- COVENTRY SQUARE SUB
- COVENTRY SQUARE SUB 2
- CRANBROOK CENTER CONDO
- CURTIS ACRES
- DE CLERCK SUB
- DENEAU SUB
- DEVONSHIRE SQUARE CONDO
- DOMINIC MOCERI SUB
- DOR-SAL ESTATES
- DRESDEN VILLAGE
- DRESDEN VILLAGE # 04
- DRESDEN VILLAGE SUB
- EAST HAMPTON
- EAST HAMPTON # 03
- EASTHAMPTON SUB
- EASTHAMPTON SUB 2
- EDGESTONE ESTATES
- ESSEX GARDENS
- ESSEX GARDENS SUB
- ESSEX NORTH
- ESSEX NORTH SUB
- EXECUTIVE HEIGHTS
- EXECUTIVE HEIGHTS SUB
- EYSTERS MOUND ROAD FARMS SUB #
- FAIRFIELD VILLAGE # 01
- FAIRFIELD VILLAGE SUB
- FAIRWAY GREEN
- FOREST CREEK SUB
- FOREST VIEW SUB 7
- FOX HILL ESTATES SUB
- FRANCESCA
- GARDEN FARMS
- GATEWAY OAKS CONDO #760
- GLENMERE ACRES
- GLENMERE ACRES SUB
- GOLFPOINTE VILLAGE
- GREENVIEW
- GREENVIEW SUB
- GRENAL # 01
- GULASON ESTATES
- HANNEBAUER PARC CONDOS
- HARWOOD
- HATHERLY
- HAVEN HEIGHTS SUB
- HEIN’S GARDENS
- HEINS GARDENS
- HERITAGE POINTE
- HICKORY HEIGHTS SUB
- HORIZON
- HORIZON # 02
- HORIZON SUB
- KINGSLEY
- KINGSLEY SUB
- KORESKY SUB
- LAKEPOINTE CONDOMINIUMS AT LAKESIDE
- LAKESHORE
- LAKESIDE SOUTH
- LAKESIDE WEST
- LEGACY HEIGHTS
- LENGTHY LEGAL DESCRIPTION METES & BOUNDS
- LINCOLN MANOR SUB
- LONDON HEIGHTS SUB 2
- LONG LEGAL
- MAPLE CREEK CONDO
- MAYWOOD EAST SUB
- MAYWOOD PARK SUBDIVISION
- MEADOWVIEW SUB
- METES & BOUNDS
- MIRACLE HOMES SUB
- MOCERI SPIZIZEN ESTATES SUB
- MONTEGO BAY SUB
- MONTICELLO ESTATES
- MONTICELLO ESTATES #3
- MORAVIAN MANOR CONDO
- MORAVIAN POINTE SUB
- MOUND GARDENS # 01
- MULBERRY ESTATES SUB
- NEW BRADFORD MANOR SUB
- NEW ERA VICTORY GARDEN FARMS
- NORTH POINTE CONDO
- NOTTINGHAM COVE CONDO #790
- PALM RYAN SITE CONDO
- PARK PLACE CONDO
- PARK PLACE WEST
- PARKSIDE POINTE CONDO
- PARKWAY ESTATES
- PENDLETON VILLAGE CONDO
- PINEBROOK NORTH SUB 1
- PINEBROOK SUB
- PINEWOOD COURT CONDO
- PLUM CREEK
- PLUMBROOK
- PLUMBROOK ESTATES SUB
- PLUMBROOK VILLAGE
- PLUMBROOK VILLAGE # 03
- PLUMBROOK VILLAGE CONDO
- PLUMBROOK VILLAGE SUB
- RESERVE CONDO
- RIDGECROFT NORTH SUB
- RIDGECROFT SOUTH SUB
- RIVENDELL SUB #2
- RIVER WOODS CONDO
- ROSENDALE SUB
- ROSENDALE SUB 1
- RUDGATE MANOR
- S/P # 04 STERLING HEIGHTS
- S/P CADY FARM
- S/P CARTWRIGHT FARMS
- S/P CURTIS ACRES
- S/P EYSTER’S MOUND RD FMS # 03
- S/P EYSTERS MOUND ROAD FARMS # 01
- S/P EYSTERS MOUND ROAD FARMS # 03
- S/P HEATHERLAND
- SEVILLE GARDENS
- SEVILLE TERRACE
- SEVILLE TERRACE CONDO
- SILVER MAPLE SUB
- SOMERSET MEADOWS SUB
- SOMERSET SQUARE
- SOUTH-HAMPTON SUB
- SPICEMILL SUB #4
- SPRING MEADOWS
- SPRING MEADOWS OF STERLING
- STERLING COMMONS
- STERLING COUNTRY ESTATES # 01
- STERLING COUNTRY ESTATES # 02
- STERLING COUNTRY ESTATES # 03
- STERLING COUNTRY ESTATES SUB
- STERLING CREEK CONDO #929
- STERLING HUNT CLUB CONDO
- STERLING KNOLLS SUB
- STERLING MANOR SUB
- STERLING SQUARE
- STERLING WOODS CONDO #668
- STONEGATE MANOR
- STRATFORD VILLAGE NORTH CONDO #754
- STRATFORD VILLAGE REGENTS #690
- STRATFORD VILLAGE TERRACES #674
- SUNCREST SUB
- SUPERVISORS CLINTON VALLEY SUB
- SURREY ESTATES SUB
- SUSSEX MANOR SUB
- TAKOMA PARK SUB
- TARRYTON # 02
- TARRYTON SUB 2
- TARRYTON SUBDIVISION #02
- TERRA SANTA VILLAGE SUB
- THE ARBORS
- THE TOWNS AT ORCHARD SQUARE #696
- TROY MEADOWS #632
- TYMBER RIDGE SUB
- UNIVERSITY ESTATES SUB
- UNIVERSITY ESTATES SUB 3
- VILLA FONTANA SUB
- VILLAGE AT VINEYARDS
- VINEYARDS SUB #5
- VINEYARDS SUB #8
- VINEYARDS SUBDIVISION
- WALDEN ESTATES
- WESTBRIDGE MANOR
- WESTCHESTER SUB
- WILLOW WOODS
- WILSHIRE SUB
- WINTHROP # 01
- WINTHROP SUB
- WINTHROP SUB 2
Market Summary
Current real estate data for Single Family in Sterling Heights as of May 08, 2026
224
Single Family Listed
60
Avg DOM
175
Avg $ / SqFt
$394,812
Avg List Price
Property Summary
- 37542 Andrew Drive Sterling Heights MI is a Single Family for sale in Sterling Heights, MI, 48312. It is listed for $374,900 and features 3 beds, 2 baths, and has approximately 1,610 square feet of living space, and was originally constructed in 1959. The current price per square foot is $233. The average price per square foot for Single Family listings in Sterling Heights is $175. The average listing price for Single Family in Sterling Heights is $394,812. To schedule a showing of MLS#20261031661 at 37542 Andrew Drive in Sterling Heights, MI, contact your LoChirco Realty, LLC agent at 586-321-9997.
Similar Listings Nearby

37542 Andrew Drive
Sterling Heights, MI
