Property Attributes
- ID#58050220165
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CityFraser
- AreaFraser
- NeighborhoodSTONEYBROOK SUB
- Zip48026
- StyleRanch
- Year Built1978
- Taxes$ 4009
- Price$ 309,900
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage3138
- Lot Size0.23 Acres
Data Source:
RealComp
Property Description
Welcome to 15500 Sherwood, a beautifully maintained 3-bedroom brick ranch featuring a 2-car attached garage and a functional floor plan designed for comfortable living. The spacious living areas are filled with abundant natural light, creating a warm and inviting atmosphere throughout the home. Recent updates include a newer front door, newer furnace, thermal-pane windows with marble sills, and newer carpeting throughout. The home offers generously sized rooms, including three spacious bedrooms with large closets and two updated full bathrooms. The large kitchen features sturdy cabinetry with convenient pull-out shelves, a comfortable eat-in area, and includes all appliances. A first-floor laundry room, complete with washer and dryer, adds everyday convenience. The finished basement provides additional living and entertaining space, highlighted by a large family room and a cozy gas fireplace. Beautiful skylights with remote-controlled blinds bring in natural light, while the door wall opens to a charming Florida room surrounded by windows. From there, step out to a beautiful patio and backyard, perfect for relaxing or entertaining guests. Conveniently located near shopping, dining, and major roadways, this home offers easy access to everyday amenities and commuting routes. Don't miss this wonderful opportunity to make this exceptional home your own!
| Price History | |
|---|---|
| 8/29/2026 | Listed $309,900 |
General Features
| Sewer | PublicSewer, SewerAtStreet |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CentralAir |
| Possession | AtClose |
| Appliances | Dishwasher, Dryer, Humidifier, Oven, Refrigerator, Range, Washer |
| Garage Spaces | 2.0 |
| Patio/Porch Features | Patio, Porch |
| Architectural Style | Ranch |
| Pool Features | None |
| Construction Materials | Brick, VinylSiding |
| Year Built | 1978 |
| Levels | One |
| Property Subtype | SingleFamilyResidence |
| Community Features | StreetLights |
| County | Macomb |
| New Construction | No |
| Property Type | Residential |
| HOA | Yes |
| Attached Garage | Yes |
| Subdivision Name | STONEYBROOK SUB |
| Garage Y/N | Yes |
| Total Rooms | 8 |
| Full Baths | 2 |
| Status | Active |
| City | FraserCity_Macomb |
| Body of Water | n/a |
| Disclosures | FloodPlainNone, TaxesHomesteadExempt |
| Senior Community Y/N | No |
| High School District | Fraser |
| Zoning Description | Residential |
| MLS Area | Area03181Fraser |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 4009.0 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Lease Considered Y/N | No |
| Rent Control Y/N | No |
| Standard Status | Active |
| Tax Assessed Value | 82594 |
| MobileHomeRemainsYN | No |
| PostalCity | Fraser_Macomb |
| Legal Description | STONEYBROOK SUBDIVISION LOT 28. (L71 P33-34). CITY OF FRASER |
Interior Features
| Interior Amenities | EatInKitchen |
|---|---|
| Basement | Concrete, Finished, Full |
| Fireplace Features | Gas |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Window Features | Skylights, WindowTreatments |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 1638.0 |
| Total Bedrooms | 3 |
| Below Grade Finished Area | 1500.0 |
| WaterHeaterFuel | NaturalGas |
| Above Grade Finished Area Source | PublicRecords |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 2 |
Exterior Features
| Parking Features | TwoCarGarage, Attached, ElectricityinGarage, GarageDoorOpener, SideEntrance |
|---|---|
| Water Source | Public |
| Foundation Details | Basement |
| Spa | No |
| Lot Dimensions | 85 x 120 |
| Lot Size Acres | 0.23 |
| Waterfront Y/N | No |
| Crops Included Y/N | No |
| Road Responsibility | PublicMaintainedRoad |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
IDX provided courtesy of Realcomp II Ltd., via Remerica Integrity II Realty and The Originating MLS(found above), © 2026 Realcomp II Ltd. Shareholders. Shareholders. The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Data is updated as of September 13, 2026 9:13 PM UTC Information deemed reliable but not guaranteed.
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of Realcomp Ltd
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating